Search results

Not exactly. I think this is what you are referring to: In this case I started a new record, entered a Product Description, and clicked the Record Selector to cause the record to be saved. Then the validation code intervenes, stops the Save action, and highlights the required fields that are...

Maybe I'm missing something, but DoCmd.OpenReport ..., acViewNormal can print to the default printer right away. And DoCmd.OutputTo can "download" (we say: export) the report.

This relation is definitely wrong. All relations need to be Enforced. Most of the time they should be from PK to FK. So in this case I expect that each employee has a TaxID FK, which links to tblPayrollTaxes.TaxID, and the relation is enforced.

I have used Proton to pretend to be in Amsterdam, The Netherlands, so I could watch speed skating program on Dutch TV which was not available in the US where I reside. IIRC it's a simple matter of choosing the VPN server you want to connect to, out of a list of many.

Reports are very limited in what you can do interactively. The Northwind 2 Dev Edition has an example of a clickable listbox, but otherwise I agree with the prevailing sentiment of doing the filtering in a form before launching the report.

That's why in Northwind 2 Developer Edition we pass name/value pairs via OpenArgs, which makes it self-describing. See the use of StringToDictionary . There is also a YouTube video about the String functions.

A few more that immediately caught my eye: 1. Dnt abbrev obj nms - Don't abbreviate object names. You are creating this not just for yourself, but also for your successor after you win the lottery. Even your Descriptions in table design are often abbreviated. Also, a description of "STINNR1" for...

I think you are in need of a Business Analyst. This person works with you to understand what you want, and creates a Functional Spec that developers can use to understand what you want. Some people in Access forums are pure developers, and want to design databases and code business logic...

Mind your precedence rules. x=1 or x=2 and y < 3 is evaluated as: x=1 or (x=2 and y < 3) while you probably mean: (x=1 or x=2) and y < 3

One option would be to transpose before exporting: Create > Query Wizard > Crosstab Query Wizard

This is how I typically do it, and it is fool proof: First write out 2 IIf statements: IIf(conditions, A, B) IIf(conditions, C, D) Then copy the second one, and paste it over the top of A. IIf(conditions, IIf(conditions, C, D), B) Then fill in the parameters, e.g. IIf(x=1 and y=2,IIf(z=3, 99...

You could also look at the various templates in Access, available via File > New.

The first argument of DLookup can be an expression that includes multiple field names, concatenated with a separator character in-between. Then you can use Split() on the resulting value.

When you typed "Me.", was the form in the Intellisense list? Then it should compile. Decompile the app and see if that helps.

Look into Conditional Formatting.

I would recommend decompiling the app. Search online for "Access command line decompile" and you'll find how to do it.

Not related to the Delete query, but re your database design: I question the StableName field in tblHorseInfo. Don't horses get traded all the time? Then you may need a new table tblStableHistory that records where the HorseID was from time to time.

ssms implies a SQL Server database. You should be able to query sys.columns for fields by that name. Something like: select object_name(object_id) as theTable, name from sys.columns where name = '???';

Probably best NOT to do that in an expression. I don't know what the values of 0 and 12 signify, but let's say they are "Points" given to such status. UNDOUBTEDLY over time the salary cutoff values will change. It seems best to store this in a new table tblPoints: BasicSalaryUpTo / MaritalStatus...

With regard to "undocumented": the procedures are (of course) in the type library, and the Object Browser (F2) will reveal them if you turn on the "Show Hidden Members" option.