Search results

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...

Your Authorization Form needs to be a main form and a subform. The main form should be based on your Patient table. This will allow you to display all info you need about the patient. Then the bottom should be a subform based on your Authorization table and linked to the main form via...

From a developers perspective, 1 form based on 1 table and you'll never go wrong. From a users perspective, by using pop-up forms, tabs and subforms a lot of those forms are seemingly integrated into 1 form. So no, you can't do all those things you want with one form. Or even from a users...

How is TOTAL being calculated? Can you show us that code and any subsequent downstream code? My guess is TOTAL is rounding rounded values. For example: 1.114 2.224 3.334 If you add then round you get: 6.672 6.67 If you round then add you get: 1.11 2.22 3.33 6.66 I think your rounding too...

Excel is the CRUD application. You're trying to reinvent a wheel with a wheel. You can create records by typing in a blank row, you can read and even print data from it, you can update values by overwriting the cells, you can delete records by right clicking and deleting.

Huh? The column name doesn't display. The label of the list box does display-- center that (or add leading spaces to it) instead of trying to fix a formatting issue in SQL.

No it doesn't make sense. 1 table makes sense. With what you have given us, I see only 1 table, exactly as it is. Again, you only need one table for this data, exactly as you have it now.