Search results

Yeh but my data-enterer does 19,500 keystrokes per hour, which is as you may know, 5.4 strokes per second....no time to move to control!!!

David, not quite sure what you mean, plus for high speed data-entry user having to press Ctrl plus another key, gets their fingers in a bind. They just want keyboard and Tabkey to do the job....no mice and no two keys at once.

Whoops...Have just found Knowledge Base article which uses AutoFillNewRecord function, as way to go, NOT the above which presents the anomaly.

I'm using the following code so the user does not re-type same info: In After_Update, Me![Deptcode].Tag = Me![Deptcode].Value And in On_Enter, If Not (IsNull(Me![Deptcode].Tag) Or Me![Deptcode].Tag = "") Then Me![Deptcode].Value = Me![Deptcode].Tag End If This code is fine except when...

Yes, definitely AfterUpdate, but only on this last of 9 fields does it produce the Error "Argument Not Optional". It must relate, i guess, to the fact that Tabbing on this field also closes the record and moves to the next blank record. Tks in advance.

Your Dummy VBMan has found that, if using code for Propercase in the last field on a form (e.g. Flds 1-3, Fld3, then next record), code does not work. Should the Propercase Code in that case operate from another option?

Jack, pls ignore last, as have found problem. Had only 40k recs with the nasty & and balance without. Code only worked with those 'with &' so had to modify a little. Thanks greatly, result popped up instantly when corrected. Two big Queensland 4 XXXX beers for you, and Happy New Year when you...

Jack,I'm getting a "Run Time Error 5" and I believe it must relate to fieldname INITIALS. I pasted my 150k table into yr query design (easiest way with a temp 1.5 gig HD), but its not clear where the code problem lies. Why would it work with five record sample db yet not with 130k recs. Its...

Thanks very much Jack. Exactly what I need, and Outlook Express now receives but can't send, hence this note. I will study that layout carefully. Also most of the code I've temp. lost is available here in the Forum. My tech had an IBM HD go too, so I suspect dual HDs (CD's too) for perm.backup...

Is anyone out there who can help me call up a module to create the two new fields INITS_A and INITS_B? I'm new at VB and after mastering code for a form, Ive forgotten what to put where to bring up the code in a MAKE TABLE query. Basically, in the field cell what do I write, in the query field...

Thanks greatly, Jack from the VB Dummy. I'd done that whilst waiting to hear from someone, and whilst I'm downloading Outlook Express 5.03 (to fix the email problem). Now I forgot how to call up the module 1 in the query. Is it Field(Initials must have two new names (say InitsA and InitsB), then...

This should be easy, but Ive had a disk crash and am awaiting holidays to end so people all get back to work in Australia and I can then get my disk repaired.... I have a field with A&B [Initials] and I want to split out B into separate field 2ND INIT. I did have a lovely Module which did all...

If the user is going to require this, then why not concentrate on using options under a Query as opposed to a Form. The filter in Access has the very limitation you allude to. the simple Query Wizard would get youir answer much faster and with less pain.

Thanks for input. I finally worked it. Primarily syntax problem (help Jack Cowley). The correct code for DLookup is : Result = DLookup("[Poscode]", "Poscode", "[Psncode]='" & NewData & "'") However, only the 'pasting' of the new text into Poscode[Psncode] is not occurring automatically...

Are you using a different criteria line for each yes/no box to achieve a result covering ALL options? More specifically, what must the query result show.

I have a form trying to add a new Position Code for a Title (Form called QryInputForm has the field Poscode. I have a related form Posform (Flds: Psncode,Title), and here's the script Ive been working with for 30 hours: Private Sub Poscodes_NotInList(NewData As String, Response As Integer) Dim...

Yes, in ref to your explanation, Pat, that was excellent. I had a similar problem recently where multiple AN/OR criteria was required including in that, a few 'ISNULLS'. I found by default, what you have explained so succinctly. My QBEs compare and select data from 8 tables, and the biggest...

It sounds like you have created the form based upon your two tables only. In Access you need to 1) Link your tables and define a relationship between them. Use relationships key at first. 2) Click query-new-design, open your two tables (the join you created will pop-up automatically). 3) Learn...

In Form design, you can open properties box and go to your tab options. Tab stop =yes for those you want to enter data in, otherwise no. Then you can also set your tab no order. If you have 9 tabstops = yes, then at the last one tab twice and your new blank record appears. Also look at your...

Sometimes the Form has limitations which are better seen by creating a query with all your linked options and then from there, drop in a Sub_Datasheet. Use color options to differentiate as well. Tools-Officelinks and drop wide ranging reports for analysis into Excel is also useful. There are...