Search:

THIS IS GREAT! Thank you, after reading your suggestion to Christopher, I tried it, and also found out that you can also accomplish the same by putting values, separated by commas, in the field...

Thanks, John. I agree with you that it is visually easier to store long message string to a variable, which I would definitely do if it were my code. Thanks for your note on the efficiency & of...

On your toggle button -- or, perhaps, from a dropdown combo selector -- check the value of the toggle or the dropdown, and change the record source of your subform:
...

What does the "xxxx" stand in place of?
I don't remember this, as I usually re-learn it only when I have to, but can you paint the highlight via report code in the "on format" or "on print" events?...

Well, just for starters, I wouldn't put it in an "on current" module, because -- won't you want someone to be able to make a selection, first? Unless I'm not understanding what you are trying to...

Hi, Judy,
If it were me, I'd skip the intervening field declarations, and just stick the fields in directly -- does anybody have a comment on this, and if it is more efficient?

Instead...

I do something (originally stolen from MSAccess help files) commonly on a form I create originally with all the field names. Then, I create the field names in a fixed format (prefaced by "qbf_" for...

My question would be, although it's not the likely culprit, but does this school system have occasional network issues and slowdowns? (I don't see how that would delete the data just typed,...

And the problem seems to be restricted to just one user.
The reason I bring this up, is, if the user does not have the requisite permissions on the folder that contains the report, that may prevent...

Another question, is, is it happening to other users, if any other users run this module.

4) Another form in the same DB with conditional formatting (and many of the same expressions) DOES work!
Joe,

I'm not one of the experts here, but often when something like this happens (and it...

This problem happens (rarely, but occasionally) to us on a network, and the more I type this, the more wrong I think I must be in how it actually occurs -- but let me describe what I was first going...

Hello -- I felt certain that I posted something about this earlier, but I can't find it, maybe I didn't. I found that I got this in one or two databases. I can't remember if I remade or dragged ...

. Thanks, Ken, I'm glad you got it working.
. There were really two parts to this question -- the SQL connect and exec, and the actual build of the string.
. As far as the sql connect &...

Ken -- it's possible that the query window is more forgiving. I know from experience here, that sometimes happens.

I am not that much of a virtuoso with connection code, and like so many things,...

Ken -- I think your "EXEC SDUpdate @SID = " is fine, if SDUpdate is the actual name of your procedure. I have the Chr(34) around the procedure name because it is a variable containing the name of...

This isn't the answer to your problem, but noting your EXEC string, I wonder if you need quotes. The following is just a sample of a call I make. I pass a procedure and a starter date into a...

Yeah, this is the null "gotcha," and believe me, others have ended up in the same boat. My commiseration!
Pat

Not sure I have quite got it, but, couldn't you just add one field that you populate with a plot counter for each plot for each Landowner, and then when you go to output, use as the column title a...

Well, I think if Han's method works fine for the first person, it should work for the next -- if you do use the running sum over group. I think (maybe I'm not figuring this out correctly) but I...

Did you chose to have the field accumulate as a running sum "over group," or "over all?"

So that those of us who don't open attachments can help, can you paste a simplified version of your query to show what you are trying to do to attain the goal of excluding that line?
thx
Pat

Monica,

I would start by creating a query with the information that you want on the report. In order to join all the tables, you need to identify what information in each table can join the two...

Can't you make the "backcolor" of your header be gray, (click on your header, or, if no open space, your header bar) and then "lasso" all your labels in the header (select all), click on "properties"...

Sometimes, on a network, I cannot delete an .ldb. It gives me the same error message you get. If I log off & then back on the network I can delete it.

In addition to what Hans said about...