Recent content by DoDo1975

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

To the top

Yes it is possible using something like that code up top, but what you had in the code up top isn't creating a temporary querydef, it is creating a permanent querydef. To create a temporary one I think you have to send an emptystring in the name parameter. Anyway, I believe if you create a...

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

Sorry, I probably wasnt specific enough. I know how to create a crosstab query, but I dont know how to use the actual fieldnames in a table as my rowsource or columnsource for the query, as opposed to just making each row a grouping of identical values from ONE column. Essentially what I...

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.

Thanks, this is great. Only problem is that my tabledef object seems to become expired even before it can be used 2 lines down. It seems OK if I define a database object, but not without?? eg Set myDB = CurrentDb() Set Tbl = myDB.TableDefs("tablename") works, but Set Tbl =...

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