Search results for query: *

To anyone who can help, I have a query that I need to create. In a table I got a list of records that shows the employee along with the points that they earned for a specific task. Here is my problem. Only the points earned in the last 12 months are valid. So I created a query that lists all...

Here's what I'm trying to do. You know how when your bank sends you an e-mail reminder every time your bill is about to be due? I want to do the same in Access but I'm not sure if this is possible. I'm assuming it may be possible if you keep the database running all the time so it knows when it...

In VB I'm trying to reference fields in my subreport but for some reason it will not recognize this reference. Here's the reference I wrote: Reports!MainReport!SubReport.Report!Field1.Visible = False When runinng this script I get the following error: Run time error '2455': You entered an...

To anyone who can help, I have a combo box that populates names based on the department. One thing I want the combo box to do is to select the first person in that list when the form opens. Instead it shows blank until you select a person. Is there a way to do this? I know you can do it in a...

To anyone who can help, I'm using Access to send an e-mail out after they hit a button. My e-mail client is Lotus Notes. I'm trying to add a hyperlink into the body of the e-mail so that the recipient can easily go to a specific file. I have looked everywhere but can't seem to figure it out. I...

To anyone who can help, How do you add a hyperlink in a message that you send out in Access (vbscript)? After sending a message out to a specific person, i want to include a link in that message so that the recipient can click on it to open the database. I prefer not to use html. I also have...

To anyone who can help, I have a multiselect listbox that lists all the names you can send an e-mail to. Some of these names need to be already highlighted when the form is opened to ensure they are included. What is the code I can use to accomplish this? Thanks for the help. Tan

To anyone who can help, I am building a data entry form that will store comments made by our employees. Comments are submitted on a paper card and then we have a data entry person put this cards into our database. On these cards, however, the employee has the option to put down their name or...

To anyone who can help, I have a mainform that contains employee information and in that form I have a continuous subform with employee points information. I've added a delete button in the subform, that shows up on each row since it is continuous. I've used a generic delete button that was...

To anyone who can help, I've recently created an e-mail function that selects e-mail addresses off of a listbox where users select all the people they want to send the e-mail to. Everything seems to work fine except when the user selects too many people. All of a sudden the rest of the e-mail...

To anyone who can help or he has the same issue, At work we use lotus notes. I created an access database that will send data from the database to anyone while your lotus notes is running. I got the code to send out e-mails using notes from another thread and everything works fine. The only...

To anyone who can help, I created a table of a list of people who you potentially want to send some information to. I'm really new to VBA but I think I need to use it to get this done. What I want to do is when a user clicks on send a form pops up that list all these people you could send it...

To anyone that can help, I have created an employee database. I have two forms. When a user opens the database he/she will see the first form which lists all the employees in a listbox (EmployeeList). The user can add a new employee by clicking on a button which will open the second form. The...

I'm having problems with using a Do Loop in VBA for Access. I'm really new to making sql statements in VBA but my application made me use it since it needs to be dynamic. However, since I'm so new I do not know what I'm doing wrong or if I'm even on the right track. What I am trying to do is...

To anyone who can help, I am creating an employee list database. For this database i want to list employees for each supervisor. Employees each belong to a department. Departments belong to supervisors. Some supervisors have control over several departments. Also, some supervisors share the...

To anyone who can help! Our company recently switched to Lotus Notes. I'm having problems in Access to use Notes to send out e-mails. When I use the DoCmd.SendObject function it opens Lotus Notes if it's running and automatically creates a new e-mail with field automatically populated the way I...

I am clueless why this error is occurring when running my query. It worked when I first created it, but now it won't do anything. This is what I did: I created a Query ("DeptList") that narrows down the search based on a date range inputted on a form. This one works fine. Then I created a...

To whomever can help me, I am building a work calendar and want to block out the holidays. I created a ListHoliday Table, in which I have listed all holidays for the year in the column called HOLIDAY. Now in my calendar I want that day blocked out (invisible). However, in my Do Loop somehow...

To anyone who can help, I'm trying to put a vacation tracking database together. In it I will have a list of employees. This is what I want it to do: When manager opens employee a continuous form opens where in the first column there is a list of dates for the whole year. In the second column...

To anyone who can help, In access when you click on the close button in the top right corner the database will immediately close. Is there a way to make sure a warning message pops up when you click on this, or when you use File->Exit? This is to prevent someone from accidentally closing the...