Search results

  1. I

    ideas on how to do this

    ok. so what i want to do is, put a ranking on a record which i already did, and have done already. what i want is to be able to rearrange the ranking, what's the best way to do this? do i use a field? a calculated expression? to elaborate, let's say i have 10 records, from 1 to 10, if the...
  2. I

    David Crake – very sad news

    he will be missed. he had good insights and was extremely helpful to this forum. i know it's been a weeks already but i hope his family and friends are doing ok.
  3. I

    master child link problem

    ok. i have done this like a lot of times and have checked this one over and over again and there is nothing wrong. i have two problems. 1 is with a form that i linked using the EmployeeID and the LogEmployeeID yet somehow, everytime i create a record, it doesn't auto populate or assign the...
  4. I

    counting the records

    yeah it works, but (this is really stupid) what should i use for a number? cause am ranking them through the primary key, not the date so the # on that thing is not valid, cause am getting an error. thanks alot for the help btw.
  5. I

    counting the records

    didnt see the allenbrowne there. my bad. but any direct tips though as to how to add a count and retrieve it?
  6. I

    counting the records

    well, ascending and it is not possible to have more than 1 record for that date. what method (sample if possible) can i use to count the records? and how do i retrieve it?
  7. I

    counting the records

    sorry if i didn't explain it to well, all i really want to do is count the 13th record for the report, and just show that record in an unbound text box. so i don't really need to specify or assign a count on each record, just count the records as is. e.g i use count() to count all of the...
  8. I

    counting the records

    i store the date, basically, each record also is tied to a certain, certification period, so each time they print this report out, it's only for that certification period. so what i want to do is, on the report for the certification period, i want to count the 13th visit and 19 visit for that...
  9. I

    counting the records

    hello. jsut want to know the best approach or sample if possible, cause i have a report that contains schedules for patients, what i want to do is, on a unbound form, calculate the 13th and 19th visit of that particular record, anyway to do this? or anyone care to teach me how? thanks :)
  10. I

    anyone know how to fix this or know what's causing this.

    i have a form that has tabs and a subform in it, odd thing is, everytime i load it as a form, for some reason, the focus on the page seems to try and show all of the subform, so my tabs for the main form are not visible unless you scroll up. how do i fix this or what is causing this?
  11. I

    carry over

    well, it's really not duplicate but rather just have the fields from the last record be the default value on the new one, but am gonna try it out thanks!!
  12. I

    carry over

    ok, i found a code from allenbrowne from carrying over the last record to the new one, i want to know if someone if familiar with that but also carry over the entire subform that has more than 1 record but shares a FK with the main form?
  13. I

    tabs and hiding

    my bad, it's actually Select Case Me.tbPNDVS.Pages(Me.tbPNDVS).Name thanks bob!!
  14. I

    tabs and hiding

    Select Case Me.MainTabControlNameHere.Pages(Me.TabControlNameHere.PageIndex).Name so here would it be like, Select Case Me.tbPNDVS.Pages(Me.tbPNDVS.PageIndex).Name or it is wrong right?
  15. I

    tabs and hiding

    so would be it like tabindex(1) then? something like that?
  16. I

    tabs and hiding

    it does, but then again, i want it to be hidden when they click on that tab, what's the best way or sample to simulate it that when i click the tab, the button would then be clicked too?
  17. I

    tabs and hiding

    so i have a tab, i put this on the code when it's clicked, yet somehow does not work. Private Sub pgVitalSigns_Click() Me.lstProgressNotes.visible = False Me.txtEndDate.visible = False Me.txtStartDate.visible = False Me.cmdClear.visible = False Me.cmdSearch.visible = False End Sub shouldn't it...
  18. I

    help writing a code

    so it would look like this? If CurrentProject.AllForms("frmMainMenu").IsLoaded Then If IsLoaded(Forms![frmMainMenu]![lstPatients]) Then strWhereSql = "WHERE qryClientStatusList1.CSCLIENTID = " & Forms![frmMainMenu]![lstPatients] & " " Else strWhereSql = "WHERE...
  19. I

    help writing a code

    getting an error, it wants me to define it?
  20. I

    help writing a code

    can someone tell me what needs to be changed here. basically, what i want is, if the form is opened through the listbox, it would filter the clientID through the listbox, but if the form is a new record, the sql statement would then be filtered using the forms clientid, here's the code. If Not...
Back
Top Bottom