Search results

Can you please describe what is going on for the form that would prevent you simply making it required? Without knowing what the scope of your solution needs to be, you'll get a bunch of solutions that won't work for your situation.

@OP, Just to make sure, this is intended to be a single user system that cannot allow two users to work on Parent records at the same time? The " Where MainID is Null;" means if you have more than one person entering entries in tblLineUnitEntries at the same time, who ever trips this code FIRST...

I've uninstalled it... the hard way... and had it reinstall with the following update. Just doesn't make sense to have something like that ALWAYS on the machine though.

Now if Microsoft could realize not all computers need to have a "Game Bar" loaded....

Question for OP, will any of the documents or images take up more than one page?

When linking to excel tables, Access will attempt to identify what type of data you are using in a given column based on the values of the first 20ish rows. Unfortunately this may not be true for all values in that column. This causes major issues with Access. Unless you are using a lot of data...

Do you have a child table to members for their membership/renewal? Were this me, I'd have a child for "Payments" that includes "RenewalDate". You could then run a process based on RenewalDate to insert payments due and have that do the look up based on their age at RenewalDate. This give you a...

You cannot "save" data in a form or report, only in a table. The real question is "What is the regulatory requirement". Do you need to print and save the report for a period of time? Can you keep an electronic copy for a period of time? Or do your regulators require that the system generate the...

And do you have questions?

What reports or other outputs will your system need to generate? Will this need timeline presentation and tracking?

I would, personally, never store documents or images in a database. I'd instead have them stored in a directory and have the path to the documents stored. This will greatly reduce the size of your database, allow you to use a variety of programs to access the documents and images natively, and...

Adding 2k images to a multi-meg application won't cause "over-sizing" issues.

Never said to add an "Empty" record. In some cases, adding a record that indicates "X" started the application on date "Y" is required for other use, such as showing "X" opened the store on "DATE", even if there ends up being no business on "DATE". Once OP indicates if this is something needed...

Are you trying to; 1) Return the COUNT of rows where there is a number in a specific column? 2) Return the COUNT of rows where there is a number in any column? 3) Return the number of columns per row that have numbers then total this number?

Now comes the hard part. Start writing out exactly what you need as outputs and what inputs are available, then start writing out what your data should look like. There are a lot of us who are willing to help, but this is difficult because only YOU can say what does or doesn't need to be in...

Are you "PRINTING" your report to PDF or doing something different? And by shrinking, what is the margin when printed VS what is the margin in PDF?

So from your description, you are going to want to make a query where you use left joins to your parent table. I would also start by making a query for EACH child table that will return either 0 or 1 record (select top 1 from a sort order such as date) to give you what you have above. As you...

By line items, are they in a child table OR are they fields in your WorkOrder table?

Please let me know if this is what you are really trying to do. "I have a table that has 4 child tables. For each record in the parent table, I need to identity if they are missing a child record in each of the child tables". If yes, are you looking for a query that returns "Parent table /...

Please note, you can use debug.print or a MsgBox to show you the contents of your sQry before you run it. I'd ALWAYS use something like this to verify my SQL is correct before ever trying to use it on data.