Recent content by aguest

Tried that but it didn't work. Found another thread on here though that has helped me to use some other code to send emails. http://www.access-programmers.co.uk/forums/showthread.php?t=61520

Can anyone help me. I've created a number of databases that will send an email to someone on the click of a button. This has been working fine for the past few weeks. Today I am now getting an error telling me the command or action "SendObject" is not available. Nothing has changed on the...

Thank you. No special reason for using a form as a report. I'm new to reports as I've tended to use forms so didn't know the best way of doing it. I now do. :)

I've attached the db. it opens with the report in question (in form format). When I click on open report it opens fine. Then when I print preview it all goes wrong. Thanks for any help as I can't figure it out.

sorry the attachment didn't attach earlier.

Hi, I've got a report, which on the screen is three chrts and a page break in between. Page is set up to print landscape. When I print the report or save to pdf it adds a lot of pages in between 2 and 3. It seems to be of chart no.2 getting smaller and smaller. I've attached a copy of the...

Sorry I hadn't reliased you'd responded when I deleted the message. In the report I just added the following code in each of the text boxes on the header. The report is only opened from the frm so it can be printed. =[Forms]![frm_Braveheart_IndivStudent_LRT]![txtacYear] This seems to have...

hi, I'm not very good with Reports, normally stick to forms but I now need to create a couple in my database. I've got a form with a number of subforms that are charts which update when I select a couple of drop down boxes. I've created a filtered report from this form, showing exactly the...

Thank you so much. Thats worked a treat.

Hi, I've attached a copy of the relevant table with a couple examples on there. When you open the sub form on it's own it refreshes but won't as a subform. All help appreciated.

Hi, I posted this in another thread but realised it might not been seen as the other one said Solved!. I've tried the fix mentioned above but it's not doing it. Acess 2010 doen't seem to like the last line. It gives me an error saying the form name doesn't followin acces object naming rules...

Hi, i'm having the same issue. I've tried the fix mentioned above but it's not doing it. Acess 2010 doen't seem to like the last line. It gives me an error saying the form name doesn't followin acces object naming rules. Help greatly appreciated. Sub update_subform() Dim dbsCurrent As...

I did originally but the user can add more than one record to the new form and I wanted to be able to attach all the records until they close the form to the same ID. Hence the public variable. I've since created it as a subform so have gotten around the actual issue but it would be nice to...

Hi, i've got a private sub that runs when the form loads. I want it to get the id of the record which has opened this new form. The public sub populates the variable but it's Empty going back into my private sub. I'm sure its a simple school boy error but it has me stumped! I want it...

JHB, It across all databases. Would it have anything to do with the fact that access is on the network and not on my local machine?