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

  1. bozic12

    SQL ComboBox row source question

    Nevermind...just figured it out. It was a stupid, stupid syntax error that took me 3+ hours to finally figure out!! Gotta love it... Thank you to anyone who may have spent some time testing this out for me. Jeff
  2. bozic12

    SQL ComboBox row source question

    Hi all, I have a combobox that shows multiple fields. I used the combobox wizard to create it because the source of these fields, 'Insert Table', is from a different table than the forms controlling table, 'Cutter Config Table', but I want the Insert_ID field from the recordset of the chosen...
  3. bozic12

    Use SQL as Source of Text Box

    Hi AlexMidd, Thank you for your reply. Yes, I'm sorry for the confusion and my mistyping. Main_Stackup_Form is actually Stackup_Form. My goal is to use the Cutter_ID of the of the Stackup_Forms current record (in the Stackup_Table), to populate a textbox on the same form with the Cutter_No...
  4. bozic12

    Use SQL as Source of Text Box

    Hi all, I have an unbound text box, Cutter_No on the form Stackup_Form, which is populated by using a Select_Cutter_Form form. I then use a hidden text box, Cutter_Hidden, which is populated using the dlookup statement to convert this number into the associated primary key of...
  5. bozic12

    Outlook Task Request coding Question

    Hi all, I have designed a simple Access db and form for end-users that creates an Outlook task request. The only problem is that I do not want users to receive updates to these tasks and view the notes and progress of the task. Is there a way to programmatically turn off the "Keep an updated...
  6. bozic12

    After_Update Event not initiating

    PH, Thank you for the reply. I see the direction you are going, and it makes perfect sense. I'm having syntax errors though. It automatically takes away the () (ie. Call me.cutter_no_AfterUpdate, not AfterUpdate()). This produces an Compile error of method or data member not found. This...
  7. bozic12

    After_Update Event not initiating

    Hi all, I'm sure this is very simple, and I'm looking past the obvious. I have a command button that executes code to open a file browser. I then have a text box that populates with the chosen file path. This text box having it's value property changed via code and does not initiate the...
  8. bozic12

    Relational Data using Forms

    Cool, Thank you both for your posts. I will try-out both methods. Joe -- I like your method, and using code is no problem. I am actually (believe it or not from my post) quite familiar with VB (although I have not had exposure to the nz function - a handy little one after looking it up...
  9. bozic12

    Relational Data using Forms

    Thank you both for your replies. PHV -- I would prefer not to use comboboxes, as some of these fields could contain thousands of records. In addition, I have a form that they can launch in which to search for a particular value if need be (typically, the user will know this value though, and...
  10. bozic12

    Relational Data using Forms

    I know I'm missing something fairly simple here... I have a form controlled by a table which has a foreign key to another table. I would like the user to input a value into a text box, and if that value is in the other table, place that primary key (the foreign key in the controlling table) as...
  11. bozic12

    Control on Form has User Input Related Value of Foreign Key

    Hi PH, Thank you for the reply. I don't necessarily want these to be comboboxes (although they are in other similar situations). I am referring to text boxes here; I have a makeshift search form (which will become more extensive after future revisions), which will populate the text boxes, or...
  12. bozic12

    Control on Form has User Input Related Value of Foreign Key

    Hi All, I have a relational database and am having issues that I'm guessing are easy to fix, I'm just overlooking the obvious answer. There is a main stackup table, that has attributes of a cutter id, holder id, and spindle id, which are foreign keys to respective tables for cuttters, holders...
  13. bozic12

    Logical Error with recordsets

    vbajock and daltonvb, I did end up using the recordsetclone method, I was unaware that it even existed! Thank you both much as I have solved my problem. I still don't know why my problem was occuring, but it doesn't matter now! Thanks again! -Jeff
  14. bozic12

    Logical Error with recordsets

    Hey all, I'm encountering a logical error that's kind of difficult to explain, but i'll do my best. I have 3 forms in which to input data for an assembly. I have another form to input an assembly number, which in turn fills in the forms with the data from the records in 3 repective tables...
  15. bozic12

    How to do a new fresh instal of W98SE

    If you can't boot to a cd, try this: If you have a Win98 start-up disk (if not, make one), boot to dos, the at c:/, type c:/deltree windows (or just format c:/ if you want to format the whole drive). After windows is deleted, boot to the start-up disk with cd-rom support. After bootup, find...
  16. bozic12

    Hi all, I have a form in which you

    Ok, thanks for the info guys. I just had just noticed that the enter even of a command button runs when I press the enter key. It's always good to learn more tips. -Jeff
  17. bozic12

    Hi all, I have a form in which you

    Hi all, I have a form in which you type in a parameter, then I have a button which produces a report based on the parameter, and then closes the form. Everything works fine, and I have the code in the click event of the button. Although not totally necessary, I'd like to have it in the enter...
  18. bozic12

    Having only one field in query be distinct

    Steven, Your changes do exactly what I desired. Thank you so much for all your time you put forth to help me out, I really appreciate it. I'd give you more than one star if I could. -Jeff
  19. bozic12

    Having only one field in query be distinct

    I sent it. Thank you for your time trying to help me out, I really appreciate it
  20. bozic12

    Having only one field in query be distinct

    yep -- [Tool Characteristics]![The Date]

Part and Inventory Search

Back
Top