The user clicks the plus sign to expand the subdatasheet, and the cursor goes to the Name field. I tried the SetFocus action but it only highlights the...

I have a paper pre-printed form I am trying to duplicate in a Access 2000 report. The paper document has 2 sides withe the front being filled in the first...

-- Hansford D. Cornett

I'm now understanding why Microsoft intends to kill ACCESS by 2010. I have a database orginally written in Access95. As each new version of Access was...

Hi I have a main form with a subform containing fields of data, I am trying to create an audit trail system using the code below from the microsoft kb...

I have a form with four buttons in the form footer that (1) open a query, (2) open another form, (3) delete some files from the user's c:\ drive, and (4)...

Hi I have a form that runs a report based on the dates entered into two text boxes, i need to add a Where statement like I have in my macro but need...

I have read many of the other posts on here regarding the issue I am having. I still can't seem to figure this out. I have a rather large database I am...

I would like to compare forms found in a production environment mdb with the same forms in a development version of the mdb. Are there any good tools for...

I am trying to use the Access 2003 Form Wizard to create a subform that will response to a toggle button that I created and to display that subform within my...

Any ideas on how I can pre populate a text box on opening a form but still allow it to have a separate command source? E.g. I have a sub form with a text box...

I am a new Access user and was asked to create a form to be used for call tracking. I have the primary form created and was wondering if I can invoke a...

Hi all, Using a table as a Recourd Source of a form is straitforward, but why is Select statement is also used as Record Sourc of a form. Clara thank you so...

Is there a way to disable the message box "A program is trying to automatically send an e-mail on your behalf. Do you want to allow this?" when using this...

I would like to compare forms found in a production environment mdb with the same forms in a development version of the mdb. Are there any good tools for...

I was coding a form with groups of checkboxes that must have at least one checked before the user can get out of the form. I used the "Cancel = True" code...

Is Creating a VIEW OR Updating a VIEW possible using SQL code in MS Access? Here is the code for Creating a VIEW that I tried (unsuccessfully) to use with MS...

Hi! I have added a textbox with a hyperlink to my form. I want the textbox to show only for the records that have a hyperlink. How do I make a text box show...

I have a simple form where all of the fields are unbound. There is one combo box which is initially populated by the query qryChaseBAIFilesCombo, and it is...

Hi all, I need to have this code search multiple fields, but I keep getting "Expected end of statement" on the Me in the second to last line: If Not...