Search results

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...

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...

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

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...

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...

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...