Recent content by belton

Hi- I've used a similar set of code for deleting and refreshing a table, using sql code to delete the data from the original table (using setwarnings to off) then using an append sql stmt to add the data from a secondary table.

I have a database, where in a form, I can reference a table as follows, and it works. dim wsp as workspace dim db as database dim rec as recordset Set wsp = DBEngine.Workspaces(0) Set db = wsp.OpenDatabase("c:dtabase.mdb", , , ";pwd=PASSWORD") Set rec = db.OpenRecordset("table1", dbOpenTable)...

How would it be done, if T1 ... TN were table fields? (ie values (" & Table1.field1 & ", " & table1.field2) & ");" . . .

What about seeking a record, and wanting to add only the values received by the seek to append one record? Any ideas?

Hi- when your code stopped, did you click the toggle breakpoint button on the toolbar?

I have successfully implemented control tip text, but it shows as one (1) LONG line accross the screen. Is there anyway to format it better?

What exactly is it that makes the linked table unaccessible for these type of functions? It works great for queries.

Hi, Im using an export specification to output from my db to a text file. The specification, and the data within the database look fine. To help, all are classified as text fields. I run the export and the output file doesn't have all the zeros of the field that the db table field does. I...

I find that when I work on different resolution monitors, the characteristics for the displaying of the forms are different... I think I'll have to go back to auto resize/center...

All but the "false"- I tried it with the false, and it still created a new table in my current database... DoCmd.TransferDatabase acImport, "Microsoft Access", transpath, acTable, "AgCentral1", "AgCentralData", False agtrans = c:\agris\trans\agtrans.mdb [This message has been edited by...

Hi- I'm trying to import a table from one database to the current database. The table I wish to transfer from has the same format as the one I'm importing to, but the names differ. I can't seem to get it to change names- it always creates a new table of the same name as the "from" database...

Hey- I can't seem to get my VB code to stop to allow editing of some data on a form, before continuing. I am using - stdocname = "WC_Sel_CropArea" Application.Echo False DoCmd.OpenForm stdocname, , , stLinkCriteria Application.Echo True as I process a table of...

Hi- I'm having a problem where I have designed my forms, and maximized them, saved them- but they don't show maximized when I run the application...???