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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by drewcp

  1. drewcp

    SendKeys Function

    I tried writing a code that will send a series of keystrokes to an external application i have been trying for a long time to do this and finally was able to get it to this point by using this article i found on MSDN http://msdn.microsoft.com/en-us/library/fx2k26ca(VS.80).aspx here is the...
  2. drewcp

    Using Dmax

    it works! thank you very much
  3. drewcp

    Using Dmax

    I am trying to create an update query that will update one table with a value created from another query it is supposed to take my field RECID from my query Batching and update the RECID field in my Batching RECID table here is the sql that i am using to try and do this UPDATE Batching...
  4. drewcp

    Work around Type Mismatch

    I used your second suggestion and it worked perfect, thank you so much
  5. drewcp

    Work around Type Mismatch

    I have the following sql statement SELECT UTADBA_PARCEL.PARCEL_ID, UTADBA_PARCEL.LINK_ID FROM Serial INNER JOIN UTADBA_PARCEL ON Serial.[Parcel ID] = UTADBA_PARCEL.PARCEL_ID; I know that it is a type mismatch because Serial.[Parcel ID] is a number and UTADBA_PARCEL.PARCEL_ID is a text I...
  6. drewcp

    Writting and If / Then

    I have my main form, Batch Query, which has three sub forms 1 - Batch Query Subform 2 - DataEntry 3 - Photo the DataEntry sub form has 5 sub forms on it 1 - UTADBA_BATCHING2 2 - UTADBA_PARCEL 3 - UTADBA_LAND 4 - UTADBA_RESIDENCE 5 - New Growth on my main form i have text box that populates a...
  7. drewcp

    Form Works / Subform Doesn't

    Nevermind on this, i figured it out what i did was to create an append query that would only append the fields that i needed and then requeried my form to reflect the new record added on my table/query.
  8. drewcp

    Query item on network drive

    YES! i did that and was able to link into it from my picture properties. thank you so much Remou for your help, that is exactly as i wanted it. Even better news is that they will all have images so i believe i am totally done with this problem. thank you so much
  9. drewcp

    Query item on network drive

    thank you much as you showed me earlier with the hyperlink, how is it i can put that coding into the image path?
  10. drewcp

    Query item on network drive

    yes, i have it saved as module1 and that's about as far as i have gotten, i did not understand how to create the form to display the picture based on the information given in the article. basically, where is image control? i couldn't find it anywhere, i was even adding pictures to try and find...
  11. drewcp

    Form Works / Subform Doesn't

    I have a form that i have set as a subform Here is my form And here it is set as a subform What my problem deals with is my duplicate record button on my subform (uses the new record icon) The new record button has the following code (as a macro) on the event "on click"...
  12. drewcp

    Query item on network drive

    Alright, so i have been trying and trying and trying to figure out how to put the picture on my form but to no avail, i am afraid that i just do not understand the article enough to do this yet. Would anybody mind lending me some additional assistance on how to do this?
  13. drewcp

    Query item on network drive

    thank you so much, the hyperlink works perfectly! and thank you very much for the link to show how to display the image on the form, haven't figured it out yet, but that is going to be a huge help thanks agian
  14. drewcp

    Query item on network drive

    On my database i have a button my goal for this button is for it to pull up a picture off my network "P:\" Drive In my table i have two fields that i need to use JOBNO PREF_PIC_NO so here is my example data JOBNO - 1998080993 PREF_PIC_NO - 11 so the picture i am trying to pull up for this...
  15. drewcp

    Write Conflict / Default Yes

    I actually don't have the code anymore because i ended up changing the database last night and took this part out. Sorry i couldn't help you in helping me, but thank you for your response if you had any ideas for this though, givin the information above, so if others have the same problem...

Part and Inventory Search

Back
Top