Search results

Wondering if we can re-visit this as I have run into a snag and I can't quite figure out why this is happening. I am opening the form by the Select Case method as a way of enforcing Security for users. However, there are some users that would require full access to all available records but...

Thank you so much! That was very helpful.

I am wondering if this is possible as I can't seem to get it to work. I am using Select Case to filter a form on open and it works fine when I have this: Case Is = 2 Forms![Open Opportunities List].Form.Filter = "[Employee] = 4" Forms![Open Opportunities...

Hello all! This may not be possible, but I thought I would ask. I have inherited an Access 2003 database and have been asked to help improve the functionality of said database. Specifically, I have been asked to create some charts for improved reporting. I used the wizard to create a crosstab...

I have been searching for this solution all afternoon and have gotten nowhere. I am running Access 2010. I have added the following to the "On Open" event on my main form: Private Sub Form_Open(Cancel As Integer) DoCmd.ShowToolbar "Ribbon", acToolbarNo DoCmd.NavigateTo...

Oh Bob!! Thank you, Thank you, Thank you!! It was the missing space!!! Arghh....

I want the user to have the option to sort or no. When the form loads, the data is in order of entry which is date order in this case. Management reviews the data and wants to be able to sort from high to low for points awarded.

I cannot seem to find a solution to this problem. I am using Access 2003 and I am trying to sort an unbound continuous subform from my main form by clicking a command button: Private Sub cmdSort_Click() Me.subfrmViewCatches.Form.OrderBy = "[PointsAwarded]DESC"...

Oh, I got it! I will fix on Monday as my work day is done. Thanks helping me think this through!

No change, same error. (sigh)

Same compile error. No difference.

This one has me stumped. I am using Access 2003 and have successfully used this code in other DBs to send emails via Lotus Notes. I have modifed my original code for a new database and I am getting a: "ByRef Argument Type Mismatch" Compile Error. I cannot seem to find the cause. Option Compare...

Unfortunately, there are employee records in the database that I cannot delete as they are linked to what is being tracked. Can I attach screen shots to show the results?

I am working in Access 2003 and I have a query that is the source for a chart on a form. The query has worked fine for several years but suddenly it will not populate for the month of April. There is data in the source table for April, but the query is not showing it and I can't figure out why...

:confused: I tried to set focus to the TempCM field but that didn't help. I took away the If.. Then....Else statement and I got a "No Current Record" error if I left the TempCM blank. Help, please....just point me in the right direction.....

I am running Access 2003 and need some advice regarding a continuous subform. The main form is unbound and the continuous subform is bound to a temporary table. When the user clicks the "submit" button, the code writes the data to a "permanent" table. There are times, however, when there will be...

oops.... I see it.... nvm SELECT SafetyGLDrivingAudittbl.Group, Count(SafetyGLDrivingAudittbl.SGDAID) AS AllAudits, Sum(IIf([SafetyGLDrivingAudittbl].[TotalUnsafe]<>0,1,0)) AS TallyUnsafe FROM SafetyGLDrivingAudittbl WHERE (((SafetyGLDrivingAudittbl.InputDate) Between...

Thank you for your quick response.... but I am getting an error: SELECT SafetyGLDrivingAudittbl.Group, Count(SafetyGLDrivingAudittbl.SGDAID) AS AllAudits, Sum(IIf([SafetyGLDrivingAudittbl].[Unsafe]<>0,1,0)) AS TotalUnsafe FROM SafetyGLDrivingAudittbl GROUP BY SafetyGLDrivingAudittbl.Group...

Hello all! I have been puzzling over this for a day and a half and am getting nowhere fast. I am using Access 2003 and have a table with the following fields: ID (autonumber) InputDate (date/time) Group (text) TotalAudited (number) Unsafe (number) Now I want to count (not sum) the records...

Just been re-reading a page from Allen Browne: http://allenbrowne.com/ser-62.html Giving me some ideas on how I might proceed with this.....