Recent content by LogicDoc

deeply in debted for all the help.... DCount("[meter serial number]" & "[Order type]","table1") this is taking place on click to save to table. what the rest of the code look like to compare these to table fields to the two form fields and decide if its duplicate or not....sorry i am...

I have a form to input data to a table. what I am trying to do is: if i enter a duplicate serial number then i want to check another field to make sure the serial number was entered as a different order type. i.e dropdown list fields are ....new order,repair order,replacement order, etc... if...

The memo field worked perfect. Thanks....

Hello, I currently have a listbox. (list32) that is populated with results of a query. I would like to doubleclick on an item and have it open a form that displays the listbox record i clicked on and a "notes" field. Its my understanding that the table fields are limited to 255 chars so i was...

Hello All, I am an Electrical controls design engineer based in North Carolina. My exposure to writing software is limited to plc and HMI (OIT) type programming. I have recently been given a new hat to wear building the ocassional DB in Access. Its a new language for me so forgive me if I have a...