Recent content by JS Smith

Can anyone explain why (M__99_COLog_Test.[CO Number]="YMC1") is working? What does the "YMC1" mean?

Thanks @June7 for the suggestion. I'll keep that in mind. Took lots of experimenting but it works with {IF { MERGEFIELD Scope_of_Work} = "Owner" "{ Project Contact }" ""} Total pain , though, as you have to use CTRL+F9 for every bracket and without VBA you can't copy, paste and adjust the line...

Hi just starting to learn Access and Word Mail Merge. I couldn't find answer via Google. Nearest solution was the Next Record but wasn't sure how the syntax should read. My Access Table is like the sample below. How can I use formulas in the Merge Fields to give me the «Project Contact» if...

Sorry Pat, I must've forgot to put it into my sample DB. I had @arnelgp's code in the Company's Control Source

Works like a dream! Can you explain why/how so I can learn? I saw the filter on the form. I think this is you fix but don't understand all the syntax. (M__99_COLog_Test.[CO Number]="YMC1")

@arnelgp your formula gave circular reference error. Tried with various combinations using "Contract #" and "Contract Number" but did not have success. Tried to create some workable sample and cleaned any company data. Attachment is a close analog of my DB. Yep, the naming convention is bad...

D'oh, thought I corrected all the text. The stuff in red has been omitted in my original post. I had name different while designing this to make it easier for me to read. I had the dlookup on the COLog form, in the Company field. I wish I could include the DB but it's too large and full of...

Form is called COLog Yes it's called Contract # until I have the DLookup sorted. I need to be able to tell the difference between the Form stuff and the Table stuff; see previously mentioned dyslexia issue.

The setup: Table BuyOut includes in it's columns Company (Short Text) and Contract Number (Short Text) Form COLog includes in it's text boxes Contract # and Company Form COLog feeds table COLog. Both Contract # and Company are Short Text Goal: User keys in a Contract # and the Company field...

Pat & Doc, thanks so much for your guidance. Might have to take this on in steps and create as I pick up skills. I'm trying to improve a process where the user starts a mail merged word doc using some Access data, edits the word doc to include data from a bunch of pdfs, turn that word doc into...

Hmm, Doc you got me thinking. Is what I want possible in Access? My last job, I spent 3 years where the most powerful tool available was Excel 2010 so I'm in the habit of making something out of nothing, usually with VBA so that may explain this goofy thinking... I have 3 tables, 2 full of...

Thank you for your help! I have much studying to do! Learning Access is like pulling a loose sweater thread...

Am I connecting the dots correctly? Tables are just data repositories? I can/should build a query, using data in the existing Project and Contract tables, which will feed this future End-user Form, the form will do the heavy lifting, calculations, look pretty, etc., then the form can append...

Thanks for adding some facts along with your opinion. I try to not just take someone's word for anything, that's lazy and not education. Usually, I experiment to see if an opinion holds water or applies to my situation. My previous Access experience is limited to using a database in Excel...

Hi! I'm an Access novice and got a new job. I'm trying to reduce some of the duplication to get more efficient. They have Access but nothing like Sharepoint or other PM software. Eventually, there will be a nice looking Form that can be printed as a Change Order for contractors while feeding...