Search results

llkhoutx, Thanks For your help!!

Casey, Thanks for the reply! I set up the field so it is bound to the table. When I do this and add records, I get all the fields written in the first record except the field in question. The other records are written fine. An additional record is written with the field in question but all...

I am having a strange problem with a continuous subform writing to a table. I have 8 fields that are bound to a table and 1 field that is unbound. The unbound field is a field that is pulled in from another form. When I am entering in test data into my subform, all the data is written to the...

Thanks for your help! I think this will work.

Right On Casey, Your suggestions worked great! I have one item however, that is not working out. My form that is bound to the invoice table has two fields that are unbound. (Total and Invoice_no) Each item on the invoice form gets written to the invoice table. I need to get the...

I have a form with two subforms. Both subforms are based on queries. There are two tables that I need to write the information to. There are no relationships between the two tables. I can use DAO to write unbound fields to my main table, but, I need to find a way to write subform data to my...

String AlanS, Thank you for your reply. I am having problems with the coding... I am new at this and need just a little more guidance as to where the code should be placed.

I am trying to add an incrementing 4 digit number to the middle of a string. The incrementing number is not working. There must be a better way of writing this. The result I would like should look like this: LB-0001-02. Where LB is static, 0001 is the incrementing number and 02 is the year...

Calculation Pat, That worked great! Thanks for the help!

I have a subform that is a continuous form in Access. In the subform, I have hours, unit price and total. I want to be able to have multiple lines of items and have the grand total show up directly under the totals column, no matter how many or few lines of items I have. I tried to place the...

Nz() function Does anyone have any examples of how this Nz() function should be set up for my situation? Any help would be greatly appreciated.

I am having a problem with calculating 3 fields to get a total for a record. The three fields that I am working with are: Quantity, Hours, and Unit Price. With Quantity or hours, either one of those two fields can be blank. I need to create a calculation that will work around blank fields to...

I need some assistance with my forms. Here is my situation: I have a switchboard that I can go to my active_cert form. On this form I have Agency_ID and a combo box, labeled combo30 that queries my cert_no table. I want to be able to have a control button on my active_cert form that will...