Search results

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!

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...

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...

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...

Hello. Using a DB that has been repaired / compacted. And I'm running a series of SQL statements that update one table based on another table. The VBA runs fine for almost every field but as I near the end of the process (field #47 of #49), I get error 3047 record is too large. Any suggestions...

Hello - I have two forms that are open while the user is in the DB. I want to move the one form to the right so that the right edge of the form is within say 10 pixels of the right edge of the Access window. And I want the 2nd form's left edge to line up within say 10 pixels of the left edge of...

Hello - I have a subform that has a field called FileID. When a certain event is triggered, I want to set a text box on the main form = FileID. I'm using the simple code below. The text box has no events, etc. so I can't imagine there's a recursive thing going on. But I keep getting a "too...

Hello - my company has migrated some DBs to Azure and I want to update the DAO connection string in VBA. Suggestions for string formats that work well please? Thanks. I was trying the string(s) below for example but I get error 3170 installable ISAM error? gsConnectionDB =...

Hello. Looking to write out an email in VBA into a MSG or EML file without using Outlook. The Server I'm using has Access/Excel, etc. but not Outlook. Can I just write out for example an HTML file that meets the Outlook header requirements, etc. and then, from another computer, open it within...

Upon opening a subform (datasheet), is there a quick way using on_current event to determine if no rows have been added? I want to turn allowadditions to be true or false to allow the addition of one row maximum. Thanks!

Hello... looking to count the numder of TIF files in a folder (thousands of folders really) without going by one file by one file within each folder. I saw some promising code but I get #VALUE in Excel or some kind of error each time. Suggestions? Here's code I have to count ALL files in a...

Hello - editing data through a form, connected to SQL server table. I get the error below ... I'm not doing anything crazy re: on_current, etc. that I can see. What's weird is that I can click OK and then the edit actually "takes". Any suggestions? Thanks.

Hello - I often will open an Adobe object. All of a sudden, I'm getting a 429 error "Active component can't create object." Any suggestions. See code below. I do have Adobe PRO, I repaired the DB (to be safe), and this code was JUST working like 1 hour ago! Edit: the coding does seem to work...

Hello all. I have a MAIN form, and a subform listing documents (SF_DOCS) and another subform listing words on that document (SF_WORDS). When I click on a different record on SF_DOCS, I want the SF_WORDS to not just load up using master/child fields, but to go to the top of the datasheet (if you...

Hello - I have a process that manipulates PDFs in Access VBA using the Adobe reference, etc. The problem is that when a PDF file is corrupt, it doesn't "crash" normally... rather Adobe will prompt me regarding the bad file and then only when I manually close the file / Adobe, Access will THEN...

Hi - rather than have 2 versions of a form depending on the type of project we're running, in my accdb file, I modify the design of the form in VBA ( I open the form in design view) and then open the form in normal view. But accde doesn't allow form design in VBA (I think). Is there any way...

Anyone have code to convert just a part of a PDF page to a jpg file? I know the PDF coordinates within the page I want to save. Thanks!!!

Hi - getting the above error but only in the accde version (so I don't know where VBA is broken). In full accdb file, no problem. I confirmed all References are good. Suggestions please?

Hi - using this code below which works for me, but only partially works for others on my team (ribbon and system objects are hidden, but navigation pane is still visible). Any suggestions? DoCmd.ShowToolbar "Ribbon", acToolbarNo 'hides ribbon DoCmd.SelectObject acMacro, "AutoExec", True...