Search results

Heres a calendar for you: Open the calendar form. If you want to change anything open the calendar form in design view and then double click on it. If you want to change properties, go to View > Properties.

But basically for the criteria in the query, under the Date (From) you put: >=[Forms]![FormName]![txtDateFrom] and then you put this under your Date (To): <=[Forms]![FormName]![txtDateTo] FormName = Your form name txtDateFrom = the name of the text box that you created in the form for...

Hello, First you have to create a query and include all the information you want. Include the date fields. Then you have to create a form based off the query. Create two text boxes for Date (From) and Date (To). Then create a button to open up the query. That is it. Well, sorry that...

Maybe check this thread out: http://www.access-programmers.co.uk/forums/showthread.php?t=154685&highlight=password

You can look at an example that is on the Northwind.mdb, which should be on your computer. Go to C:\Program Files\Microsoft Office\Office\Samples Open up Northwind.mdb and go to the Sales Reports Dialog form.

Put them in an Option Group (Symbol look like a square with 'XYZ' on the top). Should be in your toolbox.

Maybe just post your DB for me so I can look at it. I used MS Access 2000 so, if you could, make a copy of your DB and convert it to that version. The example I posted is the way to do it, so I don't know how else to help you unless you post your DB so I can take a look at it. Good luck.

OOPS forgot to supply the database. Here it is:

Take a look at the attached database. Open the Main Switchboard...but none of the buttons work and they are not important in this situation. Upon opening and closing the form, user name, machine name, date, time in, and time out information is recorded in the LoginLogout table. You can do...

Look at the attached sample. Hopefully it helps.

Solved it. Lala was right. See the attachment:

Did you put this code ANYWHERE in any of your forms? DoCmd.SetWarnings False ? If you did, you have to put: DoCmd.SetWarnings True I don't know...it is just a thought.

Just ran across this: "Add Total Text Box on Main Form for Totals on Subform" from Mr. Bob Larson's site: http://www.btabdevelopment.com/main/ I haven't looked at it at all, but it seems like it deals with the exact problem that you are dealing with...GOOD LUCK! Post back or send me an...

Ok. Thanks guys for your help and patience with my issue! I will give everyone some reputation. It actually worked the way I thought of....by enabling the Save button a searching the 4 fields to see if they are not null. I appreciate your help.

And Missinglinq. You are right. The Save button does not just Save the record. It is actually there to search for duplicated information. It does other various things too. But when the user adds a new company, to eliminate any duplications, the user then presses "Save" and a DLookup...

I appreciate everyone's help. Maybe the problem is with the Enable feature. Maybe I will enable the Save button, and when clicked it will search to see if all the required fields have information...if they do then it will proceed....if they don't it will ask the user to go back and filled out...

Ah thanks for the example DB, but it is unrecognizable format. I have Access 2000, so if you could convert it, that would be awesome. Again, I appreciate both of your help in getting me through this.

Ok the problem that has arisen is with the placement of the code. The code works fine, but I dont want to put it on all of the fields because after I fill out the first one, and then press the TAB button it will keep on giving me error messages saying I have to fill out the rest of the first...

I am still a little unsure as in where to place the code... I tried in the After Update event of the last field (txtState) but that didn't work correctly.

I am having trouble with the sum thing too. I cleaned up your form a little bit so it looks better. What I suggest is that you search through this forum. But first you can go on your computer to Local Disk C > Program Files > Microsoft Office > Office > Samples > Northwind.mdb. And open that...