Search results

Can we do the same thing with combo box?

Can we hide the old button and user sees only the new button?

Hi, Below is my requirement 1. I have 5 tables created in Access (T1,T2,T3,T4,T5) 2. I have a button click event for each table which loads the data from SQL server 3. Now i need a single button which does this, instead of having multiple buttons A single button which loads the data from...

Thanks Much! It worked :):)

Hi All, I have a form with a list box, button and reports my requirement is: 1. Select the value form list box drop down 2. Click on button 3. Corresponding report should open based on list drop down selection Ex: When i select 'customers' in list and click on button, it should open customer...

Thanks much! It worked:)

Yes please. This is a bit urgent, so please do the needful

Just checked that the table is getting created in SQL server instead of MS Access Below is my code Private Sub btnGetData_Click() Dim dbMain As New ADODB.Connection ' Declaring the Connection Dim rs As New ADODB.Recordset ' Declaring the Recordset Dim strSQL As String ' Declaring a simple...

Yes, i want to use the latest table definition everytime

Yes. I did the same, but when i clicked the button, nothing is shown. And when i click it again, it says "Table already exists". But no where i can see the table

It did not work for me. It doesn't create a new table rather insert into the existing. Code showing many errors too We better go with make table only!

I feel make table query in the VBA is easy to use rather than record set

I just wrote this in button click , but i don't see table getting created (SanTest is the table name) Dim dbMain As New ADODB.Connection ' Declaring the Connection Dim rsCustomer As New ADODB.Recordset ' Declaring the Recordset Dim strSQL As String ' Declaring a simple variable dbMain.Open...

Could you please send me the complete VBA code

Nothing particular on OLEDB or ODBC. I just found in google the code snippet that's it. Could you please send me the VBA code for achieving this: (As for using VBA, you can add code to check if the table exist and then delete it before making a new one. That is, if you're creating the table...

So, I guess when you said you didn't want to use ODBC, it's because you are using OLEDB, correct?-- Which ever is convenient, am ok with either (Am using SQL server authentication in connection string) And yes, every time i want to create new table instead of appending or inserting into...

Below is the VBA code: Public Sub CompleteDatabaseExample() Dim dbMain as New ADODB.Connection' Declaring the Connection Dim rsCustomer as New ADODB.Recordset' Declaring the Recordset Dim SQL as String' Declaring a simple variable dbMain.Open =...

Sorry for the confusion. I want to achieve this through VBA code: 1. Connect to sql server database via ADO 2. Run the query and create a new access table with the query result set Basically, i want to create tables in access with the query result set. All this has to be done through VBA code

Hi All, I have gone through few threads but nowhere i found the proper solution. Below is my requirement 1. Data is located in SQL server 2. From MS Access , i need to connect to sql server using sql server authentication and then query the tables 3. After that i need to create...

Thanks Much!