Recent content by Steveanderson

Can you give me an example of the VBA code I should use ? thanks

The whole Ideal is that users will be able to create access tables selecting only the fields they require (to have smaller files) I tried working with queries but there are too many variables here

I am trying to combine several tables into a results table. I have encountered problems because the field structure of these tables is different and varies from table to table. Table 1 Fields A / B / C Table 2 Fields A / B / C / D If I try to use an append querry the data from table 2...

I have tried to find the solution to this problem for several days but I still can't figure it out: I have two tables Table 1 (more than 1 million records) Fields A / B /C /D Table 2 (several thousand records) Fields A / 1 / 2 / 3 The field A is a unique identifyer that could be used to...

Hello Bob, I'm running access 2003 Here is what I'm trying to do and maybe I'm doing it wrong: I have a huge table with at least 200 coulmns of data. I want to create an interface which allows the user to save a new table containing only the columns that he selected. I created a form with a...

Thanks guys Boblarson nailed it! I did a mistake by not adding the spaces

I wrote a little procedure in order to add new colunms to a table Table listedemog is a list of the columns to add Column name: Demog Row data: a b c d Table Demog is the table containing all the data Column names: a b c d e f g Table DemogSelect is theresult table with only the columns...

Thank you for the information. Indeed I will be using the record number in a specific session The point of all this is to use records of a vertical table to create fields in a horizontal table. The horizontal table will be populated with data from a third horizontal table. Maybe my approach...

Sorry for the lack of clarity By line number I am talking about the record number Knowing the field name and the record number how can I extract the value of the specific cell ? I'm sure the answer is dead simple but I just can't find it.

I'm not sure that the Dlookup works here I want to assign the value of a specific record from a specific line in my table to a variable. Here is the basic idea: M = (table name).(Field name).(Line number) M will give me the value of the cell at that specific line number

I'm using Access 2003 I have the field name and line number of the record from which I want to extract the value. (Basically X and Y coordinates to my table) What is the synthax to assign this value to a variable Thank you

Thanks I found out the solution

Thanks but I think that there is an error in line 4 of my code ... VALUES ('"&A&"') could be the problem. How could I insert the value of the combobox variable in a table ?

I'm using Access 2003 and I'm trying to configure a combobox to add the combobox value to a table named listeanalyse What is the proper synthax to add the variable A to the SQL string ? Here is the code. Private Sub Combobox1_Click() Dim A As String, SqlTxt As String A = Combobox1.Value...

Thank you for the answer. I tried to use that code but it didn't work. Could there be something that is missing ?