Search results

I had similar problems with DLookup at first...can take a couple of weeks to get it right. Jack, Pat, etc are great help. In programming there are always many "Roads to Rome (roam) to achieve same thing. Have a look at my adjacent post RI still beating me...it may offer some help. Hv you...

Tks Ian, yeh in my 2nd part I was commenting on another totally unrelated piece of code I found in the Forum the other day (author Raskew), relating to carrying forward flds to next record. Now, my focussed question for this posting: E.G. Add2Source MyTable, MyField, etc. In my MainForm...

Tks Ian, now have 5 combos working and only one small conflict emerging. Gotta run more tests as one was keeping old PK field with an After_Update and an OnEnter tag method for carrying forward records. One combo i built where there's no related table (I just want it to lookup existing entries...

Dear Pat Tks, that would be easier I guess, but I've jumped to so much VB, Ive forgotten the expression to build on the Update Query? Any help, tks in advance. Nb. Just searched the Help, tried StrConv(UCase([Poscode]) in criteria, but no luck....must be close to this. [This message has been...

In my MainForm I use an After_Update event to create capitals, i.e. Me.[MyCombo] = StrConv(Me.[MyCombo], vbUpperCase) ....but in the related table the text remains LowerCase. Is there anyway to ensure reltable or MainForm hold UpperCase, irrespective of user's entry?

Dear Ian Thanks greatly. Its working. I put the function as a new module and called it by the response line code....great. Checking the related table, the Poscode fld pasted in. Beautiful! I designed a form to add info in a related field (Poscode228!Title), do I type in under response code ...

Dear Ian Tks yr suggestions. Hve some simple questions. When you refer to "above" code, do you mean my entered code or yrs 'above' that? If mine, I changed the line: Response = acDataErrAdded to your suggestion: Response = Add2Source("POSCODE228", "Poscode", NewData) at which point when I...

Dear Fornation Thank you very much for yr input. Ive just installed the following code, and hv one or 2 problems.... Can you tell me, I hv a Form POS_INPUT which opens as a pop-up ready for data-entry (Data=yes). My code : 1. Doesnt open the form (where do I put Docmd.open form, etc.? 2. Tells...

Thanks greatly Pat. That sounds like the path I'd forgotten.

Okay fellow developers, maybe I'm slow, but here's where I'm falling over again with p'raps too much code. My form has 6 related tables and is based on a query. Data comes into my main table by import and also by data entry. The data-entry often means trying to add new codes which do not exist...

Solved this problem by going back to code which carries forward text one field at a time, as the global module can create conflicts...it appears, with this one.

I have a form with an AutoFillNewRecs, which was tied to a table. Now i TIED IT TO A QUERY, and the formfields tied to the related tables cannot accept a new entry for a new record. We get the message : You can't change this field until you save the record. And if I try to save the record it...

Have a look at Northwinds your sample database. Have a look at the forms there, and use your help. Also suggest Searches in this Forum with "Lookup", "RecordSource", etc. Also go through the MS KnowledgeBase where there are many answers for you to research. It takes time, but you'll get there,

The Drop Down List option may be okay for a few records, but it also doesn't tell you if ABC Computers is the same company as ABC Computers Pty Ltd, or any one of 10-20 variations. Have you looked at running a Query/Make Table with a concatenate field of significant factors e.g. ABC Computers...

Your easiest way is to use the Search Engine in this Forum and type "Split Fields", and you'll get 61 postings that discuss the many ways to handle this.

From the MS KnowledgeBase comes this description: Comment:- Steps 45 onwards did not work for me, rather I change Tabstop from yes to no if this becomes a problem. You can still access yr other fields by mouse. To create and use the AutoFillNewRecord() function, follow these steps: 1. Open the...

Trouble with this in Access is that it is gently complicated and requires use of a VB Module to implement. Use the search engine for Auto fill New records in this Forum 1st, or search AutoFillNewRecords, or Fill Records. This is also explained in an MS Knowledge base article, if you are familiar...

Your simple Find/Replace command when in tables will do this too, but her just hit your space bar as the 'thing' you want to find and in replace just hit replace. This works only if your string has only leading spaces. Test it and see...its very quick

Tks, found my problem. I created the concateFldC with a QryMakeTable, so of course nothing happens when I enter a new record. What simple code shld I put to create C, assuming it goes in After_Update of FldB. Sorry still bit dumb with vb but gettin there.

Tks, but I'm not understanding yr 2nd sentence; or are you saying: A/Update is sitting in the wrong place viz. If fldA + fldB 'create' fldC the A/Update must be in properties fldB, and NOT fldC?