Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: utc13
  • Content: Threads
  • Order by date
  1. utc13

    255 character limit on each entry in a listbox?

    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?
  2. utc13

    Trouble with Selected() property on listbox…

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

    New version 7.0 of Acrobat acts differently with hyperlinks

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

    New version 7.0 of Acrobat acts differently with hyperlinks...

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

    Send ASCII commands to barcode printer over network?

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

    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, CHR$(27); “T”; PRINT #1, “HELLO WORLD” CLOSE #1 The...
  7. utc13

    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, CHR$(27); “T”; PRINT #1, “HELLO WORLD” CLOSE #1 The...
  8. utc13

    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, CHR$(27); “T”; PRINT #1, “HELLO WORLD” CLOSE #1 The...
  9. utc13

    Debug.print list of control names on form?

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

    Wildcards in the FileSearch method?

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

    Set ListIndex...AfterUpdate fires TWICE!?

    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!
  12. utc13

    Run module code from a custom menu command?

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

    Export excel chart to a .WMF file?

    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)?
  14. utc13

    Suggest/default filename using GetSaveFilename?

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

    Suppress "Importing..." message?

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

    Position the GetOpenFileName dialog?

    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?
  17. utc13

    Trouble with SQL INNER JOIN...

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

    Avoid duplicates in ComboBox?

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

    Detect if Database window is visible?

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

    Design suggestions?

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

Part and Inventory Search

Back
Top