Activity Stream

@ katrinabelle, First, Welcome to the forum. So what you have done is called "HI-jacking a thread". You posted your question in someone else's...

Whew... That is a lot of code! OK, try this. In a COPY of the dB, everywhere you want to preview the report, change the command FROM ...

Consider reclaiming the memory space allocated to these recordsets. Closing them is only half of it. Set rsdata = Nothing Set rstally = Nothing...

I stopped when I saw the single quote DoCmd.OpenReport "Report1" ', acPreview The syntax is Docmd.OpenReport(ReportName, View, FilterName,...

You know this how? You interjected a message box or debug.print statement to show what the value of ConfNum is? If that is true, then I have to...

Hi sir .. can i ask a help... i would like to have a sample database which shows the opening and closing balance example: DATE ...

Well, as I mentioned, I tend to struggle with sub queries, but I'm not going to delve into a vba procedure with the pseudo fields and tables that...

What are the fields in the 3 tables? Are the tables linked with PK/FK fields?

Just curious.... what do you do if/when both are Null??? I don't yet have a certification, nor a LifeTimeCertification...

And note that "Description" is a reserved word in Access and shouldn't be used as an object name. Plus it is not very descriptive...... May change...

My $0.02......... Were I you, I would listen to Micron and Ajax. FWIW, I totally agree with them. It seems like you have jumped into how to enter...

Some reading for you. Important!! Microsoft Access Tables: Primary Key Tips and Techniques http://www.fmsinc.com/free/newtips/primarykey.asp ...

Norm, Glad you found it useful. I use this as a template a lot. All I do to use it is edit the record source to the new query I want to use....

Steps to change "txtemailaddress" (no caps) to "txtEmailAddress" (with caps) 1) Hold down the shift key and open the dB. (Not really necessary....

Ok I finally figured it out after a week of barely sleeping over this... =" = " & "'" & . & !! & "'" This will let me ACTUALLY search NES...

I am still very confused as to what you want or are trying to accomplish. Leaving the issues of the table design, relationships and form design...

Not so hard. In the form design view, drag the query from the navigation pane onto the form. That should create your subform.

you might also find it better if you declare the crosstab heading change ... PIVOT DateValue(); to ...PIVOT DateValue() IN (1,2,3);

in addition to Ranmans 'same' same odbc driver? and just to clarify do you mean in a table of say 1000 records, perhaps 20 of them appear as...

Sounds like: Baldy-Cascading Combos

did you do any upgrade to those laptops? are all pcs on the same version OS? save version of Access? was this a recent issue?

BTW, your totals query does not need to be a crosstab, you can bring in the crosstab query and do a totals query.

Never seen a UNION of CROSSTAB queries but aytee's suggestion certainly looks doable. Building a stable report to run perpetually based on...

To join them use "UNION". Both queries have to have exactly the same number of fields. Syntax: SELECT * FROM crosstab_query UNION SELECT *...

ok I updated the summed query to look like this TRANSFORM Nz(Count())+0 AS Expr1 SELECT & " " & "TOTAL" AS Expr2 FROM LOGAN_ACTYS GROUP BY &...