Search results

This is a 2-step process: first split the text in paragraphs, then loop over the paragraphs and do two finds. Step 1 can be done with the Split function, splitting on (most likely) vbCrLf, and Step 2 can be done with InStr.

> [Price (AUD)]+Nz(Sum([Amount]),0) AS [Est Cost] In the SumOfAmount expression you're using tblExpenses.Amount; you should do that here too. Being explicit about which table the Amount should be read from is a good idea. Same for [Price (AUD)], which in a previous expression you explicitly...

F11 opens the Navigation Pane (side panel). Yes you CAN access the File menu; I see it in the upper left corner of the app. What you need to tell or show us is exactly what happens when you click it. It is possible you're running this app on the Runtime version of Access. Can you create File >...

The reason for that is that your Fade code only works on objects (forms) with a Window Handle (hWnd). Subforms don't have that. They are painted on the form. Fading is not possible, unless you go to extremes.

You found an imperfection in NW. The control should have BackStyle=Normal, and BackColor=Background 1. I'll add it to the fix list for v2.5 (if ever).

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.