E
Eve at RBC
Does anyone know why this is happening. It's driving me crazy. I input and
save. When reopening, the table is absolutely empty.
save. When reopening, the table is absolutely empty.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeff Boyce
Eve
Can you use an Append query to successfully add records?
Are you working directly in the table, or (recommended) from a Form? If
from a Form, is the form bound to the underlying table?
More info, please...
Regards
Jeff Boyce
Microsoft Office/Access MVP
Can you use an Append query to successfully add records?
Are you working directly in the table, or (recommended) from a Form? If
from a Form, is the form bound to the underlying table?
More info, please...
Regards
Jeff Boyce
Microsoft Office/Access MVP
E
Eve at RBC
Hi Jeff, thank you.
I'm just starting off - this just happened today. The records were there
before. I'm working directly in the table as I always do.
I haven't designed a form. I have several teams providing me with excel
spreadsheets full of information that I need to insert into a master
database. The spreadsheets were templated from the Access Database field
names.
I thought I could "get external data" from Excel but it's not working and I
don't have an export data option in the excel sheet to go to Access. I've
tried copying and pasting - some work some don't.
I'm at the point of inputting directly myself. However, when I save the
table the data has disappeared when I reopen it.
I'm just starting off - this just happened today. The records were there
before. I'm working directly in the table as I always do.
I haven't designed a form. I have several teams providing me with excel
spreadsheets full of information that I need to insert into a master
database. The spreadsheets were templated from the Access Database field
names.
I thought I could "get external data" from Excel but it's not working and I
don't have an export data option in the excel sheet to go to Access. I've
tried copying and pasting - some work some don't.
I'm at the point of inputting directly myself. However, when I save the
table the data has disappeared when I reopen it.
J
Jeff Boyce
Right off the top, I don't have an idea why you wouldn't be able to enter
data directly in the table.
You should be able, however, to use File | Get External Data | Import...
from within the Access database window to import your Excel data.
Regards
Jeff Boyce
Microsoft Office/Access MVP
data directly in the table.
You should be able, however, to use File | Get External Data | Import...
from within the Access database window to import your Excel data.
Regards
Jeff Boyce
Microsoft Office/Access MVP
E
Eve at RBC
Thanks for trying Jeff. I guess my big problem right now is figuring out why
the date doesn't save when I close the file.
the date doesn't save when I close the file.
R
Rick Brandt
Eve said:Thanks for trying Jeff. I guess my big problem right now is figuring
out why the date doesn't save when I close the file.
If you enter data and simply move to a different row the data is already saved
(to disk). If you are not seeing it disappear immediately upon changing rows
then you don't have a problem with data not being saved. You have a problem
with data being deleted after it is saved.
Are you sure your table doesn't have a saved filter applied that is hiding some
rows from you?
D
David W. Fenton
Are you sure your table doesn't have a saved filter applied that
is hiding some rows from you?
Or is set for Data Entry, so that when you close it and then open it
again, you won't see the existing records?