Search results

So I went and followed all the links that you provided, but I am not sure this is quite what I am looking for. Let me try to paint my picture a little differently. I have a multi-select box on a form. There are 54 different items on the list. What I would like to have is maybe in a query or...

I am trying to count how many boxes are checked in my multivalue list box. The list box is a lookup from a different table. All I am trying to do is count how many items are picked from the list. I thought that this would be fairly simple, but I am not getting very far. I read somewhere that...

Hello, I can make my macro attach one report to an email, but in the message I want to give them a link to my website. I have a field in my form that is a hyperlink data type with the web address in it, so this is the field I am finding in my macro, however, when it goes into the email the...

Wow, so easy. Thanks

Is there any way to make a small text box appear when you hover over a button with your mouse? For example, i have a button with the "duplicate record" picture on it, but I would like a text box, or anything of the sort, to appear with "Duplicate Record" when I hover over the button. Thanks, AceBK

Wow, thank you all for your responses, it has helped a ton. In regards to the VB project code, I save the front end as an ACCDE file and the code didn't work. When I save the front end as ACCDB file it worked. Any idea why that might be?

The DB is split with their own Front End access.

Well, that worked, on my computer. One of the other users has a message saying that they can't run the VBA code. Says something about deleting the code from my project. Any idea why it would work on my computer, but not this other person's?

Hello, I have done a fair bit of research on the forum in regards to locking specific records. I have tried the If checkbox = true then me.allowedits = false Else me.allowedits = true End If. I have also tried Me.AllowEdits = Switch(Me.Lockrecord, False, True, True) The problems...

It seems to be working, I think what happened was the description of the new item was very similar to another item, I didn't notice it on the list. Thank you all for your help

I am using Access 2010 and I have a number of different tables. One of the tables is a list of parts. I also have a form called order form. In my order form I have a lookup box to lookup different parts. I use a form of the parts list to add new parts, however, when I add a new part to the...

Thank you for your time.

It is working with the macros. Would it be true to say that I could convert my macros to VB code would be the same as just using the VB code, or is converting not a wise idea.

Thanks for the response, I have Access 2010. I found a way to make it work using a Macro, but through my digging, I have noticed that Macros is not the way to go. AceBk

Hello, I have a report called [Banners Order Confirmation]. What I would like to do is with a click of a button, export the report as a pdf to a specified drive and folder and save it with a name by combining 2 fields from the report. Also, I would like to email this report to an email address...