Search results for query: *

Hello. I'm not sure of the best way to set this up, but I have a table with a document_name field and a due_date field. Here's my dilemma: I want to have a form that I can input a document name in a text box and have a drop down with a weekday listed. Then after the user selects the due...

Hello everyone, This is my first post to this forum. I am exporting a MS Project file to Excel using the wizard. Is there a way to capture the formula's Project uses and have them export to Excel as well? Its a simple project plan, with task names, baseline start, baseline finish, actual...

Thanks for the reponse Jerry. No, it wouldn't let me. I put it in the Open event of the form and I received an error "You can't assign a value to this object."

Thanks for the response. I've tried to put it in the OnOpen event but get the following error: "You can't reference a property or method for a control unless the control has focus" Milt

Hello everyone, Although an easy question for all, I still need assistance. I have a text box which increments +1 when a new record is added. I have it placed on the control of the text box, but would like to have it automatically run when the form is opened. The code in the control is...

Okay, I've got a little further. Next error is 'item not found in this collection' and the statement highlighted is: txtDate = rst!DateCreated txtDate is the name of my textbox.

Thanks Paul. I'm getting a runtime error 3251, Operation is not supported for this type of object. I debug and the .FindFirst ("Name = 'tblUMD'") statement is highlighted. Any ideas? Milt

Thanks for the reply, Darrylle and Paul. What code would I put in the text box to retrieve the info? Milt

Hello all, I have a combo box called cboOSC on a form frm94. The combo box is populated by a subform. I want to dblclick on cboOSC to bring up another form called frmOSC. The frmOSC needs to be filtered by the value in cboOSC. When frmOSC pops up, it asks to input a parameter value. In the...

Hello all, I am having a problem sending an email using SendObject. When I use it once, it works fine. After trying the second time, I get an error 'The SendObject was canceled.' If I close the database, then reopen it, it works fine again. Although only once, of course. This is accomplished...

Hello all, I searched through the different posts for a way to alternate the background color between records on a report. The code I used was this: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Const cLightGrey = 12632256 Const cWhite = 16777215 If...

I knew the format of my autonumber maybe a problem, but it worked fine and still is. I just needed to transfer the number to a word document, that's when it became a problem. I just really need the number formatted as 70IW-03-001, etc. Here's my code for transfering it to a word doc. Sub...

Good morning all, I have a question concerning an autonumber field. Each record is autonumbered with the format \70"IW-"0"3-"000. Each record is numbered as 70IW-03-001, 70IW-03-002, etc. This works fine when the record is input in an access report or an .rtf file, but I...

Disregard. Tried this and it worked: Private Sub PageHeader_Format(Cancel As Integer, FormatCount As Integer) Me.Section(4).Visible = Me.[Page] = 1 End Sub Thanks, Milt

Hello, Is it possible have the pagefooter appear on the first page only? Right now, it appears on all pages. Thanks, Milt