Home : Bytes IT Community / View Full Version : MS Access
- Control Label
- Resizing Images then saving
- Treatise on Tree Control 6.0?
- Line Return
- 1:1 Relationships: RI Enforcement/Cascading Deletes?
- Update a Field from another table
- !!FAQ! for Date: 20031227 - New Users Look Here! [Last Updated November 30, 2003]
- How to make all negative values positive?
- Help with this Error Message
- cancel if no records
- SQL Insert question
- Finding Latest Record for an Associate
- Calculating Dates
- #Delete
- Line Returns
- Public Variable- Why doesnt this work?
- Subform popup (shortcut) menus
- Subform header in Datasheet view
- Properties problem: .Text and .Value do not capitalize
- Open Report filtering from a listbox
- Delete
- Changing MS Login ID on-the-fly?
- Create a new Form from based on a 'Filter By Selection'
- Selecting Users from a list when running a report
- !!FAQ! for Date: 20031226 - New Users Look Here! [Last Updated November 30, 2003]
- DMin Function
- Write to LPT
- Performance problem in one form only
- =Sum #Error
- I'm trying to list controls in immediate window... what's wrong with this code?
- Duplicating record
- !!FAQ! for Date: 20031225 - New Users Look Here! [Last Updated November 30, 2003]
- Access 2002: problem in VB function
- Finding dates from a query
- Combobox
- Invoice numbering
- !!FAQ! for Date: 20031224 - New Users Look Here! [Last Updated November 30, 2003]
- Replication/Synchronisation failure
- MsgBox won't close.
- Query Description Entry
- A single child changed the world!
- Combo box LimitToList property setting of No - I still get MS Access error...
- Changing Query Reference Table Names without rebuilding query
- IsNull
- Search an encrypted database and display results
- Access 2002: Call VB module from reports
- Metaphone source code
- Find and Replace Strings in Access: New Version
- Upsizing wizard
- $0.00 inserted into Currency field
- Worlds Dumbest Question!
- Is this feasible?
- Code: Private Sub help
- web database...
- Difference between rows
- Simple text file creation
- !!FAQ! for Date: 20031223 - New Users Look Here! [Last Updated November 30, 2003]
- importing accented DOS chars
- Update a record
- Double Click on a Record in a Subform to Open that record in a new form.
- Query-Generated report
- tab control inside another tab control
- Life with Different Versions of Access
- PLC programmeurs gevraagd
- print out problem
- Input Box Fails to Cancel
- combo box doesnt save
- Date Filter
- How to use VBA to delete files?
- OT. Is anyone running Access with the Linux OS?
- Referring to controls in Modules
- OT. Remote access of your Access app over the web
- access97 runtime error 3075 missing operator
- Determining screen resolution in a procedure?
- MS Access & SQL Database for JPEGS
- The "database" object type missing in Access 2002
- !!FAQ! for Date: 20031222 - New Users Look Here! [Last Updated November 30, 2003]
- Relation
- Simple code to delete all rcd in a table and import records to same table
- Combining multiple tables into one table
- MSDE - security issues while on cable modem?
- Is Access consistent with the order of events when opening a form from within a procedure?
- Access97 to WinXP from Win98
- Code for Filtering from Mult-select List Box Criteria
- OLE Server and ActiveX control
- Query in VB to Validate data
- advanced search functions (for photo database)?
- A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control
- Error 3021 no current record access 2000
- Coldfusion and Access and Field Names (It ain't Paradox)
- Windows 2000 Server and Access 2000 constant corruption
- Windows 2000 Server and Acess 2000 constant corruption
- Subforms & Counting
- Table efficiency
- how to record invoice printed
- looping through all records with VBA
- Need Help with Package and Deployment in Office XP Developer (replace - always, older files, never)
- Report Preview
- Attn MGFoster
- #Name Error in Linked Combo Box Field in Printed Report
- !!FAQ! for Date: 20031221 - New Users Look Here! [Last Updated November 30, 2003]
- <<HELP>> First level support for ms database
- Skinning Access forms
- Datensatz finden in Unterformularen
- Sharing across Win platforms
- how to set focus on a report control?
- Dsum , using numeric & Text help with the Text bit!
- Dsum , using Numeric and Text fields ????
- How to access an MS Graph Object on a report
- What is future of MS Access?
- Enter New Data In Comboboxes Only
- How to count records selected in subform datasheet?
- Move to next control in Form after pressing Enter?
- importing trouble with my access '97 D-base in access 2002 D-base format
- This is my problem......
- How do I pass a field name to a function?
- !!FAQ! for Date: 20031220 - New Users Look Here! [Last Updated November 30, 2003]
- Advantages of moving to most current version of Access?
- How to use InStr Function to get hyperlink display text?
- Forms and the Switchboard
- ChkBox and TxtBox Problem
- dialog box with no border? (access xp)
- Error 2448 does not make sense in the context of the problem
- sql help - should be simple, but can't get it.
- Report by hour / day
- Passing Values to Parameter Query
- Re Disappearing forms!
- Save data entered when using [enter a value:] in SQL
- Access problem
- Parameter Query
- How to hide tables from the Import Wizard
- Disappearing forms!
- Please Help Passing Variable from Form to Query
- !!FAQ! for Date: 20031219 - New Users Look Here! [Last Updated November 30, 2003]
- wanted: database publishing tool for MS Access
- Setting Controls from a Table in Access 97
- Shrink the size of a field
- Check Box Size
- Duplicate values
- Screen Preview differs from Print Out
- How to pass multiple arguments when calling Function?
- Trouble with Access Like Query in ASP
- Update a Form Field
- urgent : access sub-reports as popup
- Spaces in Field Names?
- Find Front End
- Automating queries by using a reference date.
- Moving data to SQL Server
- Access 97 on PC with more than 1 GB of RAM (Terminal Server)
- Problems with Access XP and SQL Server
- Memo datatype got trucated
- I want to make a web interface for my database...
- DllRegisterServer in MSFLXGRD.OCX failed
- SQL: INSERT INTO without specifying any column
- 100 Day Statistics for comp.databases.ms-access
- Statistics for comp.databases.ms-access
- Access Word 2003 Automation
- need help with vertical (columnar) datasheets
- Time-keeping with Access 2000
- Access 97 Database converted to Access 2000 - Controls do not work
- PivotTable date groupings
- emailing from a form
- Application Icon Location
- Viewing table as subform and seeing linked items
- Call query design view from code
- When does Does "On Open" execute?
- Passing Discontinuous Range (Array) of Values to User-Defined Function
- Iif Statement Returns Error in Form
- Send a draft message to mailing list
- multiple append queries using VBA
- !!FAQ! for Date: 20031218 - New Users Look Here! [Last Updated November 30, 2003]
- Importing Tables from SQL Server to Access with Keys and Indices preserved
- Searching for the right word to encompass 'Supplier' and 'Consumer'
- Automating queries by using a reference date.
- Is 2.3 MB too big for a simple database?
- Selecting from Text File Truncates String
- Is this possible?
- 255 Column Limit using Microsoft Access
- Selecting from Text File Truncates Long Strings
- Get the name of the function or sub from within code?
- Non-Duplicate List Of Products
- Display date with 4 digit year
- update combo box
- Access 2002: Replication question
- Stephen LeBans JustiDirect text justification
- Xcel or Access sort columns of names so that I remove the intersect between 2 columns from one of the columns?
- Larry, for you . . .
- Save a record programmatically from a form's module
- Updating Linked Table - why is action query failing?
- Can't update a recordset after filtering
- Update Inventory
- One customer gets #error
- Determining where a control is on a form; header, detail, or footer
- Conditional state of a record
- VB - Question for OpenForm Criteria
- Assistance needed with a small piece of code
- The Paperless Office is Now!
- No $ for Currency fields
- How do I?
- Populate control in another form
- Redemption Not Blocking Latest Security Prompt
- Acc 97, expressions
- SQL - joining 5 tables - not all records retrieved
- help with unbound fields
- !!FAQ! for Date: 20031217 - New Users Look Here! [Last Updated November 30, 2003]
- Paste Into A Combo Box
- Tabellen von verschiedenen DBs in eine DB kopieren
- Combo Box inital value to display
- DateValue
- What this query return ERROR?? :(
- Access 2002: Bar code problem
- Get the name or HelpContextID of a Toolbar Object?
- Problem retrieving printer information for this object
- Help: batch method to get .MDB table names ???
- A2K2 AllowAdditions
- Cannot import .xls file (Access 2k)
- Problem with Check Box use to Change Field Values
- Struggling with linked database problem
- Labels Dialog Box Enhancement
- Justdirect text justification
- Control Of What Is Printed In Page Footer
- Register a dll
- addresses
- I'm rusty on my Access...can anyone help with a Query question?
- Viewing linked entries in a subform
- How to loop through a record set.....?
- Problem Duplicating Forms in Access 2000
- Modifying an import specification doesn't work.
- Best way to handle distributing runtime installables from the web??? (slightly O.T.)
- Is there a trick to not have a cross-tab query sort the column headings?
- how I protect my DB with serial number disk?
- Report in Access project
- The above post is a forgery. Ignore
- MetaData Repository Standards?
- Parameter Value in IIF
- Using access to complete company forms
- problem with my code
- Sync Access with Palm PDA
- Adding a New Field to an existing Form
- Double Merge in a Access Report Possible??
- Getting User Name form Login (System enviroment variable?)
- A97: Get the month, day, and year from a date field in a table
- concatenated form fields
- !!FAQ! for Date: 20031216 - New Users Look Here! [Last Updated November 30, 2003]
- The IsNull function requires 2 arguments
- Help with DCount function and filter
- Lookup field created with VBA ?
- Protecting your work
- Access 2003 pivot-table view gone?!?
- form field validation
- MSFT Access Unable to create MDE
- Iterate through all queries in database and set description
- Using Access with LDAP
- labelling
- Filter Sort Wild Card?
- A97 - Detect Idle Time
- How do you create a Report or query for the # last days?
- Date field
- Access 2002: Updating 2 same database
- Group total in distinct field
- Copy field with DoCmd
- Changing field types with Excel as linked table
- Can I use VBA to import/link tables?
- SQL INSERT INTO a table using information from two other tables
- Possible fix for Pivot Table grayed out or no row or column sight problem in Access 2002 XP
- Uninstall
- Access 2000 - Use ADO.Recordset as Report Recordsource
- Replace text in a field?
- Go To Current Record
- How to Lock and Hide Access Tables?
- Creating report using ASP with MS-Access
- Beginner: Open Main Switchboard Item in Datasheet view?
- Do NOT click on ANY URL's posted in CDMA
- changing a form to a subform (VB problems)
- BEWARE LINKS POSTED FROM SODOMIZERS!
- Access 97 Complication
- How to merge two distinct records into a single record?
- Alternative row color with a sub report
- Text Box Assistance
- Access freezing while printing
- Changing Colors of fields on a report
- Beginner: Mde error- couldn't make changes
- Any way to record the progress of a query while it is running in Access 2000?
- Finding Login Name for a Group Login
- !!FAQ! for Date: 20031215 - New Users Look Here! [Last Updated November 30, 2003]
- Database window appears when it should not!
- Access Run Time: Alternative Version
- foxpro compared to access......can they do the same thing
- records in report disappear after design viewing
- FTP with Login and Password - what is wrong with this?
- Problem with DoCmd.OpenForm
- Dialog Box Not Dialogging
- parameter query
- Connect to back end for non logged on user
- Relationships and Cascading Updates problem
- Relationships
- Display of Menu bar while access is starting
- Table column is automatically populating itself
- SQL utility form for Access
- <<HELP>> Getting rid of part of a text field
- One Step Merge Document and E-Mail to a Group
- Update MS Access table from another table
- BEWARE LINKS POSTED FROM ANONYMIZERS!
- Subreport question
- How to: Filter Against Fields
- Access 2000 Missing Wizards
- Invalid Procedure Call or Argument (Left, Mid, etc.)
- !!FAQ! for Date: 20031214 - New Users Look Here! [Last Updated November 30, 2003]
- Problem retrieving printer information
- How to SELECT hyperlink.htm FROM table?
- Error on opening a database: MS JEt database says someone tries to modify the file
- Use Access 97 or Access 2003
- Do I use Nz
- Access & system settings
- Error on opening a database: MS JEt database says someone tries to modify the file
- Sample files
- updating/adding to another table
- Send email - capture ProfileName from MAPI
- Microsoft Access license to distribute runtime components
- Get actual text of error trapped by Form_Error?
- Quieres ganar dinero extra para pagar tus deudas lee esto......
- Different Versions of Access on Same Computer
- a2k - weird code behaviour I can't explain...
- Updating Yes/No Fields !
- Time formats
- MS Access '97 and MS-Office XP-SBE, would it work?
- Parsing some text data into records...
- update blank table record field
- Forms and Form
- !!FAQ! for Date: 20031213 - New Users Look Here! [Last Updated November 30, 2003]
- Report Writer question: can I do a "top ten"
- Re-entering combo boxes
- Beginner: Can a form edit identical data from more than one table?
- Installer problems
- Save files attached to an email
- Access data through MS query in Excel.
- The meaning of "Me!"
- Sudden shut down when saving a Query
- make modules and tables invisible bt code
- Office 2000/XP Menu items
- Another SQL Question - Update Value with Column Name
- Referring to a variable field using SQL
- Calling Procedure on other form
- Log user on opening
- Specifications - limit on # of rows?
- Help with Access XP Error 2001 "You canceled the previous operation"
- Outlook automation from Access?
- Printing a Word Document from ACCESS
- Opening the main toolbar in VBA
- PHONY FAQ
- Problem w/MSINET.OCX in Acc97 runtime
- Saving Email Attachments To A Folder
- Run time error, "The data has been changed."
- Listboxes
- Access and Calendars
- Close report without save prompt after setting input parameters
- !!FAQ! for Date: 20031212 - New Users Look Here! [Last Updated November 30, 2003]
- [vba] looping through an array
- Access Service Patch version thru VBA
- How Do I create a new record from an existing record
- DHL or FedEx Track Links in SendObject Body For outlook?
- File Open Dialog Box
- Dim MyDbs As Database
- How to calculate time duration?
- Replacing data in a table WITHOUT changing the numbers created from a running sum..
- Call One Access Application from Another
- Text Files
- ODBC call-failed error
- VBA Code learner Please Help
- Help on Access... 2.0! Really! And on 2003...
- Help on Access... 2.0! Really! And on 2003...
- help with combo box requery
- Using an Access app without Access?
- Column Names
- Conflicting Versions
- Another database bloat question.
- Imorting Excel sheets e-mail attachments
- Time stamping on a network with no dedicated servers
- CompactDatabase fails with Invalid Argument error
- Printer/Page setting disappear when front end MDB copied to another PC
- Data Input Database Design Help
- OutputTo Macro problems...
- Freeze Columns
- multiple user access on shared network drive possible?
- Field type with greater than, less than signs
- Intellisense Window Closes too Quickly
- Corrupted file A2002 ???
- Subform and button on parentform
- Something to be said for a moderated newsgroup
- Select top 100 from table1 does not work? Is there another syntax?
- Show if a parent record has a child record.
- Sequential numbering
- Creating a Query in VB
- CPU Type in Access VBA?
- Tool for finding references to and from tables/queries/reports/forms/objects
- URGENT--PLEASE HELP
- Secure Database Object
- Do Loop provides incomplete data
- !!FAQ! for Date: 20031211 - New Users Look Here! [Last Updated November 30, 2003]
- Web based reporting software?
- Turn off the Office Assistant through Access VBA
- Removing Security?
- How do I do this?
- Out of memory error Access 97/XP Home with > 512 megs of RAM
- Assigning a value to a "Form" variable: Dim vFrm as Form
- Using import/export specs with ADP projects
- Word Automation
- I need help!
- Use the File Open Browse box
- Automating the import of an OLE object
- How to save variable values for future use?
- Access Virgin!! please help
- Access 2002: Selecting necessary data from several tables
- view result differs from the result in SQL Server
- Update Your Front End on the Network Easily
- Query speed anomaly
- Ms Access Database to web page
- Why does UPDATE query change data type?
- use of autonumber
- Auto fleet manager
- SQL statement problems
- Cleanup with Erase after Split?
- Jet or MSDE
- Query syntax, can it be better than Paradox?
- print preview problem
- App name ideas
- Count in Access
- Setting control properties
- Error Handler best practices
- Microsoft Oracle ODBC
- Finding Links that are not in Links Window
- problem with creating a duration field
- Q: Regarding back-ends, is it better to have one or several linked dbs?
- Sort Order in SubForm, Access 97
- Access 2000: Forms -- Getting a form/subform linked properly
- Shared network database
- Display weekday name of the date entered
- Multiple Record Sources
- Birthday Report
- Shared database
- help with display day(date)
- application developer required
- Automating report in a different MDB ( Question #2 )
- Ffield Size Problem
- Printing forms
- Subreports / Reports with Multiple Detail Sections
- error on inserting records to subform
- Send a pop up box behind a report
- DAO efficiency question
- Snapshots -vs- .pdfs
- Access 2000 Developer Tools
- Create report from Crosstab query w/dates as column headings
- Change cursor position of active control
- bank sort code issue
- Passing trough table
- error 3464 Data type mismatch error!! ??
- Changing the data type of a field in a table thru code
- Access Help
- How to add index with CreateIndex ?
- table name with spaces in RunSQL instruction
- Calculating Rows
- Query based on a Complete Field in a Table
- Unix Time
- error message!
- The images of boys' bare butts stayed with me as fantasy material for
- Data can't be saved to the field
- Simulating Combo Box AutoScroll on a subform list?
- GIVE IT UP DON MELLON
- Does Access know WebDAV?
- Error when executing SQL statment
- Problem with the mouse scroller
- Apply ValidationRule Before Update Method
- Text Box Formatting Based on Data
- sequential numbers
- !!FAQ! for Date: 20031209 - New Users Look Here! [Last Updated November 30, 2003]
- Compatibility Access 2000 and 97
- Compatibility Access 2000 and 97
- Access 2000 Distributing
- Access 2000 Redistributing
- Problem in programming waiting list for day care database
- REQ: Question about access. Please read inside. Thanks.
- A97 Graph question
- function calling
- Deleting in vba code
- a2k - real quick help needed on report printing out too many times
- system.mdw/default/secured mdw etc.
- Mystery bat file - A97
- How to get number of servers attached
- Navigating between forms, flickering
- update table
- Problem with Validate rule and Combo-box
- sql statement wildcard in fieldname
- Many 2 many forms. Shirfting data from 1 listbox to another ...
- How to move to specific record in Datasheet?
- Help - Unable to use ADO recordset as Form's Recordset
- OLE to Store Outlook EMail Objects in Access
- Access query fails if run through ODBC
- Change backgroud color for record listed in subform in continuous mode
- VBA - ACCESS 2000
- Copying permissions to a newly created mdb file
- How to not trigger dirty event when initializing control on form through VB?
- Programmatically identifying event properties
- Formatting data within a text box
- Substituting a variable in a form control
- Open Form from external database
- Adding current time in field with toggle button
- replication
- Calculationg & Avg time in a report
- Database to a:\
- Table entry from combo box
- try it in english maybe i am more lucky
- Empty lines in report
- why does that thing doesn't work??????,
- Emailing pages of report
- !!FAQ! for Date: 20031208 - New Users Look Here! [Last Updated November 30, 2003]
- Access : VBA
- a2k - graphics with transparency
- The beloved David Fenton in his own words
- Replication Manager
- Enforce rules with code or database design?
- Is it possible to switch content in a field upon choosing a certain field?
- record is not moving to next record on the dropdownlist
- How to convert Text dates to Date format?
- changing font color within column on form
- SQL statment for muliplie tables including the count function .
- Access wizards
- error when selecting data from the dropdown list
- Subreport Totals
- AddNew - Pocket PC
- Install that update from the Microsoft Corporation
- Default query parameter values
- AddNew from table A into table B - Pocket Access
- Finding records by date range?
- OpenRecordSet ...
- Importing only NEW RECORDs in MS-Access!
- byPass Shift Key in Access 2002
- Listbox does not allow me to detect a null value
- Report with a Control Filter?
- version?
- a2k - irritating RI message
- Conversion from Access 97 - 2000
- Conversion from Access 97 to 2000
- 2nd repost: Auto FE-Utility Access 2.0
- David Fenton is a valued member of this newsgroup
- Update txtbox with value from listbox
- Compact on Open
- !!FAQ! for Date: 20031207 - New Users Look Here! [Last Updated November 30, 2003]
- Hiding Group Footers & Headers
- Validation rule trouble - ensuring values held in one field are less than those held in another field
- Automatically Updating data end of month