Search results

Thanks a lot man. It works! I really appreciate it.

Hey, I have a message box that I am needing to program. It is a yes/no message box. Here is the vb code so far. Private Sub btnSemester_Click() RetValue = MsgBox("Are you sure?", vbYesNo, "Confirmation") End Sub I need to program this so that when the user clicks yes it will clear all the...

Well to be honest I think it is a bad idea. But the sponsor for our project doesn't want to keep the data after the semester. The database is for a "Biggest Loser" competition among the staff and faculty of my university. Our sponsor doesn't want to save any "sensitive" data.

Is there a way to program a yes/no message box to clear all the fields in a database? If so I'd really appreciate some pointers... Thanks...

Is there a way to program a yes/no message box to clear all the fields in a database? If so I'd really appreciate some pointers... Thanks...

Hey everyone, I am working on a database for a "Biggest Loser" competition. I am trying to make a report that will take all the weights of people in a certain team from a certain week (there are 8 fields for the 8 weeks of the competition) and get their sum and then display the information in...

OK i tried that but it is still doing the same thing. I'll just post the entire module here. Thanks again for the help. Let me know what needs to be changed. Private Sub Week1_AfterUpdate() ' Declares variables Dim UserID As String Dim Week1 As String Dim...

I have a database that I am working on with a group, and we are having a hard time with some of our VBA code. We have set up a form that is used to update a certain field in a table. In the code we have setup the variables and they are all containing the correct information however in the SQL...