Search results for query: *

Thanks for the idea. I will definitely give that a shot. I am also playing around with making my GIS read the queries, which would make life a lot simpler. Turns out it doesn't read make-table queries but with some effort may be possible to read select queries. Really appreciate the help...

you got it

That is what i am doing right now. When somebody imports a csv file, they then have to run the make-table queries (there are several) to create the tables for the map layouts. I am looking for a way to make this process automatic. Also - sometimes the data in tables is modified after it is...

They are created by exporting csv files from MicroMine software.

Thanks for your help. It sounds like a trigger would be the ideal solution. The application is ArcGIS (mapping/GIS software). Unfortunately it can only read Access tables. If it could get queries that would solve my problem too. I have several tables in my DB. Some of them are for display on...

Well it is actually another application that is connecting to the db and reading the tables. It can't see forms but it can see tables.

Is there a way to do this? I see there are macros to automatically run every night, but how about to run it when a table is updated.

Any way to specify a field width of the resultant table in my Make-Table query? I want to run it repeatedly as new data arrives in another table, so editing the resultant table is a poor option. Even though "Trench" is width 12 in my original table, it becomes width 50 in my new table, where...

Amazingly enough solved this one myself. Seems I needed to do a couple of things. First of all edit the table join properties so "Enforce Referential Integrity" is allowed. Then check "Allow Cascading Updates". Also use Distinctrow instead of Distinct, not sure why this makes a difference but...

Alve suggested using BeforeUpdate, I prefer Dirty. Here is the code I used. Private Sub Form_Dirty(Cancel As Integer) [Date Last Modified].Value = Date End Sub

I have a form which is based on the following query. The two tables are related: tblContacts has the primary key ID (Autonumber) and since each contact may produce more than one commodity, tblCommodities.ID is a foreign key. SELECT DISTINCT tblContacts.ID, tblContacts.[Last Name]...

You don't need a book just to figure out how to use expressions, use Access Help and look under "About Expressions". If you need to do more advanced stuff, I recommend a fantastic book called Access 2002 Bible (Gold Edition) by Michael R Irwin and Cary N Prague. I use it almost everyday. It...

But for some reason when I reversed your Having clause it seems to select all matching: HAVING (Nz([Bird Control].[Orchard Pistols],0))+(Nz([Bird Control].[Cannons],0))+(Nz([Bird Control].[Triple Shots],0))+(Nz([Bird Control].[AV Alarms],0)) >= Sum([Acres])/5 ; Your clause selects 16 records...

This seems to select some records but not all of them. Will try to work with this some more.

I have a query which is performing 2 calculations. The first one is a 2-part calculation called AcresDiv5. In the first part, it sums all the crop acreage on a particular site, and in the second part this sum is divided by 5. The second calculation, called SumDevices, is the sum of all...

I am trying to run a macro (attached to a command button) which will find record(s) matching a user-typed field. A problem occurs if there is more than one record matching the criteria. I want the macro to go the first record, then if run again to go to the next one, and so on. But it just...

That's a great idea. I set the defaultvalue to: Forms![All Farms]!ID Seems to work so far, will do some more checking. Thankyou!

Ooops...sorry!! I got confused with a different part of the form. Sorry...the Varieties form is not actually a subform. It opens when a user clicks a button on the main form.

Hi, I have a subform called "Varieties" on a main form called "All Farms". The All Farms form displays information for each farm, one at a time. The varieties subform is a continuous form showing information about all the varieties found on that farm. I have an ID field which is a PK on All...

Perfect!!! You are a genius, thank you!! I checked to make sure all 65 records were returned without the DISTINCT, and it's exactly right. Thanks for your patience.