ebo2006
Last Activity: Apr 24 '08, 07:50 PM
Joined: Oct 24 '06
Location:
-
Thank you. I apologize for not replying immediately. My mom passed away and went on bereavement leave for a while. Anyway, as to the form, it has no bound objects. The form is really a basic data entry form. On click of a submit button it will insert records into the two tables. One or more records will be inserted into tAcctErrors depending on how many checkboxes were selected, where the etype field will be the value in the label describing each... -
Checkboxes in a form to update related tables.
In the form there 16 checkboxes for types of errors a user can choose from depending on the number of errors found in one account entry. I believe putting 16 corresponding checkbox fields in the tErrorAcct table is not the best way to do it although it will make development easier.
Anyway, the batabase is set up to have a tErrorAcct table with the AcctNum, EntryDate, EncoderID (some other data fields); and a related table called ... -
Jim, you're the man. It works. Thank you so much for your patience and time. I am trying to learn access own my own. A little at a time. Your'e help is a big thing. Now I don't have to reinvent the wheel. I've learned so much from this exercise: use of double qoutes and single qoutes, remembering that labels don't recieve focus, etc. Thank you again and to you too, missinglinq....Leave a comment:
-
Jim, Thank you for your patience. I copied your codes into the AfterUpdate event of the Text box. I am not getting in the routines, meaning I don't get the expected messages. If I press <enter> without entering any ID, the cursor goes straight to the next text box, no message. If I enter a 3 chracter ID (existing or not) it gives a "run time error 3061. Too few parameters. Expected 1." error message. Will it help to know that CID...Leave a comment:
-
Jim, I entered the codes but I am getting a syntax error in
I can't find the syntax error (error 3075 missing operator in query expression "[CID] =". Tried to change the [CID] with tblReps.CID, same error....Code:Set Rst = db.OpenRecordset("SELECT [CID] FROM TblReps WHERE [CID]=" & Me!txtReps, dbOpenSnapshot)Leave a comment:
-
My bad, Got confused myself. It is a text box not a label. LABELS DO NOT RECIEVE FOCUS !!!
Jim, I have not tried it yet. I'll let you know....Leave a comment:
-
Hi, Jim. I'll try this. Thanks....Leave a comment:
-
Hi. Don't get confused.
You are right, the function was used as, mentioned in the original posting, for a command button. Only now I don't want the user to choose but just press enter and the focus is brought back to the Text box to enter another ID.
Labels do receive focus. In one of the other fucntions where the user enters an item number in a Combo box, the validation is done in a GotFocus event of the Label next to it....Leave a comment:
-
ID validation
I have this code for Id validation. The ID is entered in a text box, and validates the entry in GotFocus event of a command button. However, it does not work when I use it for the GotFocus in a Label Object. It is giving me an error message "Run time error 3251, Operation is not supported for this type of object".in statement the: Rst.FindFirst "[CID] = " & Me.txtReps
Below is the complete GotFocus function. What should... -
Hey guys, you need not reply . I got it. Thanks anyway....Leave a comment:
-
SELECT statement with WHERE clause
There are two combo boxes in my form: CORP and CLASS. The WHERE clause of the SELECT statement in the Row Source Property of the CLASS combo box works only every time I start the form. It does not change the list options when I select another ID from CORP combo box. Why is this so?
Here is my select statement
...Code:SELECT [tblTYPE].[tech], [tblTYPE].[corp] FROM Courses WHERE [tblTYPE].[corp]=form.ID ORDER BY [tblTYPE].[tech];
-
I tried it and it works.
However, the WHERE clause of the SELECT statement in the Row Source Property of the combo box works only every time I start the form. It does not change the list options when I select another ID from another combo box in the form. Why is this so?
Here is my select statement
...Code:SELECT [Courses].[tech], [Courses].[corp] FROM Courses WHERE [Courses].[corp]=form.ID ORDER BY [Courses].[tech];
Leave a comment:
-
Thanks. I'll try that....Leave a comment:
-
Data Entry shortlisting selections
I have a very large table to do a dropdown list. How can you shortlist the selection options as it is being spelled out. Example, as I enter ORT for my name selection, the options will show only those starting with ORT. And as more letters are entered, the options are shortlisted further. I have seen this in some sites, but I don't know if this is possible in MS Access. -
Thank you guys for the help.Leave a comment:
-
validate if entry is in the master table
How can I validate the entry in a form, say cutomer number, is in the masterlist table, else do not accept entry? -
I did that. Can't find an access database sample for vacation and attendance tracking. Thanks though....Leave a comment:
-
Attendance - vacation tracker
I would like to study an Attendance - Vacation tracker that can add and edit retrieve attendance record by date and by employee. Does anyone have one with a source code? -
Hey, thank you guys, with the delimeter it works. One stumbling block down. I can try another feature now. Thank you again.Leave a comment:
-
Hi.
Subform sfrmOffDetail has Property Name sfrmOffDetail
and for subform frmDateDropDown the Property Name is frmDateDropDown 2.
What I expect to happened is that in the subfrom sfrmOffDetail the records from tblOffDet table (correction: the for this table is compound key is CheckInID and Dateoff; not PeopleID and DateOff) for the person with CheckInID I got from people search, with date (text2) I got...Leave a comment:
No activity results to display
Leave a comment: