Search results

I receive data in 10 separate excel spreads on 10 different balances. In the spreadsheets there are 100s of calcs that go into the standard deviation. I need the standard deviation(sd) from each of these spreadsheets in a balance table. Currently, we manually input the sd for each balance. I...

I have an older program that has a lot of entry forms. All of the forms have several entry fields. A slightly visually impaired person is being asked to do entry in this program and is having problems with size of the font used in the entry fields (too small and not dark enough). Is there a...

I added a combo box called [search#] as the first field in the form. I made search# see all the values in the column [insp_num]. I have tried the following code in the afterupdate event. The code bombs on the findfirst function. Me.RecordsetClone.Findfirst "[Insp_num] = " & Me![search#]...

I have a problem with program that tracks inspections. I want to open a form in edit mode and have it automatically go to a specific inspection number (insp_num, which is a unique text field in the table). I want the form to populate with the data from the record that coresponds to the...

Okay, I followed the other threads on IsLoaded and solved my problem. Much thanks guys. GGuy

Rich and Pbaldy. Thanks, I think that is what I am looking for. Unfortunatley, when I insert the code I get a compile error on the isloaded(). The error states "Sub or Function not defined". Could it be that I need to load an additional reference. GGuy

In the on current event of a form (Form_B) I am pulling data from another form (Form_A). The problem is that sometimes I will need to go to form_B when form_A is not open. When that happens form_B will error out. I need to figure out some form of an if statement to bypass the code that pulls...

Screen shot I have a screen shot but can't seem to insert it in the reply. Thanks Pat, I was hoping there was a simple solution or some kind of addin that would similate a very nice feature that exists in Approach. There are a lot of things that stink in Approach like scripting and queries...

I have a task to convert several Approach databases to Access. The user is very interested in keeping some of the functionallity that is normal in Approach. The ability to use the index tabs that are displayed on the top of the screen in Approach allows the user to jump from form to table to...

I need to run several begining/ending date parameter queries. All of the queries are on based on separate unrelated tables but for the same date range. I would like to be able to run a procedure to enter the begining and ending date parameters, one time and run all of the queries. One of the...

Thanks Rich that worked, I see the total for the inspection type that I am requesting and only that inspection type. I have another problem though, the sum total for inspection type repeats for each record that is queried. For example, if the total was 1600 ag-use records, then the field will...

I see what your saying but I need some help with the filtering part. I am pretty new to Access report creation. The is the reason I like the Dlookup function is that it has a where clause. For example, I will want to show the totals for an inspection type called AG-use but not Non-Ag-use or...

Because I don't want to show the totals for all the inspection types. Only some of the inspection types. Also, when I get this fixed, I will need to show other totals(same date range) from a different query on the same report.

I am trying to create a report to show totals for several different inspections types based on a date range. Currently, I only have three fields in the query, inspection type (group by), inspection type (count) and inspection date (where, date range). I am trying to use a Dlookup to show the...

The problem was that out of 10,000 records I had a couple with no data entered. I put nz() around the [CalIntvrl] and all is well. Thanks for the help. GG

In the criteria field for LastCalDt I added <DateAdd("d",-365,Date()) which works just fine if I would want only weights that are more than 365 days past their last calibration. The problem is that each weight has a different interval of time that it might be required to be recalibrated...

I have a table that is used to remember how often certain weights need to be recalibrated. The table has a field to show the date_of_last_calibration (LastCalDT) and a field to show calibration_interval (CalIntrvl). CalIntrvl can be 365, 730 ect. I can use <date()-365 to list all the ones that...

I created an application using Access 2002 (Office XP) on a PC running Windows 2000. The application resides on the server and is used or viewed by several people from time to time. One user, that only views the data, has a PC with Windows 2000 and Office 2000. This user has been into the...

I used get-external-data to import some (approx. 2000 records) tables from Dbase. It worked great and the tables seemed fine for the last 6 to 8 weeks I have been setting up this program. Today I was doing a calc on some test data that uses this table information and I found a glitch. I was...

I have a query that shows only the last record entered in my table for each account number. The table has lots of records for each account number but this query only shows the last record entered for each account. For the sake of this example, lets say, I have ten account numbers and when I...