Search results

Can someone send me the code that will send an appointment from Access to a nondefault Outlook calendar. I know the code to send it to my own default Calendar...I just don't know how to change the code to make it go to another folder. I created a calendar in Outlook that contains all of our...

I have a table that contains a person's ID and their address (there may be multiple addresses per person). Each row of the table contains a different address. I am trying to assign a row number per address for each person (Address Count). Here's an example of what I need it to look like: ID...

I have 3 subreports in 1 report. I would like the first report to print from tray 1 (white paper), the 2nd report to print from tray 2 (yellow paper) and the 3rd report to print from tray 1 (white paper). Can this be done?

Please tell me why Access and Excel are calculating the hours this way... The number of hours between 18:00 hours (6:00 p.m.) and 24:00 hours (12 a.m.) should be 6 hours. Access and Excel are both returning a datediff value of 18 hours. If I change the end time to 12 p.m. (12:00 hours), then...

I am putting a data access page on our company's intranet for multi users to enter data into one main table (could be up to 100 users - and I am not sure how many users would be opening the page at the same time). Are there limitations on how many users can open the data access page and enter...

I need to convert my text data to a number but when I convert using the VALUE function or use "format cells" to the numbers category, I loose the leading zeros. I need to keep them for sorting purposes. What formula do I use?

Is there a way to compare the value in one field with the value of the same field in the next record? I can do it in Excel by using the following formula: =If(A1=A2,"Match","No Match") But I need to be able to do this in an Access query? Any ideas?

I have two text boxes (Text1 and Text2) in a report. When the value in Text2 = 0, I want the left margin of Text1 to change to a new position on the report. I tried the code below: If Me.Text2 = 0 Then Me.Text1.Left = 3.5 Else Me.Text1.Left = 2.5 End If This didn't work. Does anyone know how...

I have two text boxes (Text1 and Text2). When the value in Text2 = 0, I want the left margin of Text1 to change to a new position on the report. I tried the code below: If Me.Text2 = 0 Then Me.Text1.Left = 3.5 Else Me.Text1.Left = 2.5 End If This didn't work. Can anyone help me with the...