Search results

Thanks yr comment but as it turned out this was a dumb posting which I self-resolved. It derives from having been deeply involved in data-matching 12,000 names in one source file against 135,000 names in another source file. In doing this all 'Non-Unique' names cannot be considered (Gender...

I am using this in an After_Update in a form for data-entry, but just added it to a calculated (concatenated) fld. Why doesn’t it work under this situation? Nor also when I add a new record, it does not update the concatenated fld until next record. Any short-term solutions? Tks in advance...

What simple command am I forgetting...I need to hold some duplicates and delete others. When I use duplicates query, and then try to update another field called "Not Unique", query says "Query is not updateable". What's the select command I've forgotten?

Have you tried building a query on a query, so you do your OR's first, then in the 2nd query do your ANDS?

Have you tried using the query option? You can do simple searches from the form using the Filter option, but it has limitations. Hence use a query.

Have you tried using the QBE option which can handle almost endless criteria? It takes off where filter runs out of flexibility.

If your 'applications' are separate 'records'in a table, then its very simple to use Query-Select (by whatever criteria), and create a new form.

I have to put my twocents worth in here. Format > works for 'appearance' only, but doesn't actually CONVERT text to Upper, at least not when text is mixed with numbers (Table then shows abc123). But if I want to set ProperCase, with Me.[1stName] = StrConv(Me.[1stName], vbProperCase), this...

Did you use the option Compact Database, which can reduce base size enormously. After that it is often necessary to keep re-making tables to get all you want in the final db. Note the option choose table or query for your new query. TableA becomes TableAA and it has all you want then you can...

This is a basic Update Query, where an extra line will pop-up in your Query Design Grid and you 'replace' text in the selected field, according to the criteria you set.

Thanks greatly, Jack. I chose to put extra code after NEXT and its working well. Helping me dump in fast another 6,000 names. I hate to be pedantic about this VB, but there remains an ability for the user to just 'Keep Clicking forward' (onFwrd Arrow bar)and hence keep pasting the same record...

Now I GUESS this line will go just above the END IF line? Or is it just above END FUNCTION?

I have successfully installed Module forAutoFillNewRecordFields. It can be set to carry forward all data from previous record. However, one strange problem: The only field in the form (from a Many-side table) tied by RI to another table, cannot be changed on the next new record WITHOUT clicking...

It is not clear why you cannot edit a phone number already in your tables. If you have made the Phno a primary key, why not add an autono. field called SupplierID?

Click File, get External data from Access and follow prompts from there....easy as...

Tks, I think the answer's obvious now.

Rich, Tks for the tips. The Record source has the same name as my table, but there's no qry by that name also, but I'll try the other options you suggest.

I have a form based on a query which i now can't find. Is that possible? Anyway the Form is happily working away, and now I decide (developer on-the-run) i want to link a new table to that form, so I can show a related table field. Viz.: Form has field X!Table A, Table B has field Y, which I...

Doug, Tks very mcu yr email. With hols here everything still shut so cannot yet repair my harddisk (Fortunately we believe repairable, as back-up disks also failed). Also on my temp 1 gig system, Outlook Express not loading properly, hence this note. I'm after a zipfile I sent you of the last...

Doug...been looking for you since my hard disk crashed just before Xmas. Some of the emails (zipped) I sent you am desperately seeking to retrieve...Also temporarily can't email out, but can receive. Appreciate contact lovina1@optusnet.com.au Thanks in advance...