Recent content by ghacig

Hi. Table that assigns a descriptive value for each day for each staff member Important Fields: ClinicDate, Staff, Description I need to create a module that will create new records and populate them with consecutive dates for each staff, then look up the corresponding value in a separate...

Hello Andy Thank you for responding. I don't think I was clear. The code does not include a command to re-query the subforms. The code is to filter the listbox. However, when the command to filter the listbox is activated, all the subforms get re-queried for no obvious reason.

Dear All I have a large from that contains several subforms and listboxes. The subforms are linked to the main form (Master-child link). The purpose of the form is to display various data when the user logs on. Everything works well except that every time a command is run, all the subforms get...

Thank you so much and sorry for the delay. It worked very nicely!

I have a continuous form that is based on a filtered table. Each record in the form contains a check box that is bound to a field in the table. I would like to have an unbound checkbox in the header of the form. When I check the header checkbox, I want the checkboxes in all the records of the...

Thanks for the code Duane. Yes, a ListBox looks better, but I have to put it in the Detail section, not the Header because it occupies more space. I tried it with a ListBox and it works well. Thanks.

Hi Thanks so much for your replay. By adding the combobox, I can remove several command buttons. Sorry if I was not clear. The code for the Toggle Button AfterUpdate is: CmboBox.Visible = True ComboBox.setfocus ComboBox.Dropdown The ComboBox will be visible and all options too, but, I would...

Dear All I have a main form that contains several subforms and command buttons. The command buttons open other forms. It is becoming busy and cluttered and I would like to clean it up. My idea is to create several unbound ComboBoxes and line them up in the Header, and on the AfterUpdate...

PHV and Remou, Code works great. Thanks for your help.

OK, I figured it out. This works. Select Case Weekday(Date) Case 1 Me.DMonday = Date + 1 Case 2 Me.DMonday = Date Case 3 Me.DMonday = Date - 1 Case 4 Me.DMonday = Date - 2 Case 5 Me.DMonday = Date - 3 Case 6 Me.DMonday = Date - 4 Case 7 Me.DMonday = Date - 5 End Select

Thanks guys. I am a little confused. What does this return? Weekday(Date,vbSunday) Of course I can do something like: Select Case Weekday(Date) case 1 DMonday = Weekday(Date +1) Case 2 DMonday Weekday(Date) etc... Thanks.

Hi I have an unbound form that contains two unbound controls, DateFrom and DateTo. The idea is to select two dates. I was wondering if there is a way and I can have a command button called cmdWeek. When the user clicks it, the two controls will be populated automatically with the dates...

under database tools, you can convert Macros to VB code when the form is in design view.

Great advice. Thanks so much for your help.

Thanks again. I am trying to format a long report with things like Bold title and bullets and numbering. So I probably just need simple tags. I have no experience with HTML tags. Any help is greatly appreciated in terms of text selection and tags. The code that populates the memo field is long...