Search results

@MajP I interpreted the OP's need was to solve only one type of survey, for multiple facilities. The design I suggested is quite the trivial thing, it's a simple many to many scheme that solves that kind of problem. Companies that verify facilities/cars/businesses according to some bill, law or...

@Galaxiom The schema you have provided shows a composite primary key, which does align to OP's initial schema, but contains no relationships. Therefore, no referential integrity is applied, data is on the fly and actions do not cascade. It can be done, but it is not advisable, as the user will...

If you want to add a criteria: add a field to the table, then add a control to the form. It is very simple. You can not add fields without adding fields and you can not add controls without adding controls.

I think you are only missing some UI design principles. This database schema is typically solved with a form/subform design. Your form should be bound to surveys and your subform should be bound to assessment_details. Do you know how to do that? Another approach (recommended by me, and it's an...

Ahh gotcha. The comments in your code show what you want to do. So, you want to type the leaves in your database worksheet and then you want them to appear on your output range that's inside your output worksheet. Let me see.

Still no attachment, Peter. Something went wrong?

You have 10 posts now, you should be able to attach it now. This is your code with code tags: Sub LookupLeaveCodes() 'Declare variables Dim wsData As Worksheet Dim wsOutput As Worksheet Dim LastRow As Long Dim LastCol As Long Dim i As Long Dim j As Long Dim...

Additionally, you could also remove criteria tables and, instead of an assessment_details table, store the 90 fields in your assessments table like this: criteria1_grade, criteria2_grade, ..., criteriaN_grade. No normalization issues there, each assessment is unique and the 90 criteria are...

Provide a sample database and explain how the info looks now and how you want it to look. That way we can provide a solution or a better approach to this problem.

This design could potentially be better: facilities facilityId (primary key) name pointOfContact lastAssessmentDate demographic grades gradeId (primary key) color assessments assessmentId (primary key) facilityId (foreign key) assessmentDate assessment_details...

It sounds like that date should belong to your Facilities assesments table, but it all depends on your design. Is it always going to be the same date for all criteria or is it going to change?

Start with these tables: Products, for storing product names and their unit of measure. Do not add prices here, prices always change and they should be stored in another table. Orders, for storing the information about a sale being made, typically its date, you'll use this record to group the...

I tried a few variations and I still haven't been able to do it with the Edge WebBrowser (Office 365). The code works fine in my IE WebBrowser though, the one I posted (Office 2016). It also works if you open it with the Edge Browser itself, not the one embedded in the web browser, I don't know...

Try this one, it has two approaches, one with an embed tag and another with an object tag. I could only disable the browser's right click though. Maybe check your pdf viewer's options to disable right click. Mine is acrobat reader and it has no option for that. I also tried applying an overlay...

We have a different setup. Using your sample and writing the filepath triggers a download for me. Do you have the Adobe PDF plugin mentioned in this tutorial by chance? https://helpx.adobe.com/acrobat/using/display-pdf-in-browser.html

Can you post a sample to see how you're loading your pdfs?

Something like this should work: Sub DisableRightClick() Dim doc as Object Set doc = MyWebBrowser.Object.Document Dim scr as Object Set scr = doc.createElement("script") scr.Type = "text/javascript" scr.innerhtml = "function disableRightClick(event)...

2037 is a random number for what you are describing, OP If you can not provide a sample database, post some screenshots of the involved procedures and your interface to be able to figure out the rest of the information.

If you are parsing a JSON string, regardless of where it comes, that module is probably going to convert the JSON into a dictionary object. You only posted here how you are trying to handle it, but we do not know how the object looks, so we can not help much. The value of your key taxType is...

This can be done nicely with a little web browser programming. It was fun. I might add a few extra bits that it requires if you're interested.