Search results for query: *

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...

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"...

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...

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...

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...

how can i set a field on a form as required? OR how can i run validation rules in the 'lost focus' field so that you can't just tab over the field and not fill it in? I know that you would usually set the table property to required but i have the form based off of a query and my tables are...

here is a visual example of the form that i am about to ask for help with because i don't know if it would make much sense without it. http://qvepgq.bay.livefilestore.com/y1povcimLSXmmbkDSjEOeMIytSqYi_XSdRhJxz_--Eqmpfqx_qgLxRizYz_VSQ0kQXvItsJ5l_udxE/batch%20query.bmp So the way that the form...

I have two subforms on a form, on the first there is a table and on the second there are data entry fields i would like to be able to click on one of the records on that table in the first sub-form and have it select that record set for data entry on the second sub-form. does anyone have any...

I have several very large link tables in my database. they are linked to excel spreadsheets. whenever i am performing any action that requires the use of these tables (like creating a form, creating a query, running a query, etc.) it takes a ridiculously long amount of time (sometimes up to 30...

I have a table named "Selections Fields" and a query named "Update Match". All of the 11 fields in the "Selection Fields" table are in the "Update Match" table also ("Update Match" has 5 additional fields). I have a form that is tied to selection fields, so when information is entered onto the...