Search results

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.

Do you have code on Form1 that checks for the existence of the current days record? If not, you could set up Form1 to check when it opens. If there isn't a record you could add one there. Much of this depends on if you need to know every day the system is started VS you only want records in the...

That's what I get for not checking each posts submission date...

While many have offered their view, I'd add something that may help you MASSIVELY in your endevor. Have you written down exactly how students relate to coursework and how it is tracked currently? Have you gotten a list of what reports or other outputs will be needed from your database? This...

This sounds like an operational issue you are trying to fix with code. Is there a very good operational reason they cannot provide filenames that are consistent?

If your email is ending up in "Spam", why is the recipient client putting it there? Is this unsolicited email? Is your sending address a known spammer? Are you using a subject that would cause the recipient to kick it to spam? And as important, why would you want to hide something in an email...

So "Youth proofed?" 🤣🤣🤣

User name or ID is authenticated by a password, thus 1 factor authentication for said username/ID. Means I can't just enter "DickyP" as my user, I need to authenticate it.