Search results

Combo boxes can be built without a separate table, you can look at existing distinct values in the field to choose from.

One big table. A good rule of thumb is that tables (and fields for that matter) should be named so generically that someone without knowledge of the system knows what each table/field is for. Also, you shouldn't use suffixes, prefixes or numbers in names. So that means you would never have a...

It kind of seems like you are just building this by the seat of your pants and seeing where it takes you and hopefully that ending point provides you with something helpful. Not a criticism, just an observation. My advice would be to start building this from the other end--not with what you...

No its not right. Computers and Drives should not JOIN on ComputerName. You should have the ID field of Computers to JOIN them. However, you don't really need a Computers table at all if it only has one field. Instead, just put the Computer Name in Drives as you have it now. Also...

From what I see it mostly looks good and only needs 1 table. The only advice I have is work toward numeric field when can. Capacity should be numeric and in a constant unit (terra or gigabytes) and if Disk Management always has a format of 'DiskX' where X is a number, make it numeric and just...

In general, entities and properties become tables and fields respectively. Cars are things and become a table. Make, model, year and color are properties of cars and become fields in that table. An overview of what you hope to use your database for would be helpful. With what you've given...

I'm not entirely certain your issue. So let me throw a few things at you: 1. You can't make a calculated field in a query and then use that same calculated field in the same query in another field: SELECT A, B, (A + B) AS AB_SUM, (AB_SUM *2) AS DoubleAB_SUM, FROM YourTable AB_SUM will return...

Pasted it into notepad and counted characters. 6 opening parenthesis, 5 closing. So 3 steps: 1. Add a closing parenthesis at the very end and hope. 2. Add a closing parenthesis just inside the last quote mark and hope. 3. If first 2 don't work, start from scratch and rebuild it clause by...

This is easier done in a query the report is based on than the report itself as you have suggested. You make a calculated field to display what you want for the spouses last name: SpouseLastNameToShow: IIF(SpouseLastName = MainLastName, "", SpouseLastName) If they are the same, show a...

How is that? Mathematically the count of the NULL set is 0. Mathematically the count of the set with only member 0 is 1. All sets have a non-null count

There's 2 different concatenation operators in play here. & : is used to combine elements of a string together ---> ("Hello " & UserNameVariable & ", You are now signed in") AND : is used to combine elements of logic together ---> Iif(A>.5 AND B<2, "Pass", "Fail") So, inside your Dlookup you...

The matching CID will be the only CID you are looking for. It doesn't make sense. It really sounds like you are checking for existence not trying to obtain a value. DCount would be a better function to use for this. Suppose you input CID=2 into the form, call me a psychic witch, but you...

Huh? What? Why? DLookUp("[CID]","[InvoicePayments]","[CID]=forms!Invoicing![CID]") Why do you need to lookup [CID] when you already have it? Are you just checking for its existence? If so a DCount would be a better function to use.

I think you got it now. This doesn't involve actual Query objects, it involves VBA that compiles your SQL and executes via DoCmd.RunSQL. You really only need 1 SQL statement if you use SELECT INTO from Elements: https://www.w3schools.com/sql/sql_select_into.asp

I think I got it, but not sure: Sounds like you are trying to use a drop down to select a PermitID for a new record in a table where PermitID is an autonumber primary key. That's never going to work. 1. Autonumbers are assigned by the system, you can't use a drop down to assign one. 2...

Yes, that's it exactly. For each new inspection you make a blank record for each question that needs to be answered. That way the continous form is populated with all the records you need and shows how you want it. No, the VBA you run when they choose to make a new Inspection would be a...

I think a form/subform gives you the look you want with the correct table setup. For lack of a better term you will need a feeder table, which sorts of acts like a junction table but is not technically connected to the main 2 tables of your database. The top info (e.g. inspection date, owner...

Me.txt_CurrentListBox And just glancing I see that sql1 has a SELECT clause but no FROM. That's not going to work.

I've lost interest in helping you and am more annoyed by each subsequent post you make. I'm unsubscribing and hope someone else has the patience to assist you.

Duplicate posted here: https://www.access-programmers.co.uk/forums/threads/positive-test-flagging-reminders.333549/ Huge on writing outlines of the project, but not much for discussing things.