Search results for query: *

Hello, I am trying to keep users from accessing the tables in a MDB file that I have created. I would like to make a password in a small form that I would be able to put a password in that would allow me to change a password in a protected table. Theoretically, this protected table containing...

Thank you. I was able to go back through the program form by form to isolate the problem. I have been making changes, saving, then creating .MDE files to make sure that the file is able to be made into a MDE file. I have found that when there were problems in the code that I may have not...

Thanks, This is the code that worked. Thanks for everyone's help. strSQL7 = "SELECT [Vouchers].[VoucherNum], [Vouchers].[BatchNUm], " & _ "[Vouchers].[VendorNum], [Vouchers].[Payto], [Vouchers].[Address]," & _ "[Vouchers].[Address2], [Vouchers].[City]...

I have an MDB that I recently converted a majority of the queries into VBA code within each form. All the converted queries have been converted into public or private sub procedures with DoCmd.RunSQL "name" as the format. I wanted incorporate these queres to create an MDE file so others...

Thanks for your responses, they have been very helpful. My next related challengs is as follows: Seven tables (called Line1 - 7) were created from the same DB, all having the same structure. I have been able to merge the tables (into table "Merge") together with SQL by performing a union...

I have looked in many books and performed numerous internet searches on how to write queries in VBA. I have not been able to successfully manipulate any of the examples nor could I debug the program code appropriately. When I use the examples for differnt types of queries, the result is the...