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 Mike Lewis 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. 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...
  16. drewcp

    Write Conflict / Default Yes

    This error message pops up on me when i click on my list box and it should be popping up because right before i ask the data to be saved to my table i am erasing the old data in the table, so it is performing exactly what i want and how i want it is there a way though to have it default...
  17. drewcp

    Form Flow

    thank you both, i took both of your suggestions and it is working great! thank you very much for your help
  18. drewcp

    Form Flow

    thank you so much, that solved a lot of my problems with this. do you know of an easier way to transition from subform to subform though? because there has got to be an easier way here's the code that i am currently using to transition with (it is in the lost focus of my last field on the...
  19. drewcp

    Form Flow

    I have a form for data entry The links below show the same form in 'form view' and in 'design view' http://qvepgq.bay.livefilestore.com/y1pyxyMBi74SfwMH51INZEX83qIQpcebwzdRTE-Au4kIo0Ocg7jpA7IXyTNFvcoE-xPaCMBi8QmKV8/form%20view.bmp...
  20. drewcp

    Required Fields

    thank you very much just wondering though, how are they supposed to do data entry without entering into the control?

Part and Inventory Search

Back
Top