Thanks Mary,
Steve...
steve456
Last Activity: Dec 31 '07, 04:13 PM
Joined: Mar 24 '07
Location:
-
Running Access 2007 on another drive
Hello everyone,
I have Access2000 as part of a Office2000 package. I recently bought a copy of Access 2000 Upgrade. Is there a way that I can keep Access 2000 on the C: drive and Access2007 on the D: drive?
When I load it on Access just dumps itself onto the C: drive.
Regards,
Steve -
Thanks missinglinq,
I'll give it a go.
regards,
Steve...Leave a comment:
-
text Field "can grow" property
Is it possible in a form while entering data in a text field to get the field to drop down so as to see all of what you're typing. I know this option is available in a Report but haven't come across any information about it regarding forms?
Regards,
Steve -
Hello again nico5038
I’m sorry for being such a pain but there must be some elementary step I’m just not getting. If I’m to understand you correctly I’m to create another table which is a mirror copy of my already established ClientServiceTa ble. If I do that I will have 2 service tables.
I’ve taken the liberty of uploading to my website two tables from a previous post that we discussed. Before pressing...Leave a comment:
-
Hello again nico5038,
Not sure I understand what your last post was referring to. Could you rephrase?
Also not sure what the term "ForeignKey " means, can't find it's definition in the help section of Access2000.
Having said all that do the two table I describled in my last post look OK to you?
Regards,
SteveLeave a comment:
-
Hello nico5038,
Is this what you have in mind?
Two tables for a service database
CustomersTable
ClientID “autonumber”
FirstName
LastName
Address
City
Prov
PostalCode
PhoneNumber
ClientServiceTa ble
ServiceID “Lookup” connect to CustomersTable “key”...Leave a comment:
-
Hi nico5038,
Thanks for the response. I'm going to need some time to digest that. I'm a real newbi to this. If I do what you suggest I'm sure it will work.
regards,
SteveLeave a comment:
-
Hello Nico5038
Yes as a matter of fact I do. I used the phone number as the unique identifier for customer's names and addresses and included that very phone number field in the discription table. The discription form is in datasheet view by the way.
Regards
SteveLeave a comment:
-
Form sub-form problem
Hello all, I’m a newbie so please forgive me if my description of the problem is not clear. Here goes. I’m developing a new database for my contracting company. I have a form with a sub form. The main-form has all the customer names, addresses and phone numbers and the sub-form has the descriptions and the cost of each service.
I may need to generate 3 different records per year for one single customer. When I start typing... -
Form sub-form problem
Hello all, I’m a newbie so please forgive me if my description of the problem is not clear. Here goes. I’m developing a new database for my contracting company. I have a form with a sub form. The main-form has all the customer names, addresses and phone numbers and the sub-form has the descriptions and the cost of each service.
I may need to generate 3 different records per year for one single customer. When I start typing...
No activity results to display
Leave a comment: