ok, i have been searching on google and the forums for sending forms/reports as outlook atachments.
all the examples i have seen are more complicated than my one.. i have one form.. and i just want to email those details.. in the form are the fields, one textbox where you put the email address, and one send email form button..
i got it working using a long module, that i didnt understand..and then i was told about the DoCmd.SendObject method which looks a lot easier..
i have one request, in the simple database i have uploaded, will someone show me where to put the code.. the db is VERY simple, and quick (one form with a send email button).. and if anyone can spare a few minutes to get this one working i will be very grateful..
I am making a form that has been set up to have a number of tabs so I can have more then 1 page on the form.
One of the tab pages is used as a search form.There is a couple of textboxes and a listbox where the results end up What I am trying to do is have a double click set up on the listbox so I can double click the result I want and have the forms ID goto that record.
Its a bound form. The primary key is called PersonalID and its bound to a txtbox called txtPersonalID.
this is my code but its not working
Private Sub lstSearchResults_DblClick(Cancel As Integer)
Dim strPersonalID As String strPersonalID = Me.lstSearchResults.Column(0) DoCmd.GoToRecord acActiveDataObject, "PersonalID", acGoTo, strPersonalID DoCmd.GoToControl "pgePersonalInformation"
End Sub
When I try run the code I get an error 2489. saying The object 'PersonalID' isn't open.
Hi I posted a thread in the tables section but two things have made me decide to try again. 1) No one answered my Question 2) I Asked my question in a way that was VERY confusing.
So I'm trying again here. I have a DB that will be used for invoicing clients. Some of the data is variable between jobs, clients & vice versa. Some of the data is recurring.
I have several tables that I need to link. They hold information that is labourious to enter over & over in a spreadsheet so I thought a database would be the answer.
One table is called tbl_Consumables This table has data which varies from time to time but not all data is changed (IE the price of an item may change from month to month. This presents a problem because if I use a table to store the consumables data & the table is linked to an invoice via the ConsumablesID field I can't change any of the consumables data without changing past invoices that should show the old price not the new price.
Basically I can get my head around how the basic design should be set up. I have two main problems. A) Trying to link a days work to an invoice & be able to change data in the future without affecting past invoices and, B) I don't know how to set up the relationships & tables so info is linked.
I have a copy of the DB here. The tables are only minimal fields & data at the moment as I don't want to go to all the trouble of setting this up & then having to change everything.
Is there a way to tie a send object to a combo box on a form? I know I can write a query to pull information from a selection in a combo box using the [form][formname]thing. What I'm trying to do is I've created a database that allows many users to enter a request in a form. then when the form is complete they need to E-mail the form to their respective manager. I want them to choose from a combo box, then click on a button and the form is e-mailed to their manager for approval. I've gotten everything else to work accept for being able to choose the manager. I know I could also leave that blank and it will ask for them to enter the recipients name. If that's my only option I'm ok with that.
Thanks
PS If this issue has already been addressed I couldn't find it.
i have a form, every post on this form is connected to a deliverer in a table, every deliverer has a faxnr. I want to be able to push a button on a form and it will fax the form to that deliverer, how woud this be done? Ive checked that microsoft page about send object and stuff but i dont get much and it doesnt seem to be what i want to do. Is this thing even possible in access?
When i try a sendobject command, i get "coudnt start the mail software, check that the software works" translated from swedish.@@1@@1
I used sendobject to send the object via Lotus Notes, but I want to skip to click the Send button from the Lotus Notes, everytime, when I sent, it goes to the Lotus Notes, then I need to click the send button again on the Lotus Notes for confirmation to send the mail. How can I skip it?
Hoping someone can help - need to know if there is a way to use a Outlook message other than the blank one that is used with the send object macro.
Maybe a normal message with a signature, template or something - when the macro is run, no formatting is included with the e-mail message, and the body of the message is limited to 255 charaacters.
Would like to use a customized message, and I need the send object macro to place the object in that message format.
If anyone can help, I would greatly appreciate it...thanks.
I am using a command button to email an invoice to a customer using the sendobject function, whilst this almost works correctly it is adding an additional mailto:address along with the correct email address.
Example: CorrectEmailAddress and then#mailto:CorrectEmailAddress
The code I am using is:
On Error Resume Next Dim Cusemail As String Cusemail = Nz(DLookup("Email", "invoiceemailQ", "orderID=" & OrderID), "") If Cusemail = "" Then MsgBox "No email Address" Exit Sub
Im new to access and i have a problem!! I have a report that i need to be sent out monthly to 3 people. The problem is i dont know where to start. I have been looking through the forum, but nothing that i can get my head around, so there anyone out there who can help???????
I have a query that runs based on a parameter a user selects on a form.
I want to dynamically create the sendobject file name based on the parameter the user selects.
Example:
My form has a parameter named medicine. When the user checks the checkbox next to medicine it runs a query for records labeled as medicine but sends the e-mail output as the query name. I want something like medicine.txt etcc...
When I attempt to create a new DB - by performing Blank Database I immediately get a message 'Object Library not registered'.
If I 'OK' that box and try to create a table, I can do so - create Table in design view.
When I then try to Import external data - an excel file I get the message 'ActiveX component Can't create object'.
I have looked ob various sites for help and forum information regarding these errors but have found nothing conclusive, with specidfic regard to Access 2003.
The version has been loaded on my machine about 1 year as part pf Office Professional but this is the first time I have attempted to run Access itself.
Does any forum member have any ideas as to how this problem could be resolved.
I am currently building a database for the company I work for that is fairly similar to the Northwind Database; however it is made from scratch so hopefully some of the common problems with that database won't find their way into mine.My problem is that when I go to my Orders form, I pick a customer from the main form, which creates a record on the Orders table. When I then go to the subform to choose a product/line item, I get the error in my title ("The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'OrdersT.") as soon as a product is chosen from the drop down list.
I'm getting an error message (informational only):
The object doesn't contain the automation object 'ClientID.'You tried to run a visual basic procedure to set a property or method for an object. However, the component doesn't make the property or method available for Automation operations.
Check the components documentation for information on the properties and methods it makes available for automation operations. This happens when I start entering data in the field "productname" of a subform.
So I'm assuming something in the form or in the code of the form is referring to ClientID. but I've checked it, and there is nothing referring to it anymore. Well, at least as far as I'm aware of.
This afternoon access crashed without any error, it just closed. Upon reopening the DB again, all my work of the past one and a half week was gone. Normally I always backup the data, but these past days I didn't due to christmas and still working a lot too. So I forgot.
I did some redesigning in the process this evening, deleting and adding some fields and code.
I can't get rid of this error. Can anyone help? Or point me in the right direction?
Also the DB is 3.5MB in size. While it is completely empty. And I can't imagine that some empty tables, queries, forms and a bit of code can be so much. But that's for a later time to worry about I guess, unless one of you says: this and that, maybe that works... Otherwise, I would really be very glad already if the error disappears....
I am creating an form in a database and whenever one of my procedure's run it creates this error message:
The expression ON Load you entered as the event property setting produced the following error: Member already exists in an object module from which this object module derives.
*The expression may not result in the name of a macro, the name of a user-defined function, or [event Procedure]. *There may have been an error evaluating the function, event, or macro.
I am trying to develop a page where users can click on alphabets to look for a company name that starts with the selected letter. Searching through the forums i came across the method of using DoCmd.
alpha = Request.QueryString("alp") if alpha <> "" then DoCmd.ApplyFilter "", "[com_name] Like ""[" & alpha & "]*""" end if
The 'alpha' variable here holds the alphabet selected by user from another page. However, I'm getting an error message saying
Microsoft VBScript runtime (0x800A01F4) Variable is undefined: 'DoCmd'
Initially i tried the usual filtering
if alpha <> "" then rs.Filter = "com_name LIKE " & alpha end if
The pages are suppose to display records in 10s. But instead of showing only the records of company starting "A" (example) it shows everything.
Please kindly point me to the correct direction to solve this problem.
Can someone tell me the difference between 'Call' and 'DoCmd' and how each are executed. For my level of programming, an newbie at that, I've used it interchangably so far without a problem. But I'm beginning to think that there is a difference. I don't want to later have to go back to redo my code down the line. I'm beginning to think that I've been very lucky so far in being able to use it interchangebly and my luck will run out soon.:eek:
I need to execute an append query from my vba code but I have to pass in a parameter. I can't set the parameter equal to a form control. I have to actually pass in a value. I don't want to use a querydef because I don't have any result sets.