Search results

Download from John Viescas the BOOKS DATABASE. Will help you a lot. ftp://ftp.viescas.com/Download/Books.zip

Also if you want, you can delete your column by this code: dim strSQL1 strSQL1 = "ALTER TABLE YOUR_TABLE_NAME DROP COLUMN YOUR_COLUMN_NAME" CurrentDb.Execute strSQL1, dbFailOnError

Try this. Create a button to your form and put this code: Dim strSQL strSQL = "DROP INDEX YOUR_FIELD_NAME ON YOUR_TABLE" CurrentDb.Execute strSQL, dbFailOnError Now try to delete.

I Think that he just forgot to take the tables from the BE database.

Here is a GENERAL code to tranfer XML files: Create a button and put this code: Const acAppendData = 2 Application.ImportXML GIVE_THE_LINK_FOR_YOUR_XML, acAppendData MsgBox "Procedure Complete.", vbInformation, "Your DB Name"

You have to try yourself to create qry's or you can use the qry wizard. It is very simple and you can do it. To give you a hint i am sure that your tables have a ClientID or something like this to bind them. If you can not do it then you have to import your database here to help you.

Sorry my fault. Use this: docmd.setwarnings false docmd.setwarnings true

rainman is correct.. before- docmd.setwarnings = false after - docmd.setwarnings = true But you do not put the before - and after - use only this: docmd.setwarnings = false docmd.setwarnings = true

Probably his values at the Excel sheet is something like this: 12-8 or 9-1 or whatever similar. So what happen next is that excel assumes that this values are dates. Thats we he have #num! errors. I Had the same problem recently.

1. First you have to import the Excel sheet to your access database. Here is GENERAL code to transfer the excel sheet. Create a button to your form and put this code: DoCmd.TransferSpreadsheet transfertype:=acImport, _ tablename:="GIVE_ANY_NAME_TO_TABLE", _...

It is very easy to transfer excel sheets and create access table to your database. I am not so advanced in access myself but THIS is not so difficult to do it. Here is the code to transfer the excel sheet. Create a button to your form and put this code: DoCmd.TransferSpreadsheet...

Maybe your table is not Access table but is Excel connection. Thats why you have num# errors. Is that correct?

You can use something like this. From Helen Fedema.

If your qry is too complex then my opinion is to "split" your basic qry and to create 2 or 3 qry's with less fields - data in it's one, binding them by the ClientsCode for Example...

Also you can use something like this: sub DeleteTable(sTable as string) dim tbl as dao.tabledef for each tbl in currentdb.tabledefs if tbl.name=sTable then currentdb.execute "drop table [" & sTable &"]" end if next end sub

go here: http://www.access-programmers.co.uk/forums/showthread.php?t=76173

I Think that you have type wrong number from what we can see from your first picture...

Did you try "On error resume next"?

Dear Paul, The think is that when I am doing what you suggest me to do, is that when I have edit the qry and I want to go again at the recordsert there is no recordset. My edit qry disappear. The recordset is empty. The only think access allowed me to do is to put a qry or a table as a...

Thank you for your JPG Paul. Now I know what is "property" in Access . To tell you the truth still I do not understand the solution but this is my problem now.