Search results

Normally, a person would use a numeric field in a table formatted as currency to enter pound, dollar, or euro amounts. But I want to use a text field, since the field will be used to contain separaters, such as dashes, in certain records. It also needs to be stored directly in the table (not a...

Did you have to variably create the appropriate number of text boxes on the fly in VBA, along with their position and size? It looks impressive. But I imagine so many complex subforms is subject to severe slowdowns. Do the arrows at the top left of each subform minimize them? Are they also...

On the StaffHomePage, how did you make the appointments bar at the top with the blocks automatically filling the appropriate time range?

I have a subform with a datasheet query. I have a button that pops up a window of the subform in Print Preview. I want the sort that is chosen in the subform (on the fly using the column arrows or the sort and filter area of the Start ribbon) to show up in the Print Preview. Using...

"When I do a requery of the datasheet in VBA to show the record, Access seems to lose track of which record I clicked on and moves to a random record that I did not click on. I tried it in both the AfterUpdate event for the Form and OnClick event for the cells of the datasheet" I have found...

I have a form where I can enter data for a single record. I also have a subform on that form that shows a datasheet of all the records. I've created VBA code that makes the datasheet highlight the selected record in the main form, or changes the record in the main form when a record in the...

I want a split form with a button that changes the source of the data shown in the datasheet. However, when I assign a new SQL statement via Me.Recordsource in the VBA, it only replaces the data in the columns of the current datasheet that have the same name as the Query's columns, and the rest...

It seems the path to both the database file and the client DLL driver need to be the same on every computer. These are saved in the Connect value of the DAO TableDef for the linked table. So far I have not found a workaround.

Apparently it doesn't update the trusted folder for the built in wizards when switching fom 64-bit to 32-bit install, namely the switch from "Program Files" to "Program Files (x86)". So I had to change that in the registry. As for the runtime, it doesn't seem to consider any files safe...

Thanks, I'll have to look into this later. Are these the only options available to me for multithreading in VBA?

I've attached a sample from a Google Image search, except the ending for my file is accdb. Do a Google Image search for "Microsoft Access Security Notice" and you'll get images of a whole bunch of the same warning window. That is what I'm getting, except my warning is for files with the accdb...

I am getting the security warning that many websites cover popping up for accde files, but I am receiving it for regular accdb files instead. This is happening in 2 situations: 1. On a computer with Office 2013 (not Professional) running the Access Runtime (I tried both 2013 and 2016...

I am inserting the query into a temporary table. The contents of the table are erased before each insert. The reason I am doing it that way is because the query I was using needed to give results between two dates which are in controls on the form. But the query designer gave me an error when...

I'm merging a couple of ODBC tables (Invoice and Customer in a Firebird database) using an Access query which sorts by date first and then customer number (both descending), and then exports the table to an Excel file. I have noticed that sometimes the sorting is off. For example, if I want a...

How would I make it animate while it is opening Word and the document, since those are time consuming tasks that take up a single line of VBA code, since I can't create VBA code to animate "inside" of those parts?

I have some VBA code that opens a Word document (using Word.Application object), replaces some bookmarks, and then saves it as a RTF file. This process takes 5-15 seconds after the corresponding button is clicked. How do I make some kind of animation appear after the button is clicked to show...

I want to connect to a table in a Firebird database on a server from each of the clients using the same Access front end. But after I connect the table via ODBC successfully on one computer (the development PC), it gives me an ODBC connection failed message on other computers when I try using...

I've noticed if I open a Word document to fill in the bookmarks, I can't do so if the file is opened or read only even if I want to save the document to a different file name. How would I go about editing a document in VBA that is read only to save under a different filename? Do I have to save...

I just looked up PlainText. Not sure how that would help here. If you mean for the Rich Text form text field that was invalidating my raw source stream, I'm not sure what the problem there was anyway, unless Rich Text form boxes automatically alter the plain text inserted into them? So maybe...

The Long Text field in the ERP's database is regular text, not rich text. The Rich Text HTML markers which have been copied as standard text are only transformed into Rich Text when shown in the ERP program. Anyway, I've pretty much accomplished it in the meantime. One problem I had was that...