Search results

I've just imported the data in from an Excel file, so I presume it's all saved within the Access file now. :confused:

I've recently changed the name of the folder that the Database and all of the data that has been imported is stored in - could this have caused a problem?

No, it's definitely just this Database. :mad: I think I've broken it! :( I've recently changed the name of the folder that the Database and all of the data that has been imported is stored in - could this have caused a problem?

The Report is coming off a table which has one row of data on it. I have created about 40 the same way with the same amount of information and they worked fine. I did all 40 in the time it's taking me to do one now! As an afterthought(other programs doing the same) it could be something wrong...

Has anyone had this problem and/or know how to solve it? When I try to create a report (by just clicking the Report button) Access seems to crash for a few minutes - I get the egg-timer and a white screen but after leaving it for a few minutes it comes up with my report. I have already created...

Thanks Neil. Would you be able to tell me the possible pitfalls of what I plan to do as to me it seems ideal for what I want. It doesn't need to be something complex, just somewhere to store customer data. The brief was simply to take the data we had and store it in a more efficient way...

I'm sorry, I didn't mean to upset you. I have taken on board all of the advice here and it has made my decisions much easier - you must realise I am just a beginner and am mostly self taught - although creating relationships etc etc might be more proffesional, in the long run, for me, and for...

Let's say I'm not making assumptions, I work for the company I'm making the DB for, I will be the primary user and I have spent a long time cleansing the data. The reason for separating HQ's from branches is as detailed above, we only want to send information out to the HQ but will have the...

The branch information will only be needed for reference and probably quite rarely, it's just something we want to have as it will provide good Customer Service in the long run. The most important thing will be the HQ, the place were the buyer sits, in order for us to send Price Lists and...

OK, after tearing my hair out a bit I've thought of what might be a tidier approach, but I'm not sure if it's possible:- To have a separate section for Branches with a button for each company which would then show a report of all branches under the account number. I know it'll be long winded for...

Thanks for the encouragement David. ;) Does anyone know if there is a template in any way similar to what I need so I can try to understand it more by seeing it?

Most of our customers just have 1 or 2 branches but the ones with many are very changeable so I will definitely implement my own numbering system. My brain hurts trying to get my head around Access!! :rolleyes: I think I shall go and study my Access for Dummies book tonight! :D

That's a very good point, I will have a look into that!

Thanks Mike, the idea of giving them all a branch number sounds good. I'm going to have a good crack at this this afternoon!

Thanks David. I will have a go at doing this. :-)

OK.....I will outline what I need and what I have and hopefully someone will be able to help me with any aspect of it. What I need: I'm creating a database of customers(retailers) for a large retail supplier - some customers have one branch, some customers have more than one, some have...