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?

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

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)?

I have been using the GetOpenFileName dialog with much success lately. I now have a need for the GeSaveFileName dialog which I have successfully converted to using my old code and some previous posts. However when a user activates the Save dialog, I would like to suggest a filename by placing...

I have an image control on a form. A different image is displayed in the control when the user moves from record to record. The images are stored in an external directory and I use the OnCurrent event to change the image control's '.Picture' property. The problem I have is that each time you...

I am currently using the GetOpenFileName method to open the dialog and retrieve a path. However the dialog appears in the upper left corner of the screen. Is there a way to position it in the center of the screen?

I’m attempting to retrieve records using an SQL INNER JOIN but the query returns duplicate records (under certain circumstances) and I need to eliminate this problem. Here’s what I have… I have a table named ‘tblLOGIN’ which tracks samples as they come into the building. One record represents...

I have a field in which I would like to provide a combo box which lists all of the values (choices) that have been previously entered for that field (i.e. the user can enter anything they want but I would like to provide them with an easy combo box that lists the other values already stored in...

I have a form that I use as my Main Menu. When my users log on the Database window is hidden therefore closing the Main Menu form exits the database (as it should). However when I’m working on it the Database window is visible and when I close the Main Menu I don’t want the application to...

I have a table that logs in incoming samples. Each record represents 1 sample that has been logged in. It has around 10 fields that track different pieces of information regarding each sample. One of these fields tracks a bar code that is assigned to each sample as it comes in. The problem I...