Search results

ReportView does not have pages so page setting/control are ignored.

Domain aggregate functions can cause slow performance with large datasets in queries and on forms. I have VBA code with probably 100+ DLookup and no issues. So yes, use DLookup before calling second form. My understanding issue can arise if domain aggregate is repeated within a loop structure...

I installed 32-bit because I prefer 32-bit Access and I installed Access with Office 2021 Pro package. I have never worked with 64-bit version of any Office app.

That doesn't work? Works for me - PrintPreview only, not ReportView.

Need to open form to new record row and pass key value and populate field? From the first form: First, make sure first form record is saved to table. If Me.Dirty Then Me.Dirty = False Open form for adding new record and pass key value DoCmd.OpenForm "myformname", , , , acFormAdd, ...

Well, did you do what I suggested?

Where is this textbox located - on main form? Do this calc in subform header or footer section: =Count(*) Then textbox on main form can reference textbox in subform: =subformcontainername.Form.textboxname Yes, must be .Form exactly as shown.

Data with embedded quote or apostrophe can complicate SQL concatenation. You say data has quote mark, does any have apostrophe - as in O'Hare? Alternatives that don't care if data has special characters: 1. parameterized SQL 2. update/insert a recordset

It may seem excessive but there are 200 tests, each with their own attributes, some with over 100 fields in table. If I could have only 7 tests and 29 fields, that would have been nice but it wasn't the case. Considered and rejected EAV model as just made it harder to produce desired reports (I...

Pat, not sure what you mean by "got out of hand". My test tables are related to parent SampleLogIn table, not to a TestTypes table. Test tables store results of sample testing. There is a TestInfo table for metadata about each test (num, name, time, etc).

Bing does the same thing, all top results are about Trump firings. Did find Wikipedia article https://en.wikipedia.org/wiki/2020_dismissals_of_inspectors_general. Trump fired 5 in first term Bush requested resignations of all (rescinded) Reagan fired 16 (rehired 5) Obama fired 1 Specific...

I would probably have 1 table in this case. I do not have relationships set up for the 200 test tables with the parent table partly because that exceeds the limit of links a table can have. I control data integrity with db design and code - lots of code. Relationships can be an aid or a...

Need to add a space after "Mrs."

Instead of "moving" records, why don't you just change the value of a field to indicate change in status? That's a prompt for input because Access doesn't know what the reference is, perhaps form is not open or the pathing is incorrect.

What do you mean by "into the main one"? Your code prompts for inputs of Type and Group - why? Because Type and Group are alias names and they are not available for the ORDER BY clause in the VBA constructed SQL. Has to be: strOrderBY = " ORDER BY tblCombo.Data, tblCategory.Category" strOrderBy...

If it were one table, and Forensic was selected, there would be 29 empty attribute fields - so what! Does every feature selected always have data for all of its attributes? 7 tables or 1 table, structure could still be viewed as not 100% normalized. Adding an attribute for any feature means...

I think that's what COALESCE() function is for. Although is kinda annoying SQLServer requires a special function to do what Access SQL can simply do with operators.

Google. I don't remember when or where I learned this. I revised my answer as you were reading. Might look at again. Think it pretty much covers the & Vs + question.

IsNull() is a VBA function call and simply returns True or False, not the same thing as SQLServer IsNull() which is actually same functionality as Access Nz() also a VBA function call. In Access IS NULL is SQL. Concatenation using + will return Null when Null is involved (null propagation - as...

Me.TheTextboxToLock.Locked = Not Me.NewRecord