Search results

Hi there Sorry if this is a 'n00b' question. I have a text box on a form that I want to make visible or invisible by clicking a button. This is my current code: If Me.txt4Comments.Visible = False Then Me.txt4Comments.Visible = True End If Exit Sub ElseIf...

Hi all Im currently trying to set validation rules for a form using VBA, does anyone know of a good method of doing this as i'm a bit stuck:confused:

Hi All, still having problems with the higlighted code, does anyone have any ideas? Private Sub cmdSaC_Click() Dim strSql As String Dim rstSaveTemp As Recordset 'Dim dbs As Access Set dbs = CurrentDb MsgBox "Are You Sure you want to save and continue this form at a later date", vbYesNo...

That worked cheers Ken, Im now getting a runtime error from the highlighted line, any ideas?

Hi, Im currently trying to write code to save records to a temporary table. This is the code I have so far: Private Sub cmdSaC_Click() Dim strSql As String Dim rstSaveTemp As Recordset Set dbs = CurrentDb MsgBox "Are You Sure you want to save and continue this form at a later date"...

I'm very fond of mine Private Sub Numpty_Click() MsgBox "If you click this you are a numpty", vbOKOnly, "Numpty" End Sub

Hi all, i'm new here and I have a query about a database i'm building with which any help would be appreciated. I'm designing a form and I need to be able to have an option to save to a temporary table for retrieval by users so that they can continue their saved record at a later time. Does...