Search results

And if you can follow VB I have a splitter that even removes the occasional "." such as "Mr." or Mrs.", all courtesy our good friend here Doug Leffler. Of course it takes "J" from John into its own initials field, and then puts John in its own field, and if John follows by Alan, as in Mr. John...

Hi Doug Thanks greatly. I can see how this will work.

I'm still very new at macros, but here's the problem. I have created TOPUP table with no records, but with all fields matching the source data's table. In Transfer Database for the destination name I have TOPUP, but the Macro creates a new table called TOPUP1, then for the 2nd transfer TOPUP11...

If anyone reads this, the sometimes impatient Richard has solved his own problem with the OpenQuery demand, and by setting up 5 Transfer Database lines in my macro. Although they all transfer to sequential table names e.g. table1, table2, etc. it appears that I then just match my Open queries to...

A little new at AccessMacros, my problem is 4 tables importing to one where field names vary but contain same data type e.g. ForeignDbase.1stname -> Mine.Firstname ForeignDbase1.Fname -> Mine.Firstname Is there a Macroprompt to allow field-matching? If I bring in each table separately should I...

Q153747 creates internal haemmoraging when I tried to run my DeptID with the select SQL function. My opened tables are GOV609, DEPT228 and POSCODE. Should I set the fields in design as GOV609.surname or GOV609.Deptcode (joined to Dept_ID), then ignore title (since I dont want 1st 2 records with...

I have had this problem also, and I solved it by tagging the duplicate set of records with a yes, assuming you can use your wizard find duplicates. Then set up a select query to find untagged records. As to quickly displaying the first instance of a duplicate, well I'm still learning by changing...

Thanks, that's great.Correct Properties found. What if I want to select 2 records per DEPT228.DEPT_ID?

If I click properties above the query I get only 4 options to change, Where precisely to do I change to 'Distinct'? My choices are Description, Format, Input Mask and Caption?

My problem is a query using QBE with the following SQL: SELECT DEPT228.dept_id, POSCODE228.To, DEPT228.Deptname, GOV609.IT_GLOBAL, GOV609.F21 FROM POSCODE228 RIGHT JOIN (DEPT228 RIGHT JOIN GOV609 ON DEPT228.dept_id = GOV609.Deptcode) ON POSCODE228.Poscode = GOV609.Poscode GROUP BY...

I have an INITIALS FIELD such that AB&CD Smith are couples. What is the expression to queryupdate COUPLES field to yes. Ive done this before but forgotten the expression. I can filter to replace all & with +, and then use my initials splitter.Any ideas? Thanks in advance...SQL learner.

I have been working on a similar problem, and conclude the form is best left just for manual entries, whilst the query is the more effective path for your reports.

Thanks yes this appears my conclusion also.

CREATING NEW TAGS TO FORM As an Access convert from Lotus, I'm making progress, but here's my question: I use many yes/no logical operators,based on query from 6 related tables.Each new search often requires a new yes/no. In Lotus I can go straight to field definition and add, then add new...

Tks, I tried that and also ensured Lookup tab selected for checkbox, but still can't get it. Strange too is fact that only checkbox created correctly is from an inner joined table's field. I suspect Access corrupted but ran repair/maintenance also. Any other ideas?

Why when I drag my fields into form design, would only one field automatically come out as a checkbox, whilst other yes/no defined fields not? then when I try to change by right-click, the checkbox options are 'greyed out'. Any help greatly appreciated.

I solved it myself.......fundamental

I have a similar problem. The Help pages talk about unique vales & unique properties, but it is not clear. What query will Make a new table just of the unique set of records (based on field [surname], or what words do I put in the criteria box. Also how does one set the Delete recs to keep the...

Appending problem finally working........ [This message has been edited by Rich_Lovina (edited 06-02-2001).]

Tks kindly. I'll give that a go, as otherwise my input form must show both old ID no and new autonumber...rather messy. Meanwhile with the new table in place, my master query wont run, because it claims ambiguous relationships in outer joins, and as there are 8 outer joins I also have to sort...