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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: miow
  • Order by date
  1. miow

    Summing Fields On SubForm

    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
  2. miow

    Summing Fields On SubForm

    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...
  3. miow

    Database security - creating login form/assigning user roles

    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...
  4. miow

    Trapping standard Access messages

    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
  5. miow

    Trapping standard Access messages

    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...
  6. miow

    Database security - creating login form/assigning user roles

    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
  7. miow

    Database security - creating login form/assigning user roles

    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
  8. miow

    Database security - creating login form/assigning user roles

    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...
  9. miow

    VBA Access - Finding a record based on user input

    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...
  10. miow

    VBA Access - Finding a record based on user input

    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...
  11. miow

    VBA Access - Finding a record based on user input

    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...
  12. miow

    Access Data Entry Form - Open Blank Form

    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 ;)
  13. miow

    Access Data Entry Form - Open Blank Form

    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 :)
  14. miow

    Access Data Entry Form - Open Blank Form

    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...

Part and Inventory Search

Back
Top