Search results

Ok ive got a criteria on a surname which is based on the value from an unbound text box. Currently in the query the criteria is: Like "[forms]![frmalpha]![letter].[text]*" Which would return all fields starting with the value of letter. This returns nothing. If I close the form the query...

Hi, Ive been trying to find out a method to validate an email field. I basically want something to check whether there is a . and an @ in the field. Can this be done at table level or shall I do it on the form , and how can I do it!! Thanks alot, ian.

Hi, I Have two fields, title and surname, and would like to combine them to make a letter address field which takes the below format: Dear [title] [surname] This would be simple except some of my records already have this data entered in a letter address field. So I want this code to run on...

Hi, Ive got a form with a few buttons on it, for example one runs a report based on the information in the form. I would like some code that when the key field of the form is null and trhe button is pressed then a message box is opened saying something like "This option cannot be run without...

Hello, Ive got a problem with an active x calendar. (running access 97) I want a query to run with the criteria of the value of the calendar, which is in a form. Ive tried the following criteria on the date field: [forms]![calender]![ActiveXCtl10.value] and [forms]![calender]![ActiveXCtl10]...

i need to make my database available to 3 users, all of which have interent access. I dont't really want to deleve into asp, is there any there alternatives. Can I split the data out of the database, and make access connect to that? Or is there anyway that the users could upload the database...

hello, Im no coder but Ive got to do a access project. Heres my problem. I have a contact management database. A form is used with contact details. I have a button on that form which opens a second form containing call details. I would like the second form to open showing the calls which...