Search results

I fixed the issue. I had another program being called too. Your code was OK. It works like a wonder! Thanks!

1st line: Private Sub Form_BeforeUpdate(Cancel As Integer)

Still get the compile error, expected identifier

Thanks for the reply, but I keep getting a compile error. Here is what I have for the before update event: Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.Dirty Then If MsgBox("Save Changes?", vbYesNo) = vbNo Then Me.Undo End Sub

I have an inventory database that tracks all of our parts. I have set up an "Edit Inventory" form so that users can update pricing, vendor, etc. The problem is that they sometimes inadvertently change another field without knowing it. Is there a way to set up the "Save" button to only save...

Mr. B - Your wise words gave me the direction to look and I was able to resolve my issue with ease. Thank you for your expertise.

I have a database that stores project information. The key items are "job number", "material type" and "material amount". We have thousands of "material type". Each project may use the same "material type" in several different sections. I would like to be able to sum the "material quantity" for...

I had a problem with Access 2007, so I did a compact and repair. This is a split DB with tables/data residing on a server. Now when I open the front-end and it tries to open Switchboard it says, "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting...

I renamed the control source on each if that is what you meant. Did you mean in the SQL or elsewhere?

I tried in the CustomerName field and when that didn't work, I tried the other fields one at a time. The reason I zipped the file is because the original exceeded the 100K limit.

It then asks for txtCustomerName? I've attached a screen shot of the report in design mode.

This is the query used to display the info. When I run the query everything shows as it should, but the report displays #Name? errors. SELECT CustomerData.CompanyName, CustomerData.Address, CustomerData.City, CustomerData.StateProvince, CustomerData.ZIPPostalCode FROM QuoteData INNER JOIN...

I know this is something minor I'm overlooking, but it is driving me crazy. I have a report based on a query. CustomerName is entered and the address, city, state and zip are filled via a query tied to the CustomerData table. I run the query and the correct data appears. In the address field I...

Oops, I know it had to be something simple. Thank you very much.

This problem has reared its ugly head before and I've been able to work around it. Now I need this to work. Table fields are PartNumber, Model and Description. PartNumber is filled in via a drop down. Model is filled in with [PartNumber].[Column](1). Model fills in just fine, but Description is...

Paul, you are always so helpful and quick with your replies. Thank you once again. I do this every few months and I know it's simple, but I just can't remember the details. Maybe I'll remember this time.:)

I've created a new table in my backend database. How do I link it back to the front end?

Still not sure how I should use Dmax. My table name is POData and the field is PONumber. I want the default value to be the maximum number in the PONumber field +1.

Thank you John!!! The subform idea works great. That solves 95% of my problem. Now...how do I increment the PO number. I just want to add 1 to the PO number in the last record and have it appear in the appropriate form field.

I will try my best to give as much information as possible in this post. I have a purchase order form. The form allows the user to input one item into the purchase order. This becomes one record. At times there are several items that need to go into one purchase order. At these times the steps...