Search results

Hi, it is a very simple issue to show the logged user name in the current form, I have user login form, when I click the button and the code checks the password and user name is meeting the condition then the login form will be hidden and the main form will show, then i have a unbound combo box...

Sa7ar, if you can put your tables, queries, form in a sample database and upload it here so maybe we can connect it together for you and upload it back, but before that you said you don't know how to connect queries to your form, after you click the button in the form properties to link your...

Hi, if you are using windows 7 maybe you can use snipping tool to snap shot some images for your errors, and upload it here then I can see it and I could figure out what is exactly happening Regards.

Hello Stu_C find attached a sample database I made ready for you, the Content are: Module1, Class Module, AutoExec Macro, just Import these into your database and the X button of Microsoft Access will be disabled, you can still close access by going to File Menu Exit, I assume here you hide the...

Resolved, Check the attached DataBase, I hope that is what you are looking for. Regards. :)

Berg I will keep you company until you solve it Would you please upload the table and the form in separate database here I will fix it up and attach it back to and explain it

Nope it shouldn't make any difference because codes work in both Can you kindly attach you form in here maybe I can test it

Ok then for sure you have button in your form to add new record then you can add this line to your button code at the end of the procedure Me.YourComboBoxName = "n/a" Then go back on your form and add this line on your on current form event If IsNull ([AnyMaincomboName]) then...

Why don't you add extra field in you table and call it user level then identify each user as admin or user then you can create a button which holds the code to populate a form with password and then on that form you can have more buttons with on click event coded to show or hide the access...

Check the combo boxes format As the rate combo box should be currency and the hours combo box should be numbers and the total combo box should be currency also the default value for each combo box should be (0) if you set the proper format for each combo bos then it should work, because Access...

Hello sa7ar As Swemebegur you can have one table indicating the status of the product Then you need to create two queries the first query is registered_product_identification_query and the second one under_registration query then create a form showing the first query data then create another...

Hi Devon If you are using jpg images then maybe your image resolution is too high then you need to open the image with photoshop then go to image menu then image size and set the resolution to 72dpi that could keep the image in good resolution and give the ability for Access to load it faster...

One question berg Are you setting the form to view as form view or as datasheet view?

You are most welcome And as far as you understood what I wrote then that means you know what am talking about anyway access will never perfume out data by magic you have always to plan it simple and insist on access to do it by telling him so many thing and direct your codes as your magic tools...

why don't you try this, Me.lblRefresh.Visible = True If Me.lblRefresh.Visible = True then GoTo strtCode End If Exit Sub strtCode: Dim ctl As control For Each ctl In Me.Controls If ctl.Tag = "RefreshStats" Then ctl.Requery End If Next ctl Me.lblRefresh.Visible = False it looks wired but...

You can also try to use the requery command Me.requery but be careful when you use the requery then your record will go back the first record as it will requery the whole table you have then to create another code to bring you back to the current record and that is easy you need to create...

Have you wrote the me.refresh on the after update event or the code itself, because If you write the code itself on the after update event then it must update the combo box as per the code values.

Hi, can you be more specific, are the tables related to each other? did you create any relation as One to One or One to Many on them, or they are stand alone tables? do you have them on the same form as a master link table and Child link table? if you can attach some images or explain more then...

I think if you explain more about your query or if you attach some images here it will be easier, one more thing you must plan it logically because if you are doing it without a proper math calculation it won't work, anyway I couldn't really figure out how you want to calculate it attach an...

Ok Mate, I almost understood what you want to do, but as I have seen that your sales can login without a user name and password I think, here is the key, to be able to work fine with the database you must have a users table, in the users table you can specify their level and from there they can...