Search results

PS, I believe you can export a recordset to a specific Excel location (using recordsets?)... so this would go the other way.

Hello - I have an Excel workbook that has a complex structure, and so I can't just import the whole thing into Access using VBA. Rather, I want to import certain rows into a pre-existing Access table (all Cols exist in Access, but all Cols may or may not exist in Excel). I have coding working to...

Very strange. I would end up getting "Only.accdb". PS, I also have an "!" in the beginning of the final folder name (e.g., \TDS Economy\ in your example, would be \!TDS Economy\, but that shouldn't impact things I would think.

Hmmm... the filename has a "!" at the beginning... would that impact things?

Hello - using a file dialog (generally works fine) but it truncates a file name when I put in a default value with spaces. I've tried Chr(34)+DefaultPath+Char(34) and also tried replacing any spaces with %20. No luck so far. Any suggestions? Thanks!

Hello - I have a table as a linked table connected to SQL server. If I open the table directly in Access (not in a form), I can filter/sort. But if I open it in a form (where "Allow Filter = True"), I can't filter or sort??? What am I missing? Thanks!

Yes I tried the drag method with no luck... it's okay for now based on other DB design items.

I'm trying to use the somewhat usable GUI of sql server - Access GUI is much easier but I'm building the back-end in sql server.

Yes, thanks. This would be an alias issue in SQL server. But can I create aliases just using the GUI of sql server or do I need to use T-SQL? Thanks.

Hello - any suggestions on this item please? Thanks!

Hello. Let's say I have a table of colors (red, white, blue, etc.) and another table that has People's names, their favorite color, and their least favorite. I can't seem to set up TWO (or more) relationships between the table of colors to the Fav field and the table of colors and the Least Fav...

Hello - I'm using Access VBA and the Adobe SDK to pull words from searchable PDFs. Works great (most of the time) but with larger PDFs, it seems to hit a performance wall where it will be extracting the same page for a long time. Sometimes, after 2 mins, it will move on. Other times it crashes...

Okay -- off to ADO I go... Thanks!

Hi-- any suggestions here please? BTW, I'm able to connect from Excel to an Access DB that has the sql server tables linked using DAO. But I'm trying to skip the middle-man of Access. THANKS!

Hello - I have a working model to grab data into Access using DAO.recordset from a database hosted on SQL server. Connection string works great. I even have a generic function to grab the recordset as long as I pass the sql statement to the function (see below please). How do I do the same thing...

Yes they are a web host / mysql host.

Okay thanks will look into…

Thank you. Yes that would be worst case but a connection string would be ideal.

Hello - we have an Access database and want to begin to migrate the data to MySQL for others to access the data (read-only for now) using a web portal. Looking for a connection string to use in VBA to link the tables in MySQL to Access. The MySQL database is hosted on siteground if that helps...

I lessened the # of fields (removed superfluous ones and it works now). Thanks.