Search results

Hi GUYS, How's developing going? I'm trying to email a report as an attachment I can send it as a HTML or TF file using : DoCmd.SendObject acReport, strNewRepName, "HTML (*.html)", _ Me.email, , , , , True. But I loose all my table format etc. How can I email a report to look like a table...

HI guys i'm trying to use the following code to export a query to an excel spreadsheet. Problems is I keep getting the following error: "variable uses automation line not supported by visual basic" for the code line: Set objXL = New Excel.Application Why is this, my references are correct...

HI guys.... I want to export a query and create a new table in an external database through code. Anyone have any examples of how to do this it's causing me som grief.. Thanks guys Paul

Hi guys I'm trying to use two criteria for a filter... At the moment I'm using... Me.filter = "selector = -1" Me.FilterOn = True I want it to filter for this and Date is today, how can I use this in code to filter both conditions.. I can do it through a query, but I want this as just of form...

Cheers Pat... The only thing is if I open the form from the Menubar how does the form know that it is being opened from here. I.e. opening from other forms I set a condition on the click event of the control, but setting the event from the Menu bar is slightly different isn't it... Cheers Paul

Thanks for the effort j Gonna have another bash in a bit Cheers Paul

Close. I have a variable called strsource which changes the record source depending on where the user opens the form from. I need somehow to set this strsource to the required query name or set the Recordsource property to this I tried me.recordsource = "query1" and strsource = "query1" in...

Hi guys, I'm using a macro to open a form from the tool bar, but I want to set the form recordsource in the macro. I can't quite seem to find where to put this to get it to work... Any ideas Thanks in advance paul

Hi guys I'm using some code to send emails to alist of people. Nut in defining the code below I get the error message.. "Compile error" "User defined type not defined" Why is this ... has it something to do with the references ... if so what because I very unsure about references etc.. Hope...

Hi guys... I can't quite get my filters of filters correct i have a query which filters a table to the first level , I then want to use a form filter to the next filter option which all works ok. But when I want to use my second filter I'm not sure how to use the code to tell access to apply...

Cheers for that Chris, I want to give the user the opportunity to save to excel should they want to, so that they can keep an external record which can be used for other analysis options. Thanks Paul

Hi guys.... I have a continuous form with lists of companies. I want the ability to filter the form firstly by company name and then by area code. My method of filtering filters the form but from the original data i.e. it only filters from the original table data and not from the first group of...

err that should be "know"

Thanks Charity..... Worked ACE! Do you no how you do the same thing but filternig by the selected value of a combo box? Thanks again... PAUL

Hi guys, Sounds simple but I want a command button to order the form data displayed by date or name or whatever... Do i need to use code behind the button to change the underlying query or can I do it on the form itself... I'm not sure what to use to do this on the form any ideas.. cheers paul

Hi guys, Is there a quick way to email the content of a query as part of the text of an email, or would it have to be part of an attachment. Any ideas... paul

OK, What I mean is that I have a table which has a list of parameter values eg. record 1 is A, record 2 is B, record 3 is C. What I need to do is a condition to return true if a text box on my form matches any entry within the parameter table. does this help shacket? cheers

Is this fundamentally wrong... I have a form which is basically a diary. Based on a table of entries. I have controls to show all appointments, today's, tomorrow's, yesterday's etc... My filter works fine for if control is clicked filter is Date(), but how do I get the filter to display...

Hi Guys, I'm trying to check conditions using code ie. If x=1 or x=2 or x=3 then ... perform event. I want to be able to do this with the criteria being the entries in a table. i.e. If x is listed in table y then perform event. I can't quite manage to get this right and I'm not sure of the...

hi guys Question: I use a combo box to display names and addresses of companies (list is 5 columns wide). The combo box updates a field on the after update event. I want this combo to update more than one field after the update event ie name and address. How do you get a combo box two update...