I have a friend that uses access 2002 that needs to change his address on the master form he uses with his company info on e.g. Company name, address and company phone number. Thank you for your help.
I have a friend that uses access 2002 that needs to change his address on the master form he uses with his company info on e.g. Company name, address and company phone number. Thank you for your help.
This sounds suspiciously like a homework task.
It depends how that info is entered in the form. Tell 'your friend' to open the form in design view and look at the form controls.
If its one or more labels, then update the label caption(s).
If its based on one or more textboxes, then the data needs to be updated in the underlying table(s)
Hi
This information should be based on a table named tblCompanyInformation.
But WHY would he need to display his Company Details on a Form? Normally this information is displayed on a Report which is usually printed out.
Maybe you can upload a zipped copy of the database so we can see the problem?
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
I'm not 100% sure its a form, it could be a report. I've never used access and I'm his computer tech and my expertise is usually not software based, especially on a program I've never used. He has a customer database and he opened it up and showed me how on a new job he enters in the job info for the customer. I see at the top of the document, each one he creates has his company info like on a header maybe, at the top of the form ? I was looking for the way to edit that info to change his address for him, so the correct company info will now show on each new doc/database entry he makes. Hopefully that makes sense.Hi
This information should be based on a table named tblCompanyInformation.
But WHY would he need to display his Company Details on a Form? Normally this information is displayed on a Report which is usually printed out.
Maybe you can upload a zipped copy of the database so we can see the problem?
Open the form (report?) in design view. Select the control that contains the info. If the property sheet is not visible, open it (see Ribbon). There is a small box near the top of the sheet that will tell you what kind of control it is. If it's not a label, then look at the sheet, find the control source property type and see what it is. If it's a table or query, there is where you will have to edit the value. The query/table name will be in the control source property row. If the control source property starts with = , post what is there. As long as you're looking at the property sheet, or at least because you have the object in design view, you should be able to tell us whether this is on a report or form.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Sounds to me like someone has left the company and taken the customer DB with them, and now trying to pass it off as his own or use it under his own company name?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Thank you Micron for the info...I will be giving it a go tomorrow.
Hi
If you can upload a zipped copy of the database we can take a look for you.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Ok...I just got off my customers pc and here is what I need help with. Looks like its a "report" that is the form I need to change the header info on. I attached 2 pics of it. I did go into one of the reports and with design view and I can see all the different text boxes and did sucessfully change the header info. But it only shows those changes on past invoices not any new ones that are created. So when an new invoice is created the old header info remains. I guess I need to find the "master" header info box would be so that new invoices will show new header, if that makes any sense. On one of the screen shots I circled in red where I need the permanent changes made.
Yes I did read your suggestions. I'm just not familiar with access at all. Tryed my best to understand your directions...sorry
Well, make a copy of the dB, delete most of the data, but leave enough records to illustrate the problem. Change any sensitive data. Use names like Fred Flintstone..
Do a Compact & Repair, then zip it and post it.
cross posted
https://www.mrexcel.com/board/thread...-text.1157212/
spyfox, please read
https://www.excelguru.ca/content.php?184
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.