Search results for query: *

I found out with trial & error that there is a 255 character limit on each entry in a listbox. I really need to store more than 255. Is there a way to increase this limit or find a way around it?

Nevermind. Idiot mistake. The listbox had been changed to single select and I didn't catch it. Thanks.

On a form I have two listboxes (lstCategory1, lstCategory2) where after I click an entry in the lstCategory1 listbox it sets the row source for lstCategory2. That part works fine. However what I’m having trouble with is after the row source for lstCategory2 is set I want the first item in the...

I currently use a form to open certain PDF documents on our shared drive. Using VB I set the hyperlink property of the command button to point to and open the specific file of interest. This has been working perfectly for over a year now. However, since I’ve upgraded to version 7.0 of Adobe...

I currently use a form to open certain PDF documents on our shared drive. Using VB I set the hyperlink property of the command button to point to and open the specific file of interest. This has been working perfectly for over a year now. However, since I’ve upgraded to version 7.0 of Adobe...

Thanks so much LEWDS. That may just be exactly what I need.

Send ASCII commands to barcode printer over network? I have a barcode label printer connected locally via a serial port. I have VB code (in an Access database) that sends ASCII commands directly to this printer to print labels. Such as… OPEN “COM1:9600,n,8,1” FOR OUTPUT AS #1 PRINT #1...

I have a barcode label printer connected locally via a serial port. I have VB code (in an Access database) that sends ASCII commands directly to this printer to print labels. Such as… OPEN “COM1:9600,n,8,1” FOR OUTPUT AS #1 PRINT #1, CHR$(27); “T”; PRINT #1, “HELLO WORLD” CLOSE #1 The...

I have a barcode label printer connected locally via a serial port. I have VB code (in an Access database) that sends ASCII commands directly to this printer to print labels. Such as… OPEN “COM1:9600,n,8,1” FOR OUTPUT AS #1 PRINT #1, CHR$(27); “T”; PRINT #1, “HELLO WORLD” CLOSE #1 The...

I have a barcode label printer connected locally via a serial port. I have VB code (in an Access database) that sends ASCII commands directly to this printer to print labels. Such as… OPEN “COM1:9600,n,8,1” FOR OUTPUT AS #1 PRINT #1, CHR$(27); “T”; PRINT #1, “HELLO WORLD” CLOSE #1 The...

I have a piece of code (see below) that prints the field names of a designated table to the immediate window. I find it very handy. I would like to be able to do the same thing but instead of listing field names of a table I'd like to be able to list all the control names on a designated form...

I am trying to set up a file search in code using the FileSearch method (see code below). The problem I am having is this... I have a bunch of folders starting with "My", such as "My Documents", "My PDFs", etc. I want to search all of these folders at the same...

I have a combobox of which the AfterUpdate event fires not once but TWICE when I set the ListIndex value via code. Anyone know why this happens and/or how to avoid it? Thanks in advance!

I have a custom menu bar that loads when certain forms are open. Right now all the menu options that I have run existing menu commands from Access. This is good, however I would like to be able to run a section of code (stored in a module) from a custom menu command. Can this be done? I can...

I am aware of Excel's capability to export a chart to the clipboard as a metafile (hold SHIFT, select EDIT, then choose COPY PICTURE) but can anyone tell me if it’s possible to export an Excel chart to an actual metafile image file (with a .WMF extension)?

Yea I caught the 'Filename' oversight. Everything now works as it should. Thanks so much for helping me work this out.

I made your suggested change and it indeed works when I chose the root C: location. The module returns 'C:\temp.txt' as it should. However when I run it again and chose the desktop as the location the procedure returns 'C:\WINDOtemp.txt' instead of 'C:\WINDOWS\Desktop\temp.txt'. It still...

OK here's the code I just ran (please note the change you suggested)... ************* 'Option Compare Database Option Explicit Public strLastPathRetrieved As String Const OFN_READONLY = &H1 Const OFN_OVERWRITEPROMPT = &H2 Const OFN_HIDEREADONLY = &H4 Const OFN_NOCHANGEDIR = &H8 Const...

Unfortunately I tried that already and I either get an 'Out of memory' error message or the procedure returns an incomplete/truncated path string. Any thoughts?

Here's the module that I originally used for GetOpenFileName but have modified it for GetSaveFileName... 'Option Compare Database Option Explicit Public strLastPathRetrieved As String Const OFN_READONLY = &H1 Const OFN_OVERWRITEPROMPT = &H2 Const OFN_HIDEREADONLY = &H4 Const OFN_NOCHANGEDIR...