Search results

Hi, I still am having problems importing large text fields from excel into Access. how else could I import a 300 character field into access as a memo field. I try to import into a new table but cannot change the data types.. thank you Jammy

Hi , I created a table, and import the spreadsheet but the memo field is being converted back to text !!

Hi, I am trying to import an excel spreadsheet into Access2000 using the import wizard. I choose my XLS file, I say whether or not the first row contains headings, (no is the anwser). Then I want to change some of the fields to data type of memo from text, but all I can see if Field 1 and data...

Hi, I have a spreadsheet with location, name and odb in the rows, eg : location name dob 1 Jo 10/02/78 1 Ste 12/03/82 2 Mik 01/11/59 3 Jop 11/11/90 3 Kat 02/05/78 3 Jo 14/04/84 How can I : 1 : Import...

Hi, you could use MAX(ID) + 1

Make sure you have correct permissions on the SQL tables and you are using an up to date MDAC.. you may need to re link the tables after changing the permissions..

Hi CS, look into using the Workgroup information File / Microsoft Access Workgroup. you can create users with passwords and give them access to update tables / delete, etc.

thanks Neil, I've played aronud with this and undderstand what you mean now. thank you, this is now working..

Just to let you know , I have a lot of info on this form, not just the 3 fields I mentioned. I have various combo boxes to select other data. the only part I have problems with is typing a number into the ID textbox, then on aftre update inserting the correct values into the town and address...

hi Neil, how can I use a combo box to do this ? I don't want to have a record source for my form..

Run-time error 13. Hi, I have modifed my code to : Dim rst As Recordset Set rst = CurrentDb.OpenRecordset("SELECT * FROM [Site Data] " & _ "where [Site Reference] = " & SiteNumber) [Forms]![AddFault]![Town] = rst(Town) [Forms]![AddFault]![Address] = rst(Address)...

hi, I hope someone can help me here.. I have a form with ID, town and address on it. I want to beable to type in an ID, press enter then if the ID exists in a query then populate the town and address text boxes with the correct info.. If the ID doesn't exist, then open another form so the...

problems mail merging in word hi guys, If I have an access database open , then I open word and try to mail merge access doesn't automatically go to the front of the screen. I need to click on the access database on the taskbar in order to do the mail merge. do you know why this would be ?

hello, I have a strange problem with some access 2000 databases. I have 3 databases. when I open them all instead of 3 instances of access opening ( so I can view all 3 databases in separate windows) only 1 instance open meaning the open database I can see if the last one I try to open. has...