Recent content by philbennison

There is no 'save as report' in my toolbar, This is excel, should there be one ???

how do i use a report sorry, i have never used a report, is it easy to change the details in a form to a report ?? Thanks in advance

Hi all, I have an excel spreadsheet, when a macro is run it opens a form and produces a list of random items. When a command button is pressed, it prints out the form The problem is that it prints in potrait. How do i get it to print in landscape every time ?? I read on this forum that you go...

Hi all, A nice easy one for you. I am creating a database, one of the fields is total cost. Is there an easy way to have another field, which calculates the VAT without using a query? I would like this done as soon as the total is entered. I have done this using a query, but didnt like this...

unable to do either Thanks for the input, however 1) because i am behind a network connection, my profile is refreshed whenever i boot up and this wipes the startup folder 2)I have already got a shortup icon on my desktop, however i was trying to automate things and wonder whether i could...

Hi all, I have created a report that i would like to appear when my PC boots up, unfortunately i am in a network scenario and cannot put things in the startup folder. I do however open outlook every morning. Can i put some code into outlook to open the report automatically Any ideas ?? Phil

the answer I have collated the infomation from various websites and forums, and place it here for future questions. Sub FileSaveAs() 'this can be changed to sub filesave() Dim mydocname Dim mydocdate Dim both With Dialogs(wdDialogFileSaveAs) mydocname...

Where do i get it from Any ideas where i would get this from ? i have check the ms website

hi all, I am trying to make a simple program to keep check of my direct debits, and cash in and out. i would like it to automatically put in direct debits when the date is due. but with out changing the date every month i am not sure how this is done. I also need to have the balance field...

Hi all, (I know this is an access forum, but would the VB script be the same ?) I have created a word template, which has text form fields in it, and a date field. Is there a bit of code that will save the template with the file name as defined in the field The fields are date, number, ref...

Hi all. I have a simple program that will email a report to a specific person when a button is pressed. Is there a way to display a message box with text on it (and an 'ok' button to clear the box) when the email is sent. i am sure it must be an easy command. My code is below Private Sub...

thanks for that, however the problem seems to be with the line strEmail = Me.email i have now substituted for strEmail = Forms!main_form!email Which seems to work Thanks for the help

i have recently created a database, there are 4 tables all linked. everything was working fine. i have two combo lists which were referenced to two other tables. these were entered as value lists. i then changed these to refer directly to the table. since then my email doesnt work. I have taken...

sorry let me clarify SJ McAbney Sorry, as you correctly guessed, i am trying to send a graphical representation of the 'printable form'. Is there a was or creating a query of the current record, and then sending a report based on that query. Also when i send the form, it sends all the data...

Can anyone tell me what i am doing wrong ?? I am trying to send the current 'printable form' to email recipent Thanks in advance Phil Private Sub Command91_Click() On Error GoTo Err_Command91_Click Dim strEmail As String strEmail = Me.email DoCmd.SendObject...