Search results

I apologize for my vagueness, I will try to explain further. First, by no means am I an Access expert, I don't do any coding and use the Macro feature to accomplish most tasks. We are in the manufactured home business and our production line moves 3-4 times per day. I have an Inventory...

Simplified, I have an inventory count and a bill of material. I want to know when inventory will be depleted or go negative by the deductions of our bill of material. I have a BalanceTable that has InvID, Date, ProductionLineStation, and Count. The Inventory Counts are in the table as...

I have made an access database for doing inventory at work. We have an inventory of approx. 700 items that need to be counted each month. I have a subform that is in datasheet view, it has Inventory IDs, product descriptions, UOMs, and a field to enter quantities. On the parent form are...

Bump Updated - I am probably not very good at explaining my problem, this maybe simplifies a little bit. In a report, is there a way to keep a value in a detail field (adj) until a record is found (test) that meets the criteria to reset the field. example...

I work for a homebuilder and earlier this year I wrote an access database to keep track of when we needed to have trusses tested. Each type of home we build have a different style and/or a different number of trusses. Each type of truss has to be recertified after a certain time frame or when...

Worked like a charm, thanks for your help.

I have a =sum() field in a footer of a report. I would like to show a blank if the sum is zero. I have searched the forum, and not found a solution. Any help would be appreciated.

I have a database that was written in Access 2000 and when I try to run it with Access 2003 I get the following Error: Your Sales database or project contains a missing or broken reference to the file 'CRYSTL32.OCX' version 5.2. *To ensure your database or project works properly, you must fix...

We have recently installed new servers with Server 2003 OS and are using Terminal Services 2003. We have installed our old Office 2000. We have an Access database that our payroll department uses to input time for employees. It queries our SQL database for information and puts it into a...

Mike, Thanks for the reply. The autonumber has been working fine, but now I want to split the database and the linked table doesn't seem to pick up the autonumber correctly, it went back to one when I tried to add new order. I have thought about making the order inactive, but there reasons...

I have an access database that I have used autonumber to assign order numbers for several years. I am now wanting to split the database and it is causing a problem with the order numbers. My situation is different than other posts because I delete orders from the table when I assign serial...

Thanks for your replies. The odd thing is that the table was not compacted or was it empty. The user said that they just recieved some sort of error and they exited the form. Very puzzling. I am really needing the autonumber for it's uniqueness not for any sequential reason. This is an...

I have an autonumber field that somehow got reset back to one. Is there anyway to reset this number, I need it to be back around 1900. This is a big problem because I use the auto number as an order number and also use that number to link the options selected to that order. Now that it has...

I currently have a report that shows sales by location for given dates with totals by location. My problem comes when a location has no sales for the period entered. It currently skips that location with no heading. I would like to show the location and show zero sales for the total. There...

Worked perfect Lagbolt, It worked perfect, Thanks.

I am a newbie to access and am having some difficulty with a subform. I have searched the forum, but could not find an exact match to my problem. The following is a simplified version of my problem: Tables: TSerialNumber, TLocation, TSubLocation(Location and SubLocation Fields) Form...