Recent content by Papa_Bear_1352

Hi RG Initialy, the 50 records on the subform each with 4 date fields will be null. I want the user to enter the first date and the code will generate dates in the other 149 fields according to certain rules. The code will not work if any of the other records are selected. These dates can then...

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 Again I tried putting the following code in on_error event MSGBOX("on errrr " & ERR.NO) but it was never displayed, on_error event never invoked. In after_update, ERR.NO is zero. Steve

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...

Thanks Hayley and fizzio. Took bits from both replys and it works great. Steve

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...