Search results

Reference a field on a sub form (Resolved. Thank You) Hi All I am trying to reference a field on a sub form from a button on the main form. I want to read a field called "Date1" and I want Date1 from the first row, regardless of which row has been selected by the user. The statment used is...

Hi everybody I have used the following command to output to a word doc DoCmd.OutputTo acOutputReport, "stdletter", acFormatRTF, "stdlet.rtf", -1 "stdletter" being a report with the current customers address in the top left for a letter heading. This works fine except that when the word doc...

Hi All When linking a table, "linked table manager" puts in the full file name ie "C:/folder/mdb name/Table name". This is great for one front end and one data back end. I want to copy the front end and the data mdb to another folder, delete all the records and add different data. Of cause...

Hi all I have a form attached to a table, the key being a text field. When I add a record by clicking the star button and enter a dulicate key, I get the standard very wordy error message. Which event do I use to trap this error so I can add my own message. I have tried afterupdate and...

Hi All I have an access form with a list box containing a number of customers, column 0 being the customer ID. This list can show different customers depending on criteria that the user inputs and I select the records by building an SQL command. What I want to do is add a button to run a...

Hi all. What I want to do is write a one off database to insert a field in a linked table preferably not at the end using code. If I use ALTER TABLE, I get the error "can't do this to a linked table!". The easiest way would be to talk the users through the change but there are a number of...