Search results for query: *

When opening Access, the default printer changes from "Letter" to "User-Defined". The output is then unreadable. I then open the printer option box and change it back to "Letter" and all is fine until I reopen Access with the same result. I'm using Access 2003 with a Brothers HL1440 How can...

I need to rename a Word doc using VBA in Access. I have been able to open the existing file and save as the new name, If strAgent <> Me.Combo15 Then Set WordInst = CreateObject("word.application") WordInst.Documents.Open ("C:\Access\Folder1\" & strAgent & ".doc")...

I have a set of unbound text boxes numbered 181 thru 205, I'm trying to fill with the following code. cnt01 = 0 cntBox = 181 Do While cnt01 < cntRes Me.Text(cntBox).BackColor = lngRed Me.Text(cntBox).ForeColor = lngRed cntBox = cntBox + 1 cnt01 = cnt01 +...

I have a number of forms that are set as Pop Up = Yes and Modal = Yes, Auto Resize is set to Yes along with Scroll Bars set to both. Everything works fine except for 2 users who use a smaller screen resolution. They are unable to view the whole form. If a form fills the page with the screen...

I use the following code to create an Excel file. This works great the first time, but if I reopen the form and click on Command 125 I receive an error "Object variable or With block variable not set" When I close Access and reopen the form, it functions fine. What am I missing? Thanks, Bill...

I am attempting to use DLookup to retrieve the file number (primary key) of any and all previous records that the hull numbers match in a table named “Vessel”. I have started with the following code, and created a new record with duplicate hull number to test with. Private Sub...

I need to convert number amounts over a million to text, as on a check. I have seen solutions for amounts under a million, however we transfer funds over $1,000,000.00 daily. Users are getting tired of typing the amount out. Can this be done? Bill

I have a name field that can contain more than one name, the names are always separated by “and” (i.e. Thomas S. Smith and Tracey L. Smith). I need to split these names out to separate names on certain forms. I started with this code: If InStr(ucName, " and ") Then ucBuy1 = Left(ucName...

I need VBA code to move a Query to a Excel spreadsheet that already exist. I can Click and Drag the query to the opening sheet of the Excel, but I need a easier method for my users. I have tried to use OutputTo command but it just overwrites the entire spreadsheet. Thanks for your help.