Recent content by Lisa S

Works perfectly - easy when you know how - thanks ever so much!

Hi I have created a parameter query which queries a date field with the criteria Between [Enter Start Date] and [Enter Finish Date]. The question is, how do I tweak this so if all of the dates were required I could just click OK to the 2 input boxes and not enter any criteria and this would...

You need to add the following code to the Form's On Current Event. Private Sub Form_Current() yourcomboboxname = fieldname End Sub

I am going to guess that your set up is a table for your products and a table for your customers and linked via a customer id field in the products table?? Therefore, when you create your query, you need to add both the customers table and products table to the query and add the customer name...

Hi I have also posted this to the tables forum as I was not sure where it fitted in. I am trying to create reports based on the following: I have, with previous help from this forum, created a table which details approx 200 images but holds the path only and the images themselves are in a...

I think I have found the solution and thought Alex may want to try this. After many hours of struggling I took my customer id off the main form and it works. It seems as if you take the primary key field off the main form (the primary key of the primary table)it behaves. If you needed the...

Hi, thanks for the responses I have tried to use the record selectors and I can go backwards and forwards one at a time but if I click to go to the last record and then click the first record button it flickers and then crashes Access. It seems OK one at a time in any direction but backwards...

Hi I have 3 tables, organisations, contacts and calls. I have created a form which shows the organisations as a look-up, the contacts in datasheet view and calls in datasheet view. So I can choose an organisation to view the contacts, click a contact and then show only the calls for that...

Hi, thanks for that Yes, I am displaying both sub forms in datasheet view. The other view I was trying to describe shows the sub forms as you would normally see a single form in design view, i.e. able to move and modify the fields and "get at the fields" whereas sometimes it just shows a white...

Hi I have a form which has a main form and 2 sub-forms. Can anyone explain as to why, when I go into design view sometimes the sub-form shows as a white block and then other times it shows the acutal fields in the sub-forms. Am I going mad or does this happen to other people and why...