Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Append query
I am using an append query (Query1)to add the name of the current
logged on user to a table using Expr1: fGetFullNameOfLoggedUser() I then have a text box on a form that displays the information contained in the table. All works fine if I run the query, whilst it is in design mode, and adds the name as many times as i click on the red ! mark. In my form I have under the On open an event procedure as shown below Private Sub Form_Open(Cancel As Integer) If fGetFullNameOfLoggedUser = "b******y paul" Then Command50.Visible = True Command51.Visible = True End If DoCmd.OpenQuery "Query1" DoCmd.OpenForm "frm_shutdown", , , , , acHidden End Sub The problem is that the text box remains empty so the name of the current user does not show, i know the query works from what i said earleir, can anyone see where this newbie is messing up ? Thanks in advance |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Append query
Methinks you need to be posting this in the Access newsgroup, not the Excel
newsgroup "Deltic" wrote: I am using an append query (Query1)to add the name of the current logged on user to a table using Expr1: fGetFullNameOfLoggedUser() I then have a text box on a form that displays the information contained in the table. All works fine if I run the query, whilst it is in design mode, and adds the name as many times as i click on the red ! mark. In my form I have under the On open an event procedure as shown below Private Sub Form_Open(Cancel As Integer) If fGetFullNameOfLoggedUser = "b******y paul" Then Command50.Visible = True Command51.Visible = True End If DoCmd.OpenQuery "Query1" DoCmd.OpenForm "frm_shutdown", , , , , acHidden End Sub The problem is that the text box remains empty so the name of the current user does not show, i know the query works from what i said earleir, can anyone see where this newbie is messing up ? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you append one row to another? | Excel Worksheet Functions | |||
Find and append | Excel Discussion (Misc queries) | |||
Append text | Excel Discussion (Misc queries) | |||
Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
Append worksheets together in one | Excel Discussion (Misc queries) |