Search results

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)

Is this just like how anti-abortionists are prevented from protesting outside abortion clinics? The action of the police is to prevent violence, before escalation. Perhaps there are lots of no-go zones.

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...

You need to have a clear understanding of the data you need to track the status of you "keg" inventory. From what you have already described you wish to track your kegs. A keg may be in store - filled, emptied or tapped -ie standing in the bar. The kegs have barcodes that allow them to be...

Notice I was talking about factors affecting fighting the fires, not what caused them to be uncontrollable. :)

I suspect there are 2 other factors affecting the ability to fight these fires: 1. The demand for water, from hydrants and domestic taps/faucets, affected the availability of the water - the water system in urban areas is not designed to handle wildfires of that scale, and the demand for water...

Yeah, whatever you say... it seems the OP needs to provide input - which we might not get.

Perhaps I was not clear enough in explaining this above @Pat Hartman - I think LarryE's posts about the relationship and normalising would be obviously useful to the OP to consider more deeply (I am not saying do not normalize). That is an appropriate activity, especially from what the OP has...

Jeez - if the comments about Col's jibes are dangerous then what about the comments and jokes in threads in the watercooler - about transgender, about is Islam a threat etc... those are just as likely to inflame hatred. Introspection warranted? No?

Wishing everyone a Happy New Year, a quick recovery, a siesta and the grace to hide your smirk :unsure: From Kiama:

The socio-political programs invoked are not significant - they are limited by their geo-politics, The significant changes impacting modern human evolution are the changing availability of birth control, the quality and availability of food and water, infant mortality, the availability of...