Search results for query: *

Hi, I need to enable Outlook (2003 on XP) calendar sharing for myself and another user. We both have Exchange listed in the email accounts, though we are actually using POP email and this account is also listed. Outlook does not give us the option of sharing our calendars (it's grayed out in...

Hooray! Tek-Tips to the rescue yet again. I didn't realize that you could use the grouping/sorting window to sort without grouping. I took your advice and first sorted by lastname in the grouping/sorting window without any header or footer, and on the second line put sortnum with a group...

Hi, I have a report based on a query with sortNum as the unique ID number and last (last name), among other fields. For each sortNum there can be one or more query results. So, on the report it makes sense to have a sortNum header with the labels and the text boxes in the detail section...

Thanks, JediBMC. I did try changing the column width (it's datasheet view btw) and inputting a large whole number. Since it works in the table, it should have something to do with the form field properties... By the way, it did work before - so maybe the db is corrupt. I will create a new...

Hi, I'm stumped. I have a table with one of the fields formatted 'double'. There is no problem with inputting numbers in this field. I can input decimals and it doesn't round them up. There is a form based on this table. When I input numbers into this form in the 'double' field, it will...

Eureka! Thank you so much, hneal98, pjstephenson and mp9 for helping me out. It was the last missing piece in this report. It must be the date format that did it; I never would have thought of it myself. It's one of those things that if you don't know it, there's almost no way to find out...

Can anyone help with this DSum Syntax? I have been at it for hours. If I take off the 'AND' part it works fine. I'm pretty sure the problem is with the 2nd condition. Me.txtCpesNeeded = DSum "[creditsReceived]", "subqryCpeLetter", "[sortNum] = Me.txtSortNum AND [appliedOn]>=#" &...

oops, I was a bit hasty hitting the submit button. i messed up my variables. here's the code again. ----------------------- Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim dteGradDate As Date Dim dteNextAnnivDate As Date dteGradDate = Me.txtGradDate dteNextAnnivDate =...

misscrf, Thanks for your reply. Actually, I realized that I was asking the wrong question. What I was trying to do was figure out the next anniversary date of gradDate. Silly me was trying to strip the mm and dd values from gradDate and do it that way. I was able to solve it much more simply...

I have been searching through the posts; apologies if this is already out there. I have a database which calculates continuing education credits earned following passage of an exam. People are required to earn x credits per year, based on the anniversary of passing the exam (gradDate). Each...