Search results

Sorry for the delay in reply I have been on a break. I have a very complex spreadsheet which works very well but is about 4mb in size and causes storage problems when saved because I have a large number of clients and they have one spreadsheet each and this number is growing. I want to use...

I am setting up an access frontend to an excel worksheet. I am creating linked tables using the excel input fields. I find when I have created the tables I can't create a primary key as access won't allow modifications to the linked table. Has anyone any suggestions as to how I can set a primary...

Ron Thanks for your answer. I am leaning that way myself but wondered if I would be heading in the wrong direction. Cheers Peter

I need to design an application which will store client data including financial information such as loan details and budget details. I then need to do a number of calculations based on cashflows up to 40 years into the future and produce reports and graphs etc. I am very familiar with excel and...

Thanks will do.

I am creating a form with a subform. I have a subtotal on the sub form which I wish to display on the main form and perform a calculation. However, when I create the text box and set it's Control Source to the address of the subform total I keep getting #name? errors. I have checked the code &...

mmm Might be a bit down the track before that happens. :cool:

That sounds like what I'm looking for. I'll look it up. Thanks again I owe you a beer if this works I feel like I've been going round in circles for hours with this one. Regards Peter

Next problem encountered! I have created queries to count opening stock, stock sold, stock received. When I try to create a query that works out the On Hand amount, ie Opening stock +Stock received - stock sold, the query will only list those products that have actually had a sale. That is if I...

Thats spot on. Thanks

Hi shadow I think you may have something - I have been trying to construct the query based on the orders primary key and not the products key. I will have another go based on your advice. Thanks a lot.

I am creating a customer db with a stock ordering capability. I wish to create an inventory that updates based on stock sold. The order details table lists the numbers of each item that is sold but I need to be able to group similar items from different orders, total the sales and then deduct...