Search results

Tried it. Still the same. At least I've learned a little about coding though :)

D'oh I see what you mean. I could use .To .subject etc. I'll try!

I'm not sure I understand the question, which is no doubt part of the problem, because I don't fully understand this whole thing, having copied it from another thread and adjusted it as best I can. I assumed the With / End with means that the statement between them refer to the same thing...

Hi, I've used other threads here to learn how to create Outlook emails and the following is almost working. The "button" is actually an image (which I forgot to rename!) on the detail section of a continuous view form which displays relevant email addresses against data. When I click it I get...

I think you need =Sum([LineTotal]) or whatever your total is called

Hi, Create a query using the "wizard" to begin with. It will ask you which table you want and then which fields. You will probably want to have "detailed" view rather than "summary" at this stage. When the query is created, consider that a "first draft" and go into design view (button with a...

Hi, I have (1) a crosstab query which takes a parameter from a form dropdown, (2) a make-table query based on query 1, which puts the results into a simple table and (3) a report based on the table When I change the selection in the dropdown and run the make-table query, I get the standard...

Hi, I just wanted to come back and say thank you. It took a little bit of trial and error but I burned some midnight oil last night and cracked it. Knowing I was taking the right approach helped me persevere. Thanks a lot. Pat

Thanks for your reply. That's pretty much the conclusion I was coming to too, but I'm not really sure what that query would show. Currently there are 12 near-identical queries which calculate the %values for each region, then one master query pulls those togther with a query that lists the...

Hi, I need help to work out how to differentiate to a user things that are null and things that are null but are not supposed to be. I’d better explain! Hundreds of products can be sold in any of 25 categories across 12 regions. For each product and region we have StartDate, EndDate ,Target...

Hi, I've got some code (with help from this forum!) that allows me to select certain categories of staff in my database and add all those email addresses into one message. I've tested this and it's working fine, using both Outlook 2003 (at work) and Outlook 2007 (at home) Now I need to add...

Kiwiman - Thanks so much. I knew there had to be a way to do this. I can see me adding a whole bunch of buttons to the QAT, then minimising the ribbon. Grr...I hate that thing! NickHa - I don't mind admitting I'd be in WAY over my head with most of that. I'm an information/business analyst...

In Excel 2003, you can create a custom button and then assign it to a macro you have created. Can you do this in Excel 2007? I can't seem to find it. I've got about a dozen macros that run from custom buttons and I've tried to set the same thing up on a colleague's machine using Excel 2007...

Hi, I've searched various threads on page numbering problems but have not come across this one. Before I go into too much detail about my report, is there a particular setting I should look at that might be causing my 19-page report to be numbered '1 of 18', '2 of 18'....all the way up to '19...

Hi, I'm not doubting your code! I did try both versions and your subsequent suggestions but they resulted in error messages as reported above. I fully expect these are due to other problems in my database and not your code. On another form I had an error message about DAO-something (which...

Thanks Linq I wasn't sure whether your suggestion was to put two events on one form or if the second one was for the subform, but it gave me enough to go on. This is what I came up with..It's on the OnOpen event of the main form and frm06_Reminders is the subform. I put a transparent button...

I didn't know that requerying was looked on as bad practice, if that's what you're driving at, but Access is something I've just picked up as I've gone along, with loads of help from the good people on this forum and I'm sure I have some awful habits. In this case, there's another subform which...

Ok...no error message this time....but now it simply doesn't work. The subform stays on the first record rather than going to the last one. The foillowing events also fire from this main form. Could any of these be interfering? Private Sub Form_Current() 'Display a big warning to show that...

I tried the first option but got a compile error. Looks like it doesn't like ".Recordset". See attached jpeg. I don't think it's worth trying the second approach, as it uses the same thing? Thanks

Hi, I have a fairly simple form and subform arrangement and the subform could contain hundreds of records for each main record. When I open the form I want the subform, which is in continuous view, to automatically scroll to the bottom record which will be the most recently entered. How do I...