Subform adding editable fields to subform

[kshope25]

So I have a subform that shows directly on my main form. Dependin on which route i select in a seperate combo box, that specific route information shows up in this sub form (route#/Scheduled Time). I want to add some extra columns to this subform so that, for example, if a route is running behind, i can update that route with new times....but i still want the scheduled data to show, so i'll need to do it in another column.

BAsically i wanna be able to do the folowing:
1. select a route in the combo box (already done)
2. have the scheduled data show up in the sub form. Howver, i dont want this data to be editable. (already done)
3. update with new times due to the delays. - this is the part i cant figure out. I need some blank colums that are editable to show up on the subform so i can update with the new time.......however, i dont want the scheduled data to be editable.

final subform would look something like this:

Route#/Scheduled/Actual Time
BBAA2/12:30 P.M./4:30 P.M.

The "Actual Time" Column is the only one that i want people to be able to edit.

 

[Mihail]

For me, this sound as a NOT normalized database.
Can you post a pic from your relationships window ?

 

[kshope25]

i can, but it's empty. When i click on relationships, nothing shows.

 

[Mihail]

i can, but it's empty. When i click on relationships, nothing shows.

This confirm what I said.
Do one more try: Right click in that window then select Show All.
If still your tables will not appear then upload your DB.

 

[kshope25]

yeah nothing still appears. It could be b/c one of the tables that im using to get the route number and scheduled time are linked tables to an ODBC database that isnt actually stored in my current database?

Thank you for your help by the way!

 

[David R]

Linked tables can be shown on Relationships screen just fine. Something is rotten here... what happens if you temporarily copy them into your Access database? Can you even do that, or are there size limitations?

 

[kshope25]

I can copy the tables into my database just fine....problem is that the schedule data (in ODBC Table) is always changing, and so i'd have to run an update query to update that copied table everytime the schedule data was changed in the ODBC table. I was trying to avoid that, so that is why i linked to it.

 

[David R]

Sorry, I didn't mean permanently putting it in your database (though you can do that via VBA for every time you boot up, for example). I just meant to try it once and see if that solves the problem you're having this week. If so you may need to look and see if some field format in that ODBC table isn't matching with what Access can use.

If that doesn't solve it, it at least gives you a version you can strip down, compact, zip, and upload for us to poke at.

 

[kshope25]

i just figured out a work around....not ideal, but it'll def. get the job done. I appreciate all of your assistance on this! Thanks a lot!

 

[David R]

So what did the workaround turn out to be? I'm curious, and other users might want to know the trick later...

Glad you got it working though. I hate niggling little stuff like that where you're like "No, seriously, it's RIGHT HERE! *points*"

 

[kshope25]

Thanks David...yeah when you mentioned temp. copying it over, it gave me an ideal...i'll just convert that ODBC table to a local table here in my Database,and every time the ODBC data changes, i'll have it run an update query to update this local table....this will accomplish what i'm trying to do. I'll also add the extra columns i need to this local table, so that they'll be editable when i need to do that.


Thanks!

 

[Mihail]

We tried to help you.
Now, you will be so kind to share with us your approach ? Maybe, at a later time, we'll be able to solve our issues by using what we'll learn from you.

 

[kshope25]

Hi Mihail

Please see above for the workaround I used. I'd say that the work around is probably not the best way to do it, but it will accomplish what I needed. Thank you very much for your help.

 

[Mihail]

I can't write as quickly as you, native English speakers, can.
So I post the question... after the answer

 

[kshope25]

No Worries at all. you and David were both very helpful to me. I"m just starting out with database design and i have taken over some systems that dont appear to have been set up correctly (relationship wise) originally, so it makes it that much harder for me.

 

[David R]

I wrote my first database with ABYSMAL normalization (I knew a little, but not enough). It limped by for several years like that while Pat Hartman chased me around the forums with a stick... I eventually had to take it offline for a week or two and restructure everything. Now I'm a believer!