Search results

The SQL will be something like: INSERT INTO SSM ( Field1, Field2, Field3 ) SELECT [New table].Field1, [New table].Field2, [New table].Field3 FROM [New table]; Change the new table name and field names to match your own. Easier if you let access create the sql for you: create > query...

Are you using a form and want to click a button to run this? If not just create an append query and run it. Need more details on what you're trying to do.

That's just code to run a query. Personally I'd rather create my own query in access then use DoCmd.OpenQuery "...." to open / run it rather than inserting the sql in the code.

Was it not documented in 2000 as well? Perhaps not but yes, it's not documented any more but it still works in every excel version. Not sure why it's not documented though, seems odd.

Your original formula was correct, this is not. As it's numbers you're dealing with, it should not have quotes. Quotes are mainly used to represent text. Better it's far better having more functionality and flexibility for future use with the data. It's the forumla of choice for most people...

There is nothing wrong with : =IF(AH2>80,"80+",IF(AND(AH2<81,AH2>64),"65-80","Under 65")) What if you remove any formula in AH2 and just type a number does it work? Edit: It does work if you just enter a number, the problem is with: =LEFT(YEARFRAC(AG2,TODAY(),1),2) I propose you use...

Try adding oApp = nothing after oApp.Quit. If that doesn't work try : oApp.Application.Quit oApp = nothing instead of oApp.ActiveDocument.Close oApp.Quit

Having a quick look at the code it seems fine, I would think your problem lies within the query.

This may give you a better insight to the problem, although there may not be a solution. http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/817e24aa-9ff2-4f13-bf1a-bbd073590bac/ When you click on another tab it automatically closes the other tab which prompts the save.

You need to build a query or queries to do that. Then you just enter a line of code to execute the query at the point you mentioned.

That's not possible, well not practical at least. You should create a dummy table to hold the imported data, check the ID, copy the records which are new to the other table you have. Move all the imported data to the original table and delete the dummy table or leave it?

Ok, assuming all records have a customer ID, query the two tables checking for IDs not in the new table. It should be an append query to copy those records into that seperate table.

I wouldn't create a macro for that, just code it in a button. Example for importing a text file: DoCmd.TransferText acExportDelim, , "TableName", "c:\.......\TextFile.txt", True Change the parts in red to match your info. Tablename is the name of the table the data will be imported to. True is...

Try Debug > Compile first before trying to convert to ACCDE.

Will only 1 record be excluded or can multiple be excluded?

http://stackoverflow.com/questions/7481309/vba-issues-converting-string-to-date-using-format-or-cdate This should solve your problem.

What if you try: SELECT * FROM Signals

I would do something simple like: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Query1", "C:\Users\u549032.RRLOCAL\Documents\SABRe deployment governance PSSU.xlsx", True This would replace all the code you have there! It depends what you want to do, this may not be what you need.

Try this: MySQL = "SELECT Query1.Tracker FROM Query1 WHERE (((Query1.Tracker) Is Not Null));" I don't actually know what Query1.Tracker is or Query1, this is not how I would get values from a query. Did the book show this? Maybe someone else here can help you.

You haven't got a space before FROM and WHERE.