Recent content by miow

hi thanks to both remou and ssatech I will give them a go and let you guys know how I get on. Thank you! Miow

Hi there I have been wrestling all day to just try and simply sum up some fields on form and can't see where I am going wrong. Any help would be greatly appreciated. Details: I have 2 forms. One form has the following information: item no unit price quant totalunitprice The...

hi crowley16 Your suggestion sounds like what I would like to do. I have already got a table with usernames and passwords. How do I create a table with permissions on forms, meaning how can I set permissions on forms myself and not user built in access security. thanks for your help in...

Hi VicRauch Thanks for the work around, I will take a shot at this and let you know how I get one...oh sometimes these standard access messages can be annoying! thanks Miow

Hi I am trying to find out the error code for the standard Access message of "You are about to delete 1 records, are you sure you want to delete this?". This is presented to a user when they try to delete a record. I want to trap this error so that i can find out what the error number so that...

Hi there Thanks to Melegan and ItishardtoProgram for their suggestions. I will give them a go and let you know how I get on. Much appreciated... Cheers Miow

Hi there Yes I do login using the built in Access security user level permissions. My query is that the login box is very simple and I would like to present the users with a nice login form instead of the very basic login box that Access presents to the user. Thanks in advance. Miow

Hi there I hope you guys can help out a newbie. I have an access database that has several forms that only certain users can do certain actions on e.g. add information, delete information etc. I have set up Access user level security to assign the right permissions to the forms based on...

Hi there, FOR ZION7 I have worked out why I was getting the error about combo box and the values, it's because i had created a bound combo box which was attached to my tblCustomers. Reading some other websites I see where I went wrong I had to create an unbound combo box and attach the query...

Hi fneily and Zion 7 thank you for your kind advice and helping to get in the right direction. FOR FNEILY I did have a slight issue with fniely's suggestion as the customer_input_name and the frmCustomer both had to be open, I also think I went somewhere wrong with the one of the steps. One...

Hi there I am a newbie trying to be adventurous with my Access database...my query is how to locate a record based on user input. Details: I have a table with customer information with each customer assigned a unique customer ID number. I want the user to be able to search through the table...

Hello fneily...you really have been my saviour today. I kept reading about those form properties but just couldn't find them!! Thanks your directions worked a treat. thanks again. Cheers ;)

Hi there Thanks for your reply...I have been looking for these options all day and can't seem to find them. I am obviously suffering from Access overload ;) On the ALL tab i cannot see any of these options....:( I assume you mean go the properties of the form in design view? Cheers :)

Hi there I am a newbie to this forum and I hope someone will be able to help. It's probably a very simple problem I am experiencing. Basically I have a form called "Maitain Customer" which is an unbound form so doesn't reference any data in any tables. I want to create 3 command buttons on...