Search results

Just creating the textbox should get you the desired result. To save to a table you would have to add more code.

Dim iRecordCount as Integer 'get the value in the textbox on current form. iRecordCount = CInt(nZ(Me.txtRecordCount, 0)) 'set a default value If iRecordCount = 0 Then iRecordCount = 50 End If strSQL = "Update [JT Client List] set TempAccountManager = " & intAccountManager strSQL = strSQL &...

Actually you are not far from what is needed at all. Have it look like so: Expr1: MedianF("[NorthAm R2]","[OBS60]")

What application is pulling the data from the spreadsheet currently? You can reference the Excel Library in your Access Application and use the Offset(StartingCell,0,1) function to get the cell next to your AG reference.

Why did the last reply not work for you? Was it because you did not understand it, or because it failed to run? It worked real well in my test. Where you have the Median placed in your pdf is the criteria row.

If I understand you correctly. You need to create a query that pulls in the data from your table where status is null and sort it ascending by date, then base your report off this query. Or am I missing something?

It is going to very difficult to code something if you have no standards in place.

Not sure about the query and table access, but you could put a function/sub that writes to your audit trail table on each form_open and run on autoexec. Like I said I am not sure how you would execute it when a table or query is opened.

OT: Take a fishing trip to Algoma, Wisconsin sometime. I went with my Father-in-Law last year. Cost us $400 each for 3 days King Salmon fishing on Lake Michigan with a Capt and First Mate. Had a blast and caught enough salmon to last us all year (came back with 20 fish each averaging 15 pounds).

You could create a new report and have each of those reports be sub-reports on it. I haven't worked with WinFax so not sure how to send two reports with it.

I agree with Neil. Although I don't really understanding your process, it seems that tblOverallStatus could be consolidated into your tblStudents table. Aren't all the various statuses(Education, Employment, Crime, etc) related to a student? Also you might want to slightly alter your...

Expr3: you can change this to Score: to give you a more meaningful name. How is this determined? Do you have a set of parameters that tell you this? e.g. Between 0 and 5 = 1, 20 - 32 = 4, etc...

Pretty sure you can remove the IsNull and IsEmpty references since the function arguments are not Optional. Try this: Function StatusColor(QOH As Integer, QAUTH As Integer) As String On Error GoTo ErrHandler ' This line HERE should trap the error, but for some reason its not. Ideas? If...

Not a pain in the least. Column C: IIf(Not IsNull([Locally Assigned RB]) And Not IsNull([Assigned RB]),[Locally Assigned RB],[Locally Assigned RB] & [Assigned RB]) The 'Column C: ' Section simply tells the query engine what you want your field named. You can put almost anything you want...

Why can't you just run the code from your mainform click rather than run it from the subform click? I do not know if you can refer to a subform button click as that code is labeled as Private.

Didn't know that you wanted that extra 'functionality' based on your initial question. Can you set the focus to the textbox before calling the Find dialog? Something like: Me.TextBox1.SetFocus DoCmd.RunCommand acCmdFind

Ahhh just re-read this and that is the problem. The IIf statement should be it's own column, not the criteria of a column.

For wife I got her some earrings (blue topaz), a new outfit (she picked it out months ago and thinks I forgot), cell phone charger for her car, cd, dvd, and a book.

Tools | Options Click on Edit/Find tab. There is a section called Default find/replace behavior. Click the General search radio button.

See Query1 for Select version, Query2 for Update version in the attached. Both work perfectly, all I did was copy/paste from my earlier post. Not sure what the problem you are seeing is.