Search results

I have a two column report that I need a group of records to split into two columns. I need the column on the right to start in the column on the left and wrap into the right column. All of my sections are set not to keep together,

Using Nz(ctl.ItemData(varItemSelected), "") on the red text, seems to have fixed the issue with null. I will keep an eye on it as I said before its inconsistent. Running debug never produced any errors

I am on Access 2016 64bit. My VBA is not great but I manage. The code I am working with was done by someone else that is no longer available. I am having issues with one of my list boxes. I am not sure but it seems as though it is retaining the previous selection in memory and its...

Brian got it exactly. I was trying to use the IIF Statement to accomplish this. It's not the syntax I wasn't understanding it was the out put I wasn't getting. But it does make sense now. I got it working by applying another IIF Statement to another field in the query. But eventually this...

I only need to test one condition. Is the field on the form set to yes. If it is then the query criteria needs to be 133 or 86 to return records with 133 or 86 in the ID Field If the field on the form is anything other than yes then the query criteria needs to be 133 to return records with...

Yes this is correct with in the IIf statement. But in this case the IIf statement is in the criteria of the query, or the where statement of the query.

Nope I'm expecting if the condition is met then criteria is 133 or 88 If condition is not met I expect criteria to be 133

Thank you for your help. I think I understand now why it doesn't work with the IIf statement. I am expecting the the IIf statement to return 133 or 86 as the criteria and in actuality it is to give the 133 or the 86 but doesn't know which one. I guess I can always go down the route of...

So why does it work if I just put 133 Or 86 as the criteria?

I don't need to evaluate two conditions I need to the the 86 and [TempVars]![EID] as the true return. Lets simplify this, I might be making it confusing. If [Forms]![FrmAttendanceLogsRpt]![BlkFilter]=-1 Then I need 133 or 86 If [Forms]![FrmAttendanceLogsRpt]![BlkFilter]= 0 Then I need 133

Forgive me if this has been covered but have been searching and haven't come up with what I'm looking for. I'm trying to have a single or multiple query criteria based on what the user checks on a form. I can't get the True condition to work at all, I get no records. Here is what I'm using...

I have Field1 Field2 Field3 I need to concatenate these three fields into one but for each record the order can be different. What I want to do is have another field in the table to store the concatenation order as the field names not the field values. I also need to display the...

Is there a way to just change the Where statement without having to change the whole Pass Thru's SQL?

Alright I have been searching and I still don't quite understand the querydef. Let me give a little more background on what I'm trying to accomplish. Right now I have a db that uses passthru queries for pulling information into forms and reports. Also in the database are linked access tables...

Anyone have any thoughts or suggestions?

I am working on being able to print pdfs that are stored in a directory from my database. Is there any way to set the page settings in adobe from access. The pages are over sized and need to be scaled down to fit on legal size. I am currently using this code to print the documents but they...

So the company I work for rolled out Windows and Office updates last night Now my tree control menu stopped working. We are on windows 7 64bit and office 2010. The node_click sub no longer opens any of my forms. Any suggestions besides the fact that I was using an ActiveX control to begin with...

thank you sir I will give a go and see what I can do

Can this be used with a query that is already built or do I have to write it in vba?

I have searched on querydef but have not found anything for pass thru queries. Maybe I missing it.