Search results

Yeah definitely woulda been in the money back then..

AOL= Facepalm!

Yeah, it will work as you want it too!

You have your field designations wrong in your query... You need to do it tablename!fieldname. You are doing it backwards it should be FacName1: IIf(Len([tblFaculty]![FacultyFirstName] & "")=0,[tblFaculty]![FacultyLastName],[tblFaculty]![FacultyLastName] & ", " &...

Does this help? Private Sub updateb_Click() On Error GoTo Err_updateb_Click [STotal] = [Order Details Subform].[Form]![SubTotal] [Total] = [Freight] + [STotal] + Nz([Taxes],0) [Balance] = [Total] - [Payment] DoCmd.RunCommand acCmdRefresh Exit_updateb_Click...

How about this Dim i As Integer For i = 0 To Me.List0.ListCount - 1 If Me.List0.Column(1, i) = Me.Text2 Then Me.List0.Selected(i) = True End If Next

Try stopping your print spooler service and see if it opens for you.

Using 2010 now and its 64 bit.. thought it had something to do with win 7 64bit but now im not sure

Well I can see from your coding that you are missing a lot about what is needed for it to properly work.. Post up a sample and we can see if we can get it working for you

You can can write alittle code for the checkboxes to make it so that if one is selected the others aren't

No im not saying create a seperate query, im saying create seperate IIF statements then combine them when you get a few working...

Wow, what a mess!! Try creating one at a time getting them to work then combine them - ONE at at time to see if you are getting what you want... If you want to post up a sample database then you can and we can take a look at it to see if we can get it working with your SAMPLE data....

Are you seeing this with just access or all office products? I am seeing it with all of em and What I end up having to do it kill my print spooler service and restart it and the applications wont hang... dont ask me why that works, but it does....

Wouldn't matter. If you press the only 5 button, then they would show, if you press the no 5 button then they would show. Because you are resetting the rowsource each time it doesn't matter what is in the box at the time of the button press

Can you post up a sample of your database so we can see what is goin on.

K im not sure whats going on there, but put this code behind your checkbox Dim strSql As String If Me.Check11 = True Then strSql = "SELECT tblPrimaryData.Project_Name, tblPrimaryData.Project_Creator, tblPrimaryData.Project_Status FROM tblPrimaryData WHERE (((tblPrimaryData.Project_Status) <>...

See attached. I did it using the checkbox

Thats because I am using 10. Not sure why it would inject my dll reference in there like that, i'll try to post it up again.

The IF statement will work if you want to use the checkbox. I just did it as a button to show you the general idea behind it.

Take a look at my previous post.. Under option 4, as Allen says. You are essentially changing the design of the form. Are you sure you want to do that? If you are using 2007 you can turn on value list edits, but you will be prompted to save the design of the form every time you change it.