How to Update Business Name and Address in mdb?

[CompuPro]

I have a mdb file that our company has been using for years and would like to continue. But I need to update our business name and address within the file so when I do reports and invoices it reflects the correct information. I am using Access 2013.



Could someone please give this newbie the steps to complete this.

Thank You,
CompuPro

[June7]

Where is the business name and address stored in the db? Is it in a table or is it static text in form and report design?

[CompuPro]

Unsure, I took over this database from someone else. How do I tell? I have updated the business name in the Visual Basic portion. But I have not been able to locate where it would be for the invoices and reports.

[June7]

Where have you looked? Have you explored all the tables and do you know what data they store?

Open form and report in design view. Do you see any labels with business name and address?

[CompuPro]

I have looked in the design view and do not see any labels with the business name and address. I also have looked through the tables and have not found anything. Yet when I try to do an invoice it displays the wrong business name and address. Is there anywhere I could upload the mdb file so you could take a look and let me know what I am doing wrong and where to look to change it so I do not have to ask again? I would upload it here but the file unzipped is 2.2mb approx.

[CompuPro]

Ok, I figured out how to Compact the file and zip it so I can upload it here. If you could take a look at it then let me know how to change I would appreciate it.S & N TRANSPORT LLC.zip

[June7]

Invoice Customer via 30 day report has a label control with "R and W Transportation" caption. Change the caption to change the displayed name. Same for the address in label in footer section.

Just select each label and type desired text in Caption property.

The address has embedded carriage returns to force multi-line text. Type embedded CR with Ctrl+Enter.

[CompuPro]

That is what I do not know how to change. Sorry, I am very new to Access. How do I change the caption to change the display name? Same for the footer?

[June7]

Select label and type text in the Caption property on the Properties window. Or double click on the label and start typing.

Very basic Access functionality. Perhaps you should complete a tutorial - on line or introductory book.

[CompuPro]

So I need to switch to design view and then double click on the "Form Header" and start typing. Nothing happens other than the Property Sheet opens. It does not give me anywhere to type in the new business name. Same for the footer information. Is there a step I am missing?

I do not understand. It does not allow me to change, When I click on the information it brings up the Property Sheet and does not give me the business information to change. I am sorry I am new to Access. Please give me step by step directions. Thank you

[June7]

Double click on the LABEL control - the boxes that show the company and address - not the header and footer bars.

I did give step by step:

Select label and type text in the Caption property on the Properties window. Or double click on the label and start typing.

[CompuPro]

I also have no label to select. It only shows Form Header.

Maybe it is different in the version of Access you are running. There is no label showing, so I can not select or double click on. Not trying to make you mad. But your instructions are very vague for someone that told you I was very new to Access.

[June7]

The db you provided shows the label controls I described. Access version should not make any difference.

[CompuPro]

That is what I am saying. I have no LABEL control to click on.

[June7]

I have never used 2013 (don't want to). The file you posted is an old Access format (mdb) so it was probably created with version prior to Access 2007. Perhaps if you imported everything to a new file, 2013 will handle it better, although it really should not be having this issue with the mdb format.

Or find an Access 2010 computer and run the file and see if it behaves as it does for me (shows the label controls).

Since I cannot replicate the issue and don't have Access 2013, that is really the best I can offer.