Search results

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

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

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

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 would like to add an icon to the VBA icon menu, not the Access menu, that can execute a specific procedure. I was able to drag the Macro... "command" to the icon menu but that just gets me the list of procedures. I then have to locate the procedure I want and click on it. It's better than...

I was wondering if anyone has found a way to grab stock market data since Yahoo has closed up the free access loop hole a few years ago. I have a work around using Excel which links to the data and a simple refresh gets me the latest numbers. I link this table to my investments database and run...

I need help with the management of the navigation pane. What I am looking for is the vba code that "rolls up" each group of objects. I don't want to see the entire list of tables, I just want to see the headings of any group that has an object in it. I can use the code below to minimize the...

I am importing one large field from Excel, a string between 300 and 600 characters long and delimited by a semi-colon, which does not exist in the data, so I get the whole enchilada. Additionally, because of the length, I changed the field type to memo, from the default text. All of this is...

I need some confirmation on something that I have noticed is causing a connection problem. When I build a front end I am linked to tables on SQL Server using an ODBC connection with the DSN of "BEData". When I send the accde to a client with the same DSN but pointing to their server, the...

I am getting two different results when I preview or print a report. When I preview a report the report title and page title are populated with the strings I built and assigned to global variables. In the report load event the GVs are assigned to the text boxes. Everything works great. If I hit...

I am exporting data from Access to Excel and following that up with formulas and formatting. The code is in Access and works on the Excel object and it works fine. The problem is it doesn't work a second time. I have to run compact and repair in Access and then the code works again. Below is...

I have an Access database that goes to http://download.finance.yahoo.com/ and gets me about a dozen numbers/dates for each stock ticker I send it. And I loop through about fifty companies. Been working for over a year, really got to rely on it. Now on Monday, the code failed. The page cannot be...

I am posting what I learned today because hours of searching have uncovered something that no one seems to have mentioned. What really happens when you try to hide the navigation pane? I am using Access 2010. DoCmd.SelectObject acTable, , True 'select the table object in the...

So the default document window options is Tabbed and I designed the database to use Overlapping. So I am asking if anyone has some cool VBA code that I can run to change the client's machine when they open this database. This started when a person in the office opened the executable (accde) for...

I had a user ask me if repeated typing of the same letter can cause a combo box to move to the next one. It's tough to describe, so here is the example. The combo box lists states by their two letter abbreviation. You hit c and it goes to CA, California. She wants to hit c again and have it...

I need Access to link to tables in two different databases that are located on the same server. When the FE is opened, the connection to the first database works, all twelve tables connect. The problem is with the connection to the second database. This connection kind of works, the two tables...

In Access 2010 I am entering a number in a text box on a bound form, hitting enter and the After Update event does not fire. When I move off the text box, the event fires. This is particularly annoying when a person is typing in their password, hitting enter and nothing happens. It also fails on...

Windows 7, Office 2010 VBA 7.0, Access left and right functions work fine. I enter a mid(TBN,4,99) where TBN is a string variable, in this case, the table name. I want to get rid of the "dbo_" that precedes linked tables for a project. When I compile it, I get an error that VBA "expected array"...