Search results for query: *

How can I make a field required only if a check box is checked. Thanks Lakshmi.

I am using the following command to export data DoCmd.TransferText acExportDelim, "HourSpec", "HoursData", filename, True When I run the query HoursData the following result is displayed on screen Actual DOLLARS.INPUT 1000111TA 61056 01420000 d 20040011 15.50 but the...

I have the following code on the click event of a command button in Access. It works fine except there are messages that pop up in excel regarding overwriting and saving in CSV format. Is there a way to supress these messages? =========================================================== Private...

Is there a way that I can export a query in Access into comma delimited text file? Thanks Lakshmi.

I have a report in crystal 7.0 that I am exporting in chr format. The problem is that the report header repeats in every detail line. In the preview the report looks ok. Is there a conditional way to avoid this? Also the report has " as delimiters. How can I supress these? Thanks for all ur...

I have a report in crystal 7.0 that I am exporting in chr format. The problem is that the report header repeats in every detail line. In the preview the report looks ok. Is there a conditional way to avoid this? Also the report has " as delimiters. How can I supress these? Thanks for all ur...

I have a report in crystal 7.0 that I am exporting in chr format. The problem is that the report header repeats in every detail line. In the preview the report looks ok. Is there a conditional way to avoid this? Also the report has " as delimiters. How can I supress these? Thanks for all ur...

I have a crystal report that would export data to chr format. I need to be able to do this at the press of a button on a access 2000 form. Shell "e:\hours.exe", vbNormalFocus only opens the exe and then the user has to choose export options. Is there any way to pass this from access while...

I want to be able to open a master detail form in read only mode when the form starts up so that the user cannot change data by mistake. If the change the data mode property this disables the add & delete buttons. Also how do i get the user to edit mode if required. Please help Thanks Lakshmi.

I have a query that has a where clause & get its value from a combo box. I want it to show all records if nothing is selected in the combo box How can i achieve this? Please help. Thanks Lakshmi.

Is there a limit on how many records a access database can hold?. I tried to link and import a excel file with 50000 rows and all I can see in access is 16383 rows. Please help...I am using Access 97

I am using the TransferSpreadSheet Method to transfer information from a Access Report to Excel. I use a query in access for the information. But there are column data on the report that is changing value in excel... for example a col with data 4a is changing to 1.666667. Why is this...

Is anyone aware of issues with installing office 97 on a w2k workstation. Please let me know Thanks in advance Lakshmi

Can someone tell me how I can uninstall Service Pack 3 & Install Service Pack 2 on a MS SQL 2000 Server. The Service Pack got installed automatically when I installed the SQL Database Server. But to run my application I need service pack 2 only. Any pointer will be great help... Thanks...

I am trying to install Crystal Reports 7.0 on a NT w/s. This is the error that I get While registering OLE servers, Setup had a problem with REG.DAT, SHELL.DLL or disk space The installation then aborts. Any idea why? Please help Thanks

I have Pervasive 2000 database. I am trying to link one of the tables to Access 97 so that I can insert data into one of my access tables using insert statement. I was able to link the table in access using ODBC data source & see the information. Now here's my problem....The date column in my...

I am new to WINAT so this may be a silly problem. I am using winat to run a bat file once a day. This bat file is supposed to open a file on the server & do some processing.The server has been mapped to e:\ drive. Now this is the problem. When I open this file stored in the c drive it work fine...

I have a Win98 and powerpoint 2000 loaded on it. I have a presentation that of 10MB. For some reason when I try to open this file on my computer it hangs up. I have checked for virus, and also my startup menu is clean. I have 5 GB hard disk with more than 1/2 free space and 320 MB Ram. Why is...

I need to run this SQL from a OSQL command. DECLARE @dt varchar(100), @cmdd1 varchar(1000), @cmdd2 varchar(1000), @cmd varchar(1000) SELECT @dt=(convert(char(20),DATEPART(dd,getdate()))) EXEC master..xp_cmdshell 'cd\' SET @cmdd1 = 'DEL C:\script\Archive\'+@dt+'*.prn' PRINT @cmdd1 EXEC...

I have the following code. When I run it through SQL Query it runs fine, but it does not run through a dts. DECLARE @dt varchar(100), @cmdd1 varchar(1000) SELECT @dt=(convert(char(20),DATEPART(dd,getdate()))) SET @cmdd1 = 'DEL \\C1467\script\Archive\'+ @dt+ '*.prn' PRINT @cmdd1 EXEC...