Search results for query: *

Thanks cjashwell! Worked perfectly! A star for you. I'm used to using SQL and forget that I can easily go through the jet.

Try adding .edit just before you loop and after the with statement.

I'm trying to drop the Default on a field in my MSACCESS 2000 table Here is my Code: dbs.execute "ALTER TABLE tblJobs ALTER COLUMN JOBNoOnFile_R DROP DEFAULT" I'm getting syntax error and don't see why. Does anyone know what I'm missing Thanks for your help, LaDeana

I have a query which uses a formfields as it's parameter. I can use code to open this query docmd.openquery however, when I try to set it as a dao recordset, I get "Too Few Parameters expected Expected 2." I am using txtfromdate and txttodate from a form and the query runs great even in code...

I have some old foxpro 2.6 tables which need to be linked to my access db in code. I have an ado connection string which works for me to access the tables: "Provider=vfpoledb;" & "Data Source=W:\testf;" & _ "Mode=ReadWrite|Share Deny None; Collating Sequence=Machine; Password=''" Can I use...

I have developed a database with a sql server 2000 backend and now need my mac users to work with the data. Does anyone know if there are OLEDB drivers available for sql server which are compatible with Excel x? I would need to run stored procedures from Excel. Has anyone successfully used...

If you use the expression builder, the "«Expr»" should be replaced with your expression. Try: =IF(ISTEXT([Text56])=TRUE;"";IF( [Selling Price Wholesale] <>"";IF([Selling Price Wholesale]< [Text51];[Text51] * [Text56];[Selling Price Wholesale] );[Text51]*[Text56])) Also, you may want to name...

Thanks for your suggestion. I posted it on their forum but they suggested to add pks to the table, which I'm unable to do. Thanks

The keys are maintained in the cdx files. They are running all our production data so changing any data structure in these tables may result in horrible problems which I wouldn't be able to fix. Thanks so much for reading my post. If you have any other suggestions please send them along! I...

I am trying to link foxpro 2.6 free tables and their indexes in msaccess through code. (.dbf file and it's associated .cdx file) I'm able to link them using dbase IV however, the indexes will not update when deleting or adding records. I have tried to create an inf file which points to it's...

I am trying to link foxpro 2.6 free tables and their indexes through code. (.dbf file and it's associated .cdx file) I'm able to link them using dbase IV however, the indexes will not update when deleting or adding records. I have tried to create an inf file which points to it's cdx index...

I know this is an older post but I found if someone else stumbles on this as I did try to change the SET statement to: Set rsMaster = CurrentDb.OpenRecordset("Select * from T-Promos") It worked for me.

Try inserting your page break as a &quot;next page section break&quot; instead. This will let you have different headers and footers.