Search results

Only 5 fields and they are all Text fields. Shouldn't be a problem.

The user in the ms access app, selects the excel table and then it gets linked to ms access. I want to then export that to SQL Server. I tried exporting to SQL using this : AmzConn = "ODBC;Description=SQL PassThru;DRIVER={" & GBL_strDriverVersion & "};SERVER=" & AmzSrv & ";DATABASE=" &...

is there a way to export from ms access to SQL Server using vba code?

This does not provide an error msg but it does not save the column changes. Thanks! I guess there is no way of saving the column changes of a subform. Currently I am saving the changes to a table and then when form loads it is moving the columns to the saved settings. When the form closes it...

that's exactly what I have. I have a table that records the column orders and when the form opens it checks to see if the order is set and will set it to the last saved settings. But the order is set each time because any change gets recorded but does not save on the form. When the form...

I have a form with several subforms... It can be any subform that the user is changing the columns on. When i run this from the parent form: DoCmd.Save acForm, sFormName I get error #2489

The user moves the columns around to their liking. I changed the font of a random column to bold and then back to normal to trigger the save prompt. Do you know how to default to saving without it prompting me to save when the form is closing when i click on the X ?

I have a subform that I move columns around and change from bold to normal font. When I close the main form, it prompts me if I want to save the subform. I don't want it to prompt me, I just want it to save by default. How can i do this?

putting into a recordset did help. thanks!

it does return 1 record. I believe it is on a LAN. I will try to put it into a recordset.

It is 1 view that is linked. It is not being dynamically created, it already exists. The stored procedure just updates some of the tables that are being used in the view. Then the DLookup is used to retrieve the values.

I am having performance issue with a DLookup on a linked view from SQL Server. I am executing a stored procedure in SQL Server that runs and updates the data on a view. I then do a DLookup to get values from the view and it takes about 5 seconds for each DLookup to retrieve the data. When I...

I want to set the recordsource on a GrandChild form: I tried these 2 ways and i get the error msg: "Run-Time error '2467': The expression you entered refers to an object that is closed or doesn't exist. I have the code below in the OnChange of the CurrentForm (this is the 1st subform)...

found my answer: Private Sub Form_Open(Cancel As Integer) With Me .Move 0, 0 .Width = 6.5 * 1440 '6.5 inches wide for the window .InsideHeight = 2.125 * 1440 '2.125 inches high for the window working area .InsideWidth = 6.25 * 1440 '6.25 inches wide for the window working area...

What was the solution? That link is no longer valid.

I have a large sql table(6 million rows) with about 10 columns. I link the table to an ms access application. When I open the table in ms access and want to edit a column, it takes 15 seconds for it to respond and change the value. After that i can edit the values of any record and it is...

I saved the values of 3 comboboxes to a table and when the form opens, I want those values (default) to be populated in the comboboxes. I tried doing it like this below...but I get a run-time error 424 (object required). Me.cmb_Projects.Column(1) = rs!DefProject...

I call a sql stored procedure from ms access. How can i tell if the sproc failed or ran successfully? Also, is there a way to do error trapping and pass the error to ms access ?

Thanks, but that does not Select the items and it only loads the selected items. I think I figured out a way. This is working for me: I'm adding the same rowsource to the listbox2 as listbox1. Then I am Selecting same items like this below. The listbox is the same name. The first listbox...

I have list1 in form1 and a user will select multiple items from that list. There is a button on form1 that when clicked, it opens form2. I want to copy All the list items from list1 to list2 on form2 and I want to select all the items that are on list1 on list2. So that list2 has the items...