Any Access gurus around this lunchtime?
#1
Scooby Regular
Thread Starter
Join Date: Feb 2002
Location: nix fur bremser...
Posts: 1,757
Likes: 0
Received 0 Likes
on
0 Posts
If so, I'd much appreciate your help.
We're testing a new bit of software which helps you turn round RFPs really quickly - looks pretty good. It does this by interrogating an Access database which has been populated which other responses - all Word documents. We've just completed 2 blinding responses which I'd like to add to the database but don't have a clue how to do it. I'm supposed to submit a request to the US to get it done which'll take forever so I'd rather do it myself.
All I do know is that the information in this database is held in 'Tables' under the 'Objects' tab. Any ideas on how to get these new responses in?
Cheers
Kav
We're testing a new bit of software which helps you turn round RFPs really quickly - looks pretty good. It does this by interrogating an Access database which has been populated which other responses - all Word documents. We've just completed 2 blinding responses which I'd like to add to the database but don't have a clue how to do it. I'm supposed to submit a request to the US to get it done which'll take forever so I'd rather do it myself.
All I do know is that the information in this database is held in 'Tables' under the 'Objects' tab. Any ideas on how to get these new responses in?
Cheers
Kav
#4
Scooby Regular
iTrader: (13)
Join Date: Jan 2001
Location: Midlands - between notts and derby !
Posts: 4,997
Likes: 0
Received 0 Likes
on
0 Posts
Does one of the entries under the table tab have a name of responses or something like tbl_responses ?
If so can you double click on it. This will give you a spreadsheet like view. Can you relate to the data displayed ?
Dave.
If so can you double click on it. This will give you a spreadsheet like view. Can you relate to the data displayed ?
Dave.
#5
Scooby Regular
Thread Starter
Join Date: Feb 2002
Location: nix fur bremser...
Posts: 1,757
Likes: 0
Received 0 Likes
on
0 Posts
Yes - it's called 'Answers' and like you said, double-click on it and you get something like a spreadsheet. I can relate to the info in there but how on earth do you import it?
Cheers mate
Kav
Cheers mate
Kav
#6
Scooby Regular
iTrader: (13)
Join Date: Jan 2001
Location: Midlands - between notts and derby !
Posts: 4,997
Likes: 0
Received 0 Likes
on
0 Posts
It all depends ....
You could add a new row with the information you want. Use the >* next to record at the bottom of the spreadsheet screen.
It all depends on how it has been coded will determine wether the data will be seen. If the are any keys or related tables id in the columns they will need the correct values entering. They may have created a 1 to 1 relationship with another table. These are a bit more difficult to answer without seeing the database.
Dave.
You could add a new row with the information you want. Use the >* next to record at the bottom of the spreadsheet screen.
It all depends on how it has been coded will determine wether the data will be seen. If the are any keys or related tables id in the columns they will need the correct values entering. They may have created a 1 to 1 relationship with another table. These are a bit more difficult to answer without seeing the database.
Dave.
Trending Topics
Thread
Thread Starter
Forum
Replies
Last Post