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

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

Nope that did not work..All other rows in the column with 4b, 4c as values work fine.... Actually the template is another problem...this is not exporting to a template...just a plain excel file.

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

I was able to Install it on a 2000 workstation...My question was if there are any problems that anyone might have using these office apps in the long run.......

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