Search results
-
P
Copying Table
That depends on your interpitation of easy. You already have an ado recordset with the foxpro data. You can open an dao recordset of a new access table and copy the records. dim db as dao.database dim rsB as dao.recordset set db = currentdb() set rsB =...- pajamasw
- Post #2
- Forum: Modules & VBA
-
P
How can i add macros into form which I had created through VBA
Can I ask why you need to create the from dynamically?- pajamasw
- Post #2
- Forum: Modules & VBA
-
P
IN
Use a case statement. Here is a copy of the Access help for "Select Case" Select Case Statement Example This example uses the Select Case statement to evaluate the value of a variable. The second Case clause contains the value of the variable being evaluated, and therefore only the statement...- pajamasw
- Post #3
- Forum: Modules & VBA
-
P
Passing parameters to a report based on a query
Sorry, I misunderstood the HTML/UBB info on the page. Here is a plain text version. To pass vb parameters to any type of query, here is what I have developed. First create a global variable in heading of any module such as: Public strFirstName as String Then in the same module create a...- pajamasw
- Post #5
- Forum: Modules & VBA
-
P
Passing parameters to a report based on a query
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <meta name="GENERATOR" content="Microsoft FrontPage 4.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <title>New Page 1</title> </head> <body> <font SIZE="2"> <p>To pass vb parameters to any...- pajamasw
- Post #4
- Forum: Modules & VBA