Search results

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...

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 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...

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...

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

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...

Is there anyway to auto populate one field in a form with data from the last record?

I have spent many hours on a report and don't want to start over, so.... The report is table-based and a user wants one more field added. Sounds simple, right? I have a query that returns the value I need for the new field. How do I add it?

I need to add a number to my inventory table based on a query. I want to add quantity_received from one table to instock in another table. There will already be a number in the instock field. What sort of query should I use. I already have a query to return the value I want, I just don't know...

I have set up a macro that among other things outputs a report into PDF format. I set it up to automatically go to the correct directory where I could also put in a file name. Is it possible to have the file named automatically from a field in the report? Specifically I want the PDF file to be...

I created a report based on a query. The creation process goes fine and I am able to run the report, but when I go back in to make design changes, Access crashes. I started from scratch and recreated the report with the same results. Below are the "details" of the crash: Problem signature...

I have created a report that will act as a purchase order. I want to have a field that will act as a point to put a reference number. This number does not need to be stored anywhere. One criteria for the query that the report is based on is vendor name. When you run thew query or report, it...

I have a query that returns all the data I need for a report. PO data is stored in Table1. One of the fields in Table1 is VendorName. The address and account info for that vendor is stored in Table2 along with the vendor name as stored in Table1. How do I get the address, city, state, zip and...

For some reason the dates and times stopped showing up in my reports. They are displayed as #Name?. The reports have =Date() and =Time() as I believe they always have. Not sure what changed to screw things up. Any ideas?

For some reason, my switchboard manager isn't working. Not really a problem because I can edit the table. I need a list of commands such as "4" opens a report and "1" opens a form in add mode. What is the command to run an append query?

I have created a new table in the backend of my database. How do I link it to the front end? Did I do this the right way or is there a better way?

I am using Excel 2007 and am having trouble with certain numbers. The cell formatting is set to general number. When I type in 12-2896 (part number), it gets changed to Jan96. When I check the formatting, it has changed itself to a custom number into a date format. It only does this with a few...

I have a report that lists among other items "Part Number" and "Part Description". Both items are stored in a table called "CustomInventory". I have another table that stores items for a work order. "Part Number" is stored in this table called "ProjectData" according to the project. The part...

I have searched the forum for the amswer to this question and have found something that partially works. I want to input info to a combobox. The table holds partnumber, description,cost and weight. I choose partnumber from the dropdown in the combobox and want description, cost and weight to...