Search results

Thank you for the tutorial.... I got it, finally.... strSQL2 = "SELECT * FROM NEMailNotes " & _ " WHERE NEMailNotes.ShiftDate = #" & HoldDate & "# And NEMailNotes.CC='" & HoldCC & "'"

spikepl, I thought that I had done all that to get to where I am :-( Here it is from the query builder: SELECT NEmailNotes.*, NEmailNotes.CostCentre, NEmailNotes.ShiftDate FROM NEmailNotes WHERE (((NEmailNotes.CostCentre)=[Forms]![frmSecurity]![EMPCC]) AND...

I am actually trying work out two SQL statements. One from a query and one from a table. the gist for both is: strSQL2 = "SELECT * FROM NEmailNotes " & _ " WHERE NEMailNotes.ShiftDate =#" & HoldDate & "#" And " NEMailNotes.CC='" & HoldCC & "'" So I am selecting all fields from...

Thank you both....face palm about the FROM clause....but.... So if I try to run my second example utilizing the syntax checker the immediate window displays: SELECT FROM NEmailNotes WHERE NEmailNotes.CC='ABC13' but I now get a runtime error 3141 - The SELECT statement included a reserved...

If someone could please be another set of eyes for me? I can't see the error in my statement below: Dim HoldDate As Date Dim HoldCC As String HoldDate = Forms!frmSecurity!ShiftDate HoldCC = Forms!frmSecurity!EMPCC strSQL2 = "SELECT...

Just wanted to share as I resolved this issue. I took out the SQL statements I used above and simply sourced the main report to the Element table and the subreport to the OTC table. Then I took all the controls out of the main report page header and moved them into a new header I created for the...

I was reading this thread in the hopes of shedding some light on an issue and I wondered if anyone had any more insight. http://www.access-programmers.co.uk/forums/showthread.php?t=271232&highlight=show+users I have a database that I converted from Access 2003 to Access 2010. In the...

I have been working on this for over a week in Access 2010 and I know that I am almost there, but need some help getting over this last hurdle as I have a severe case of tunnel vision on this while I am trying to get it to work. I have a Main Report based on my Element table and a subreport...

Help with subreport and images I am hoping that I can better explain myself after playing around in a test database I created. Working in Access 2010 I have two tables: Type and SubType. I am creating a main report with the table Type as the record source. The TypeID field is a foreign key in...

I have worked out a solution for the header, so that is a non-issue. However I cannot get the other issue working properly. I have a main report with a subreport. I need to force a new page on the main report after 2 records are displayed on the subreport.

Help with subreport and Images.... I need some help in Access 2010. I am creating a report with a subreport. I need the subreport to do two things and I can't seem to get them to work together. First of all, I need a page header to repeat which I got working creating a header based on an...

Oh good grief! You just pointed me in the right direction! I am not the original author of this database and would not have built it like this, but I had to work with it and have been trying to get it to work for someone else.....Now I see my problem..... the form was based on one query based...

JHB,I get no records returning when I set my security level to 10. If I set it to any other level (1 through 9) the form filters correctly and returns the records for each level / case. The other odd thing is that when I open the form directly from the Navigation pane, I get a parameter pop-up...

I have a Security form that opens "hidden" with an AutoExec macro. On it is a security level text box that is populated based on the user login ID. When the Security form opens, I have code that opens the [Open Opportunities List] form and this sub that filters the form based on the users...

Okay, simplified the code as follows: Sub Security() Dim HoldUserLevelAssignment As Integer HoldUserLevelAssignment = Forms!frmSecurity!SecurityLevel Select Case HoldUserLevelAssignment Case Is = 1 Forms![Open Opportunities...

No need? Sorry, always did it that way.... But now I think I see the lack of logic.

Well, this is weird, if I switch Case 10 and Case 1 and try to open giving myself level 1 instead of 10, it opens as if it was case 10 (i.e. filtered for John and Jane Doe) but having switched them, it should be giving me all.... I'm confused.:confused:

JHB, thank you for your reply. I have been digging deeper and stepping through my code. I am stumped. I have a Security form that opens "hidden" with an AutoExec macro. On it is a security level text box that is populated based on the user login ID. When the Security form opens, I have code...

Sigh... no, still not working. Thinking I will re-build the form because I just can't figure this one out.....:confused:

Sorry I wasn't clear. I had been working on it for 2 hours straight and was over tired when I wrote this. Basically I have 10 cases. Case 1 through 9 have the filter turned for employees. Case 10 is for management has no filer applied but no records are returned. It's very strange.