Search results

I want a running total in a query. I have used a DSUM in the past but needed help with that one also. I have looked at several threads, copied and pasted and still can't get this DSUM to work. This is what the query looks like: SELECT InfoTable.InvID, InfoTable.Level, InfoTable.Desc...

I am trying to create a CSV file using the ImportExportText / Export Delimited. Everything is working except the fields that are text in the table that resemble numbers are exported as numbers (000 exported as 0 or 067 exported as 67). These are GL SubAccount fields and when I import the CSV...

I am trying to use a macro using ExportWithFormatting to export a Table to an excel file. I would like the file name to be a field in another table. This field is also in a form that is open if that is preferable. There are many threads here and elsewhere and it seems this can't be...

We are running Office Professional 2016 on a server that is not connected to the internet. When I click on the Access program, for 8-10 seconds it appears it is trying to connect to the internet "Getting featured templates..." Once that is over I can click on a database and it opens within...

I am trying to create a running total in a query. I googled and found something using DSUM, it appeared to be what I wanted but I only get #Error in the field, not running totals. I want to have a running total for each InvtID that resets on each new InvtID. The InvTranQuery totals by InvtID...

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

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

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

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

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

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