Search results

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...

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...

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...

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...

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...