Search results

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.

I have two reports. Short and Long. The second report has one field which is an picture embedded. I'm tryint to do something like, If field is null open short report else if field is not null open second report. Also account for the fact that multiple records can be selected to print. There...

Can you do something like if field is null only print page 1? Can you do a open report and only reference a page number?

I have a report that is two pages, the second page only has an picture embedded. This is not a required field, so If the field is null only print page 1 else print both pages. Any suggestions?

I have a report that is two pages, the second page only has an picture embedded. This is not a required field, so If the field is null only print page 1 else print both pages. Any suggestions?

Yes it is bound to a table