Search results for query: *

Thanks Man...works like a charm!

I'm trying to find out which tables in my DB don't have an index. Is there a select statment I can run that will give me a list of tables without indexes? Cheers

I get the error when I try both examples: Arithmetic overflow error converting numeric to data type numeric. The statement has been terminated. Is there a way to do it in a Update Statement? Cheers, Justin

I have a table called table1. It has a column called column1 and the datatype is numberic. Each record in that column has a trailing ".00000". I'm trying to build an update statment that will trim off the .00000. Any help would be great! Justin

Hello, In CR 8.5 I compiled a report to make a .exe and .crf file. The report itself is landscape, so when I execute the exe and print to a windows the report doesn't show up in landscape. Is there a setting that controls this? Thanks

Thanks Jeff I'll give it a try!

Hello, I'm having some trouble trying to get a Word 2000 mail merge to automatically insert the data from it's data source(TAB-Text file)when the file is opened. I know you can do it in VBA, but I was wondering if there is a way to do it in the mail merge wizard that I missed. Thanks for the...

I am trying to set up a mail merge document that when I open the word doc it will automatically do the mail merge in that particular file not open another. The merge would get the data from an outside ODBC text file. Anyone know how to set this up? Thanks Dutt

I'm trying to find the sum of a formula I have created in CR 8.5. I'm getting an Error message: The summary/running total field could not be created. code: sum(@formulaName) @formulaName = abs(@Def) @Def = field - field If you can help it would be greatly appreciated! Thanks

Hello, I'm starting the documentation part of my program at the present time and am having a little bit of trouble trying to Print screen the form. How do you Print screen JUST the form and not the whole desktop??? Thanks

...Set xlbk = xlApp.Workbooks.Add Set xlsht = xlbk.Worksheets(1) Set mydb = CurrentDb() MySQL = ("SELECT * FROM [Table Name]")'Enter Query Here 'Open the recordset with the mySQL Variable Set myrec = mydb.OpenRecordset(MySQL) myrec.MoveFirst...

Thanks a bunch! I didn't see it at all. Now that you point it out it makes perfect sense. I have only been programming for less then 6 months, thanks for taking the time to help!!!!!

...Manager" 'make counter = 2 -->1st line is teh headings x = 2 'Set query in the variable MySQL MySQL = ("SELECT * FROM [Project ID Master]") MySQL = MySQL & " WHERE (([Project ID Master].[Project Start Date]) " MySQL = MySQL & &quot...

...Manager" 'make counter = 2 -->1st line is teh headings x = 2 'Set query in the variable MySQL MySQL = ("SELECT * FROM [Project ID Master]") MySQL = MySQL & " WHERE (([Project ID Master].[Project Start Date]) " MySQL = MySQL & &quot...

Thank you very much for the help!! Everything worked out great! Dutt

...one should I use: txtSDate.SetFocus SDate = txtSDate.Text txtEDate.SetFocus EDate = txtEDate.Text Set rstMaster = dbs.OpenRecordset("SELECT * FROM [Project ID Master]" _ & "WHERE (([Project ID Master].[Project Start Date]) AND (([Project ID Master].[Project Close Date])...

So if I only want to create the query in code and export it in code what would I have to do? Would the code look like this: 'open database Dim db As DAO.Database Dim qryRDT As QueryDef Set db = CurrentDb 'set the dates the user entered into variables txtSDate.SetFocus...

Hello All, I'm trying to export a Query from a Access 2000 database to a Excel spreadsheet. The user will enter two dates that he/she would like to the data between. EX. All data between 10-Aug-01 To 20-Aug-01. I'm not really sure how to go about doing this, I'm relatively new to VBA. Here is...

I figured it out, my Table had the wrong name Thanks ide Dutt

Thanks Aivars, Everything worked out great with the control! Thanks for the help Dutt