Search results for query: *

Yes

What I have had to do before is to copy the data into Excel and use the Advanced filtering function in Excel to take each column and create a new column with unique values. I was hoping to find a faster solution using Access. Steve

What I am doing is creating a table of values that I will read into list boxea and that can be used to generate new queries against the main table. Steve

Sorry about not being more specific. Let me provide an example: Region Site US OR US AZ US FM Asia PG Asia KM Asia KM Europe SW US AZ Europe MO Asia PG Asia PG What I want from multiple columns -- several more than what has been provided in...

I tried using a totals query using "Group By" but I had the same effect. I can get unique values for one column, but I can't get unique values for more than one column at at time. Steve

Do you mean using Reports? I don't have much experience with Reports, could you provide a little more information? Steve Graves

I want to construct a query that will generate unique values for multiple columns -- so that the row relationship among values will no longer be maintained. Currently each column has multiple values for the same column. I have set the row properties to be unique but this only gives me unique...

I have created a Data Access Page in Microsoft Access using the wizard. Microsoft provides a Script Editor to modify the VB script. I can get the JavaScript code to run but I can't get any VB script code to run. The section of code that I tried was: <SCRIPT language=vbscript event=onclick...

I have a data access page and I want to close it using a command button after it updates the database. I tried putting window.close into the onafterupdate and onclick events for the button but nothing happened. I am still testing the Data Access page in the Access environment before I put it...

I am new to using data access pages. I want to use the page for data entry. But I want people to only enter one set of data. I set the command button to save the data but I don't know how to get it to close the page or go to an different page with a message on it.

The text import just fails whenever the number of columns is greater than 256. As far as normalizing goes -- that would be great but from a practical standpoint I just want to load the data quickly without spending a lot of time on it. I am more interested in running reports and looking at the...

I have a text file that I want to import from a survey program that has 378 columns. The column limit in Access seems to be 256 columns. Is there a way to change the column limit in Access? The people I am working with want an easy method to import this that will not take up much time on...

You are correct. I wanted to back up my MDB. Thanks for the information. hciSteve

No, it isn't. So are you saying that it has to be for that method to work?

Oh, yes and have your query be a "Make Table" query that puts those selected values in your new table.

Why not just create a query in Access that includes all of your tables. Then request the field you are looking for matched to your criteria. You can then either run the query in VB using: DoCmd.OpenQuery Or you can look at the SQL code for the query you created in Access (use a right mouse...

One more thing -- the helps advised me to add the mdf extension -- I have tried it both ways -- using the mdb and mdf extension.

I am trying to use the CopyDatabaseFile method to backup my database. But every time I run it it tells me that the CopyDatabaseFile is not available at this time. I tried changing the options to No,No; Yes,NO; and No, Yes -- nothing worked. DBFile = "FileName" + Str(Time) + ".mdf"...

Got it. Thanks to both of you!

You were right. But I don't see what I did that was different? Thanks, Steve