Hi,
I would like to automate the process of refreshing (updating) the linked tables in MS Access. Is there a macro action that can do this process? At this time I am going to the Link Table manager and manually selecting the tables that need to be updated.
Thanks,
Lysa
Hi,
I was wondering if someone could help me figure out how to append the data from a recordset retrieved through ADO to a table in my current database.
In my current database I have a table called "StandardTable" which has the defined field names.
I also have a Form that has a combo box that...
Hi John,
Thanks a lot for your help. I ended up using this code.
For i = 0 To adoRst.Fields.Count - 1
cmbUniqueID.AddItem (adoRst.Fields.Item(i).Name)
Next
I put in in the Form_Load() in the form with the combo boxes.
Thanks again,
Lysa
Hi John,
I have run the code with the form opened and closed and get the error.
Is there an additional reference library that I have to add, maybe?
Lysa
Hi John,
I inserted the MsgBox MsStr code and it displayed a message box with the field names of my recordset. I also changed the name of my combo box just in case it was that....but still got the same error. Could it have to do with the properties of the form or the combo box?
Thanks Again...
Hi John,
Thanks for the code, but I keep on getting the error 424 "object required" at the line cmbUniqueID.RowSource = myStr
Right now I have inserted your code in the module with the ADO connection (seen in the first posting). Is this the right place to place the code?
Thanks Again,
Lysa
Hi,
I am connecting to an access database through ADODB. The connection is working and I can retrieve data from the recordset.
Now I would like to be able to view the field names from the database that I am connecting to in a combobox in a form.
Here is the code I have so far.
Dim adoConn As...
Hi,
I have a syntax error and I don't know how to fix it.
I am trying to filter a report based on a date range.
Here is the code that I have attributed to a cmdbutton in a form to filter the report based on a date range.
DoCmd.OpenReport "rptRequestDate", acViewPreview, , "[StartDate] >= #" &...
Hi,
I am making a map request database in which the map maker must record the information for the map request. My problem is concerning the location.
Right now I have one listbox for the continent, country, and province. The country listbox is filtered by whatever continent is slected in...
Description
I want to select a value from a list box and "on click" of a button I want to see the selected value in the text box. I then want the values in the text box to update my table.
The reason I want this design is because I have to select multiple values from the list box and I want to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.