Search results

We are now up to 3 posts where you give us a synopsis of your project and I think I finally see a sentence hidden in there that has to do with an issue (but no specific question though): The most common way to call a macro from VBA is via the DoCmd.RunMacro method...

Ok? How can we help you?

Every parenthesis, quote mark and bracket needs a partner. One of yours doesn't.

Just noticed you missed a closing parenthesis. So the Dlookup has one and needs one--that starts right after DLookup and closes with the very last character. The one you don't need starts before [FullAccession] in the criteria string and is not needed, so simply remove it...

Gotta think like a computer. Actually, you have to think like two different computers at once. The last computer evaluates a logic string (the criteria of your Dlookup). When you want to concatenate 2 different rules of logic together you must use ' AND ' between them for this computer to...

You need to not make a single query, but a single table with those values. Why not partition your tables by geologist as well? Alteration_RMC, Alteration_GJP, Lithology_JDM, Mineralization_KAR, etc etc.? Why not partition your tables by year as well? Alteration_RMC_2023...

This is more about logic than regex. You need to come up with hard and fast rules that you can logically implement. You've only given 2 examples, so I can start you off, but you need to verify what I say is the rule is actually the rule for all the data you have: 1. Go to the position after...

No. You cannot access the forms/reports/queries/modules/macros of AccessDatabase1 from AccessDatabase2 or from Application1. You can access the tables of AccessDatabase1 from AccessDatabase2 and from Application1. You can have AccessDatabase1 open and run its...

The only big issue is TestGroup. When you feel the need to numerate field names (Test1ID, Test2ID, etc.) it's time for a new table. Data should be accomodated vertically (with more records) and not horizontally (with more fields). So to group 4 tests you would add 4 records to some table...

You know the business rules, we know databases in general. The best way to do this is for you to show us what you think it should be and us pointing out glaring errors and asking questions. So, post the best ER diagram you have

Define 'hidden'. You can put it in a span with the text color same as the background. You could set the . visibility set to hidden. There's an input type that is hidden. Even with all those options it doesn't ensure the mail doesn't go to spam. That could be based on a variety of things

Is RecId in the SELECT of qryMaterials?

Replying to your numbered points in post #11: 1. Unique RegNo. Not an issue. Make sure in Design view of the table you enforce this fields value to be unique. 2. Multiple Dispatch orders/invoices. Having multiple related records in another table is not a reason to copy over data. Your...

Gotta ask, is the WHERE clause actually just periods? If not, can you just show us the actual code of it? If so, that's an issue.

Stop everything and step away from your forms. Your table structure has a lot of errors that you need to fix before doing anything else. In fact, what you asked about initially shouldn't even be done--you get your tables right and it's no longer an issue to address. First, foremost and in...

Yes, its you can use more than equijoins (those using just = sign): INNER JOIN ABC ON SomeField >= OtherField INNER JOIN DEF ON FieldX != FieldY INNER JOIN GHI ON Field1 Like (Field2)

This should do it: SELECT emp_details.* FROM emp_details, reference_table WHERE (((InStr([emp_details].[city],[reference_table].[city]))>0)); Of course it looks for 'cai' anywhere in the emp_details.city field. So that means a city called 'Ancaid' would be a match

No. But that doesn't mean the ultimate aim is unachievable. You just need to tell us the ultimate aim. It's unclear what you want to do, so I suggest you demonstrate your issue with a concrete example. Show us sample data from employee_details, show us what is in Reference_table and then show...

I don't know if its a complete rework. Is the current authorizations form a single entry or continous form? When the user adds multiple new records do those remain on the page so they can see them (continuous form) or does the prior entry go away once a new one is started (single entry)? If...

Not to be harsh, but that response indicates you don't understand my solution. You've missed the forest for the trees. Don't get hung up on 'main form' 'sub form' designations. Those are just technical descriptions. My solution does what you want, here it is again: The main form is based on...