Search results

Moving the pointer would have worked, but the form in question is opened to one book only, bound to the table, so I have nowhere to move. But it's not a bad idea. Perhaps I can do a union query to a blank record, move to that, whack the image, and move back. Will let you know how that works out...

Years ago, I stored images in an Access table where they were converted to bitmap images. This caused the database to swell to 1.8 gig, just under the maximum of 2 gig. I want to replace these images with files on the hard drive; that process is working fine. To do this, I would like to be able...

I want to put a solution out there even though it may or may not be related to the OP's problem. I received an out-of-range error on the CopyFromRecordset line of code in a procedure with error trapping. It occurred when one procedure, that was looping through forty records until end of file...

Gassman, thanks, that worked. In the Microsoft Learn world, they did not show the split code, so I had the UBound above that line of code. Then I was trying to populate the unrequired "dimension" variable. The simple phrase, and then, got me the answer. Feel like I had my head up my ass. Now I...

I need some help with arrays. I am passing strings of different lengths, and the code is blowing up when the last element is empty. In other words, an array expecting seven elements is only getting six, or five. And to be clear, it all works fine when there are seven. I have a string that is...

Reread Pat Hartman's suggestion. The answer is not to move the cursor there, it's to put the information there using an append query. If your text boxes and combo boxes have the information for the next record, create variables, assign the new information to them, then do an append query using...

Just throwing my two cents in, because error 91 is a pain. It means you started an IF statement with no End IF or a Select Case with no End Select. But C&R would catch these. So, I am suggesting you look for the Dim dbs as DAO.Database without the Set dbs = CurrentDb in the procedure. That's the...

I have a Library database that has images of book covers stored in the books table as OLE Objects and bound to an object frame on the form. There are also images of authors in the authors' table. I am the only one using the database, so it is not split and is currently 1.7 GB in size, which is...

I have this import procedure that is bringing in over sixty thousand rows of Excel data and then parsing the semi-colon separated strings into individual columns. All of this is working well. The question is about the progress bar to show the user that Access is working on this task and not...

Thanks, Pat for the tip on SSMA, I just downloaded it and will try it soon. I was wondering if you could elaborate on the FK double index you mentioned. When creating a table, Access will create a duplicate OK index on my FKs, (they all end with ID), and I am happy to let it do that. If you are...

Thank you all for the feedback; it helps to know I have been considering similar options as you guys. To Minty, thanks for the speed test and the cloud suggestion. Unfortunately, the sensitivity of the data prevents any of this information from being stored in the cloud. To Dave, I have tried...

I wanted to continue this thread because I have a few questions on this issue as well. The database and I are in Connecticut, USA, and people in Europe and India are complaining about the speed, about 30-60 seconds to open a form, using ten to fifteen hops, most of them are triple digits. When I...

Wanted to let you know how this turned out. I normalized the three text fields, type and subtype and unit into their respective tables and updated the import table with the primary keys. I am also checking for new values in the import table that don't exist in the normalized ones and doing an...

It's an ongoing process. There can be as many as twenty people importing a different spreadsheet each day with documents to inspect. I think I am going to normalize it now and see if the next step in the process will work as well when comparing text strings verses numbers. Thanks for your input.

I am being asked by a client to do something that I already know is wrong, but it is nagging at me that they might have a point. So, I was hoping that others here could weigh in with their opinions and give me some advice on how to alleviate the client's fears. They are asking me to identify...

@Pat Hartman Following your suggestion, I put the code back in the on click event of the command button, it's the first line, and put the stop on that line. Doing everything except C&R and the bouncing ball did stop on that line, even when VBA was closed at the start. However, when the C&R is...

I think I have found the problem. I went looking for code to identify the name of the module and the procedure so I could identify the location of the error. Unable to find a way to identify the procedure code, I decided to manage that myself. However, the module code I found and used...

I understand the difficulty of trying to solve this problem without seeing it and looking around. However, I will have to ask those at work on Monday if the form can be distributed even if it is the only object in the otherwise blank database. Sorry, the security here is really tight.

After compacting and repairing the db, (W10-Office 365), closing and opening it, seven command buttons fail their respective on click event. Two buttons created recently, and on the same form, work as expected. So, I open VBA and open the class module for that form ("frmAdmin"), click on any of...

I wanted to say that I have this problem also and I can't seem to make it stop. I will offer up one piece of recently discovered information in the hopes it triggers a thought out there. On my continuous form there are twenty-five records displayed. When the cursor is on record number one and I...