Recent content by Scythed

Thank you both very much for your help I did some tweaking and messing around and I think I have it working :)

Nevermind I figured it out, it was a typing mistake when i Set rstSales... :(

Yeah I would have learnt this for myself but our teacher has barely even taught us how to do sql queries properly, he is more of the type to sit back and say have at it. Which is fine except I need a little bit of guidance at least to do stuff in something like VBA. Also this is for high school...

Thank you very much for your help I figured it out stupid me I forgot to rename the user input :P DCrake security really isnt an issue for me because its just a school assignment. Security is just a little bonus in marks, not a ground breaking thing in terms of being beaten etc. Do any of you...

I am trying to use this script to act as a security feature so that you have to login, but it is giving me a Compile error - Method or data member not found. If anyone knows what the problem is I would really appreciate it. Thank you. Private Sub Login_Click() Dim strUser As String Dim strPWD...

Can anyone please tell me what this means. I am getting an error whenever I try to run this bit of code. It is giving me the error during the indicated line. Dim dbCarpetDatabase As DAO.Database Dim rstSales As DAO.Recordset Set dbCarpetDatabase = CurrentDb Set rstSaless =...

Ah nevermind thank you anyway i set the allow value list edits to no and that works, ta.

When I do that it gives the person the option to edit the items in the list, is there any way to disable that? Or make it so they just cant type anything in?

Does anyone know of a way to make it so that you cannot type in the combo box, only select the option? Thank You if you reply.

Thank You very much it worked

Does anyone know if there is a way to make a placeholder for an image so whenever you select an item in a combo box it changes to an image of that item stored in a folder?

Thank you for your reply, I did not really understand what you meant but I have simplified the process somewhat using your help. Thank you very much.

Thank you very much

I am attempting to write a delete query so that once you select an item in a combo box and then hit the delete button, it looks for the Item you have selected then deletes it from a table. This is what I have at the moment but when I run it a popup appears, treating the DeleteUserCombo part as a...

Edit: Nevermind I just removed the square brackets and the acNormal part. Thank you. I tried that and it seems to have fixed that problem, but now I have another one. When I type the username and password in it tells me that the form name '[Browse Menu], acNormal' is misspelled or refers to a...