Search results

That's what the popup/search form is for, yes. Every report (query) can reference the same Form.searchForm.StartDate field.

If your tables aren't huge or speed is not a big factor, DCount should do exactly what you want.

Your question is a little vague, but it sounds like you're talking about filtering by form? Your "form to supply the Start Date and End Date" needs to stay open behind your report. The queries for your reports can reference that form's fields directly in your criteria... look to the Expression...

Sorry, our network goes out if it rains (wish I was kidding), so I'm paranoid. sumdumgai, use what you're comfortable with. We're just offering advice.

Might it be easier to import the whole thing and then throw out the ones you don't want? Importing by VBA is going to be perilous if you have a shaky network...

That actually has 0% to do with what I was asking. Do you use anything like DLookup, DSum, Dcount, in whatever those comboboxes 'do' when a user tries to use them to create a record? Or are they just comboboxes ON the record and they are the first thing your users fill out in a new record? User...

What do the comboboxes do to 'create a case'? I agree that this is probably network problems, but if any of this uses domain functions (Dlookup, etc) that will slow you down immensely.

For some reason plog's version will NOT work directly in a form control source (in Access 2010, at least). You can put it (or the easier to parse FormattedBuildResolution: [BuildResolution] & Chr(34) ) in a query, though, and use that behind your form. I don't know why it makes a difference.

In the States, the high-potency stuff is usually called an Energy Drink. Sports Drink is things like Gatorade, etc.

Yeah the biggest trick with InStrRev is that it counts from the BEGINNING even though it's looking from the END. So you have to use Mid(), not Right().

Clip out the last folder with InStrRev? Or if you won't be moving it very often, you can be lazy and just hardcode the folder.

http://www.independent.co.uk/news/science/belief-and-the-brains-god-spot-1641022.html

Just plain tap water in my coffee cup at work, unless I'm falling over in which case a cola of some sort. RARELY coffee. At home, usually tea, soda, or again tap water (KCMO has some of the best in the country, we sell it bottled).

Something else must be going on to stop it from moving records, then. Have you tried: Docmd.GoToRecord acDataForm,stDocName,acNewRec

If(Me.DataEntry = True), I believe. Although I think if I understand the question correctly, the form is already in DataEntry mode and you want to check if this is already a new record. Me.NewRecord will get you that.

Good catch Keith.

Look into DCount if you must supply the number to them. Don't count on the numbers being exactly consecutive.

I don't fully understand your first question. Yes it is possible to put this at the end of a field:& "." For your second, you're not asking it a question... what values can [SIGNED] have? Signed:SIGNEDYN:Iif([Library].[SIGNED]="Y","Yes","No")maybe?

http://msdn.microsoft.com/en-us/library/office/ff834513.aspx may be useful, then, or other Googling for 'database name DAO'. Good luck!

For Column Names, put them in the Page Header.