Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by FirstDirk
-
Using String to Set User Password
hayo, I tried your code, but sorry it doesn't work under Access 2000 cause of the dim wsWorkspace as Workspace. The rest i think is ok. -FirstDirk- FirstDirk
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
NOT PRINT RECORD RE VBA CRITERIA
I don't know what the logical AND of these fields will receive, but I would prefer this : if not IsNull(me.PO_BOX) OR not isNull(Me.STREET) then print xxxx endif - FirstDirk- FirstDirk
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
add an optional box in to form from vba code?
xq you can try this : in your form you create several boxes a1,a2,a3,... but all .visible = false strSQL="select field1 as a1, field2 as a2 ... (dynamic) from tab where ..." ' what ever you want. depending on the fields you select you do a1.visible = true a2.visible = true...- FirstDirk
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Parsing string constant with " in sql query
simma, in my programs I tried this : Dim strSQL As String Dim Dlm As String Dlm = "'" If InStr([Field2], "'") > 0 Then Dlm = """" strSQL = "UPDATE tab2 SET Field2 = " & Dlm & _ [Field2] & Dlm & " where field1 = " &...- FirstDirk
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
