Recent content by mandywoolf

I have imported a spreadsheet from excel into access, and created another table as well. I have to set up a query taking data from both of them. That is no problem. The created table lookups a field from the imported table and i have also set up autolookup. I enter all the details into the...

well, i make the query in design view and then when i run it the data appears. I then save it, but when i open the query again in the datasheet view and all the data has gone. Amanda

thank you all so much for all your help so far, but i have another query. I have imported a spreadsheet from excel into access, and created another table as well. I have to set up a query taking data from both of them. That is no problem. The created table lookups a field from the imported...

thanx, but how would i do that? i'm really useless at access - sorry! Amanda

I have 5 columns of data. I hide all the other columns so that only those 5 are seen and try to export the spreadsheet to access. When i do this however, access always comes up with fields 6/7/8 in my table which, even after i have deleted them means that i can't set a primary key? Any tips...

hi again don't suppose you know anything about excel??? I have 5 columns of data. I hide all the other columns so that only those 5 are seen and try to export the spreadsheet to access. When i do this however, access always comes up with fields 6/7/8 in my table which, even after i have...

wicked - thank you. it is all making sense now. I am about to go to bed now, coz it is late in the UK, but i will try it tomorrow and see what happens. i will post again tommorow, so if you could check again that would be great. thank you heaps for all your help Amanda xxx

ok, well that makes sense no - thank you. I have tos et up a query that has all the headings from the created table - ok, i can do this bit I have to format the food field to lookup food from the imported table - i have done this also But then what. I am not sure what i would need to enter...

The first table isn't empty. It has all the data that i have imported from excel. I save that, then set about creating the new table. I know that because i've set up the lookup feature the data should move across into the new table, but it doesn't and it just makes absolutely no sense to me...

a bit more info I import a file from excel. I then set up another table, with one of the fields looking up data from the imported tabe. I did this by changing the data type to lookup wizard. When the table is ready i save it, but the data is not moved from the imported table to the created...

Don't s'pose you know the answer to this by any chance? I have to import a table from excel which is no problem, but it then goes on to say that i cannot set my primary key to a null value - not quite sure what that means. I then create another table with 1 field to look up data from the...

thank you! Thank you sooo much - you really are a lifesaver! Amanda xxx

Hi Everyone, As part of my assignment i have to create a switchboard to facilitate the use of my database. I looked under the help option and it tells me to go to tools, then add-ins and lick on switchboard manager. On ym computer however switchboard manager is not there, only add in manager -...

Hi Everyone, hope you are all ok Really desperatly need your help please! I have to import a table from excel which is no problem, but it then goes on to say that i cannot set my primary key to a null value - not quite sure what that means. I then create another table with 1 field to look up...