Activity Stream

Thanks Colin. I'm not sure I correctly stated my problem. The example in my OP was not complete. The thank-you letter contains name, address,...

It sounds like this is the FE of a shared database. If so, suggest you relink all the BE tables. Also, unlikely but possible, check none of the...

Thank you for the replies. Yes, I have 'enabled content' and have code running within other forms that works just fine. Even if I just make a copy on...

The UK postcode structure has so many exceptions, it is very difficult to write definitive rules Suggest you use a table of all postcode areas AB,...

Hi Can you upload a copy of the Excel file with all text in English?

I can only guess because I still know nothing about the related tables. If you have a jobs table, an equipment table and a jobsEquip table (latter...

Thanks for the reply. I have a single table tracking all the tools, which are serialized with a company assigned serial number, and a quantity of...

As a rule there should be the County such as West Yorkshire etc... So I can search for the word Yorkshire and found out that lots of records didn't...

I have found something that worked. Rather than two queries it took three. For some reason I could get a query to pull up the minimum values as...

I did eventually figure out my issue and wanted to post it in case anyone else needed it. In the concatenated queries, I had clicked TOTALS and then...

Do you want the same record on Navigation Subform or do you mean related records of dependent table? Navigation Subform does not have Master/Child...

2 I've used Albert's code many times where I've included data related to individual recipients as fields. For example in my schools apps, letters...

Additional advice. Set FamilyName of tblFamilies as unique index - then user can't enter same family name twice accidentally. Don't use...

Thanks for the quick reply. Code is running fine! I just want the Access window to be activated / focus set. SetFocus API is a good idea. I've...

I have a table called tblBuilding with field names ID_BuidlingName_Address_etc Then I have a form with a navigation subform insert into it This...

I had to look that up, not being a big fan/user of nav forms beyond helping others in forums with their issues. Seems to me that is a means of...

It might have something to do with this appAccess.Run "openjobdetailsform", GetJobID(strJobNumber) You may be tying up the application with...

Field Name ID number for the record that I want. Can I use Navigation where clause?

Not sure what you are asking because of the terminology you use (I think). F'rinstance, what is a "form ID"? Your issue might be able to be...

The form has a navigation subform in it. I tried the Tab Control it worked great but other issues came up so need to use navigation form if...

What do you mean the main is blank? If you 'load' this form, how is it blank? Simplest approach is to use subform container control on a Tab...

I tested CF with combobox and when it is Disabled I am not able to select anything.

Thanks again, June7, for pointing me in the right direction. Here's my solution to working on a continuous subform with two combo boxes, and...

Did you see post #10? Same could be done with 4 records.

Thanks for the help. I agree but we switched over to a different DB and what use to be one record for a particular funding document # that posted...

Possibly each sheet (except for Total) would be a table. I see a lot of data duplicated across sheets (such as name info) so will need a lookup...

Note that with 3 tables, 2 are grouped (1 & 2 ), the 3rd isn't - thus (1 & 2) & 3. With 4 tables you need to group first 2 as a inner/nested group,...