Search results

Can you help me out with a pivot chart in vba? I have a list of products in a list box that may change and I want to show only the selected products in the pivot chart.

Bill, Thank you thank you thank you! I have two more problems but it works! I have been dealing with this for too long and I was over complicating every part. Here is the code I came up with: Private Function AutoSetUpPackage(ByRef connection As ADODB.connection, _ ByRef RecordSet As...

Bill thank you so much for your reponse!!!! Ok I never thought of doing it starting from the total amount and count down. So should I be using an array variable? Just to let you know I might ask some foolish questions out of being extremely tired and I'm an idiot. So Before doing any sql to...

I have an access database that takes orders and then when it is approved would take every item on the order and create a record in a shipment table based on availablity and then create any number of packages with and number of items in that package. In my product table I have a field that is how...

So thinking about this. I think I'm going to use a select distinct SQL statment to get all the vendorIds in a list. then loop thur that list by pulling all Order details under that order AND that vendor ID then create the PO that way. I would still like some input if that is not the best way...

I'm not sure how to phrase my question but I'll give it my best shot. I have an order table with a details table. At some point a user must assign a vendor to each order detail in order to send out Purchase orders. I was thinking of using SQL insert statments to create the purchase order in...

I have a few days to fix this problem. I do appreciate that you respond to me so quickly to my posts.

ok I was using quick reply. Here is the database. David thank you for taking the time to help me out.

Hi David, I am not sure of the file types. They are all pictures that display in a picture box on a form in the database. Access is saving them without a file extension. I double checked to make sure that I am viewing file extension and I am set up that way. I have no idea how they were added...

David, So I used this code and your blob module. Dim rs As New ADODB.Recordset rs.Open "SELECT productID, picture FROM products WHERE productID = 5", CurrentProject.Connection If Not rs.EOF Then BlobToFile rs("picture"), rs("productID")...

David, Wow. It was a bit overload for me but I think this was the code I was looking for to put into my database: <code> Dim rs As New ADODB.Recordset With MasterDbConn rs.Open "SELECT * FROM TblEmbeddedObjects WHERE fldDocumentName ='" & Me.LstEmbedded & "'"...

Hello, I am currently working on a database that I did not create. It has 4000 records all with a field for a ole object where a picture is stored in the database. Since this is making the database 500mb I need to change it. How do I make this change. I would create a text field in the table...

I hate to beat a dead horse but wanted to add this just in case someone else reads this. If you have to move data over from access to excel using someone else's parameters then do not use a template. It's a huge pain in the ass and you should just figure out the formatting on your own and code...

I am using this in Access. Unfortunately I cannot post the file. I wish I could but my employer will not allow it. The use is I hit a button and it exports a table to an excel spreadsheet. I have another one that exports it then inserts it into an email. I wrote this a while back and now...

Thanks bob but same error happened. I've never read that a method could be called that way. Weird that they allow different ways to call them. Do you have another ideas? "Variable or with block not set" is the actual description.

David- Thanks for your reply. What should I google to create an excel template and export the data to the template? Do you have a quick link. I could get it to do it as a single function but did want to learn why my code was not working. I thought because I had no programmed in vba for some...

The first method goes thru ok. It does raise an error but completes it's job. The second method to change the size of the columns does not run. I guess I can stop error trapping and let it pass thru. But I would like to find out what is wrong. The first line of the method to merge cells throws...

ok got different error. Object doesn't support this method or property.

Ok no problem with the fixing of my post it has been a while since I posted on here

sorry I though I posted it.