Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by lrumd

  1. lrumd

    Two wireless Linksys routers in cascade

    Thanks, Frank. "MAIN" issues addresses starting with 192.168.2.15 and "DEN" has address 192.168.2.2, so there is no conflict. Thanks, Dan. So, it IS ok to have the same SSID name? I take it both should have different channels, correct? Will try that. Luis
  2. lrumd

    Two wireless Linksys routers in cascade

    I have two Linksys WRT54GS routers; one called "Main" connects to the Internet via the Modem and serves as the DHCP server. The other one called "DEN" has DHCP disabled and connects to "Main", wired through one on the 4 ports in "Main". Both serve as wireless connecting points and are set to...
  3. lrumd

    Subform within a subform

    Thanks, Richard. Never used tabs, looks VERY interesting Luis
  4. lrumd

    Naming conventions - help needed

    That got you a star and a medal [medal] Thanks, godawgs!! Luis
  5. lrumd

    Naming conventions - help needed

    Ok, I have been able to determine when the AfterUpdate event triggers. Now I this is what I have, but it's not liking it: Private Sub ApptDate_AfterUpdate() If Me.ApptDate.Value <> &quot;&quot; Then Forms![frmPatients]![subfrmOrders subform]!Visible = True End If End Sub I am trying...
  6. lrumd

    Naming conventions - help needed

    I can't seem to be able to &quot;address&quot; a certain control when I am writting code in my main form. Let me explain: frmMain subfrmSecond subfrmThird LastName EntryDate Item FirstName Place Amount ... ... ... ...
  7. lrumd

    Subform within a subform - data entry

    Thnks jf, but I still have a problem: I added the line: Me.subfrmOrders.Visible = True to the AfterUpdate event of the ApptDate but it doesnt work. I am obviously doing something wrong, syntaxis-wise The actual subform name is tblOrders (don't ask me why I used that name; should have named...
  8. lrumd

    Subform within a subform - data entry

    Ok, visible = false in my subform. Now I can't see the subform. Now I need to make the subform become Visible using code; where should I write the code? In the subform itself? In the parent form? In one of the controls? Remember, the subfrmOrders is itself a subform of the...
  9. lrumd

    Subform within a subform - data entry

    How do I set a subform to accept data only if its parent subform has data? Let me explain: frmPatients subformAppointments subfrmOrders I do not want orders entered in the subfrmOrders UNLESS the user has first created an appointment in the subfrmAppointments. Thanks Luis
  10. lrumd

    Subform within a subform

    How do I set a subform to accept data only if its parent subform has data? Let me explain: frmPatients subformAppointments subfrmOrders I do not want orders entered in the subfrmOrders UNLESS the user has first created an appointment in the subfrmAppointments. Thanks Luis
  11. lrumd

    Picture in my report

    Bob: This is perhaps a little off the subject. but I have been following this thread with great interest, and can't help it, I have to ask.. What exactly does Me! ..... refer to? I never understood it, perhaps because nobody explained it well. Is ME! synonym to &quot;This FORM we are...
  12. lrumd

    Reversed one-to-many relationship

    Thanks, Ricky. Now that I understand it, it appears to be pretty obvious. I feel like a fool. An enlightened fool. And yes, a patient can have several Drs. and Diagnosis, but for the purpose of my database, I am tracking certain patients, their referring physician, their main diagnosis and...
  13. lrumd

    Replication / Synchronisation Question

    Look at Microsoft Knowledge Base Article 198950 You will have to re-create the folder and the replica, then delete it. The problem apparently arises when someone deletes the folder. You need to re-create the folder with the same address (ie \\server\public\database\mydatabase ) and...
  14. lrumd

    Reversed one-to-many relationship

    Sorry, AppointmentRef in the tblPatient RELATES with AppointmentID in tblApointments Luis
  15. lrumd

    Reversed one-to-many relationship

    I have the following tables and relationships. Everything looks fine EXCEPT the relationship between tblPatients and tblAppointments (I need 1 patient to have many Appointments, not the other way round) tblPatients PatientID tblPhysician PhysicianRef---------PhysID...

Part and Inventory Search

Back
Top