Search results

My company's ERP system's database in an Informix database. I am able to connect to their tables through and ODBC connection in MS Access and write queries, reports, etc. It is not possible to change the structure of the tables though. There is one table that has 310 columns in it that I need...

I have a database setup that has 10-15 concurrent users. Recently I setup a module that contains a lot of functions that this database uses. I also have other programs that could utilize those same functions. It is possible that I will need to modify the functions from time to time. Is there a...

Where statement causing "This expression typed incorrectly or too complex" error I have a several sub queries that run to calculate some fields for me including teh field [GP%] which takes the difference between two fields and divides by one of them to get the percentage. Then they get pulled...

I have a very large program that allows users to enter up to five quantities at once and the program returns a price for each quantity. I have the code structured so that the same code runs basically 5 times with one variable for each quantity. For example, take a look at the below code. I have...

Our company has a computer system that allows users to attach PDF files into the system. The system stores these files in tables as an OLE Object when I view the table in MS Access. I am linking to the table through an ODBC connection. If I double click on the OLE object of a given row I get...

A customer provides a forecast in a table which is not formatted how I like it. They have a table in which column 1 has the Part. Then they have a separate column for each week for the rest of the year. The fields show the pieces (if any) for that part that are due that week. Giving me the...

There is a form where whenever the form is closed, the below code needs to execute: The If Then just looks at if certain fields are all null and if so, it deletes the current record. If at least one field is not null, the AppendQuoteCharges routine is called. The form has 4 or 5 navigation...

I'm trying to create a query that generates random numbers for each record, sorts them by that field, then selects the top record. This should randomize the record being selected. I can use the Rnd([ID]) function which does appear to generate a random number. Problem is that each time I exit...

I'm building an application via Access that will allow a user at my company to import a CSV file with hundreds of records, press a button that runs several insert queries which inserts some of those records into our ERP system based on criteria. Each record of the insert query must have a...

Please help optimize my query. I'm creating a report that shows usage and sales of inventory over the past 90 days. In addition, I need to report to list the Last Activity Date for each product. I have a query to give me all activity - CSP IPs. This takes about 5 seconds to run. To filter...

I'm trying to build a query that adds up the total sales for a given product per date. The problem I'm running into is some products have $0 sales on a given day and don't appear in the table I'm querying. How would I get the query to add a record for that day for the given product with 0 in the...

I'm working on a report called Open Orders and when the database loads, it takes you to a Navigation Form. You make some selections mostly from combo boxes, then click run report which runs a query then launches the report. I want the user to be able to click a check box called "Ready Only". If...

I have Access 2010 and am trying to create a cross tab query that will display the percentage of the subtotal as the values. For instance: Current Late Default A 8 1 1 B 15 3 2 C 40 8 2 Current Late...

I created a db mostly through VBA and have spent a few weeks testing and have never seen this error. I finally split the db, and distributed the front end. Sometimes things work fine, but eventually the user gets the following error when clicking a command button or doing some other event...

I have a search form that allows users in input up to 5 fields to search for previous quotes: Customer Number Part Number Revision Number Quote Number Request For Quote Number The results are displayed in a List Box. If the user double clicks one the results, the record opens up by passing...

I designed a database that stores information about a part, then on a seperate form, allows the user to create a quote of that part. We now see the need to attach files at the part information level. There will be three separate fields to attach the files. These files will almost always be...

I have set up a database and thus far only set variables at each form, however, now I see the need to set these variables up at the database level. I am having issues though. For example, I have a Search Form. When the user searches and finds right customer, they can double click it and open it...

I am trying to use the Dlookup function but am running into some issues when I try to use multiple criteria. I have a table that has the a price for a given range of thicknesses. I want the Dlookup to pull the price from the correct range. The ranges are defined by two fields, LowThickness...

I have a multiple item form that displays multiple items and allows the user to edit these items from one form. There is a combo box which includes the value "Other". When this is selected, I would like a text box/label to appear for the user to specify what the Other is. However, when I...

I have a combo box for CustomerNumber that is a lookup from another field. When the user clicks on the down arrow, it shows CustomerNumber (the primary key) and in the next column CustomerName. However, when the user selects one, it only shows the Customer Number in the combo box display. Is...