Search results

If you use a combobox for the OperatorNo on the MachineProduction entry screen, the LimitToList property and NotInList event will get you where you need to go. I would suggest looking up the above mentioned property and event to acclimate you to how it works. But in short, it would go something...

Why don't you try posting your code that includes your actual file name. We might see something that may not be obvious to you.

You need to put the error trapping in the OnOpen event of the form, and then set Cancel=1 if you get a certain error. Or from your OnActivate event, if you hit the certain error, DoCmd.close

You need to create a relationship that enforces referential integrity to cascade deletes.

Tools->Options, Click the Advanced tab. Select Edited Record from the Default Record Locking option group.

try "SELECT transaction.* FROM [transaction] WHERE (((transaction.Invoice_date) Between #" & forms![form_rep]![from] & "# And #" & forms![form_rep]![to] & "#));"

Tools->Security->User and Group Accounts... Click on Print Users and Groups Button on the Users tab.

I'm not sure, but probably

I had this happen to me a while back on a database that had become corrupt. Repairing didn't fix my woe. I created a new database and imported all of my objects from the corrupted database, ran a repair, compact, then set my startup options.

Open the module, and select tools, then references. Scroll down to the Word Object library and place a check box beside it.

Did you check the references to make sure you have referenced the Word Object Library?

The full command line, with parameters, for the DoCmd.SendObject method is DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile] So if somewhere on your form you have a field which displays the project name, ie...

Total: DateDiff("n",[End Time],[Start Time]) This will give you the difference in minutes.

This should work: dim db as database dim rst as recordset set db=currentdb set rst=db.openrecordset("yourFindDupesQuery") if rst.eof then do your no records stuff else do your found records stuff end if

My main issue was that I didn't want two tables or specifically a temp table. It wasn't really an Access question per se. I'm trying to accomplish this programmatically in VB with SQL server as the db. I have since come up with a solution using disconnected recordsets and arrays. Thank you very...

I know this may sound a little strange, but I was wondering if I could query an array or a temporary recordset with a table. Like if my array or recordset contained the following: 9/3/2002 0 9/6/2002 0 9/12/2002 0 9/15/2002 0 and my table contained 9/6/2002 50 9/12/2002 125...

On which line of code are you getting the type mismatch error?

I can't imagine any other technique that would be more correct. Unless, Pat Hartman herself pipes up with a reason why this method is incorrect, I would go with it.

It's not obvious to me why you can't link the tech to the employees table. Did you attempt the suggestion I gave? It is indeed possible (and correct) to add a table more than once in relationships design. Just add the Employees table again and create the relationship between the Orders table and...

Refer to Audit Trail