Search results

For me it is up to the individual when they sign up to a membership to specify/nominate a salutation, which is optional. Don't make assumptions. Communications with the member reflect their choices - not yours. If memberships are family-based, or some other grouping (eg. organisation...

Reinforcing the foundations: you must get your database schema right for the job you want to do, which as others above have mentioned and offered some insights. From what has been described by you I would suggest some changes / thoughts about the rules/relationships you are interested in: A...

@RFreund - preliminary observations and questions: - some typos in naming fields - hopefully not in the real table: ProposalTypeID, ProjectCountry - does the Main Proposal Table have a ProposalID PK (autonumber?) - The type tables provide further detail specific to the type. Is ProposalTypeID a...

From the picture there are 6 duplicates of each of the 2 records shown, however the data set is much wider than shown. Are the columns shown the only ones of interest in determining a duplicate? From within Excel: To identify and retain a single record from a set of duplicates in a dataset, you...

A star schema might look like below, however I do not have the subject matter expertise to be sure about the placement of data in the tables (eg AdmissionID and UNSWStudentID (I took some liberty with some names)). The dimension tables would generally contain every combination of the...

Step 1: Identify and remove duplicates: in what sense are they duplicates? As this is an extract of data / combined data from multiple queries of the uni enrolment system (possibly combined with data from UAC or external sources) then what combination of data will allow you to determine the...

Form what is being described at #14, the data is only for reporting so the OLTP normalised model is not applicable. This is essentially a data set that should be structured as a data mart - star schema or snowflake style schema are more applicable (for a RDBMS solution - after cleaning out...

The above link provided in the code is no longer active: so you need to look furth afield: eg: https://learn.microsoft.com/en-us/windows/win32/api/winuser/nf-winuser-activatekeyboardlayout...

Your structure includes employees and other tables that are not in scope of the extension you require. The following is a preliminary structure for discussion and review. A discussion of inventory and stocktaking with sample access code/ db is available here...

Date of Birth is defined as a text type field - If you want this to work DoB needs to be set as a date/time type field in the table. As it is how will you filter using a text range of >=1970-1-1 and <=1990-12-30 Once you have set up a date/time field for DOB you will need to work with the date...

Agree with @CJ_London re separate fields: 1. Do you have the SupplyID in your ingredients records? I presume it is not the PK for the ingredient. In the ingredients record it might not be named SupplyID but there does need to be a field: text, unique (with restrictions on which characters can be...

Try DateAdd function https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/dateadd-function use it to display the calculated date in the textbox. for 1 week: dateadd("ww",1, DateReceived)

Have not seen it mentioned - but Type is a reserved word and should not be used as the name of a field. and it is recommended that ID is descriptively named - eg FilamentID - to prevent misunderstanding with any other ID fields that are found in other tables (when you decide you need them)

Also suggest invoice is really InvoiceLineItem, as currently it shows an Invoice is issued for each JobDetail. Expecting that JobDetails are collected and invoiced. JobDetail - InvoiceLineitem - Invoice (and then InvoicePaid and PaidAmount may then be attributes of Invoice). [it may also be...

The evaluation of the condition used to determine whether the code in the loop is to be executed in a Do Until vs a Do While Loop is located differently in the loop structures

can't see it? Look at this sample: Public Sub LoopExample() Dim Check As Boolean, Counter As Long, Total As Long Check = True: Counter = 0: Total = 0 ' Initialize variables. Do ' Outer loop. Do While Counter < 20 ' Inner Loop Counter = Counter + 1 ' Increment...

This link is a reference to a solution for Combos and ListBoxes: ALL Option for Combo and list boxes Somewhat lengthy code,

This should be a new thread: Go to Forums --> New Thread: Post it in an appropriate Forum: General

The QR code identifies the keg allowing the keg's record to be found in the table of kegs (KegInventory). It does not change its status until you take an action to update the Location or Status. The keg record includes the type of beer (type of beer / brand etc is another table), Location is...

Perhaps the issue is that the relationship os not correctly defined - looking at the OP and the attributes, it would seem that, because the Project appears to hold the foreign Key (KF) to JobCards that a Job consists of many Projects. However looking closely at the attributes in each it would...