Search results

Brilliant, Works Great Many Thanks

Hi All I have been looking at other thread but i havent found anything that is similar to my situation. I have a stock table of products and i want to display an image of each product based on one that is selected at that time. All the images are in one set folder. I need to find the image...

Thanks Guys - Much Appreciated!!!

Hi Guys I am begining to create a IT support database for my company. I have never really needed to use secuirty for the other projects that i have completed but this one is a bit different. i have used the security wizard to create the users and groups but would like to get the basis of the...

Thanks, that worked great! Martin

I have a table accessable by ODBC and am trying to create a query to only import the records for the previous month. I am struggling on the criteria for the query. If anyone could help me it would be much appreciated Thanks Martin

CSV Posts Hi Doc I Apologise as there was no offence intended by submitting another post. I am new to the forum and am not sure how to go about getting answers to new questions. The 1st question I asked was to find out how to create a header on a csv. Once I had done this then I found that...

thanks for the suggestions guys but i have no idea how to go about this. I know now that I need to open the file to edit it. (intra.txt) is there not a find and replace type code to look for all the quotation marks and then delete them and then re save the file. Thanks for your patience Martin

Hi all I have created a text file from an access query. This contains csv information. However for me to upload this to a program i need to get rid of the quotation marks that are present in the file so for eaxmple "ABC" would become ABC. Is there any way that i could create some code to...

thanks i would do this but this is a program for somebody else. Is there anyway that the csv could be exported without these quote marks or a piece of VB code that could be used that would delete them automatically. Thanks Martin

CSV format Hi All I have created a table that i am exporting to a csv file. The only thing is that the text entries contains the quote (") marks at either end of the string. Is there any way to get rid of these so for example instead of adding "T" it adds just T Any help would be greatly...

Thanks I'll try that would that enable me to add a header to the file that contains the information for the data that the comapany i send it to needs Thanks Martin

Hi All I am trying to create a CSV file from a query and am not sure how to go about it. I have the query complete but do not know how to format it and save it as csv. In addition in need to add a header for the file on line 1 which contains the file information for the company that i need to...

Hi All I am wondering how you link a field in a chart that is on a report with a sparate field that is on the report. I am trying to show a chart that displays products sales but i want it to be the same product as the other information on the form. Therefore i need to link product code on the...

That will do nicely! Many Thanks Martin

I have calcualted the required stock for each product that we need to buy For example we stock a paintbrush and want to keep 4 weeks stock and as a result we need to order 437 to keep this number of weeks stock based on average sales. However there is an economic order qty from the supplier of...

Hi All I am calculating a stock replenishment value for a stock system. I have calcualted the required stock needed but require that this number be a multiple of a economic order qty field. Is there any fuction that can be used to calculate this figure and make sure that it would round up in...

At the current time I am producing a program that uses ODBC to update tables overnight from our main database software. One of the tables is about 800MB and needs to be updated once a month. I created some code to carry this function out along with some others at the click of a button. (like...