Search results

I am still trying to find a way to use code to send email through access of reports. I would like to have the ability to send more that one email to several addresses.

I have been looking for a way may date field to increase the date with each new record. Example for the first record the date field has the date of 01-jun-08 so when a new record is created the date will change to 08-jun-08 or vbSunday or +7. This is for secheduling purposes. Any...

How can I have a number field behave like the auto number function? I saw somewhere that through code you could have the number field increase each record by 1. Any ideas?

I am have trouble eliminating the $0.00 balances in a query. From what I can figure out is that even though the Balance appears as $0.00 in reality it could be anywhere from $0.0012 to $0.009 or something like that. What I am trying to do re reconcile the Balance field. If the balance reads...

How would I go about retrieving data from one table into another? One Table "A" has three fields "Subject#", "Subject" and " "Date" Another table "B" has a form attached that is used in scheduling these subjects with the same three fields mentioned above. (plus other fields that need not be...

How can I stop agents from leaving a database open after they have finished there days work. I maintain and modify a database from home, but some agents forget to close the database at the end of the day. That prevents me from doing any modification on the database. Maybe a simple message...

How can I filter a simple check box. I have several check boxs e.g. "Male", "Female", "Married" and "Single" Depending on the information the entry could have Male check. the next field could be Single which would be checked. What we would like to do is have a "Button" for each of the 4...

Is there any way the you can use Code to cause a form to do page up and page down. I have a Long form that some of the information that is at the bottom of the form is out of view and only use by certain people. How can I have a botton on click go page down to the bottom and another button...

Is there any way to turn a tab sequence on and off. I need to keep serveral controls out of the normal tab order from most of the agents. Only a few agents have a need to enter data in these fields. Perhaps a double click in the control could turn on the tab order for these seperate...

I have a field called "TimeStamp" What I would like is that if someone modifiys or make any change in the form that the "TimeStamp" will record the time and date of change. How can this be achieved? sandrao

I have a small form that I use to create a report every month. Some of the information in those field carries on every month but other fields change each month. How can I have just certain field cleared of the information without deleating the entire record? Can a query update a field with...

I have created a cbo box that I am using to selects locations (citys) in a field. I have used "Distinct" to elimate the duplicates but I also want to elimate three locations. They are Verdun, Lasalle, and Montreal. In my query I have tried the following statement in the Critera location...

I have a problem. all my Access 2007 have be Endoded. Now the password is missing. HOw can I Decode of delete the password on all my Databases? Sandrao

I read that the Tag property can be used to store a records value and upon moving to the next new record fill in the forms control with the value stored in that tab property. How would I go about this? Can anyone give me an example on how to use it and what can be stored and how to retreive...

I have a small db that I will be having three groups accessing it. I want to restrict each groups access to one or all forms. I would like to have a simple password form to do this. Can this "If" statement used for three different passwords and three different forms? Private Sub...

I have a form in which I am scheduling speakers it called “Speaker Assignments” I am trying to use DLookup to retrieve information from a Table called “SpeakerInfo” I have created a unbound text box called “txtSelectSpeaker”. What I want to do is enter the last name of the speaker in the...