Search results

New Info... maybe it will shine some light... So when I close the MS Access file... then open it again and run the code... the code runs fine... I can close it and open it over and over and (if I do) the code runs perfectly... So I guess access is hanging onto something (i.e. not letting go...

Eh... it broke there so I added that in to see if that was the issue... it isn't... I have since taken that reference out... The crazy thing is this thing toggles from running perfectly to breaking, then back to working... over and over again. If it processes fine one run... the next run it...

I thought I was setting variables for the workbook... and I specify the worksheet within the code. I know I could use a variable... but I am really only using it in a few places... I use: Set objActiveWkb = appExcel.Application.ActiveWorkbook And... e.g. I reference the specified worksheet...

I am using MS Access VBA to create and excel spreadsheet and format the sheet from MS Access. When I run my code, it runs great and I get the formatted report exacly as I wanted. Then when I run it again, it throws an "Object Variable or With Block Variable not set" Error. So my code runs from...

Sorry it's been so long to get back with you. I took a look at your screen shot, it's kind fo impossible to tell what's going on because you are dealing with two underlying queries one bound to a form, the other to a report... If you can: find which two queries these are and post the SQL code...

I thought a subquery might be faster...no?

If there's really only one value in query 1... or if you always want the biggest ID value in query1 I think you could just write a subquery in your New Query... For Example: > (Select Max(ID) From Query1)

Looks to me like you would be better off to use the Group By in each query (vs. grouping by everything at the end). The issue would then be if your date field is a straight date or a DateTime... If your date field is Date only, then you can Group By the date field and it will only should give...

Tell your professor s/he needs to work on how s/he words the exercise. As there is no such thing as sponsor donantions in the grid, naming something "sponsor donantion" assumes that this field will be the place that the actual donation will be applied, but I think s/he is actually asking for a...

Yes, you should be able to do this... I think your issue might be how you're grouping the data. Don't use distinct... use Group By. No sure how much you know about MS Access queries and the GUI... You need to use the totals button (found on the design ribbon) of your query, in design mode...

Hmm... I am not sure what you are using as a query that your report is bound to. Sounds like maybe your Orders table. You say that OUTSTANDING is a field in the orders table but (when you run your query) OUTSTANDING is "blank" even without any criteria. If you just open the Orders table are...

Blank in the query or blank in the report...?

When you added the OUTSTANDING column into your query... if delet your criteria... is it still blank when you run the query... or are you getting values, then?

Within your query... On the criteria line for Field: lectureplace Put: "A" on the line underneath (i.e. the "or:" line) Put: "B" In the criteria line for the field: lecturesubject Put: "politics" This should give you A + politics or B + any subject

To recreate that PAID checkbox, Copy this code: PAID: IIf((Nz([COMMISSION],0)-Nz([txtTotalPayments],0)) <=0.05 And [COMMISSION]>=0,"Yes","No") Open the query your Report is based on, then paste the code into the query In the area where the field name usually goes. Then, in the criteria of the...

I have a dropdown combo box in a form. On the dropdown listing, you can choose any item or “all” the items. If you choose “ALL”, the query that the form is bound to post the field name, itself, to the criteria for the field. I don't know a better way to word that, but its hard for me to follow...

Sorry I originally, accidentally, posted this in the Macros section... when I meant to post this here: I keep getting this error: can't find the field '|1' referenced to in your expression Here's where it bugs out: [qryBuyPlan_Working subform1].Form.RecordSource = "SELECT BUY_PLAN_ID...

Sorry posted this in the wrong area... moved to the VBA section

I inherited an Access app, where the previous developer would hide objects underneath other objects or make them so tiny that it makes them nearly impossible to find in design mode. I find myself lassoing everything in hopes I see it's outline... or trying to tab through all the objects. The...

There is likey a better way to do this... maybe some functionality in Access where you just press a button... that I just didn't know about. If you've ever accidentally moved or changed an underlying table to a query and then opened your query... Then realized what you just did, closed the...