Search results

Put this on the onclick event: If Me.Checkbox1.Value Then Me.checkbox2.Value = False You could probubly also use an option group. HTH

If you can have it enter the default value after update of the previous field. That is the only way that I know. To do that type me.field.value=your default value [This message has been edited by adz2013 (edited 02-06-2002).]

Look at the "Wildcard Peramiter Query" quetion on this page. I think you will find your answer there.

Try this in the onOpen of the report: Me.ReportFooter.Visible = MsgBox("Would you like to see the Report Footer?", vbYesNo, "show Report Footer") = vbYes HTH

In the table make the ip address the primary key. Or you can just index it. [This message has been edited by adz2013 (edited 02-06-2002).]

Format the field to a fixed number.

Setting up a parameter is a great idea it will narrow down the number of queries in the database.

Each query should have the fields that you want in your form.

The message is fine it is just letting you know that some records can't go in because they would create dups. If you are going to run it on a regular basis create a macro and the first field should be SetWarrings NO the next field should be OpenQuery and you can have all the queries run in one...

create a query for each form. A form can have a query as a data source.

One way to prevent them is to have a primary key and anything that has the same primary key will not go into the table. Then you have no dups. To get rid of the ones you have create a duplicate query using the wizard and delete them.

I am not exactly sure I understand what you are asking, but I think you want an append query. Change the make table query to an append one and the old records will not be erased. HTH

only post a question in one forum please. Check over in the query forum for your answer.

Open a query in design view and bring down both tables. If the Student_ID is in both tables then link them by student_ID. Then in the first field type Rec:IIf(Status="recieved",Date) In the second field type Com:IIf(Status="Completed",Date) Under the criteria for the first two fields type Is...

if you are asking for a start date and a end date. On the report put a text box and in it put =[Enter Start Date]. Then put a second text box and put =[Enter End Date]. You must put the same wording in the text boxes that is in the peramiter in the query. Just put a = in front of it. Hope...

Try =Sum(PDI)+Sum(PDRN) in a field at the bottom. or make two text boxes at the bottom and add PDI and PDRN seperatly. Then make them invisable and make a third text box and use =Sum(PDI)+Sum(PDRN). Give that a shot.

Make all of the fields the same font size and type. Align the fields so they all start at the same point. I would align the labels and the text boxes. Anything else just play around with it.

In the design view on the tool bar there is a button for TOTALS. Click on that and then above sort there is a totals field select Max.

Thank you LQ

I have a student form it has all the info on a student. Instead of using the menu item find I want to use a combo box. On the top of the form is a Combo Box. In the combo box is a list of student names. I want to select a name from the list and have it find that student record in the form...