Search results

Carn, I've done a similar thing on a report, I'll post the code and you should be able to apply it to your sub-report. You need to set the Format property of each of the textboxes that you want to change color on the report to 'Fixed'. Then type in the following code: Private Sub...

You'll need to do this with 2 tables. One for the category of instrument and one for the actual instrument. The tables will have a one - many relationship i.e. one category can have many instruments. HTH

If you want the records on the subforms to change everytime the records on the main form change, so that the subforms display the record matching the main form, you need to ensure the Master and Child fields are properly set up.

Try using a listbox to display the results rather than a subform. The rowsource of the listbox would be the query. The user could select the location and date, press a command button (Check Date or something similar), which would run the query and you could then requery the listbox to ensure the...

Place a combo box on a form, Access will then ask if you want to get the values from a table/query or type in the values. Select 'Type in the values' and enter the values you want the user to select.

try >DateAdd("yyyy",-35,Date())

You'll need to refer to your fields on the subform differently than on the main form. The syntax is; Forms!NameOfMainForm!NameOfSubform!Forms.NameOfFieldOnSubform

I can't unzip the file either, I get an error from Winzip saying it doesn't appear to be a valid zip file. Can you upload the file again?

You will need to insert the query as an attachment.

You should have 2 tables (tblPeople and tblQuestions) and the primary key from tblPeople will be the foreign key in tblQuestions.

This may be more of a problem to do with the way your database is setup. It sound as if you have 2 tables - one for students and one for courses. If this is correct you have a many - many relationship i.e. many students can enrol on many courses. You will need to have a link table in between the...

Look at the following example, it should help you to get started http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb HTH

Laurat Depending on what you're trying to do, you may not have your database set up correctly. Does each Clock No have only one Supervisor and Employee? i.e. ClockNo=1, Supervisor=Smith, Employee=Jones ClockNo=2, Supervisor=Bush, Employee=Blair If it does, then ClockNo in Table A should...

The following example should give you an idea http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb HTH

Have a look at http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb

Take a look a the following example http://www.rogersaccesslibrary.com/download3.asp?SampleName=SaveFileToSpecificDirectory.mdb It should give you a start

Use the 'DoCmd.PrintOut' command i.e. DoCmd.PrintOut acPages, 1, 1, , 1 This should print out one copy of the first page of the report Viel Glueck

Place the following code on the forms On_Open event If Me.RecordsetClone.RecordCount = 0 Then MsgBox "There are no items to display", vbInformation DoCmd.Close acForm, "Name of Form" End If

Switchwork This isn't difficult, especially with all of the helpful people on this forum. You'll need 2 tables, TblClients, which will store the name of the client. Your main form will be based on this table and TblJob, which will store each of the jobs that have been done for the client. The...

You will need to tell Access to requery the mainform and not the subform so rather than using comboboxname.requery, you will need to use Forms!Nameof MainForm!Comboboxname.requery