Search results

Hi Thanks for your replies. I have managed to determine where I went wrong. When launching the form for a test the elements were hidden prior to the start and I had been setting the focus of the subreport prior to making it visible. Makin the report visible then setting the focus allowed...

Hi I have a report that in standalone form for a test that changes the heading dynamically according to the test being administered, when it is to be printed. However I have embedded the report in a form for administering a test using the computer. Unfortunately I am finding it difficult to...

Hi I have used MAJP's suggestion regarding variables and so far so good it is working correctly. Once again thanks to you both Regards Jeff

Hi Sorry for the delay. Many thanks for the suggestions i will try them out and see which works best. Regards Jeff

I have a query which returns a single record based upon using DMax on one field and a lookup value from a form on another. Run in isolation the query correctly returns a single record but when I try to use the query as a recordset it returns the above error. The cause of the error is the...

hi I apologize for the delay in replying, but have been out in the jungle with no internet for a few weeks. I will look at restructuring the table I think and take it from there. Thanks to all for your advice. Regards Jeff

I am writing a database for use in a casino and am looking for some advice regarding the linking of tables. Generally everything is fine apart from the creation of a query which returns duplicate values which I think is due to the way I have structured the data. There are three linked tables...

Hi Discovered that I should be using continuous rather than datasheet and it works okay now. Best Regards Jeff

Hi I have a form with embedded sub-form in datasheet view, and all data displays correctly, the problem I have is in formatting the sub-form to match the main form. I would like to remove all headings, background color etc. and leave only the data showing, however I am unable to achieve this...

Hi I have been trying a few different ways to populate the field but as I am accustomed to using Excel VBA perhaps I am approaching it from the wrong standpoint. The payments table has three fields, two of which appear on the form, Customer ID and Payment, payment is a required field, the...

Hi Thanks for the reply, I will try it out and see how I get on. regards Jeff

Hi I have a simple database recording payments made by customers, just two tables and a form, the tables are customers and payments and data is entered via the form. Initially the payment date was entered for each records from the form but I am trying to autofill the date in the payment table...

Thanks I will give it a go and see how I get on Regards Jeff

Hi I am currently transferring a system used for discounts from Excel to Access and would like some advice. I believe that what I want to achieve will be possible in Access Reports but would appreciate any pointers. What is very easy in Excel is a little more complicated in Access, but overall...