Recent content by Gethzerion

OK, understood. Many thanks to all of you for your help.

I don't know if this would work, but the command to requery the form would be simply: me.requery Place it it in the event on click for the command button before its opens the report to be printed.

To: GolferGuy Yes the code you posted does appear to work. No error messages either in comiling or operation. So many thanks :))

I seem to recall if you are using an SQL statement to store dates, you need to use the DateValue function to store them correctly - ie so they don't change to US format.

Me. refers to the active object, typically the form that is open at the time. So instead of writing out the entire form name to reference, in your case, the checkbox you can shorten it to Me. Forms![MyFormName].Checkbox1 is equivalent to Me.Checkbox1

Thanks again guys, I realy appreciate the help. At the risk of sidetracking this thread can I ask: (1) Why shouldn't we use the 'Call' statement? Can anyone point me to a knowledge base article or similar on this? (2) What is the drawback to using "AllForms" compared to looping through all...

Hi Folks, Yeah, To both GolferGuy and OlcayM, I twigged the issue with defining it as a string rather than as an object, specifically as a form, as I drove home. Then I wondered why I had set it to be an object. Changing the received variable to type string makes both my method and OlcayM's...

Hmm sorry, that doesn't work. I get a compile error - "Type Mismatch" pointing at the call statement.

K, The database I'm currently building is growing at an exponential rate, and I'm bored of typing in the same code to check if a form is loaded before opening it, and then closing down the old form. So I decided to write a vba script to do this for me Option Compare Database Option Explicit...

If this doesn't help, then please be kind in your response. My understanding of archiving is as follows. Firstly create an empty table (if one doesn't exist) that is a duplicate of the table you wish to archive records from. The only important change is that if you have used an autonumber...

Thanks for your quick response. So I can go up to 2GB using a BE of JET/MDB? If I did decide to use the free version of ACCESS 2005 SQL Server, aren't these freebies only free until used for business???

Hi, Have been asked to "update" an archaic database for a consultancy firm. The existing database is approx 20+ years old and appears to use .DBF files for storing the records. Now, the DB itself I can do, but I've normally only written DB's for one or two users. So before even considering...

How do you want the user to select the number of months worth of records? In the QBE, for the query, under the date tag field, place in the criteria row a >=DateAdd("m",-x,Date()) Where x is the number of months

Maybe this will help: Appointment 01 Test 01 1111 Alpha1 £0.99 2222 Alpha2 £1.99 3333 Alpha5 £3.25 Test 02 5555 Alpha15 £2.00 Test 03 6666 Delta9 £5.00 7777 Delta12 £2.25 This is an example of the data that needs to be entered.

Hmm ok. So if I've understood correctly what you have written. I would use a pop up form to enter the test codes? The FK would then have to be manually trasnferred (albeit through VBA) into the link table? As an un-tested suggestion, based on the recordset not being updatable due to the join...