Search results

You got it!!! You are a genius Thanks a bunch Dennis

The call Message is highlighted Private Sub cmbQueries_Click() Dim stDocName As String If IsNull(Me!cmbQueries) Then Call Message("Please select a query to edit.") Else stDocName = Me!cmbQueries DoCmd.OpenQuery stDocName, acViewNormal...

Thanks fo the quick reply, I replaced the code as suggested by the error message stil the same Regards, Dennis

CMD button to run selected query Hi All, When I use the following code in the cmd button I get a compile error Sub Or Function not defined Private Sub cmbQueries_Click() Dim stDocName As String If IsNull(Me!cmbQueries) Then Call Message("Please select a query to...

Hi all, I have two dates, start date and enddate in a form, would like to calculate working dates between both dates in a third field called Exp: (using a query buider in the form) <code> Public Function GetNumberOfWorkDays(sStartDate, sEndDate) Dim iDays Dim iWorkDays Dim sDay...

Update field Hi All I solved my own q? Me.cbxapprovaldate = Me.cbxapprovaldate.ItemData(0) thanks Dennis

Hi all, After updating a text field, I would like a combo box to show a date from its row source, I trying to avoid cliking in the box.. The row source has only one date that remains for a whole month before being replaced on a monthly basis.the text field name is dates, and the combo bx is...

Hi all I have two cascading cbx's, would like the value from them to select the corresponding report. Any help would be greatly appreciated Dennis :confused:

Update field Thanks for your quick replied, will give it a try have a nice day Dennis

Hi all, Need to update a field from a subforn to a field in the main form. All records in the main frm are captured as pending until the transactions are process in the subfrm and a field is worded "complete" then would like to update the main field from "pending" to complete the main form...

Not sure how to do it thanks Dennis

Hi, I placed the code and the behavior is the same as before. Is a continous form so if a second value is selected all previous selections go invisible. I think the id record should be referenced somehow. thanks Dennis

Hi all, I have this code that it does not work just the way I would like to. Here is the problem, Is a cbx in a continous form, when I select the value "Pending Affidavit" a "Noyears" field is visible, unfortunaly it does the same for any other value selected I know it should also reference...

I used your advise, it worked great Thanks Dennis

Hi All, I have a cbx with seven categories which represent 7 separate frms. I would like to select a value from the cbx and click on a cmd button that will open the selected frm on the current ID. Any help would be greatly appreciated thanks Dennis

I did exactly as note, but did not work. Get regular error message "The form name xxxx doest not exist" reviewing: I change cbx property to yes, under cbx "not in the list event I placed code" I might be missing something Dennis

Thanks it works fine, one final q? If there is no fmr built yet, I would like to add a message" No form available" How can I do this again thanks a bunch Dennis

Hi All, Would like a cmd button to open specific form selected from a combo box. Any help is appreciated thanks Dennis

I needed a wake up call Thanks Dennis

Thanks Wayne makes sense, now how about being able to select a rpt from the cbx ? have a nice day Dennis