Recent content by ruru9292

This statement works and generate my new table. thanks a million for all who help out.

I did change it to command below and still not making new table. again if I open my query and run it it generates this table with no problem. db.Execute strSQL

Okay Here the actual code and debug result for two entries only on the form. Private Sub Command3_Click() Dim cn As DAO.Database Dim rs As DAO.Recordset, tst As DAO.Recordset Dim StCr, Crt As String Dim strSQL As String Set db = CurrentDb Set rs =...

I am using the method above because I tried to use this statement below and did not work. every time I add it on my query criteria line it automatically changes the 0 to "0". I welcome any other method that will do multi selection. WHERE Instr(";" & [Forms]![myform]![UserEntry] & ";", ";" &...

I tested the query on another computer and it works fine. it seems there is some issues with the memory size on the first computer. Thanks

Hello, I am trying to pull mutiple order from MyTbl and make new table Called NewTbl based on entries a user can type on a continious form. This form is bound to table called MySelectTbl. The user types on each row one order #. I am using the code below to read all the entries the user enter...

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

Thanks for the tips

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

Thank you Vidru, that link helps.

Thank you PHV. I was able to open the report, but in a design view. Is there a way to let it run once I pass this command Application.FollowHyperlink "\path\to\report.rpt? Thanks again.

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.

Thanks Roy-Vidar for your Link. It helps a lot.

Thanks Willir. The link works great.