Search results

Bob, Thank you for the reply. I haven't thought of this one and will give it a try. I was mainly concerned on the specs of the export rather than the import and I was barking at the wrong tree I guess. :D One a side note, does this confirm that Access really converts the -1 yes/no value a 1...

Hi Everyone, I have been trying determine why whenever I export and yes/no field from an Access 2003 db to a csv file, all the -1 (True) values are being converted to 1. Is this really the way Access handles this data type? because whenever I try to import it back, I then experience and...

Guys, I need to find a way to convert results of a single column query to headers of a table. Here's a gist of the situation: I am doing a database for Freight Rates but the fields and number of fields vary upon each lane. Now I need to find a way to pull information out of different tables...

Hi Everyone, Been a while since I last posted a question here but now I really need somebody's help. I've got two different queries and I want to export them into a single file. I know I've got two options which are OutputTo and TransferSpreadsheet but here's my dilemma. 1. When I use...

Hi Everyone, I'm stuck in coding a database that creates an excel file with a pivot table. I am able to create the Excel object, export the data to it, perform some minor formating, add a new sheet to put the pivot table in.. However, when I open the created spreadsheet, it doesn't have any...

Hi guys, I have three tables. the first one contains addresses with regards to the shipment in transit. the next table contains the details regarding the sender and the receiver and the third table contains the items that are to be shipped. I created a PK in the 1st table and then linked...

Hi everyone, I'm currently working on a database that handles invoices. In a certain month, around 25,000 invoices are processed. Some of them are repeating but with different amounts that I need to get the total. It shouldn't be a problem right? I just need to do a summation and group it...

works like a charm! modified a few codes but it fits exactly what i needed. Thank you so much Pbaldy!

Hi everyone, Im trying to modify a database that generates invoices. Im having a problem in adding items coming from an ItemsTable to a SelectedItemsTable. Since the numbers of items are too many, i decided to use a search form that will search the ItemsTable for the Item that the user wants...

Thanks for the reply jal. I'm gonna if any of the to will work. One question though, do you think this will still work even if the MS Access database that I'm building will be placed in a Sharepoint Server? Thanks again.

Hi everyone, I am a novice VBA user and currently fixing an old database that produces instructions for freight and shipping. The database outputs an excel file that is copied from a template using the function FileCopy. Now my question is can how can I add a function that will prompt the...