Search results for query: *

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 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

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

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...

Hi All, I'm trying to look at two fields using recordsets and if the number is less then 7 places put 00 in front of the number. ex. 12345 would then = 0012345. The datatype in the database is Text. It would iterate throught the table to see what records needed to be changed, update them and...

Hello, I just started learning vba not too long ago and I'm doing this project. What I have to do is import a table named ImportTable into the Project Master File table, but only updating the records in ImportTable that are different then whose of Project Master File. 'open the database and...

I'm importing data into an Access 2000 database from Excel 2000(comma delimiter Text File). The problem I'm having is that my field customer ID 0010002 when importin into access it chages it to 10002. I've tried ever datatype. If anybody knows anything that will keep the zeros let me know...

Im trying to use the Common Dialog Control in Access 2000, but when I create it on the form it gives me an error: The OLE server isn't registered. To register the server, reinstall it. I have been at this one all day! I have references it in my vba toolbar but still no go. Is there away to fix...

I'm trying to program a browse button where you can select a program on your hard drive and output the path/filename to a text box. I think I need a control to do this but not sure. Someone Please Help!!!! Dutt

Can someone please help me in detail the process to import data automatically from a text file to an MS Access 2000 database. The import not only has to import data, but update the fields that are needed to be modified and leave other data unchanged. I was looking at doing it with VBA with SQL...