Search results

Sorry guys let me clarify, I do not care if a record in a table goes from line 5 to 500 this will not affect my code at all. The only thing I am asking is if there is a way to reference a line in a table without referencing any fields in that record. Line 5 for example. Just the 5th record...

-boblarson I understand what you are saying, but for the way i will be using it it does not matter to me if it changes. Im simply scanning a table for needed information. My question was simply if there is a syntax for recordnumber in the dlookup criteria? Is there? I have it working the...

pbaldy do you happen to know the exact syntax for that? if dlookup("patientname","tblpatients","Recordnumber = ' 5 '") = .... something like that?

Im trying to find VBA code that will look up a specific record in a table, does this exist? Im actually going to use VBA to scan the table for something im just not sure what function to use. What i mean by specific record is not the dlookup function. I mean literally the first record in a...

Redesigning the database is not an option for me at this point. Is there a way to do it with VBA?

No some are blank, some patients only need to be seen M T F for example

I'm pretty new to access and am totally lost as to how to do something. I have a table for patients with nurses scheduled to see them looks something like. PK Case Number Name MondayNurse TuesdayNurse . . . etc I want to generate a report to list all of the nurses for a given day and who they...

Thanks a bunch worked perfectly

If x(21) = True And x(2) = True Then Forms![Distance Matrix]![t221].Visible = True End If If x(21) = True And x(3) = True Then Forms![Distance Matrix]![t321].Visible = True End If . . . Im having trouble with the cstr command inside the brackets there, any way to...

Awesome that worked perfectly, Thanks a bunch guys.

Can anyone confirm this syntax? still having problems with the code, Getting a sub not defined error on CN. Dim i As Integer For i = 1 To 20 town(i).Value = Nz(DLookup("City", "tblpatients", "CaseNumber = '" & CN(i).Value & "'"), " ") Next i

hey guys I know there is a way to loop this but i cant get it town1.Value = DLookup("City", "tblpatients", "CaseNumber = '" & CN1.Value & "'") town2.Value = DLookup("City", "tblpatients", "CaseNumber = '" & CN2.Value & "'") town3.Value = DLookup("City", "tblpatients", "CaseNumber = '" &...

Hi guys, Im trying to 'force' data into a table with an after update sub on my combo box. I need to code it so that it will look up a record in my table base on certain criteria, and insert the combo box selection into a certain feild within that record. I have looked into FindFirst...

Hi guys I'm stuck on how to design a form. I have set up a database to keep track of nurses and patients. I need a form that allows the scheduling of nurses to patients, all i want it to keep track of is what nurses went on what day, what week it was and who they visited. This form is...

Hey guys, I'm working on a database that should handle some scheduling and was curious if there is a way to do a Monday through Friday calendar view for multiple people. Like a one week calendar with multiple rows for different people. Im not sure if i need to elaborate but i need to be able...

Thanks a bunch man

Hey guys I just joined up a few days ago in anticipation of having some problems doing an access project for school and I'm finally stuck. Not a very complex problem I just don't know the syntax. Here is my code. Dim stra As String stra = "Aide" Comn1.RowSource = "Select...