Search results for query: *

Hello, Any one can tell me why I can not delete more than about 100 records at one time? Requirements: I have two databases one is the current and other is archive. I want to select old records from the first DB and dump them in the second DB. So first I am running a query that appends all...

Hello, I am trying to run a query that pull all the records base on an entry a user make on a form. for example. Consider selecting all records where multi OrderNo entered by the user on a form seperating them by ; . I am using the select statement below but getting no result. if I enter one...

Hello, Is there a way to run crystal report by clicking a button on microsfot access form? Please advice Thank you.

Hello, I am trying to run a crystal report from the code. is there a simple way to do that? thank you in advance.

I have a simple query attached to my combobox and bound to hidden column 1. this query retrieve around 22,000 sorted records. when I type a name it search and retrieve the record then display it on my form. Consider I have the data below: ID first name: --- ------- 1 bob 2 jerry 3...

Hello, I am trying to enable some fields on my form if some criteria in my query is valid. However I am getting error 3061 too few parameters: expected 2. for simple explanation, I put two fields abc & xyz on my form, and onloading form I am calling sub to enabled these fields if they match...

I have master/detail form type. on my detail section I have control tab. on one of these tabs I have the subform. for simplicity I called the master form x, the control tab y, and subform on tab is z. I am trying to set the allowedit property to false on the subform if the user who login is not...

I have master/detail form type. on my detail section I have control tab. on one of these tabs I have the subform. for simplicity I called the master form x, the control tab y, and subform on tab is z. I am trying to set the allowedit property to false on the subform if the user who login is not...

Hello experts, I want to print the same label in the detail section as a rows using For/Next command. If for example my bound field on a form has a value of 5 then I want to print 5 labels and so on. Any Ideas? Thanks in advance