Recent content by jlocke

it so happens its the first tab.

I have a form with a combobox that queries a table, when i make my selection a form opens to the appropriate record, but now my form is a tabbed form. How do i open that form now basedon my selection? Thank you

thank you i knew that.... i've used that for time calc. just didn't remember. thank you

date conversion i'm not really worried about that to much i would just assume 365 days in a year.

I need help on how i can convert 1184 days to years, months, days. thanks

Thank you so much. never even thought of searching with "drag and drop". and the link i beleive will do just fine!

Humm.. I don't see how this will let me drag a "med" up of dwon this list by dragging it?

I need to manage a list of, in this case "medications", with this list the most common "meds" are on the top of the list. there will be at times new "meds" added that should be at the top of the list. I want to create a unbound box that will let me drag the "meds" up or down in the list. The...

:) I'm having problems with a simple piece of code using datadiff. all i want is to know how days from today is 3/10/2006, which obivously will countdown as everyday gets closer. joe

sorting grouped reports Why wouldn't make sense? i want grouped items and then want to be able to sort on different fields, say i want sorting on column A then another time sort on column B or C? Joe

I have a report that was being sorted by an option box which allowed me to select which filed to set the sort by option. I had to make a changes to the report design to group by "Property Address" using the Grouping and Sorting options, now when i select a different sort option in my option box...

No data in the on no data event Private Sub Report_NoData(Cancel As Integer) MsgBox "There are no records to report", vbExclamation, "No Records" Cancel = True End Sub

Thank you :) Richo thank you works perfect! I've tried somthing like your code but the Nz i beleive is what i needed.

Ok here is my problem, i have a report selection form which help generate report based on all types of criteria, the one problem i have is when i i don't fill in the Agent box(see snapshot)(left empty) i want all agents on my report. here is the sql code i have. I have tried various Iif...

Thank you both For the time being i will use the easiest solution just to get this done. but will work on the better solution offered by RoyVidar. This Access forum is awesome!