Search results for query: *

First thought that comes to mind is a Macro and Scheduled Tasks. Setup the Macro to retrieve the email and extract Excel file and move it. Then set a Scheduled Task to perform that Macro when you like. FYI - Scheduled Tasks can be found in Control Panels. Reading that, I know it's not a lot of...

Have you tried deleting that profile (exporting to file if needed for backup) from the Outlook client and setting it up again? -Chris Starlight B. M.

I've encountered problems like this. I would check the Exhchange properties for Outlook (Right-click Outlook Icon>Properties>Microsoft Exchange Server), and make sure server name & mailbox name is correct there, can hit check name to confirm. Also, it helps to have the user use the same username...

I happened to install Outlook 2000 on a machine here at work and set it for Email Only during the installation setup. We used to use an exchange server, and we no longer do, the mailboxes and address books have all been exported to files. This employee got a new computer, so I loaded him up with...

As was mentioned, I would use a report. When you have data that you know is going to variable, such as your subform data, allow the textbox to grow (textbox properties Grow=Yes). Depending on the width you set for the text box, the data will wrap at the right side of the textbox and continue...

What's the error that you get? -Chris Starlight B. M.

Oh man! I set the bound column = 2 and that fixed it. I was basing the column bounding rules on a 0,1,2... type of list, not 1,2,3... PHV, you know a lot of great Access functions! I would have tried the DLookUp() had MajP's suggestion not fixed the problem. Thanks for the suggestion! -Chris...

I added this to OpenSchedule_Click()Dim strCriteria As String strCriteria = "[ScheduleID] In (" & txtSeeValue & ")" DoCmd.OpenReport "rptByChris_PrintMultipleSchedules", acViewPreview, , strCriteriaThat works perfectly! Thanks! No book I've looked through ever mentioned any of these methods! Can...

OH! I think that would work great! I didn't know how to run a criteria command like that on the fly. Thanks! -Chris Starlight B. M.

PHV, UserCodeL_12 is a valid ID. I'll play with that. That addresses how to get the combo box to show the correct value. I'm getting the ID value on the report, and not the corresponding description. FYI: The contents of the table (tblEMPLOYEES_Extension_UserCode12) look like this...

I have a form, with a list box. The user selcts various items from the list. I want to print a report based on the users selections. So far I have this:Private Sub OpenSchedule_Click() On Error GoTo Err_OpenSchedule_Click txtSeeValue.Value = "" Dim intCurrentRow As Integer For intCurrentRow =...

That combo box uses this as the RowSource: SELECT tblPAY_EMPLOYEES_Extension_UserCode12.ID, tblPAY_EMPLOYEES_Extension_UserCode12.Description FROM tblPAY_EMPLOYEES_Extension_UserCode12; ID is the ID/Key and Description is the corresponding description. The user selects a Final Check Disposition...

I am puzzling over your number of columns. I'm womdering if something like this might do:Dim ColumnSize as Integer ColumnSize = Len(qryMyQuery)Just a guess there. In Query Design Mode, enter -1 on the Criteria line for the first criteria. On the Or line for the rest of the columns, enter -1 for...

I'm a little confused at what you want from the column count, it sounds like you want to know how many columns there are in each table? or how many columns are checked? Check boxes store either NULL (No entry), 0 (False, no, or not Check), and -1 (True, yes, or Checked). To create criteria for...

Read through http://www.tek-tips.com/viewthread.cfm?qid=1199817&page=1 and found an answer I needed. I was doing something similar in my form. I did get one oddity. My form loads and queries a table to populate comboTermFinalCheck. SELECT tblPAY_EMPLOYEES_Extension_UserCode12.ID...

Will do, I just try to keep the forums less cluttered by addressing similar issues in the same thread. Also, I find if others have a problem that relates, when they read through a large thread, they may find the answers they are seeking through reading it. -Chris Starlight B. M.

Read through this thread, and found the answer I needed. I was doing something similar in my form. I did get one oddity. My form loads and queries a table to populate comboTermFinalCheck. SELECT tblPAY_EMPLOYEES_Extension_UserCode12.ID, tblPAY_EMPLOYEES_Extension_UserCode12.Description FROM...