Search results

my bad, it's actually working :( i got a typo in, at If Not IsNull(Me.txtEndDate) Then 'read the dates selected in the variables dtStartDate2 = Me.txtStartDate as you may see, the Me.txtEndDate should also be Me.txtStartDate, but a question though, how do i add a line that will run...

:confused: can anyone point out what's wrong with my code? it's supposed to filter the enddate of a record from a unbound date field. Function setRateList() 'set starting sql statement strStartSql = "SELECT tblCareGiverCompensation.CAREGIVERCOMPID, tblCareGiverCompensation.COMPRATE, "...

hi, here's my thing. i have a table with a field called rate, what i want is, on a form that creates the record, i want the rate field to be filled (or populated?) by whatever i click or choose from the combo box, how do i do this? any pointers?

oh yeah, thanks! :D

can you change the color of the labels when it is enabled = false? cause it only changes to gray.

thanks. works now :P

here's my code, i copied it off from a sample database a long time ago, now my thing is, when i click the listbox, it would query the records selected, but what if my listbox has records that are null? how do i add the line to the code? Private Sub lstSchedule_Click() DoCmd.Requery...

here's the table, tblschedule scheduleid clientid visitdate visitstatus what i want is to group all clientid, meaning that if a client has multiple records, it will only show the last record or max record for that client.

how do i group records? let's say, from a tbl with a FK, i want to group all FK of that tbl to the last record? what's the best way to do it?

i already did that, it works but my real main issue is, that is sort of shows the last record, say the last visit confirmed on the next record line, so meaning, if the record does not exist yet that field will be null. i really hope i find that mileage db that allenbrowne made.

yes. but then i want that record to join another query (same table, schedule) then from the qryMAX i want the field that shows the last record to then be part of that query, so i can have a query that shows clientid, THELASTCONFIRMEDREC, visit date, status. but the thing for the lastconfirmedrec...

i want to know how to do this properly. i have a table that has a visit date and a visit status field, what i want is, to make a query that will return the last visit that has a status of confirmed then use that field in another query where i'll alias it to say, "last confirmed" visit and it...

Nothing special really. It was an error on my part. Sorry. I copy pasted the child field and somehow the controls got screwed up. So I was getting the FK from another control instead of the one that I want.

lol i found the problem :)

ok, i seem to have a problem. i have done this many times with other forms and somehow for some reason this one is not working, here's the deal. i have a main form and want the primary key of that form to link to my subform as a foreign key in that table, yet somehow, everytime i create a new...

hi. i want to know how to fill a textfield with the selected record from a listbox? any links i can work on?

ok, so i have a main form and a subform. what's the best way to validate data from both forms using only the command button on the main form? e.g i have a save and undo button on the main form, i need it to also read any changes/additions with the subform, any helpful links?

hey, i tried using the code with my exsiting code but doesn't seem to work :(

yeah i have seen that, but does that apply to my current sql statement? can i use the code with the existing code that i have?

i have this code to populate a listbox, it can search names, dates and status etc. but i only have 1 option for sorting, what's the best possible sol'n in regards to when a user clicks say the label for client, it will sort it out a-z or z-a? Function SetScheduleList() 'set starting sql...