Search results for query: *

I am working in an ADP. Since I had a hard time customizing MsgBox interaction with a user(ex: making text bold), I followed some advice and created forms I call in lieu of a MsgBox. Primarily I use the Forms to validate new record entries made by a user before a complete entry is recorded in...

You rule. That worked!

I have a problem in an updatable form I have created. I hope I can explain the issue clearly. The detail section of the form is populated by a view I have created containing the following fields: Selected <--a checkbox set to all 0s Car# <--the name of the vehicle(ex: #319, #256, #4) PO#...

Hi all. Quick question. I just set up my first updatable form in an Access ADP! I created an updatable form for a warehouse that receives shipments. The underlying View I created which allows users to enter or change the date a shipment arrives[PlaceDate] is coded as follows: SELECT...

I’m close, but I’m stuck in my attempt to update certain controls on a form according to choices made in other combo boxes. I am working on a program which records weights for shipments. Here’s what I have so far. I have a table named CONTAINERS which lists available cars by type(trains...

Nevermind..figured it out on my own. You can only use RunSql to act upon a table(i.e., INSERT, DELETE, UPDATE). I used the DMax fn() instead. THX!

I have written some code where I insert a new record into a SQL table based on user input on a form if a record does not currently exist for those values. But I then need to find out what the new record number is in the SQL table. The SQL Insert statement creates a new Notice ID in a table...

The DCount fn() was exactly what I was looking for!! It took me a little while to figure out how to set the criteria according to form parameters, but I got it. I have been working from what I thought was a great book: MS Office Access 2003 Inside and Out from MS Press. It’s one of those huge...

I am relatively new to ADPs and Access development. I am creating an appl to track industrial shipments. When a truck comes onsite, 2 weights are recorded..an Incoming(full) weight and an Outgoing(empty) weight. I have a table named SCALE_READINGS to store Incoming/ Outgoing weights for each...