Search results

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

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

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

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

Hi, I am trying to create a screen, where data entered into fields will affect other fields on the screen. Specifically, I want to set up a field that if the user enter's a specific code, this will protect a couple of following fields following it, or enable them if the code is changed to...

Hi, I am very new to MS Access, so please excuse the potentially simple question. I have created a two forms off the back of a DB which I have built. I am trying to add functionality which will enable me to auto-close the form on entry if data does/does not exist on a table. I have managed to...

Hi, I am still very new to MS Access 2000 but have come across a problem which I do not know how to resolve, even if it is possible. I have set up my DB and added all the relationships. A couple of the tables have an autogenerated number as one of fields and this is the PK on each of them...