Search results

The folders were created and tables relinked except I couldn't find [Selectie_tbl]. Also the database won't compile since it is missing some reference. Maybe the general.mdb needs to be configured.

I agree with the pass-through query since these are typically very efficient. There was no mention of the number of records and fields. Also, are all fields required in the reporting?

We had a similar normalized table structure at a former employer. We added an attribute table to store different characteristics about a Part. For instance the attributes common for hard drives might be manufacturer, size, type, etc. A printer would have paper size, brand, model, ink/laser, etc...

I was expecting: Persons PersonID PK FirstName LastName Address Phone Groups GroupID PK GroupName PersonGroups (Junction table) PerGrpID PK PersonID FK GroupID FK I would add to the confusion of multiple persons at the same address or multiple phones or phone types. Just the...

If this is all true then it makes sense to not post your ideas in threads where they will never result in any level of support. I assume you could contribute some minor, repeatable, implementable ideas that could help someone. I see lots of posts that move away from hard-coded designs to a more...

@Imb, if you could post a very simple demo of your system for something as basic as managing a mailing list with the ability to create groups. In a standard Access app, this would require about three tables and three forms. My best guess is your system tables would resemble the results of the...

A running sum to get the totals would probably work if you removed the BeginBalance from the longer expressions and added it back in as a single value.

I would like to give @phillip the benefit of the doubt by assuming this was a data report that was produced by an accounting system. With those kind of numbers, it's hard to believe they are all keyed into that table.

You could pitch your solution to one of the group leaders at the Access User Groups. Typically they are going to want a PowerPoint and documentation to even consider your presenting. Some group leaders will want a walk through of the presentation prior to exposing you to their members. (I...

I'm not sure why you would do this from the main form when you are displaying potentially many invoices in the subform. You could have a text box (possibly hidden) in the main form that gets the value of the current InvoiceID from the subform code. Then use the text box in an update query of the...

Everyone with less than 100 posts have some limits to what they can post. Maybe a link (even in a quoted reply) or other content.

You should have tried looking at the report’s rexordsource in datasheet view. Nulls would have been apparent.

@Imb, when are you going to post full documentation or a sample application file since you seem to be pushing your solution on a frequent basis. Maybe set up a zoom call for some of us to actually view this "dynamic" solution. If not, it does absolutely no good to read your posts.

Ken, in all my decades of Executing SQL statements, either I wasn't aware of that "feature" or forgot it decades ago.

I would make sure the Lvl# fields are in the report's record source and included in the GroupHeader1 as bound controls. They don't need to be visible. Then, open the report's record source in datasheet view to make sure the Lvl# fields are valued (no nulls). Then, this code in the...

I’m a bit afraid to ask but could you share the relationship of the connections database?

Can you assure us the record has been saved? Also, are the Lvl1,… fields are bound to controls in the section with the image controls?

CJ, can you explain your code? Maybe you know something that I don’t which is quite possible.

Report sections have an On Format event that should be used to set controls visibility within that section. I would try something like: Me.[Lvl1Img].Visible = Me.Lvl1 Using numbers in field names raise a red flag regarding normalization. Do you have Lvl2,…

To each his/her own. If I have an employee table, ever field in the table begins with emp. The auto number primary key is empEmpId. The foreign key fields begin with three letters identifying the table followed by three letters from the related table and “Id”. I love not having to think about...