Recent content by dtaylor89

The sql statement should be ran after I click a button

Run-time error 2342 A run SQL action requires an argument consisting of an SQL statement. This is my error when I run the code

I am trying to write a SELECT statement to count the InitPW from a table where the PWord is null and the textbox on the form "txtNewPass" is = InitPW but some reaseon this isn't working does anyone see something wrong with the below select statement Dim sqlText As String sqlText = "SELECT...

Hey, you guys I have a huge problem!!! I have a database that has linked tables. When you open the database from the SharePoint site as read-only you are still allowed to edit the tables. This can not be! At the same time some users need to able to edit the tables. How do I manage this? is is...

And I also moved the movenext between the two End If

Hey do you see something that I'm doing wrong in my code because when i hit print it immediately prints the reports selected but the one with the attachment still only printed the first page. Dim rs As dao.Recordset Set rs = Me.Recordset Do While Not rs.EOF If rs("Print") = True Then...

ok how can i make this work just to loop through to directly print. I will only have the user preview single reports

so something like this Dim rs As dao.Recordset Set rs = Me.Recordset Do While Not rs.EOF If rs("Print") = True Then If (Me.Metric_Display.AttachmentCount) = 0 Then DoCmd.OpenReport "rptMetrics", acViewPreview, "", "", acNormal Else DoCmd.OpenReport...

I have a split form where they can check which records they want to print.

Ok that fixed my error however how do i account for someone selection a record with an attachment and one without an attachment at the same time. When I do this I only get the short report and i dont see the long report.

Yes I can view the report any other way. Only when i use this code I cant see the report. If I take out the if else statement and just open the report it works just fibe

Is there a way if a record is missing a certain field(attachment) then open short report else open long report. Or is there a way that you can have one report with two pages and say if field(attachment) is null only open display page 1 else display page 2. I have some code like this If...

Or is there some way that I can have one report with two pages and If field is null dont print second page else print both?

I have some code like that If (Me.Print) = 0 Then 'Checkbox Call MsgBox("Please make sure you select a metric to print!") End If If (Me.Metric_Display) = 0 Then DoCmd.OpenReport "rptMetrics", acViewPreview, "", "", acNormal Else DoCmd.OpenReport...

Yes they are.