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...
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...
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...
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...
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.
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
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...
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"...
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?
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
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.