Recent content by smjohns

Oh I forgot to mention that the above dlookup statement is placed in the Control Source option for the output field.

Hi, I am fairly new to Access development so please excuse the newbie question. I am creating a form which has a drop down list field with various values. Depending on what I select, to view only protected fields are populated using a dlookup statement such as the following...

Hi Rich, I have tried your code, but I think I must be getting a little confused....DOH. This is how I have coded it: Dim rs As String rs = "Forms!Client_Setup!" & Me!Client_ID & "" 'MsgBox rs [Forms]![Client_Setup].Requery Forms!Client_Setup!Client_ID.SetFocus DoCmd.FindRecord rs The...

I am not sure if it is me being a bit thick, or just my inexperience with Access. Either way, I am struggling to work out how either method would work. There are two routes, where a requery of Client_Setup screen is necessary and that is on clicking the save button and the close button on the...

Navigation Buttons Help Hi, I have created a screen which lists all records and have two buttons on the screen to add a new record and amend an existing one. I also have a piece of code 'on activate" which does a me.refresh. If I select a record using the navigation bar and then hit the...

Hi Pat, Thanks for you help, that works perfectly. Cheers. Simon

Hi, I have set up a new record creation form and I have set up three of the fields as combo-boxes which are restricted by data entered in a field earlier on the screen. This works quite well unless the user changes the data in this earlier field. If this happens, the LOV's are not refreshed and...

Access 2000 Reports Questions (Part 2) Hi, Ok still new to Access and not sure how to do the following. I have created a report, which displays the data from a single table....pretty much easy going on that. The problem, is that I need to provide the user with the ability to restrict the...

Thanks the prez, took some effort but got it to work at last !! Cheers Si

Hi ThePrez, My humble appologies, you were completely right about the main form record being saved when I clicked on the sub form. Unfortunately, I need a message to be issued before this happens. Do you know what event I can use to trigger a "are you sure you want to save" message for the main...

Hi, Thanks for the quick reply. I shall give these a try over the weekend. Regarding your point 2, the changes on the main pages are not saved when you click on the sub form although the changes I make to the subform are saved as I update rows. If I click on close when the cursor is on the...

Hi, Can anyone help with the following questions I have on Access 2000. I am still fairly new to all this so hope these questions are not too basic. 1) I am creating a form where certain fields need to be available for entry or protected based on data entered in other fields. I also want to...

Thanks, that worked a treat and I ended up with a script like the following: Thanks for all your help Simon

Hi, I am completely new to development (I am a software tester by trade) and have hit a smallish problem, whilst creating a screen on an Access2000 DB. I want to limit a field's drop down list based on a three criteria: Firstly I need to extract all Reservation ID's off the reservation table...

Fantastic. I have now replaced all my forward facing auto generated ID's with just number fields and added your code. Rather than adding it as a default number when you enter the create new record screen, I have added the code to just before the save action is performed. This means that if two...