Search results

So in practicing with this code building, I've recreated the same code, but have basically reversed the action which is to make the fields blank on a button click. (deleting the info from the tblcutsheet) I believe my code is right, BUT get an error on the CurrentDB.Execute string... Private...

Thanks arnelgp, I appreciate it. plog, you as well. I'm certainly not afraid to learn, and I DO study the difference between my code, and the ones offered to me for the next time. There is a balance.

Okay, so I understand the fundamental. The code is below, but I feel I've got way too many or not enough commas? Private Sub Command82_Click() Dim strSQL As String Set strSQL = "UPDATE tblCutSheet SET Customer_Name = " & Chr(34) & Me.Customer_Name, & Chr(34) & " WHERE Account_Number = " &...

Thanks for the feedback. I took a look at the website you posted, but because of my unfamiliarity, I don't quite know how to arrange the code to do as you suggest. I see the SET and WHERE, but don't understand what to actually do with them...

Good Morning, I'm an amateur when it comes to code. I have two strings that work, but they won't work together. I have Dim strSQL As String and then two strSQL statements. Only one will work, the other does nothing. How can I combine them? They both work, but not together. I can't come up with...

Perfect! Thanks again!

So place that (either) of those codes directly underneath the other code on my click event?

I hate to even ask, but is it simple enough to reverse this when I untoggle the same box/button? Basically, make that account numbers 'text box' become blank if they're no longer in service?

This worked like a charm. I'm really impressed. Thank you very much, it is much appreciated!

The account numbers DO exist, so this might help. When you say update the data directly in the table, what do you mean? Where do I place this code?

Ahh, got it. Is there any way for the form to reference the account number associated with the cut sheet form? As it stands now, that code works, but replaces the acocunt # 1 in the first record of the second form rather than placing that text in the corresponding account number box...?

Thanks for the reply! I'm getting the following error. That IS the name of my form, yet it isn't finding it?

I've created two forms, and need the toggle (Yes/No)button to be able to fill in another form with two pieces of data from the form that has the toggle. (See attached example) I've manually filled in the Customer and Phone on the 'Cut' Sheet from the 'Customer Data' Form. Is there some sort of...

Sorry for the late reply, thank you! I've taken your advice!

Good Evening, I found a code from another website, that will show you the Computer/UserName/Connect information of all users within the database. I'm not much of a programmer, and was wondering what type of code I need to put where to get this particular code to be able to capture which user...

I learn something new every post. Literally. Worked like a charm, and makes sense. Thank you. Very much appreciated.

Good Morning, I created a query that will give me a list of information from a few different tables based on an employee. I've run the query, but it doesn't return ALL of my employees. The data it does return based on employees I do see, is accurate. Any ideas? I've attached a screen shot...

This makes sense. I'll be sure to check that out, and then give it a test. Thanks for the feedback. -J

Good Morning, As I build my first database, I now realize that I may have missed a crucial step. I've created a database centered around my employees. I have created various sub-forms and tables with pertinent information that relates to incentives etc. I've always had in mind that I would...

After reading your post, I now get what you're saying. Self teaching myself. thanks for your help! This worked.