Search results for query: *

Hi Ken Reay I played around with a few things and got it to work fine Thanks so much on the normal access security theres a option to use current user but the way Im doing it these not I know I'm starting to pick your brain abit to much here but my vba skills are not that good so if you dont...

It works when I have the table linked to the form but the problem is then users can view each others usernames and passwords Is there a way just to have 2 text boxes and then link those to the form Thanks so much for all your help Regards Paul

Thanks for replying I copy your code and changed all the names to suit my field names and it came up with a compile error and high lighted the first line (cn As adodb.Connection) maybe theres an easyer way. On my form there is a section for normal staff to fill in and a section for branch...

Hi all I have just designed a database for my company. but Im having a problem setting up a login screen for users I don't want to use the normal USER and GROUP permissions That Access offers. I acctualy want to setup my own permissions and rights for users. I have created a table with the...

Hi all I hope someone out there can help me with this I created a active server page in Access 2000 This page looks up a customer list whick is storded in an Oracle Table.I copyed the page 3 times and devided the customer list in alphabeticle order from (A-C) (D-L) and (M-L)for each page The...

Hi all I have created a data access page in MS Access 2000 This page looks up data from an oracle database I copyed the htm file and Access database to our entranet server which does not have access on it. What I want to find out is how do you link the htm file back to the access database so...

Anouther solution is to check your cache in the bios if they are disabled it could cause this problem. Try enabling them as I had the same problem a while back. Even when I tryed to reinstall it. The setup would hang on me. I enabled My cache and presto it worked first time. Hope this helps you...

Hi there Ive been creating this Data access page that suspends customer accounts if they have not paid there account for the month We have 2 account managers in the company. What im trying to do is that if the customers amount owed is less the R5000 The 1 account managers name appears at the...

Hi there Try checking if you cache is enabled in you bios If it is disabled you could incounter a problem Like that Cheers Paul

Under each of the questions and answers there is a little sign that says "Mark this post as a helpful/expert post!" Just click on that and you will give them a star Happy to help Cheers Paul

Hi there I suggest the best way to do this. Is buy using Group filter Control Read up about it on the access help menu or assistant It explains to you how to set it up and The explanation is very basic to understand. Hope this helps you Cheers Paul

Hi there I had the same Problem as you guys. But managed to get it sorted out. Data Access Pages where only released in Access 2000 and XP. Im afraid even if you Change you data base to 97 you wont be able to open the Data access pages. What I could suggest is opening the saved Html file (that...

Hi all I worked my own problem out Data Access Pages dont use the same wild cards as normal Access forms. They use ASCI 2 wild cards so in my querie I was using "like(*)" to sort out the Alphbetical order of my customer list and Data Access pages do's not recanise that character...

Hi there I created a data access page in MS Access 2000 pro. The page consists of a combo box that looks up a customer list and inserts the customer infomation into the field text boxes below. When using my table it works fine, but as soon as I use a querie no customer names appear in the combo...