Search results

When I converted back to Access 2K I changed the amx records on the query and this setting was saved at this point so the same problem doesn't occur.

Just found out very simple really. Tools Options Advances Max Records

I use .movelast to find the record I want to change (the last one added). I am getting the record from tblctmat , adding it to the same table and then changing it's id (effectively copying it) but this is all done together but I need to do this for all records in the recordset from tblctmat...

Below is code I am using to insert data into a table an dthen update the est_id. It works fine for the last record in the loop but the others in the loop are not being updated by the bottom piece of code. Anybody know what I am missing Do While Not rstmat.EOF Debug.Print rstmat!est_id...

Perfect thanks.

When I tab past the last field on my form when in edit mode a new record is created ?? Why ? How do I stop this?

Thanks Pat

Try puting in a DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 after you have updated the record

This is what I did and it works SQL = "INSERT INTO SQLACCESS.temptblctest " & _ "( Drawingid, cid, CTDNumber, Revision, custom, prepdate, prepby, " & _ " SELECT Drawingid, cid, CTDNumber, Revision, custom, prepdate, prepby, " & _ " FROM SQLACCESS.tblctest " & _...

FoxPro code equivalent in SQL This is a FoxPro command I need to know anything that will do the same thing in SQL. select * from ctmat where ctmat.est_id == ctest.est_id into table c:\temp\ecopy_a.dbf

I am using Access 2003 .adp and .nomatch doesn't seem to be valid

I am using a .find to locate a record in a recordset if I dont find any record I want to move on to the next piece of code - how do I do that.

I have a text box with a default 0 when the user clicks in the box and types the text us entered before the 0 I need it to be typed over the 0 thus replacing it. I know there is a way to do this using fill from left or right but for the life of me I cannot remember how or where I found it before.

I was afraid of that, was hoping not to have to make dummy records. Thanks

I have a pivot chart with weeks on the Category Axis. If I select weeks 24,25,26 and 27 but there is only data for 24 and 26 (these are then shown on the graph) how do I show that the others have no data in them I need them to be shown on the chart as it is problems that I am reporting and weeks...

I need to create a report with 7 coulmns something like this Cust Invoice A B C D E F Total Sales Cust1 8897 €1 €3 €1 €5 €2 €3 €4 €9 Total €2...

I am using A2K .adp and I have the same problem except CrossTab queries aren't an option in .adp (unless I've missed something)

I have since been told that this does not work in .adp only in .mdb so I'll have to find another method of finding records. Thanks anyway

I am having a number of speed issues in my app where I am using recordsets , finding the record that matches a field in a form I have open and then updating the record. I believe I could do this using a query instead of a recordset if I could get the correct syntax for using forms.fields in the...

Tricky as the form I want to move records on is already open but not the form I am using. Also how do I enter the pgdn command as when I try it as a keystroke it just does the 'Page Down' action and moves me on to the Wait line