Search results

Ended up getting it to work. I had to add in to make the value save on the subform rather then to the table for this to work. The operator needs to be able to see the last two values that where entered in. Without clogging up the main table this was the easiest way I knew how to relate that...

I have tried that without success also.

On my main form I have two subforms which are invisible to the operator but are used to pull up the last two records from different tables. The operator enters in the new record on the main form. I am trying to make it so that after they click save it updates to last two records again. However I...

That almost sounds like was I spent last week working on. I have a button on my report that prints the report that is pulled up at the time. http://www.baldyweb.com/wherecondition.htm Print is the default action for this code I found out, I was actually just trying to start with opening...

Thats what I have it set as... I am working on making it small enough to attach as a zip file to add on here. Well after looking over it again I did have that set to one of the number fields, completely forgot I had it formatted and bringing up just the number used rather then the whole ...

Yes, well I want to bring up the report in report view not preview print. However I am still unable to get the code to bring up the report. Instead I keep getting error messages.:banghead: I'm still learning all of this stuff, so what I am trying to do might not be possible.

I end up getting Run-time error '3464': Data type mismatched in criteria expression. Debug highlights the whole line. ProcessChangeID field is text. It is not the primary ID auto-number access gives it if that is what you are wondering.

Private Sub Command5_Click() DoCmd.OpenReport("Report2",acViewNormal,,"ProcessChangeID = '" & Me.PCid & "'",acWindowNormal,OpenArgs) End Sub and I am back to the Compile error: expected =

Private Sub Command5_Click() DoCmd.OpenReport("Report2",acViewNormal,,"ProcessChangeID = '" & Me.PCid "'",acWindowNormal,OpenArgs) End Sub Compile error: Expected:list separator or ) the red is what is highlighted when the error comes up. It is ProcessChangedID no spaces in the actual code.

No and when I go to edit that on here it looks normal :-/

Okay, I changed it to follow how access suggested. It now looks like: DoCmd.OpenReport(ReportName,acViewNormal,,"FieldName = '" & Me.ControlName = "'",acWindowNormal,[OpenArgs]) But now I get and Error message: Compile Error: Expected: =

I don't know why, but when I put that in it is trying to print out the report :-/ I used the code Private Sub Command_Click() DoCmd.OpenReport "SecondReportName", , , "FieldName = '" & Me.ControlName & "'" End Sub

I have report page that pretty much brings up a summary of multiple records. It would be nice to be able to push a button next to the summary and have it pull up the full report of the record it is next to. I have the full record page asking for id number right now, but I was wondering if there...

So I know the answer is probably very obvious I just haven't found it yet. I have a report shooting off of the main table and other reports off of queries. They hold the same information so that part isn't really important. However I would like for when one of the reports is opened to ask for a...

That makes sense. I forgot that the person who made the table change the regular ID to something else. Thank you.

The save setup is exactly the same as I have it on my other databases so I'm not sure where I went wrong. Private Sub Save_Click() On Error GoTo ErrorHandler Dim db As Database Dim sn As Recordset strCount = 0 If Me.txtPC >= 1 Then If Not IsNull(Me.ChangeDate) Or Me.ChangeDate <> "" Then...

Haha, true... Been a long day already meant to say 2011 >.<

Hi, I cannot figure out what I did but I assume it has something to do with an "if" "then" "elseif" statement I have on another part of the form. I get the Run time error '3061' Too few parameters. Expected 1. Set sn = db.OpenRecordset("SELECT * FROM TableName ORDER BY ID DESC"...

Welcome to the Access World Forums! So I'm supposed to state a little about myself I guess. I've been working with Access (mostly 2007) since September of 2011. I live in the United States. I don't really have any notable hobbies.