Search results for query: *

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.

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, Thanks PH. it helps in a way that I have to make MyQry generate new table called MyQryTbl as shown in my query below. is there a way to run my Select query instead of Make table query directly without generating new table? below is my Code. ... Thanks again. Private Sub Form_Load()...

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

Thanks for the details, however; if I use Onload from the subform itself the Me.Allowedits works, but when I call the function from the main form it does not. my requirement is that Onload from the main form x, I am calling a global function to disable record editing only on my subform z. I...

Thanks you all for the details, however; my requirement is that Onload from the main form x, I am calling a function to disable record editing only on my subform zFrm. I tried all the command below with no luck. Form_z.Form.AllowEdits = False Form_z.AllowEdits = False z.Form.AllowEdits =...