Recent content by tlaksh

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 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 actual text file looks...

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 am trying to import in character seperated values, seperated by commas. The problem is with Report headers repeating in each detail line. 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.

The statement works with Like but then when a combo item is chosen it also includes anything that looks like this item. for eg. if the combo item chosen is 16 and we have say 167 in the table it displays result for both. Thanks Lakshmi.

Thanks Steve ..it worked Lakshmi.

I tried that but it does not seem to work. I am adding it in the query's cliteria along with [Forms]![Parameter_queries]![Combo1] & "*" but it still does not show records for all the options in the combo box 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.