Search results

Thats for the above. By the way, since the original thread, ive removed the combo box for something simpler. Now the email macro just needs to refer to the field [text43] which is a text box on a form which prefills with a valid email address. However when i put this in the send object macro...

I currently have one report (they will expand dramatically when i get this figured out) which i want to email to an individual in snapshot format. Now, ive used macros in the past to do this and im fully aware of the popup which shows up asking you for permission to send the email via...

Worked an absoloute treat, thank you for your help!

Hello all, I have a tabbed form with multiple option groups. Each of the options stores a number corresponding to the option selected. Its important to note here that not all of the tabs store the same numbers to mean the same things e.g. my first tab has option groups with only acceptable...

Sorry Doctor B, a little confused. Will this still be able to pick up and use email addresses stored in a database table? Or will it still require me to make a macro for each of the email addresses? In essence, i want to have a form which allows you to select an individual, press go and then...

Is it possible for me to have a table of email addresses and then have a macro use that list to simply fire out emails to all of the listed emails? I currently have a macro for each email address. As you can imagine, its not helpful.

Hi all, I have a table which contains renewal information. This is basically a long list of client names, company name, amount they recieved and date they recieved the money. I have a query which pulls this out of the renewal table and i have based my report on this query. My problem...

Hi all, I have numerous macros which have the 'sendobject' function. they are sending snapshots of a report to individuals and then also cc'ing the report to another person. This all works tickedy boo. However, when you run the macro, it uses Outlook to send them. And you get the message...

Hi all, Is it possible to sub text boxes on a form? Basically, i have a purchase orders form and the sub total of each item is displayed at the end of the row. Obviously this is the item price X the quantity. However, i have a grand total text box as well which needs to be populated. Ive...

As an extra, im trying to work out how to requery a subform on the 'on click' event of a command button. The command button is located on the main form "AssignedItems" and the sub form to that is called "AssignedItemsByUserSub" Ive tried some VB but i am poor at it at best. I have also...

Thanks for the help Trevor and VB, I worked out that the issue was primarily through the table links. Once i rectified them, the script worked perfectly. I have gone with vbNullString only because i saw that suggested somewhere else as well. Again, thanks for both your help.

Sorry, What was different about that code to the ones above it? Or am i just being stupid?

Thanks for thsi Trevor. However, when i run it i get the following message: "You tried to assign the null value to a variable that is not a variant data type" Any suggestions? Ive googled the error and come up with mumbo jumbo. Thanks!

Is it possible, on the click of a button, to clear the contents of a particular cell(s) in a table? I have a data entry form. On the click of a button i want to be able to purge all of the information in the underlying table except the clients ID and Name etc. I dont want the whole record...

Doc, I have followed exactly what you said and it all makes perfect sense. I have users list being updated with the selected items id through combo boxes as you suggested. This works perfectly. However, i am a little lost as to how to assign the UserID (primary key in the user table and...

Thank you for all of the above Doc. Youre a lifesaver.

Hi guys, I am currently looking to build a IT iventory for the company i work for. I have built a few other DB which are now working fine. However, i have come across an issue with this one which i need fixing. I will have a main form which will list the User Details. Each of the users will...

VB You have no idea how much of a genius you are. Works like a charm, as does everytime you help. THANK YOU! :D

Hi all, Quick one i hope. I have a text box in my report which provides a percentage figure of two other text boxes. The text box control is set to this: =[text77]/[text88] Also, the format is set to percentage. This all works amazingly if there is data. However, if there is none it...

Can someone suggest a way to do this? I have a form which has a combo box in the form header. Bascially i want to be able to select a record from the combo box (in this case a book ref no) and when selected it will show all client who are in that particul;ar book. The clients come from a...