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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Hello; I am needing to use a vari
Seems as if you want to use a Select Case statement, but I'm unsure I understand exactly what you are doing. You need to list all conditions and deal with each. Select Case rs1!Pigment case "501" amt = rs1(Color) case "505" 'Do this case Else 'Remainder...- KJBarrie
- Post #2
- Forum: Data Management Tools general discussion
-
Create Archive database with same security rights as main database
Access 2000 application, secured with an mdw file. If I create a database in code, with a view to archiving data from some tables, will the tables automatically have the same access rights as the original source tables, or do I need to do something actively to achieve this?- KJBarrie
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
-
Search dates in access
Here are some bits of code that may help you. You can get frustrated until you realise that dates in queries should be US dates: Public Function MakeUSDate(X As Variant) If Not IsDate(X) Then Exit Function MakeUSDate = "#" & Month(X) & "/" & Day(X) & "/" &...- KJBarrie
- Post #2
- Forum: Data Management Tools general discussion
-
Creating a compiled (.mde) Access Database, or NOT!
I have a rather large split Access database that I want to compile to an mde file. I feel like throttling a microsoft programmer, but I don't know his name. All I get is "Cant make mde file" I know about creating a chain of mde's for split databases. If I remove all code I EVENTUALLY...- KJBarrie
- Thread
- Replies: 0
- Forum: Data Management Tools general discussion
