Search results for query: *

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.

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

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

I am using Excel VBA and I want to be able to use VBA to cycle through all of the possible combinations of a pivot table. I used the Macro recorder but all it does is record the specific items. For example: ActiveSheet.PivotTables("PivotTable1").PivotFields("Group").CurrentPage = _...

I am working on a database that has multiple Forms using VBA. The first form I created showed up under "Microsoft Office Access Class Objects" in VBA but the other forms I have created haven't showed up and I can't figure out how to get them to show up so I can start writing VBA code for them.

One of the fields in my table comes with commas for example Smith, John. When I tried a while back to use an SQL statement to match rows in this table from another table, it gave me an error message about the comma being a functional character -- I think it was "AND". So now I want to do one...

I am trying to manually create a sequentially numbered key using the code Dim myRecordSet As New ADODB.Recordset Dim rs As DAO.Recordset myRecordSet.ActiveConnection = cnn1 Dim SQL1, SQL2, Statement As String myRecordSet.LockType = adLockOptimistic myRecordSet.Open...

I wanted to create a macro that does an Insert into of an autonumber field from a Macro. I started off by choosing RUNSQL. I can't seem to get anywhere. My latest attempt for the statement is Insert into tblTrackerTest (index) SELECT [tblTracker].index from tblTracker I thought that I could...

In the following SQL statement below I want to be able to pass a parameter of a column name after the WHERE statement -- see below. SQL2 = "INSERT INTO SelectedEmployees ( ID, Region, SID, ccMailName, DomainAddress) " SQL2 = SQL2 + "SELECT ActiveEmployeesWithEmailTest.ID...

I am somewhat new to Access. Without having to create a Query I want to display a Table column in a list box. They only way I could get this to work was to create a query that extracted that column. I have to do this for several columns and don't want to have to create lots of queries just...

I am relatively new to Access and I am unclear on how to solve this problem. I have one table that contains the entire number of people in our company. People want to be able to send me a list of names that are a sub-set of the people in the company. I can create a second table containing...

I want to be able to do one action in my VBA code if my SQL SELECT query is NULL and another one if it isn't. To do this, I need know how to test my VBA SELECT code to determine if the SELECT statement is NULL. The code I want to test is: SQL1 = "Select ID" SQL1 = SQL1 + "...

I want to pass a paramater to an SQL statement in my VBA code but no matter what I try it always prompts the user for a value. I want to have the value passed from the VBA code and not require user input. Steve