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

Re: Where statement causing "This expression typed incorrectly or too complex" error I did remove all special characters (%) and spaces from field names and also removed quotes from the 0.05 but am still receiving the error. Any other suggestions?

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

Ok so I took some tips from your presentation. Also added a For statement that sets the control based on the iteration. This reduced my code from 175 lines to 85 lines just for this section. Thanks everyone Dim Qty(4) As Integer Qty(0) = Qty1 Qty(1) = Qty2 Qty(2) = Qty3 Qty(3) = Qty4 Qty(4) =...

Wow that's great! Thanks I was wondering if a function would be the way to go and I could just pass Qty1, Qty2, Qty3... plus all of the other needed variables and pull out the results. Where I got hung up was on the controls for each Quantity. When the price for a given quantity is calculated...

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

I can ask but my experience has been that multi-billion dollar corporations aren't very receptive to requests for changes to IT systems by relevantly tiny suppliers :banghead:

Thanks for quick response. I'll have to figure something else out

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

The article explained the Rnd function but didn't really give a solution to how to avoid getting the same first seed each time. The 4th post on this thread gives the solution with creating your own randomizing function with this code in a new module...

I took pictures showing the results of that SQL if I remove the Top 1 clause. As you can see, it does not appear to be sorting by the Rnd(ID) field. Also I closed database, re-ran the query and took another picture. Exact same numbers are generated. See attachments

If I refresh the query, or close the query then re-run, it does generate a new top record. If I close the entire database then re-open and run the query, it goes back to the initial record every time. Here is my SQL (loc_ref_ctl_no is a unique identifier):

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

That worked. Thanks for your help

Yes it does appear to have a unique field called [OrderNumber]. The data in that field all begins with a P then has about 9 numeric digits. As far as I can tell no two records have the same OrderNumber. Assuming it is unique identifier, how can I take that and create a field in the query that...

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

Thank you for the suggestion. I will try to better organize it next time I request help. This query searches through a few million transactions and selects the transactions I'm looking for then cross references that to other tables for more info. I wish I could simplify the query but...