if you have referential integrity turned on in the relationship

you won't be able to change the data type

cos you can only join like for like with it turned on

(ie number to autonumber and text to text)

Posted By: blindasabat on September 25th 2007 at 13:30:13

Message Thread

Anyon out there good with microsoft access? (n/m) (General Chat) - lovely old job, Sep 25, 12:59:42
- cast it into hell, (General Chat) - NCFC4life, Sep 25, 13:22:53
- What do you want to do? (n/m) (General Chat) - tudders, Sep 25, 13:13:06
  - I have nearly set it up how I want it, but I cannot convert all rates to UKP from USD & I (General Chat) - lovely old job, Sep 25, 13:21:05
    - if you have referential integrity turned on in the relationship (General Chat) - blindasabat, Sep 25, 13:30:13
      - ^^He's right, but that's about the extent of my knowledge. (n/m) (General Chat) - tudders, Sep 25, 13:34:45
  - Enter charge out rates, job cost info. (n/m) (General Chat) - lovely old job, Sep 25, 13:14:22
    - Put the 'charge out' rates into the 'charge out rates' column.. not sure after that. (n/m) (General Chat) - malkybarkid, Sep 25, 13:16:39
      - ok (n/m) (General Chat) - lovely old job, Sep 25, 13:18:43
    - In Excel? (n/m) (General Chat) - tudders, Sep 25, 13:16:00
      - It's in exel now but want to convert to Access to save time. (n/m) (General Chat) - lovely old job, Sep 25, 13:17:08
        
        use the import from excel feature then (n/m) (General Chat) - blindasabat, Sep 25, 13:21:23
        
        ... (General Chat) - blindasabat, Sep 25, 13:23:40
        
        ok (n/m) (General Chat) - lovely old job, Sep 25, 13:22:54
- I access microsoft easily every day (n/m) (General Chat) - pants, Sep 25, 13:02:53
- Only the basics. (General Chat) - Arizona Bay, Sep 25, 13:02:02
- yes (n/m) (General Chat) - blindasabat, Sep 25, 13:00:22
  - good (n/m) (General Chat) - lovely old job, Sep 25, 13:01:19
    - there's one now (General Chat) - blindasabat, Sep 25, 13:04:41
    - lol (n/m) (General Chat) - pants, Sep 25, 13:03:01

Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.