Search results

maybe try making the function public and not private?

change DoCmd.Close acReport, "Overview", acSaveYes to DoCmd.Close acReport, "rpt_LTL Shipments for CS", acSaveYes

also make sure your report name is correct, if your report is named "rpt_LTL Shipments for CS" then you should be fine but if your report is named "LTL Shipments for CS" then you need to make it that. Not what it shows in the VBA editor but what it shows on the designer view.

ok try this Private Sub Command11_Click() DoCmd.OpenReport "rpt_LTL Shipments for CS", acViewPreview PrintToPDF ("rpt_LTL Shipments for CS") 'Dim olLook As Object 'Start MS Outlook 'Dim olNewEmail As Object 'New email in Outlook 'Dim...

copy your code into here so i can see it. Any time you see a sub or a function with parenthesis at the end such as in this example Function PrintToPDF(SrcFile As String) the stuff in parenthesis is called an argument, meaning you have to pass something to it, because the code is...

either way here is a link that may or may not help http://www.access-programmers.co.uk/forums/showthread.php?t=176968

why couldnt a user just highlight selected text on a webpage, then CTRL+C to copy, then CTRL+V to paste into your form?

This is the code i use to save a pdf to desktop. I save mine to here then open up outlook, send email in another code then delete the file back off the desktop. first on my button event DoCmd.OpenReport "Overview", acViewPreview PrintToPDF ("Overview") Dim year As String year =...

thats exactly what i did before. i just always had to remember that if i deleted a customer that i would also have to manually delete jobs etc etc on down the line. I have it working fairly well with relationships however it doesnt cut down on my code as much as i thought it would. it def does...

even though you use external images, they should still show up no matter who uses it, without having to use a zip file. Try it: set a form with an image (on a button, or image control) then open it on another pc, you should still be able to see the image without having the actual image file on...

First, if you have spaces in your field names then you must use brackets around them as shown below. I try to make it a habit of using brackets for all field names regardless. Second, is cboBillingCustomer text or a number?also check the spelling of CustmersExtended, is that supposed to be...

odds are these are built into a dll somewhere and just from scanning the web a little on the the topic i dont think it will be an easy task. Why not download an icon pack from the web (there are literally millions out there) and utilize them. Heck you may be able to find an icon pack replica of...

You will need to put the code under an event such as the on change or on exit event of the text box. Form_frmExpandAssembly.cboAssemblyID.value = Text23.value If your combobox is set to not allow edits or additions and also set to limit to list then if whatever is entered in the textbox...

http://www.access-programmers.co.uk/forums/showthread.php?t=196521 try this

this is def better. As with a lot of things it just takes some understaning. I like to be able to visualize what im coding and with Join SQL i have never been able to lol. Ive attached a screenshot of my relationships for you to look at if you have a spare moment. I have added 2 tables plainly...

Thank you for the detail and the time it took to write it. Thats what ive been looking for. i actually saw that i had the branchid inside the jobsite table and inside the customers table and i removed it last week. It is no longer in jobsites. Tables are linked in this way Branch To...

Actually the INSERT query is the problem of understanding. I know how to make tables related. In fact they are all related in a chain event to each other. What i never understood was how to link back to a table 3 of 4 tables deep. Hence the title of the post " Understanding Relationships and...

still havent really figured it out, but this works. Just not sure if its the proper way to do it. I did try to go into the access query design but it produced this: INSERT INTO Customers ( CustomerName, BranchID ) SELECT Customers.CustomerName, Customers.BranchID FROM Branches INNER JOIN...

i actually didnt see the last link until now. Ill read over it also

i appreciate the link, however Im already aware of common SQL language, just not with appending into 2/3/4/5/6/7 related tables at once. I did read the joins portion and that explains some of the SELECT statements, but again no help with INSERT INTO