Search results

Thanks for the suggestion, but I still cannot get it to run the priority code again after I have already entered a date and selected a priority then try to change the date received. Lets say I enter 8/13/01 into date receied txt box, select priority 'A', and it auto fills priority date(Date...

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...

I put the If statment in the Calendar method and it works if the date received field is blank. But when I try to change the date of the date received field it will put the new date in the 'date customer up' txt box. Code: Private Sub Date_Received_MouseDown(Button As Integer, Shift As...

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 figured out the previous problem but I have another dilemma. When I click into the 'Date Received' txt box the Calendar pops up, but I want to make the calendar disappear when the mouse is not on it. So, say someone clicks into the text box and decides not to change the date and moves the...

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

Thanks, That will work perfectly for what I need.

That works!! thanks Just curious, could you create a message box saying "Use the button" when a user tries to enter text.

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

That worked perfectly. Thanks Carol

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...