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 strongm 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: *

  1. txfink

    ActiveX ComboBox

    I'm not really sure how to do this, but I'm sure there is a relatively simple way for some of you all who know this stuff better than I do. So here is where I'm at and where I'm trying to go. I'm looking for any input on how to get there. I have two worksheets, called 'Input' and...
  2. txfink

    Using Worksheet_Change Event

    I think this is an easy question, but never tried it before and having problems getting it to work so figured I'd pose the question. Any help will be greatly appreciated. What I'm trying to do is run some code (a select case statement) when a specific cell changes. The code (the select case)...
  3. txfink

    SQL To Insert Newly Created AutoIDNumber Into Another Table

    Finally able to get to the system I'm working on today and I tried the recommendations - it worked like a champ - thanks a bunch for the help. Does anyone know of a good site that covers sql syntax? I understand the logic of the code we just used, but not the syntax. I'd like to get a reference...
  4. txfink

    SQL To Insert Newly Created AutoIDNumber Into Another Table

    Thanks everyone for the responses - I definitely would not have come up with that on my own. I'll be playing around with it here today and will let you know if I have any problems. Much appreciation. -smf
  5. txfink

    SQL To Insert Newly Created AutoIDNumber Into Another Table

    I think this is going to be an easy question (and answer), but I'm not familiar with how to get it to work and I've been trying to figure it out for a little while now. Thanks in advance for any assistance - let me know if more information is needed. So I have two tables, with relevant fields...
  6. txfink

    Subform Comobox Requery

    I thought about doing it that way, and it would certainly work if 'frmAddNewTransaction' was the only form accessing 'frmAddOwner', but I have three other input forms with essentially the same scenario (selecting the owner from a combobox or adding an owner via 'frmAddOwner' if the owner isn't...
  7. txfink

    Subform Comobox Requery

    Perfect - thank you both. It works great now. I added the first line of code from lameid in the 'On Active' event for the main form. Forms![frmAddNewTransaction]![subfrmTransactionOwner].Form![cmboSelectOwner].Requery I think the logic would be when the owner is added, 'frmAddOwner' closes...
  8. txfink

    Subform Comobox Requery

    I think this is pretty simple and my lack of knowledge with VBA is holding me back, but I've been trying for a few days and still can't get to work so figured I'd post the question. Let me know if anyone would like any other information. Thanks in advance for taking the time to read / help. So...
  9. txfink

    Need To Delay Input of Bound Controls Until Event

    Thanks guys for the responses so far. The event I thought of was a button the user would click, but really it could be anything - doesn't necessarily have to be a button. The data being entered by the user will be in text format so it would be hard to validate it against any kind of input rule...
  10. txfink

    Need To Delay Input of Bound Controls Until Event

    So I have a form with controls (text boxes) bound to an access table. I need to have the user input the relevant data into each text box and then after entering all the data, a user initiated event triggers the data to save to the table. I don't want the table to be updated at all unless the...
  11. txfink

    IE error

    Have a user running xp sp1 and when he opens IE6sp1 he gets program error. Nothing specific, just generic send / dont send error message from xp. IE window never launches. Sys restore failed so I removed programs and non msft services from startup, ran spybot, pulled IE from registry, downloaded...
  12. txfink

    How do i enable a printer to see 11x17 paper

    Try to uninstall all printer sw and then reinstall driver
  13. txfink

    New Dell Computers & Win XP

    Are you using fdisk or the xp cd to format? I've seen similar situation where xp disk formatting fat32 caused problems. Used fdisk to delete / recreate the partition and 98 installed fine. Probly at least worth a try.
  14. txfink

    moved ram from one laptop and not sure...

    Boot the system with each chip seperately, using only the slot that is not broken. Whichever chip causes the system not to boot up is the bad chip.
  15. txfink

    moved ram from one laptop and not sure...

    try each chip seperately in the memory slot that isnt broken. if the system boots with either chip in, they are both fine. if not, the one that causes it not to boot is the problem.
  16. txfink

    Strange CDRW/DVD problems - A challenge for someone

    Try pulling the cdrom from registry and let xp reinstall it. I've seen this fix some strange cd issues. Delete upper and lower filters from this registry key and then reboot - HkeyLocalMachine - System - CurrentControlSet - Control - Class - 4D36E965-E325-11CE-BFC1-08002BE10318
  17. txfink

    Fax Service w/ Officejet

    When you configure the xp fax services you can pick the modem you want to use. In the setup of the xp services you have the option to pick the officejet as the fax device. This link may help if you want to use xp fax services...
  18. txfink

    fax over ip (FoIP)

    anyone ever setup and used fax over ip?

Part and Inventory Search

Back
Top