Search results

I have a txt box 'Date Received' in which I use the calendar control to input the date. I also have a combo box 'Priority' and another txt box 'Priority Date'. When I select a value from the combo box it auto fills 'Priority Date'. What I want is when I change the date received txt box I want...

Ok, I think I have just one final question. I posted twice already and have figured out both problems, but I have one more. I have two text boxes that I want to use the calendar event for but I don't know how to arrange the code so that both txt boxes can use the Calendar method. Code...

I am having trouble getting code to work for a calendar. When I click in the text box it brings the calendar up, but when I select a date I get the error message: Microsoft Access can't move the focus to the control Date Received(txt box). Here is the code: Private Sub Date_Received_Enter()...

I am having trouble getting code to work for a calendar. When I click in the text box it brings the calendar up, but when I select a date I get the error message: Microsoft Access can't move the focus to the control Date Received(txt box). Here is the code: Private Sub Date_Received_Enter()...

I have tried creating a ole object field to store emails and pictures related to a record but I have only been able to store one object in the field. Is there a way to create a box to store multiple emails and pictures related to a record. Thanks

I have three fields: "Technical Communicator", "Phone #", and "Fax#", and I want the user to click a button called "Add /Change Dealer Info" with these same three fields instead of entering it directly into the fields on a form. Can you supply me with the code that will throw up a message box...

I am trying to create a button that uses the filter by selection command. Could someone supply me with the code to accomplish this. Thanks

I am trying to create a button that uses the filter by selection command. Could someone supply me with the code to accomplish this. Thanks

I want to have an autonumber field but when I delete a record I want the number to remain the same and not increment when I replace the record. So if I had a record 955 and I deleted this record then replaced the record with new info it would not skip to 956. Can anyone supply code to ahcieve...

Is is possible to paste more than one object in an ole field?

Could someone supply me with the code for placing a button on a form that brings up the file upload window so that I can place a file in an OLE object box, if it can be done at all. Thanks

I have a button on my form that opens a smaller form. Can you control where the form pops up on the screen?

When priotity = D then I want the priority date = date received + 14 and also the status to equal "follow- up". I cannot get the txtbox status to show "follow-up" Any suggestions? Private Sub Priority_Change() If Priority = "A" Then Priority_Date = Date_Received + 1 ElseIf Priority = "B"...

I received help from this site yesterday, but I am still having problems with the code. I will try and describe my situation. I have two tables, Dealer Info and Call Log. In my form I have a combo box that should provide a list of the dealers in the Dealer Info table. When I select the dealer...

I received help from this site yesterday, but I am still having problems with the code. I will try and describe my situation. I have two tables, Dealer Info and Call Log. In my form I have a combo box that should provide a list of the dealers in the Dealer Info table. When I select the...

I am getting an, "Operation is not supported for this type of object", error when I try to execute the code below. The line that it stops on is: rst.Findfirst"[dealer]='" & Dealer &"'" Any suggestions? Private Sub Dealer_AfterUpdate() Dim db As Database Dim rst As...

I am getting an, Expected: end of statement, error when I try to execute the code below. The line that it stops on is: rst.Findfirst"[dealer]='" & Dealer&"'" Any suggestions Private Sub Dealer_AfterUpdate() Dim db As Database Dim rst As Recordset Set db = CurrentDb...

combo box to automate related text fields This is my situation. I created a form that provides me with record information from my Call Log table. I have a combo box with a list of dealers. In a seperate table called Dealer Info I have the fields: "Dealer", "Fax", "Phone#", and "Technical...