- Checking when "leaving" current record
- Storing a Query In a Record
- Average value
- Calender view?
- Error loading DLL in Switchboard
- Search fuction in Access2003
- Choose query columns from a table based on records in a second table.
- Auto-select next record alphabetically
- duplicating records in parent and subform
- RE: Switch function
- Break text into separate fields - HELP!!!
- I'm not so smart
- problem sending an email with SendObject
- Using VBA code to create a command bar entry to open a form
- Query Value Display
- Public variable
- Passing Values
- Problem saving record in multiuser environment.
- Forms, SubForms
- Two Subforms - Same Record
- Limit Recordset to 3 products
- Re: Insert a "," into a SQL string for a listbox
- Cross reference CurrentUser() against a table of names
- Problem with next/lastrecord
- Re: requery listbox that uses function as rowsourcetype
- Re: Modal forms do not stop code from running
- Visual Basic Error
- how to remove Chinese Pinyin Input Method Editor (MSPY2 IME)
- Refreshing a forms records
- add textbox data to new record without using control source
- Save Record
- Re: Form to Form Coding (Object Required error)
- Message Box
- Visible code error
- Form Does Not Go To New Record
- form & subform auto update related field
- Previous post, updateing a combobox
- Calculate Weekdays (Excl Weekend Days) Between Dates
- Open form only if subform has data
- Re: Calculate Weekdays (Excl Weekend Days) Between Dates
- Err.number
- Counting number of line in a memo field
- Set an access db login form
- Re: Form to Form Coding (Object Required error)
- subform based upon listbox based upon listbox
- How to requery a combobox on a subform
- One Pence out query
- After Update
- After Update Problem
- Cannot invoke event procedure
- Subform reference returns value from query expression
- Re: text box displayed in all 3 tabs when it should not
- text box displayed in all 3 tabs when it should not
- Multiselections in List Box
- Running a module from a command button
- Record Count zero on form
- Code problem Help!
- updating main from with data from subform - repost
- Data Entry on a subform
- QueryDef
- Open Forms
- Combo box statement bank
- Combo box statement bank
- managing application quit
- Grammar Check Memo Field
- HOW TO LIMITATE NUMBER OF THE RECORDS IN A TABLE ?
- getting rid of helpbox on menubar
- HOW TO LIMITATE NUMBER OF THE RECORDS IN A TABLE ?
- Attach custom popup menu to runtime query datasheet?
- Code to break text into separate fields
- I need a routine to generate a unique number for a key
- programmatically check if form is open
- Updateing a combobox
- Change Chart Object Problem
- Capture Duplicate Records Error
- Null error
- Localization problem
- Toggle buttons
- Subquery Events question
- Need routine to generate unique number for key
- search form
- Changing drop-down menu at run time
- how to display a file "thumbnail"
- Right-click menu is not available in .mde-file
- Incorporating Files Into a Database
- Scroll madness. Please heeeeellllllp.
- Working in Access RunTime
- Replace a / in a string
- Delete query question
- Setfocus or docmd.gotocontrol
- How update a combo box when a record is updated
- Default Value's correct syntax
- If a certain tab is selected then run a code
- Active control Name
- Making individual records read-only
- Text Box in Forms
- Form input into query
- update field value through ado
- Listbox
- Greyout Fields
- months in a listbox
- HOW TO SCAN AND STORE DOCUMENTS FROM ACCESS
- Locking Record
- list box
- Setting DefaultValue Property
- REPOST: (No Response) Coding A Search Button
- Unlocked Zoombox Wizard for Access 2002
- Avoid Creating A Duplicate Record
- Access MySQL
- Getting a value from a table to display on a form???
- USING WAV FILES IN DESIGNING A FORM
- previous record from new record
- Tools startup allow full menus
- problem with custom toolbar & switchboard in A2002
- Queries and reports in access Need help please
- http://vampirillo.com/galerias_fotograficas.htm
- Wireless Network/Access2K
- Problem using WithEvents
- Sample Form
- Combo box question
- RunCommand not working
- Default Form View Settings
- Menu Bar Names & Commands
- changing value of field (notunique values) programmatically
- Forms code and external sub or function
- KeyDown Event Problem
- Send keys to an object outside of Access
- Combo Box Update
- Referring to calculated field on subform
- Calculations on specified records
- Get Free Domains .COM .NET .ORG with Free WebHosting
- Automatic check a box after a report is run
- Problem with close button
- Adding an Image to a form SHUTS DOWN A2K !?!
- Limit number of Records in Continous form
- Switching Printers using form
- Menu Bar
- Hiding/Unhiding column in datasheet view
- Locking individual records in a form
- Upload files using VBA
- BOF and EOF
- Update Query Question
- Basic form coding in Access 97?
- Error 3061
- Listviews & Submenus
- Subform Records Selected
- How do I restrict AllowAdditions and DataEntry to just a single record at a time
- No icon when adding embedded OLE object with code?
- Dlookup problem
- Microsoft Web Browser ActiveX Control
- change a line in a memo field??
- Option group coding
- form coding
- Changing Source for a form.
- Re: Override default Msgbox title ???
- RE: Combo box
- Re: Combo box
- how many rows selected
- Network User ID
- Access 2000 run time error "record is deleted"
- automatically Add date on doubleclick
- Calculating Parent & Child Data In Subform
- Active page for TabControl
- New Balance from Previous Balance
- How to question the data base on certain criteria
- Run-Time Error 3061 - Expected 1
- deleting row from continuous form
- Filtering a form by dates that fall in the current week
- open file with given application
- custom menu bars & switchboard don't work in access XP
- Combo Box
- Output text to excel textbox
- Combo Box
- Multi Selection With Combo Box
- Run-Time Error 3061...Too few parameters. Expected 2
- Need help with creating querydef
- Programmatically backup back-end database
- Returning Array from Function
- Email form problem - Did work now doesn't
- Get autonumber field using a querydef after an insert w/o transaction
- Number of record retrieved on a form
- Resize Form
- ODBC connection
- Global Variable loose value, when and how I don't know ... please help!
- Combo box On Click event doesn't fire.
- ADO Recordset Cache
- Update to table problem
- Mainform/subform/subform problem
- Updating field
- Age from date
- User Licence
- Programmatically update MDE/ADE file
- Why no update? Help!
- executing a querydef
- Control Calendar Stphen Lebans 2nd cuestion
- Locked Record Indicator
- Problem with RecordCount or RecordClone!
- Looping through values in a table
- updating data on a subform with data from another subform
- Custom Find Button
- Hide command button
- Closing forms
- [Resend]: RunTime Error - 2455
- How make a Subform to create a New Record
- update query
- Display all records, each in a form text box
- Command Button
- RunSQL asking for a parameter
- RE: Null Issue
- Appending text for export to word
- Lost Focus/Enter Key Hit ?
- Field Search/Setvalue Auto-Date
- Dates & initial values
- make table query/sql
- User Paint interface
- Insert word document in record with code
- Disable The F11 or Shift Key On Open
- ADO recordset, Form RecordSet Property
- get enum text description?
- save form data in code
- Open File Dialog
- Proper way to declare an object?
- Dynamic Reference to Forms objects
- Dereferencing objects: Am I living on borrowed time?
- Date function
- Packaging a DB using InstallShield
- Expression
- Re: Business Time
- Requery doesn't work immediately
- Help!
- Combo box question
- Scrollbar behaviour in textbox ?
- Not in List
- Which method shall I use?
- Getting mouse position to move form
- How can I set a different caption to a report that I send directly to printer
- Find control attributes
- DAO querydef parameters
- ADO - recordset navigation with code
- Automatically update a form when table is changed?
- Coding A Search Button
- Form's Recordset property question
- Add New creating unwanted records
- Why is creating this query with code slow?
- Form code debugging
- handling empty subforms?
- Sum Times and Display Result - Access 97
- Sub form access
- List Box Question?
- HElP with On-Key-Down please
- Re: Value List
- determining selected columns in datasheet
- Leading "=" Lost in OpenArgs String
- Re: Forms as classes
- Use of Modules
- Populating new record in continuous mode
- Help... Adding to a new table data from other linked sources in my form.
- Filter code
- All Event Procedures produce error
- MEMORY ERROR When Running Code
- Re: prompt for input field
- Undo Button
- create parameters dynamically?
- How to use Outlook as a database "dashboard" ?
- Experts Please Help
- Querries are not working in Windows XP
- Different switchboard displayed depending on user.
- Events not excuting on form. No error message given. .
- moving data from popup to subform
- Getting a type mismatch error when trying to run code
- list boxes
- arrow down in combo box
- default form values
- Custom Cursor
- Code error!!!
- Automatically saving records in real time
- Calculating Datehired w/ Vacation, Sick, and Med. Leave Time
- Need help on Packaging a XP Project using InstallShield
- Control recordsource/Controlsource issue
- Runtime Error 2001
- Public Variables
- Help! Subform not showing all records
- Number coverting to days
- OpenForm w/ where clause issue
- Help!! cannot clear breakpoints from Access VBA
- In code check to see if query has no records
- 04 May 2004, How to change parameters of Import Specification through VBA Code
- HELP!!!
- Object variable or with block not set error
- copy folder
- 1- how do I know there is (Folder) Name (MyFolder) In H.D?
- "auto repeat" for a command button
- RunTime Error - 2455
- how do I know there is (Forlder) Name (MyFolder) In HD
- format in SQL queries
- Record X of Y
- RE: Cannot Get Path Hyperlink Issue Resolved
- FindFirst and Apostrophe
- Maintain DATE format on click in datasheet view?
- Create A New Record From Same Data
- Re: Cannot Get Path Hyperlink Issue Resolved
- Copy Folder
- RE: listbox requery
- Looking for the parameter to search "Any Part of Field" in the Find dialog
- Securing a CMB
- Creating a backup copy
- Set Focus Problem
- REPOST: Problems with Text Box
- Click Function Problem - Code Help Required
- Check that the date entered is the current date
- Run-Time 13 Error - Type Mismatch
- Function for Date Subtraction, exclude Weekends
- Search Function on Form
- How To Set Absolute Path vs Relative
- Change the color of the label on a Y/N form element basedupon value
- Continous form problem
- form and tables
- SendObject multiple reports
- Prevent macro or code from running until a condition is met
- Linking control to query, instead of forms record source
- Search Field
- Subform not showing all records
- Call subroutine in parent forms code module
- Form Filter
- Write Conflict error message
- Write Conflict error message
- Misterious error in Docmd.Save
- scanning documents from access
- Password problem
- Text box value validation
- Recordset Error
- Use of DateSelect in SQL filter
- Use of DateSelect
- Currency format
- Old form, new fields for new table
- identify the type of bar code?
- How can I know number of tables in my data base using textbox
- Need code for record update
- VBA references to subform
- SQL Problem
- A way in code to input criteria into a certain column in a query
- Word objects
- This code need Notes to understand
- SQL problem
- @@'IDENTITY Object problem - Help!
- Is there a way in code to rename a file
- Form Behavior Problem
- What is wrong with my code?
- Custom Autonumber
- Duplicate record restriction
- How to refer to a fieldname from a string
- Update combo box
- inputbox request
- troubleshootin before_update
- cannot get form to load appropriate data -- unless it is in design view!
- MDE & MDB
- How to create resizeable + moveable form without titlebar ?
- What is the fastest way to verify a record exists?
- dlookup/null
- Sorting Records In Subform
- Remove the last, empty line on subform table
- Trouble Using VBA with Access 2000
- Prompt for password
- Help me !
- Change filter in OpenReport
- Check Checkbox
- Calculate an Age from Birth Date to current date
- Application ICON
- Adding a pop up warning
- OLE Electronic Document Link
- Computer Stuff with 100-Stores
- SELECT statement assistance
- Color Histogram Needed
- What do I need to do to make VB6 from work in Access
- code to insert OLE object
- Dependent Combo Boxes - No Values
- listbox
- E-mailing an Excel chart from Access
- Custom Cursor
- Unlocking fields
- Computer Stuff with 100-Stores
- Is There any Form Event for moving from record to record when using Navigation button
- DoCmd.OpenReport
- Change Table Links in VB
- Making something visible based on a condition
- Open a Form showing the same Record as when closed
- getting an accurate record count
- How To Synch One Subform With Another
- synchronizing form with listbox
- organize at print
- re-setting check marks to null
- Strange thing happened on compaction
- Deleting a record, still!
- Control Calendar Stephen Lebans
- Binding ADO recordset to form
- USER LEVEL SECURITY
- Embed Report in Email
- Coding After Update
- Subform Problem
- Before update
- syntax help on form
- Combos and subforms
- tabControl - Active tab?
- Creating numbering on the fly
- Re: Report: Move to a new page when a field changes
- List box with a carriage return??
- Auto expand not working with comma
- Populate a list box with names of tables in current database
- finding duplicates in a form
- multiple switchboards
- Re: Multiple Switchboards
- Update on Sync Combo Boxes
- Send Email Attachment
- NEIL - sync'd combo boxes ARRRRRGH
- prompt for input field
- On_Dirty
- Multiple Switchboards
- not sure whats wrong with time calculation
- ComboBox Filter
- Test for no records returned
- what is a command equal to = (CTRL+')
- I'm struggling with my limited knowledge of code
- Avoiding duplicating info on subform
- user level security
- finding duplicate values on a form
- Help with code to run query and test a field in the record
- If, ElseIf, Else, End If
- Re: Pass name of control in Openargs and access/set values ??
- How to delete an related record
- Help with hiding/showing forms
- Creating a Custom Form to Work Like a Msgbox
- syntax error? Help
- Moving Subforms Automatically
- Help run time error
- Run-time error Object Required
- Getting 'query does not exist' message but it does !
- Error Handling
- Return to line into a text box..
- Auto fill-in
- Enable controls in subform???
- Limit selections in combo box
- Pass name of control in Openargs and access/set values ??
- Form Position.
- ON SCREEN NUMERIC KEY PAD
- Re: Value of a listbox (If...Then...Else Statement)
- subform hiding calls
- Using Excel functions from within Access
- => Don't know what I've done form won't open
- how to "push" button from code
- Query Speed
- List Box Selected Item
- Calculated field on form
- Report: Multiple IIF Statements in a control source
- Loop through form objects
- Storing code in a String Variable
- VB command for save record
- How do I trap the error?
- Form
- Get Free Domains .COM .NET .ORG with Free WebHosting
- Form_Close
- Please help with hiding/unhiding forms in code
- check if any item selected on listbox
- making combobox read only
- HELP ME!!!!!!!
- Rebinding ADO recrdset to form fails
- Null Values Causing Errors
- Record Navigator problem
- validation rule
- me.dirty = false deletes records
- Calendar Control
- RE: Select from Combo Box OnLoad Form Event
- Delete record howto?
- Really need help on this one
- Visible Property
- PrtMip
- User Group
- Selecting all entries in a list-box
- Re: 'ORDER BY conflicts with DISTINCT' message
- Filtering blocks 1 single record
- Novice having problems executing a macro - Help
- form not showing live data
- docmd.runSQL
- Why do I get this error?
- Insert a record in a table
- inserting icons or buttons into a flexgrid
- Re: Query SQL keeps getting erased
- DoCmd.SendObject
- Help switching between forms
- On Click Revisited
- ADO programming
- Form appearance
- ADO Data Control
- Pass object to procedure
- Returning value from pop-up form
- Desperate for Help, not getting errors from execute sql commamd
- Importing .dat files
- Importing form from earlier version of access - error
- Append query from code record count
- Comparison with OldValue
- Open document using its default application
- Checking for time intervals
- synchronizing list with form
- Test a field for error
- Record selection in a continuous form.
- adding new record
- Best Way to shoe error and information messages
- Switching between forms
- Slow
- re-use of code in a module ...
- Slow client-server access
- what's wrong in code
- Having problem with SQL in VBA
- Open form with Enter key???
- Is it Escape, Undo or CancelEvent?
- How can I attach a file
- Using DateAdd
- position of scroll
- Struggling to get to a second form passing data
- Re: Combo Box Code
- Changing Background Color Based on Record Data in a Continuous Form
- Send email from within ACCESS
- email data from form
- query
- Set Form Location on open
- continuous form fonts
- subform view
- SELECT STATEMENT
- Disable Mouse Wheel Access 2003/2002
- ID with Alpha
- Can Access play a sound WAV via VB code?
- INSERT INTO syntax error
- Treeview shows up wrong position
- ESC button in a Form
- Populating ADODB Recordset from query
- Query SQL keeps getting erased
- Automatic Date Calculation
- Order by date in DESC
- Error on compact and repair database
- Setting default values for built in Search
- making group footer invisible in report is messing up the number of pages
- Form Takes Forever to Open & Save
- Updating main form
- Changing the LinkChildFields property in code
- Re: If .. then statement
- Reports with Columns - label on left side
- Kick Starting AfterUpdate Event in another Form
- i need help stepping through a table
- Copy calculated values to a table
- Calendar Control again
- Emailing
- Repost (No response last time) command button code
- REPOST (No response last post) Text Box issues
- Logging not auditing - Replica Database
- Repost help with forms updating multiple records
- is it possible to call a value from another table????
- Opening sub form
- Emailing
- Question...
- how to disable or lock a combobox
- Help with Docmd.RunSql Please
- Query Problem
- FindNext
- Tracking my tables in MS Access
- Convert format error
- Form - variable length of a textfield (help)
- SQL Insert Date Problem
- RE: "No Current Record" when should have some...
- What is wrong with this code??
- Findfirst?
- Put message to form
- Process records from a query
- Re: "No Current Record" when should have some...
- #ERROR appearing in all input fields in subform
- Listbox Default Record
- Listbox Default Record
- TextBox DefaultValue
- Security - Security & User Accounts
- Re: "No Current Record" when should have some...
- Incrementing a value in a field
- On Click
- Help with queries
- AddNew Do...Loop with captured Primary Key
- Forms, have controls avail for specific rows of data
- Problem updating unbound controls
- Multi Select in Option Groups
- Re: Logging
- Copy Previous Field Value
- ToolTipText over a word as ref. to a record
- SQL problem
- Send Outlook Mail
- Report Criteria
- hyperlink subaddress syntax
- Re: Unable to go to next Record
- Getting data from forms
- Change tab control color
- Re: Opening A Network Directory
- Refresh records - deperate!
- Embedding a newline in strings
- Environ("home") through Citrix NFuse
- nodata event in forms
- RTE '3077' if a Surname has a Single quote
- Update Data via RECORDSET
- Query to return duplicate options
- forms!formname!field vs. me.fieldname
- Stop from keying in twice
- 97 to 2000 changes
- Form automatically appearing when DB opened
- Update or Cancelupdate without Addnew or Edit
- Repost: Requery Subform
- PLEASE! 3rd Repost! Why is NO ONE answering my (simple) question?!
- Text Box issues
- Repair and compact
- Recordset not updatable
- After Update doesn't
- Automatic Entry of Data into form
- Command Button Code
- Access 2002 program error
- how to close a form based on its text box value
- Cancel Cllick Event Won't Cancel
- ACC2K - How can I generate a large amt of text by concatenating many fields
- Creating SQL Connection
- Save
- search in a form
- Copy Value From Previous record Using Only Command Button
- Urgent: Improper Shutdown Corrupted Database
- Save
- Reusable Form Part II
- Why do I get Runtime Error 2501?
- AuditTrail() function
- Save
- PrintSelected Records from DropDown Box
- How do I refere to a control in a form???
- Error handler 2003
- Finding NextRecord
- Reusable form?
- inserting calculated value from a table with checkboxes
- Workgroup function
- pivot chart
- testing for a Reference from another mdb?
- Simple SortOrder Emulation
- Calendar event fails?
- Sentence Case
- Repaint problem
- Using Variables in place of Field Names
- Populate ListBox with different query using openArgs
- Help from an expert needed (List Boxes)
- Re: Time calculation
- Database Tracking in MS Access
- Cannot reference control
- Delete a related record
- Passing variable
- Voici LE Moyen de Faire Beaucoup D'Argent Facilement !!!(TO SEE IT IN ENGLISH , JUST GO TO THE BOTTOM )
- Calculating a field based on a lookup range
- maximize db window
- Using Table Fields to populate a Textbox
- Last User
- Formate text in a form (Access 2000)
- problems, still
- Form / Subform Reference Error
- Retrieving the most recent date in a recordset
- Pulling up a record from a combo box
- How to handle error loading Picture property in Image frame.
- filter by form question
- Remove all punctuation
- Item not on the list.............yes it is!
- Re: Easiest way to add field data via a Command Button
- Eratic code execution
- Re: Grid Control
- Calendar control
- Query by form Output format
- Hiding multiple subforms
- Ken or Doug? -- another SQL syntax stumper
- Input data form
- use of ISNULL()
- Criteria help in a query
- Textbox Query Question
- Textbox query question
- Detecting Running Applications
- How to Get AutoNumber after Insert
- repost Q: screen.width replacement for a2k2?
- Passing Params
- odd thing happeningwith subform/new record
- Coding a button
- Access 2003 crashes after editing/creating code behind forms
- instr() function
- Instr function working
- Code Problem?
- Best way to check for deletion of data
- Help with Requery
- auto import
- Default Value based on Criteria?
- Default Value based on Criteria?
- Clear text box
- Refresh a recordcount of subform
- Workgroup name
- For input of new record prompt user with previous record's fields
- Access 2003 - form property not working with 'medium' macro security
- Queries listing
- No response
- Sync'd combo boxes must update recordset
- combo box to make textboxes display?
- Compile, Crash, Scream
- Another ComboBox ?
- Can Click Action Act Like On/Off
- Re: Tutorial for Access 97
- Access 2000 Unexpectedly Quits When You Run Code to Close an Object
- Multi-control problem!!!
- Filtering a SubForm
- Required combo box
- Error Handling
- Record Navigation
- error ???????
- How-2 Make A TextBox Flash On A Specific Date
- Tough problem please help
- Change fieldtype
- Setting Code to execute when user changes records
- SetLinkCriteria From Subform Tab Control
- Dumb Question that I can't find the answer to.
- Dimming Menu Items
- Changing dispay order in datasheet mode
- load listbox function buc Access 2000
- Coding property of the controls on subform
- Logicals - Efficient design or not
- TextBox Text Property
- switch between two subfroms
- autonumber and subform
- Re: Tutorial for Access 97
- DLOOKUP FUNCTION
- call procedure from another module
- SQL Insert gets syntax error but works in Query !?!
- ID with Alpha
- Requery from seperate mdf file
- Validating an entered directory/filename
- autofill field if blank
- Refresh data after search
- Run time error 13 - recordset find
- use of Array to filter by
- Array in Filter
- End user queries
- Data Duplicatiion - Please help
- Which event shall I use?
- #Error in fields on a form subreport
- unbound listbox in subform update? (Access 2000)
- Hover-button effect
- Preforming calculations in query
- Lebans or other Raw Binary Image Storage
- OpenDatabase Method
- Mouse Wheel
- Output multiple lines to text box
- Gant Chart ???