save forms with data

[action8]

How do you save forms with data on them?
say, I have an ms access application, and I am using it currently.
it has a form for scheduling gym members to come to practice daily, for five days a week, the form has name of people every 15 minutes scheduling.

now, I pay somebody on the internet to improve the form (add more button to go back/forth one week at a time).
I get the project back, add/import the table from the old application to the new and improve application.
however the cheduling form is empty!!!!.
I have five weeks scheduling people. 400 entries to redo!!!
I have to manually enter the scheduling form again!!!
does anybody know what am I talking about?

 

[dhookom]

Forms do not store data, they typically are used to display datt. Tables store data.

Are your schedule records in the tables? Is your application split into a front-end and back-end?

Have you opened the form in design view and checked the record source?

Duane
Hook'D on Access
MS Access MVP

 

[action8]

I am new with this stuff.
table store
member's last name, first, phone, address....
I attach an image of the form
top part is: weeks radio button : week1, week2,wk3.. wk6.
left most column is time: 8:00am, 8:15am,8:30am,....,5:00pm
next six columns: monday, tue, ... Saturday
and I schedule people for every 15 minutes
it is a form.
I ask a programmer to modify the form to add
left and right scrolling button so we can scroll for more wks.
In the meant time, we are scheduling people for six weeks.
now, the new form with left right scrolling button arrives.
with some more vba Code.
the current form is filled out with hundreds of names.
How do I transfer the name from current form to new form?

 

[action8]

record source is empty with elliptic ...
when I click in the slot of time
another form pop up for selecting name of people
please see attachment
is it ok for record source is empty?

 

[dhookom]

I expect your form is unbound so it wouldn't have a record source. Again, tables store data. Do you have any tables with records?


Duane
Hook'D on Access
MS Access MVP

 

[action8]

tables? yes I have tables
tblmembers - fields: memberID, last, first, phone, address, dob...
this table has about five hundred members,
tblAppt - fields: apptID, ApptDate, ApptTime, memberID,paidYN,ConfirmYN, rescheduleYN

OH, I found it the data are stored in the tblAppt table.
so for MS Access 2003, what is the simplest method/way to replace the tables, they have the same name.
my situation:
when I send out the database, I only have few members and few appointment, and to keep sensitive data, I just send out with faked name, faked date of birth,....faked phone.

Now, I receive back the database with improvement, the table names are the same, the database back end and front end are the same,
how do I use the new improved database with my real data in current table from the current working database.
I have to replace faked data with real data and not messing up the memberID (key).

 

[dhookom]

I would rename the tables in the file you got back from the programmer. Then link to the tables with your current records. Use File->Get External Data->Link... to find and link to your tables.

Duane
Hook'D on Access
MS Access MVP

 

[action8]

so the programmer gave me an improved version database, with tables containing faked data with primary key and so on...

Step 1. rename the tables in the improved version database.
step 2. file-> Get extern data -> link
Q1. do I link to the tables with "non faked" data?
Q2. should I delete the faked data first, to avoid primary key issue?
Q3. by linking I append the "non faked" data to faked data, is that right? what is the end result of link?
sorry for too many questions!!!

 

[dhookom]

Q1. You link your actual tables into the new and improved application.
Q2. I wouldn't delete the faked data. I as I suggested just rename the faked tables.
Q3. There is no appending. Just link your actual data tables into your new file.

Duane
Hook'D on Access
MS Access MVP