Search results

Because the subreport is grouped and I need the totals for all the groups. and the main report has other totals

Access 2007 Windows 7 trying to get a subreport total to show on my main report getting #error no matter how I code Running a subreport containing a total in report footer (only field that name of subrpt total fld subrpt [SubRptExp].[Report]![gramtrcvd] Any help much...

Created a 2007 DB. Will be more than 100 users with access. We need those 100+ users to not be able to see anyone else's records. What is the best way to do this on login? Using Windows 7 Jennifer

Working in Access 2007 Windows 7 Report should look like this in detail section SITE Amt Balance site 700.00 6800.00 site2 1,000.00 5800.00 site3 0 5800.00 site 4 500.00 5300.00 What it's doing is taking the amt fld...

When I open a data entry form, I'd like the placeholder to be in a certain field which is located in form header. Even though I set the tab order, the cursor ends up in the 1st tab of the detail section. Where and what do I need to specify go to this field on open? From the command button that...

Thanks so much for the response. Found the .dll file in the folder(wasn't told it was there) Anywho...all worked out. Learn something new all the time.

Converted a really old MDB to an ACCDB. error message on command button is Sorry cannot find the Mousehook.dll file This is the Module.... Private Declare Function StartMouseWheel Lib "MouseHook" _ (ByVal hWnd As Long) As Boolean Private Declare Function GetCurrentThreadId Lib "kernel32"...

Yep, created a new shell and imported. Way quicker than trying to find the other solution. Thanks all.

That didn't work either. I've converted over 20 db in the past year...Never had this kind of trouble.

Have a 2003 db need to convert to 2007 this one keeps telling me it is opened by user and cannot convert I have it on my desktop and only person with access to it I have opened it exclusively, tried renaming, etc. Any help much appreciated

Well, that worked.... Thanks so much. Never heard of that... Turns out, it was created in 2000, UGH

Using Access2007 Windows 7 Have a 2003 mdb need to convert. On open their are no edit functions available. the db opens with a password form. I can't convert, or get to any of the objects. Looked at the permissions on the properties of db, nothing special going on there that would deny me...

Excellent, You guys rock... I'm with you on the naming fields. So far into this, would have to edit lots of stuff, and will do, first wanted to get stuff working. Thanks so much.

Access 2007 Win7 My expression Passed: IIf([maxof%]>0.7,Yes,No) but, I also need to have it be true if that same field [maxof%] is empty or null When I place isnull IIf(isnull([maxof%])>0.7,Yes,No)) it gives me all the records as true, even those less than 70% Help please...

Operator error folks... sorry, I figured it out... had other criteria setup in query that needed to be deleted.

Access 2007 Win 2007 =IIf([max%]>0.7,Yes,No) expression to populate a check box on a subform When I use this and run...the yes works correctly the No wipes out the records' other data(i.e. staffid, name of training) from the query max% is running in. How do I keep this showing and have...

Thanks for the help. Yes, I agree about the name of the field. Was a quick query and not too late to change.

Trying to come up with the expression for this result IIf([systemreqcountofworkshop].[course code]="CDV", and IIf(Max([Union X Percents].[%])>0.7,"X"," ")) not working.... need to stop looking at it, :) Any help Course code = CDV AND max of % is greater than 70 in order for field to be...

my final code that worked for anyone else searching... Private Sub Command673_Click() On Error GoTo Err_Command673_Click Retry: Dim strInput As String strInput = InputBox("Password", "Enter Password") If strInput = "legal" Then DoCmd.OpenForm "Legal subform", acNormal Else If...

I got it figured out with a combo of many things :) Thanks for all the help....