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!

  • Congratulations TouchToneTommy 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: spencern
  • Content: Threads
  • Order by date
  1. spencern

    Changing Printer before print

    Hi everyone, I have a report that is printing out to a label printer. The only problem is, the label printer is only used for this application and shouldn't be set as the windows default. Is there anyway to change the printer in the print dialog only when the report is run, and then set it back...
  2. spencern

    Changing default number of copies to print

    Hi, I'm investigating the purchase of a thermal label printer to use with an access app to print labels. Every time a label is printed, there needs to be 3-5 copies of the label. I'm thinking that the best way to print would be to setup a report with a single label in access and then change the...
  3. spencern

    Changing time on a page

    Hello, I've got a page that I'm trying to print out the current Pacific time on but I've run into problems because my server is based in england and is 8 hours off. Does anyone know if there is anything I could do to my code to make it adjust to -8 hours of what the server's time is...
  4. spencern

    Selecting record to print from subform

    Hello, I'm working on a pharmacy db and can't figure out how to print a report based on which record is selected in a subform. Basically I have a subform that shows refills. I want to be able to right click a row in the subform, select print and have it print out a sheet of 10 labels. I think I...
  5. spencern

    Requery Combobox on subform

    Hello, I have a main form add_customers that has a subform Equipment_Subform1. One of the fields in the subform is a combo box that gets its data from another table. I have a button to open a form to add entries to the table that the combo box gets its data from. After I add entries I want to...
  6. spencern

    Selecting records to print

    Hello, I'm working on a db that has a large list of customers in it. I am trying to figure out the best way of printing address labels only for selected customers. This is what I am thinking of doing, maybe someone else has done this and knows a better way... Every customer record has a field...
  7. spencern

    Updating Combo Box

    Hello, I'm working on a db that is medical related and I'm having a hard time figuring out how to update a combo box on a form. On the add patient form is a combo box showing doctor names. You select the patients doctor from the list. If the doctor is not in the list I have an add doctor button...
  8. spencern

    Best way to do gender selection

    Hello, I'm making a form that stores some information about people including gender into a table. I'm not quite sure how I should make the selection of gender on the form though. If I use an option group then it will only store numbers in the table, and I don't really want to use a combo box...
  9. spencern

    Option group values as text?

    Hello, I'm sure this must be simple but I can't get the values of radio buttons in an option group to have values stored as text, I can only get 1 or 2 for a yes/no situation. Can I store Yes or No in the table instead of 1 or 2? Thanks, Spencer
  10. spencern

    Simple Search

    Hello, I'm working on a database and I would like one of the forms to have a text box that will search through all of the last names in one table. It seems like it should be simple. I'd like to stay away from the built-in Find dialog since it's not as easy as just entering a name on the form...
  11. spencern

    Error when using Access Wizards

    Hi, I'm using Access 2000 and have a problem when trying to use any of the wizards to create forms, tables, reports, etc. Whenever I click on one of them I get an error saying "ActiveX component can't create object." I've tried using the repair function on the office disk, but it still...
  12. spencern

    Using Digital Camera Wizard

    Hi, I've got a Minolta F100 Digital camera. When I connect it to my computer with xp home on it, it only adds the removable drive icon in my computer. I want it to open up the autoplay window and ask if I want to use the camera wizard to copy the pictures to my computer. When I plug the camera...
  13. spencern

    New Install of XP on Home built machine

    Hello, I've just built my first computer and am now trying to install XP home onto it. I keep getting an error message though and the machine has to be restarted. Here's what happens: I put the XP CD into the drive and reboot. A message says to boot from CD press any key. (If I wait to long I...
  14. spencern

    Building Computer- Help with Switches and LED's

    Hello, I'm building a computer for the first time and I've run into a problem with the switches and LED's that are build into the case and the connections on the motherboard. I have an ECS P4 Mainboard and an ATX Case. I've got the motherboard in the case and started to connect the different...
  15. spencern

    Clicking button keeps it pressed down

    Hi, I'm new to Visual Basic and I'm just trying out some simple ideas I have for easy programs. I was wondering if any Visual Basic wizard could answer this. Is there any way to make a command button stay pressed down when you click it and then pop back up when click it again? Like a toggle...
  16. spencern

    New Popup Ads

    Hello, Lately I've been getting ads that popup when I'm using IE that look like the've come to my computer without me clicking on any type of ad or going to a site that has ads on it. This is one that I received a few days ago... http://mvhs.stormhosts.com/popup.asp If the link doesn't work, try...
  17. spencern

    Inserting IP address into Database

    Hi, On the first page of my site, I want to insert the users IP address into a database. I made a command under server behaviors and put the following code under sql: INSERT INTO visitor (IPAddress) VALUES (IP) Then down below in the variable section I put IP as the name and...
  18. spencern

    FTP Problems

    Hello, I'm using UD4 and I'm having some trouble with my ftp account at stormhosts.com. Currently I can't delete any files from the account. If I try to it waits 60 seconds and then says connection to host has timed out. Anybody else have any trouble with this?Anyone know any soloutions...
  19. spencern

    Quick Title Question

    Hi, I'm working on a video and I'm trying to get the titles that can be created in premiere 6 to fade in and out. I've got one piece of video that's about 1 minute long on the Video 1 track. I've made 10 different titles and put them on the Video 2 track. I want to superimpose them over this...
  20. spencern

    Making a database an .EXE

    Hi, I'm thinking of starting a small database project for someone who doesn't have a version of Access on their computer. Once I'm done with the database is there anyway I can turn the .mdb into an exe that will let data be entered, but won't let the forms be edited? Do I need the Developer...

Part and Inventory Search

Back
Top