neosam
Last Activity: Dec 30 '08, 06:19 AM
Joined: Mar 13 '08
Location: Bangalore, India
-
Well the int(Now()) command helps. Thanks guys......... -
I still get the same error message. "Cannot find project or library" and the 'date' in the code is highlighted....Leave a comment:
-
But would this not be a query? how do i insert this in the where clause in the code?...Leave a comment:
-
When i tried doing that, the paranthesis () just disappeared. and it ended up being the way it is now. Am unable to change that....Leave a comment:
-
Date queries
Hi,
Sorry to be reopening this thread. but i am still unable to get this solved. The code i have used is
I get an error message saying "Compile Error : Can't find project or library"Code:DoCmd.OpenReport "NameOfTheReport", acViewPreview, , Date - 3
If this is closed out, i can deliver my project. Please help!!!
Thanks
Neo -
Adobe with VBA
Hi there,
I have posted this question in the VB forum also, but i do not get a response. I want to know if data from a .pdf file (Adobe file) can be imported into an excel sheet. if so do i need to have some additional software to be installed apart from what is normally installed in a Windows System. Kindly help me out here.
Thanks
Neo -
Adobe with VBA
Hey,
Is it true that you need a Adobe reader to take data off a pdf file through VBA.
Thanks
Neo -
VBA with Adobe files...
Hi,
I dont really know if this is the right forum for this question. Is it possible to write a code which takes data off a pdf file(Adobe Acrobat file) and puts it in an excel file. Can someone shed some light on this please???
Thanks -
Well NeoPa... there is a table where email ids of people are stored. there is the name in the first column and the email id in the next. and there are some 8 names and ids in the table. What is required is that on form load an email must be sent to everyone whose ids are there in the table. Is it possible to send mails to everyone is my question.......Leave a comment:
-
Thats what i had thought... but when i run it, i get a error message saying "Cant find object or Library" Do I have to reference some particular library for this case??...Leave a comment:
-
When i do that.. the "()" disappears as soon as i move to the next line.... This is what i have been thinking about........Leave a comment:
-
Date queries..
Hi All,
I want Access to open a report where the date is 3 days prior to today. Is this possible? I have written a code something like this :
Do I have to predefine the variable date or is it a system defined variable?Code:DoCmd.OpenReport "ReportName", acViewPreview, , Date - 3
-
Sending mails to ids stored in a table
Hi there,
Its me again with my silly questions. But this thing has been bogging my head for quite some time. I have a form and when it loads a mail is sent with a report to email ids listed in a table. I am able to send it to only the email id in the first field of the table. The code i used is :
...Code:data = DLookup("[Email_Address]", "TableName", "[Email_Address] <> ' '") DoCmd.SendObject -
Yipeeeee.... It works ... thanks...Leave a comment:
-
Hi,
But the filter is not always the same. For example if the user requires data from a particular date, only this data should go to the required person. This is where i meet with a problem. is it possible to save a filtered data and then send it each time?
Thanks...Leave a comment:
-
using the where command along with a DoCmd.SendObject command
Hey all,
I am not able to integrate these 2 actions in one command. What i am doing is...
A button which sends a report with only specific data to a particular person (via outlook). I am able to filter the records using the where comand and i am able to send using the DoCmd.SendObjec t command. but only seperately. Is it possible to insert the where command in the DoCmd.SendObjec t syntax??
Thanks -
Hi Puppydogbuddy
Thats awesome.. thanks......Leave a comment:
-
Hi.
I am not really sure if that is a HTML or ASP page. Could you tell me what is the sureshot way of finding that out.
Thanks...Leave a comment:
-
Dude,
You are a life saver.........Leave a comment:
-
Adding fiilters in reports.
Hi,
This is wierd.... I had given filters to a report and when a cmd button is clicked, the filtered report (Data having a particular date) is opened. This worked fine yesterday. but today it is not filtering the data in the report... Could someone tell me i have edited the coding by mistake?
Code:DoCmd.OpenReport "ReportName", acViewPreview, , "Date >= From_Date" & "< To_Date"
No activity results to display
Leave a comment: