Recent content by jsbotts73

Thanks missinglinq for the explanation of the confusing property Data Entry.

Problem is solved. I was given "Similar Threads" when I posted this thread and got the answer. I had the data entry set to yes, and changing to no corrected the problem. Sorry for this post. Being new to Access Forum, perhaps I do not know how to search the prior threads. I entered a search and...

I have made a form and put the Default View to split form. It was working just fine until today when suddenly the datasheet view showed an empty table. I have checked the table itself and it contains the expected data. The record source of the form is the table tblExpenses. In an effort to...

Thanks to all!! You all were so fast!! I just read after I posted about Collections which as a Rookie I had not run across. Thanks again to all of you. All of you had the same answer that worked.

I am having a problem using a TextBox as a parameter in a Public Sub. I have tried passing it as a string, as a property of a form and with no luck. I am lost. It compiles but will not run without errors. I am an Access Rookie. Here is the code of the sub: Public Sub AllCostsMTD(frm As String...

pbaldy: WOW. It now works which will prevent me from having to copy and paste a bunch of code. I used - Sub Expenses(tbx As String, frm As String), and when calling the sub - Expenses "tblExpenses", Me.Name. Now works as intended. Again thank you so much. I had been searching for days on the...

Thanks so much pbaldy. I have to knock off for dinner too. After I will try your new suggestions. I appreciate you so much.

Thanks for the quick response. I should have made it clear that I have written the sub in a module and the sub to be used in several forms. Because it would not accept Me when used in a form I have to substitute the name of the table and the name of the form.

I am an MS Access rookie. I am trying to create a sub routine in a module and would like to have two parameters in the Sub. The first parameter is the name of a table, and the second the name of a form. In the code below I have only put the type of parameter I would like to put in the sub...

It has been over two years and I must say I was negligent in not thanking all that posted to my thread. Very thoughtless of me. The project was discontinued and I did not follow though on this thread as I should have. So, thank you Sneuberg, and Mr. Hans for your help.

Thank you so much, sneubery and MrHans!! You have taught me something. The problem is solved by putting the following in frmDietExercise Form_gotFocus() event: Me.OrderBy = "DietExerciseID.Value" Me.OrderByOn = True If there is a special way to post a Thanks, I don't see it.

Here is what I tried: Private Sub Form_GotFocus() Dim SQL As String SQL = "SELECT PI.*, DE.* FROM tblPatientInformation PI, tblDietExercise DE " & _ "WHERE PI.PatientID = '" & Me.tbPatientID.Value & "' " & _ "ORDER BY DE.DietExerciseID" Me.RecordSource = SQL...

I am new to Access. How do I place the code in the Record Source?

Sneuberg - Doing what you recommended in your last post took me to the first record, but did not let me go to any other records. It also asked for the parameter value of DE.DietExerciseID. It was placed in the Query method of the form.

Placed them in the Query method of the form and got a dialog box asking for the value of DE.DietExerciseID"