Search results

Are you bored? :rolleyes: :p ADO creates it. ADO reads it.

Advanced Data Table Gram

There are several built-in methods of saving data to text files. They will be much faster than anything you write yourself. Export your files, create a new container file, open each file, read its contents and append them to the container. ADO allows you to save recordsets as text with...

What's do you mean by 'navigation pane'?

From outside of Access you'll need to create a connection to open a recordset from. https://www.connectionstrings.com/access/ I'm pretty sure Excel has a wizard for connecting to external data sources though.

Do you have a table or query in the rate.mdb file called A? Check that the connection's .status returns 1.

Private Sub Command0_Click() MsgBox CurrentDb.OpenRecordset("select datecreate from msysobjects where name ='t1'")(0) MsgBox DLookup("datecreate", "msysobjects", "name ='t1'") End Sub

Buttons can be transparent.

http://www.developerfusion.com/code/1130/turn-off-warning-messages-in-ms-office-applications/

:rolleyes: Well, he posted in an Access forum and the code must be running from somewhere. :confused:

I don't know if 2) was referring to my example or not (I didn't use any text boxes). But if so, the value (text) displayed when you click an option would be a numeric ID in a real-world scenario. You could easily adapt it to show checkboxes beside items for multiple selections. You only need...

^ Depends how you export the data. If strings are enclosed in quotes they'll most likely be imported as strings. But that's often not the case. I can't think of any reason why you'd want to open a csv file in Excel from Access. Summats up 'ere.

@op

or a browser

To get unique values from a field you use distinct. select DISTINCT full_name FROM tbl_user The fact that you have non unique records in the user table is worrying if they relate to the same person. 25 seconds is too excessive to be just about table indexes. You probably have a very slow...

A query can't be 2 things at once. It can either be a crosstab or a maketable. You can use one query inside of another (different type of) query though. select * into newtable from qrycountperstore

Leave 'Export data with formatting' unticked.

If both tables should be the same, delete and insert everything from scratch. If you UNION both tables together you can check if they match by GROUPing... select [Kreditor nummer], Sum(n) AS nsum from (select distinct *, 1 as n FROM [Supplerende kreditor stamdata] union all select...

text105 references check62 which doesn't exist Text99 references FieldName which doesn't exist Your naming of controls is atrocious.

You don't need to paste in the click events. Generate them when the form opens. Private Sub Form_Open(Cancel As Integer) For Each c In Controls If Left(c.Name, 5) = "btnID" Then c.OnClick = "=MouseUI(""" & Mid(c.Name, 6) & """)" End If Next End Sub Public...