Search results

Have a look at the following thread, there are a couple of examples of the sort of thing you are looking for: http://www.access-programmers.co.uk/forums/showthread.php?t=79620 HTH

I think I've found an example of what you're looking for - http://www.rogersaccesslibrary.com/download3.asp?SampleName=CrossTabReport.mdb. The example will produce a report from crosstab query, which you can then ecport into excel if you wish, although the report has a sum at the bottom and on...

Have a look at http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb You should be able to modify this example to suit your needs. HTH

So long as the query doesn't take too long to produce the results it will be OK. The performance of the query is more important than the size.

Have a look at the following example: http://www.rogersaccesslibrary.com/download3.asp?SampleName=ListBoxTypeIn.mdb HTH

I've got at example at work where the user clicks on a button and a calendar pops up with todays date highlighted. The user can then select a date and it is automatically entered into the data field. I'll attach the example on Monday evening after I finish work. EDIT - Just had a quick...

Thanks for the links, I'll check them out. :)

ducker - sorry to hijack your thread pauldohert - Could you upload the database or some of the code as I'm going to be implemeting a system within the next couple of weeks and I'm looking to include something similar in my system.

Yep, you would just need to requery the 2nd listbox (employee records) after selecting the value in the 1st listbox (Supervisor record)

You will need 2 tables. One (Supervisor Table) will hold the SupervisorID (Primary Key) and the SupervisorName (this can be split into 2 fields if you want to use firstname and surname). The second table will hold the EmployeeID (Primary Key), SupervisorID (from the Supervisor Table)...

You will need to use a dynamic query as the criteria will change with each use. Have a look at www.rogersaccesslibrary.com, particulary the 'Create Queries' examples as it shows how to create the type of queries you require. If you're still having problems, attach a copy of your database and...

On the OpenEvent of the form type Docmd.Maximize and this will maximize the form HTH

I've attached a database, which I downloaded from Rogers Access Library http://www.rogersaccesslibrary.com/ a while ago. It may point you in the right direction. There are a few other examples on the site. HTH

You should be entering new details in a form. You should have one combo box for Model and another for Model sizes. These should be set up as cascading combo boxes so that after you select a model, only the sizes available for that model shoud appear. Search the forum for cascading combo boxes...

oops :o Got a bit excited as I thought I had an easier answer :p

Why not use the DateAdd function? SELECT Recipients.Inst_Name, Recipients.Rec_First AS age FROM Recipients WHERE ([dob]<=DateAdd("yyyy",-18,Date()) ORDER BY Recipients.Rec_First; You might have to tweak the SQL statement a bit, but it seems much easier than using a function AND a SQL...

Bob - DateAdd does indeed only check the difference in days, months or years depending upon what is specified, but if someone enters a date, which is more than 16 years from the date it was entered, they are older than 16. DDrew - I've attached the database, it should do want you wanted...

Place the code on the After_Update event, rather than the Change event.

Use the following code on the After_Update event of the textbox If Me.NameOfTextBox > DateAdd("yyyy", -16, Date) Then Me.NameofCheckbox1= True Else Me.NameofCheckbox2 = True End If HTH

A file with the extension .OCX is an ActiveX file, which is why you received the warning message as viruses can be passed using Active X files. In order to use the control, you first need to register it. Have a look at http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q297279 HTH