Recent content by stupiet

Initially I wanted to avoid using VB, but after using your code it works like a charm. Thanks for the tip!

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

Thanks Remou, for the detailed help. I'm going to try it out and see how it works. This should work exactly as I would want it.

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

You are right! I guess it does not know the field exists yet when you use it in the Open Event. Appreciate the help!

It won't even work if it is used as follows: Private Sub Report_Open(cancel As Integer) Reports!MainReportName!SubReportName.Report!Field1.Visible = False End Sub

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

Thanks Paul & Alan, Alan, I tried your first method and it works great.

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

Thanks PH! Works like a charm. Learnt something new thanks to you guys again...

Thanks Remou and PHV! The selection works great. However, I ran into another problem after I ran this. My listbox is set up with 3 columns. The bound column has the e-mail address, the 2nd column the name and the third column has their job title. I wanted to make the pre-selection criteria be...

I did think of doing it that way, but there will be times where the user would want to exclude some of the pre-selected people. Especially if they send it out a second time etc.

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