Recent content by tvanstiphout

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.

Open the Immediate window (Ctrl+G) Type: Application.SaveAsText and a <space>, and follow intellisense prompt. Similar for Application.LoadFromText.

This is a normal error that gets raised when you (or your code) cancel certain actions, such as OpenForm or OpenReport. That's why in Northwind Dev Edition's error handler, we wrote: If lngError = 2501 Then Exit Sub '2501 = The OpenForm action was canceled. Not really an error. BTW, I...