Search results

I was looking at the Northwind database and in the customer list form there is a button to collect data via email. I want to add this to my project however before doing so I need this question answered. How do you send the email so the user can edit it and reply. I sent it to my email address...

I have a form where the user may pick more than one city for the same record using a multi select list box, I want to store the selected choices in a seperate table to keep it normalized. However I want to see the choices in a field on the form separated by ; or | Does anyone have a similar...

I converted an access 2003 to 2007 and want to enable the date picker on the form fields where dates exist and remove my buttons to show my own date form picker. I verified the table and the form fields and all are enable however the date picker does not show up. I compacted and repaired the...

I have a function CheckEmailName() that works, at least in the immediate window. Like this: ?CheckEmailName(joe@workcom) returns msg: missing . Wonderful but when I tried to use it on my form in the beforeupdate on the field like this it did nothing: CheckEmailName(MyField) PS I did try it on...

I have a tbl with facilities and another table with bed types, each facility has types of beds. I have a contract form with a subform of contracted beds by facility. Right now I dont have the beds linked where if you choose all the bed types for a facility the spinner control would go to 0 in...

I'm getting an error eveytime I want to delete a linked table in ms2007. Message: (isn't a valid name. Make sure that this does not include invalid characters and puctuation and that is not too long.) :cool: I renamed the table as delete, still no luck. Anyone know why this is happening? My...

I downloaded the extension for msaccess 2007 and the run time version. I am following the instruction from microsoft but I must be missing something because I can start the package process I choose a folder for the pkg. then go next and I select the project to pkg and choose a subfolder I don't...

I have a form with a dropdown box with 5 columbs The dropdownbox returns columb 2. I have another field I want it to be filled with columb 5 of the same record? I was able to set the control source to =[field].Columb(5) in access 97 using a list box an it use to work, I'm drawing a blank on...

I have a contract control number that starts with either AB or TR when it's AB in the "ContractControlNum" field I want the "Contract Status" fields on the form to return 1 and likewise when it's "TR" I want it to return 2. I place the code below in the "On Current" on the form and it only works...

I just created the following: Private Sub ContractControlNum_AfterUpdate() Dim L2result As String L2result = Left(Me![ContractControlNum], 2) If L2result <> "AB" Then 'or L2result <> "TR" Then MsgBox "You must enter either the letters TR or AB in front of the Number." End If End Sub This...

I would like to remove the msaccess splash screen for my project and replace with my own. I also want remove the menu and toolbars and allow only "close" and "compact and repair|". Is there a link where I can follow step by step instructions or if anyone has code to make this work, I would be...

Is this the place for VBA help?