Search results

Thanks for the reply:) i have tried that but it doesn't really do what i would like. Datasheet view is perhaps the closest, but any editing would require a lot of clicking by the user which I'm trying to avoid. I was hoping for a simple continuous form with a list of check boxes for each...

My Pleasure;)

Oh I see Try this code then in the click event of the button: If fsub1.Visible = False Then fsub1.Visible = True Else: fsub1.Visible = False End If Just substitute the "fsub1" for the name of your subform.:D

I can't seem to find a way to solve this problem:confused: I'm working on a database to run my window cleaning business. I have a customers table which contains all the details for each customer ie address, name etc. There is also a Jobs table which will contain a record every time a...

Try this code in the VB editor of your button click event: Dim strCopiedText as String strCopiedText = txtBox1 txtBox2 = strCopiedText End Sub Just substitute the "txtBox1" and "txtBox2" with the names of your 2 text boxes.:)

denileigh, the easiest solution is to make sure the toolbox wizard is on while putting the button onto your main form. it will pop up with a number of options, one of them being opening other forms. Once this is done, you can go into the VB editor for that form and copy the code to open other...

Ok, just seen the message didn't quite come out the way it should, but hopefully you can make out what I mean.:) Can anyone help? Please??

Hi guys hope you can help:) In my database, i have a list of addresses which are grouped into different areas. The user will need to visit each area separately and go to all the addresses on the list. My problem is creating a report of the list of addresses in a particular order that the user...

Hi I have the following tables in a database: 1) Customers 2) Employees 3) Suppliers 4) Contacts The contacts table contains all the names and address info while the other tables contain specific info related to customers, employees and suppliers. I want to link each of those tables to the...

Actually, I've just solved the problem. Here is the solution that worked if anyone else needs it: Private Sub btnDelete_Click() RoundName.SetFocus Dim strRoundName As String strRoundName = Me.RoundName.Text Dim SQL As String SQL = "DELETE Rounds.RoundName FROM Rounds WHERE...

Hi It is defined as a string in the expression: Dim strRoundName as String and then as the value of a textbox in the form in the expression: strRoundName = Me.RoundName.Text This works fine but I would like the variable 'strRoundName' to be used as the criteria for the DELETE statement.

[SOLVED!]Please help with delete query :confused: Hi all I've created a delete query and I wanted to run it with the RunSQL command. Here is the code: Private Sub btnDelete_Click() RoundName.SetFocus Dim strRoundName As String strRoundName = Me.RoundName.Text Dim SQL As String SQL =...