Search results

I figured it out. Its not me but incompatible software versions...http://support.microsoft.com/kb/266277/en-us

I am using ADP's. Also, I did try 2 separate computers with the exact same results. I'm thinking that it is somehow in my connection string. I just don't see how. I have to qualify that this is my first Access project - SQL attempt so I probably just don't know what I'm doing. My connection...

I'm just getting started using access projects. I am the owner of a Database on a SQL 2000 server. I can connect to the database and view the tables through access. I can even create and drop tables using SQL CREATE TABLE and DROP TABLE through ADO commands. But I cannot edit anything using...

Open the subform in design mode, highlight every control in the row, Click Format->Conditional Formatting. Use Expression type. Enter [RemovedP]=-2 and set the formatting for that condition. Jesse

Set a reference to DAO then something like dim dbs as database dim rst as recordset set dbs=CurrentDb set rst=dbs.OpenDatabase("SELECT * FROM YourTable") if(rst.RecordCount<>0)then rst.MoveFirst do rst.Edit 'Do cleanup stuff here rst!FieldName="What ever should go...

Try changing Me.Form.Refresh to Me.Form.Requery. I think Refresh just tells windows that the form needs to be redrawn, Requery does just that, reloads the forms data based on its current Recordsource jesse

The 2nd problem is the same as the first, just a different data type. this DLookup("date", "Tbl_bank holidays", "Date=" & counter) should be DLookup("date", "[Tbl_bank holidays]", "Date = #" & counter & "#") Critera strings need to be built according to the data type of the field you are...

Hi I've done every search I could think of, but haven't come up with a solution. I'm having a problem with file system security settings of windows 2000. I have a FE/BE database setup, the BE is stored on a network drive that all users have access to. The FE is stored in the same spot on every...