Recent content by newby2VBA

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

You are amazing thanks;)

This is really helpful.I want to show the selection on the main form so I was wondering if you know how I can retrieve from the tblOtherTable the selections made and show it back on the main form in one field, unbound obviously. Or if there is a better way I'm open to suggestions.Thanks for the...

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 figured it out :)

This input mask was my problem: 0000\-00\-00;0;_ off to the races again , Thanks ;)

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

This is my problem I should of explained better... What it returns is what I want to display as a msg if the user does not enter the email address correctly, otherwise it will return nothing which is perfect since it meet the criteria I want.

The Function returns a string Msg, not a true or false so were does that leave me?

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 was thinking of using case statement with select queries for the recordset wondering if there is examples out there I can look at. I see this problem like an inventory system when decrementing your form it would show available items on hand.

That's not helpful. My tables are normalized.

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 fixed it by not importing the linked tables when migrating to 2007 and linking afterwards all is normal now. Must be a bug in msaccess. Thanks for your time!

I recreated the front end and the same is happening I am confused