Search results for query: *

Hi, I was hoping someone might be able to give input as to the best database structure to efficiently store the following information. The database is to be used to store laboratory results for multiple sites. Information: I have multiple sites(1000) with site specific data like name, lat...

Hi, When I attempt to send SQL through ODBC from arcview to access, I can't return any records if the search criteria I am using contains a space. How can I send a space in this string properly? Any help would be appreciated. Joel Lindsay Vancouver BC

I used Dlookup to populate a value in query1 and then use this looked up value as part of my where statement in query2. This seems to take a long time as I think that query2 runs query 1 for every record separately. Does anyone know how I can make query1 become a snapshot so that query2 can...

I have 3 queries which build an end query which contains all the information I want to display to the user. I would like to display this information in another query, but change the way it looks. This is what I have now in the final query, Site Name, Site Abbreviation, Sample ID, Sample Type...

Hi, I have a form that I use to open another form to gather data. In the second form opened, users are to pick certain fields that they want used in a query. On close of this form, I would like to pass the chosen information to the original form, into a listbox or textbox. Can anyone tell me...

Hello, I have created to list boxes. The first listbox lists the values of a certain group in a table. I would like to be able to select one or more of these values in the first listbox, and then press a button to "send" these values into the 2nd listbox. I would also like to be...

I would like to find the method to return the column of the active cell in VBA for access. If a cell is active or referred to through the Cells object using integers, how can I return the alphabetic equivalent for that cell?? I know that I could make a function or procedure to do this, but I...

I am trying to calculate the 90th percentile for a returned recordset, the same way I could groupby and use an aggregate function like Sum, Var, Avg. Unfortunately, I cannot figure out how to do this properly. I have tried doing it in a crosstab query, but I need my original columns to stay...

I am trying to make a crosstab query by using the field names from a table as my row headings. I cannot figure out what to put in the QDE pane to make this happen. Any help would be appreciated.

I would like to get a listing of the fieldnames in an access table from within vb code included on a database form. Because I am already connected to the database, I shouldn't have to make an odbc, dao etc connection to it should I? Can anyone tell me how to retrieve these table fieldnames??

I am getting the error message relating to Ambiguous outer joins when I try to run my query in access using the QBE pane. I know that I can get around this error by deleting the automatic join it makes between 2 tables that I dont want joined, but I would like to know why it is trying to join...

I would like to display my recordset that I have opended using a QueryDef.OpenRecordset in Access. Ideally I would like it to be displayed in a table like format(query like). I just want to either dump the records into a table, or display like a table. This should be easy but I cant figure out...

I have a search form which creates a valid SQL statement from the form elements. I have verified that SQL is correct by pasting into a query and running. I would like to use this SQL string I have created to allow users to press a button on the access form, which will then run the query...

Anybody know how to do a lookup of the datatype for a field in an access database? I want to bring the table name and field name in as variables and then lookup the datatype for that field. Any help would be appreciated. JL