Search results

Great! Now all I have to do is figure out how to actually do these things. Oh well, looks like up for another learning experience :)

Ok, lets see if I understand the process correctly: First, I click on an item in the combobox on my "Order Check" Form. This sends all items with similar suppliers to a premade table. A form pops up that is based on this table where I can change the records as I need. Then the updated...

That sounds like a much more efficient way of doing it. I've never used Apend queries before though. Do I create them in code? or use a wizard and save it? Also, do I use the CreateTableDef Method to make the temporary table. I'm not too experienced with these particular things, so thanks for...

Hi everyone, I'm having trouble with the AddNew record method. Access help only has examples of code for user input and I can't seem to find specifically what I'm looking for in the archives. I have a combobox on a form that is linked to a query that checks for low product inventory...

Ok, I tried To create 2 subreports of the same report only with one showing the last week, and the other showing two weeks ago. The problem I have now is connecting the two reports. I need to add a text box on the subreport that I want to be visible to show just the efficiency of the that line...

AH! Hey you're right! I just flipped the code and now it works fine. Lol, I guess I couldn't see the forest through the trees. Thanks for your help everyone! You guys are the best :)

Thanks! Actually, the way I have it set up now is with that link to the Snapshot Viewer dowload. This is causing problems though, because some people still can't get it to work even after the download. Some people even refuse to download it because they are afraid of virus's. I don't have...

Just to be sure, I went back and cut/pasted it. I updated my code once again but it still won't work. I know we'll get to the bottom of this but I wonder what could be wrong? When the debugger comes on, it automatically highlights the DB.Execute stSQL "Dueorders" is the name of the query...

Hello, I was wondering if it's possible to send more than one file format to an email with the sendObject method. I'm tring to include acFormatSNP and acFormatRTF all on the same email as two different attachments. That way if someone can't open the SNP formatted file, the RTF should still...

Sorry, I've been out for a few days with bronchitis. I hope your not getting tired of me Travis but the code still doesnt work. It's the same Syntax error in where clause message. I'm hoping that this is a small mistake on my part and easily fixable. Thanks for your help, Ben PS, I updated my...

I wish someone would answer this, Im having exactly the same problem. Is there anyway of keeping the lines and pictures when converting to RTF?

So close! I tried putting in just what you wrote, but it says there's a syntax error with the Where clause. Do you have any ideas? Here's what was giving me the error stSQL = "Update [dueOrders]set[Inquerysent?]= #" & Date & "# where" & stWhere

That works fairly well Travis, thank you. There is still one problem though. I only want it to update those particular records that are sent to the report. Right now, its updating all the records that are on the form's query. Maybe I messed up on the syntax of something. Ive update my Code...

Hi Everyone, I'm stuck again on an ordering system that I'm trying to develop. I'll expalin my situation and hopefully one of you brilliant, wonderful people can help me :) I have a combobox, "TheList", that is connected to the query "DueOrders" on my "Order Check" form . It basically shows...

Of course I meant Sub-reports, but i'll give that a try and let you know if it worked. Thanks!

That sounds like a good Idea, but I don't it's possible to get the efficiency from a query. That number is generated by dozens of calculated fields from 5 different sub-forms. I;ve tried duplicating the results in a query but it's just too complicated for one. Could there be any other way of...

Hi everyone, I'm trying to automate a bunch of E-Mails and I can't figure out how to add spaces and formatting in the message text. For example: DoCmd.SendObject acSendReport, "Dueordersreport", acFormatSNP, Email, , , "PO# " & PO, "Hello," & _ "Please review the following...

Hi everyone, I'm having a problem with a new report I'm working on. It's a rather complicated report that has lots of codeing and objects. Anyway, the final product of this report is the average efficiency of the two product lines we had for the previous week. But... I need also need, on the...

I'd definately like to see some samples of that. Thank you Chris. I think what I'll wind up doing is just sending a link of the Snapshot program with my Snapshot file. It's just a pain in the arse. All I can see are 50 little old ladies sitting behind a computer, trying to figure out how...

I'm trying to set up a brand new ordering system that orders products automatically by email. It sounds like a really great idea, (sure to win me some brownie points with my boss), but I can't seem to find an adequate medium for sending orders and follow-ups. I know how to send stuff by email...