Search results

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

Using that sample that you gave me I tried to snip off some bits and eventually ended up with this. Note: My username in the table is CustomerID. Password is LastName. My username input on the form is CustomerID as well and the Password input is also LastName. Private Sub Command5_Click() Dim...

When I try it using a text box it gives me a result of 0. This is the code I used, same as yours except adapted for my textbox names. Also, do you know how to set the contents of a text box to nothing or null? I want to make it so all of my text boxes, labels, combo boxes etc are empty when I...

What are the advantages of using a textbox instead and how would you modify the code to accomodate it for a textbox instead of a label? Also, Do you know how I can alter that code provided by pono so that it places the value into the label instead of making it appear in a popup? Thank you.

Hi, thank you for your replies. The only problem is I don't fully understand how to link the form to the specific table. Do I have to bind the text box? If so, do you know how to do that? Because I cannot find it in the properties list of the text box. Thank you.

Hi, what I am trying to accomplish is to multiply the contents of a label by the contents of a textbox. Eg. The label is a static number that shows the cost of an item and the textbox is a variable that you can change to the amount that you would buy. I want to be able to find the total cost of...