Search results

Hi all - I have a from that has information icons that opens a separate form to help users make the right choice on a form. With each information form users are able to choose "Yes" or "No" and then it returns them back to the form they started. I am great to this point however I am having...

I am trying to create a form with a button attached to each record that would allow the user to click the button and it would automatically open outlook and fill in the TO:, SUBJECT: and BODY: fields. I am very close to this but I am running in to a few issues. Here is the code that I...

Hi all! I have a database in which users have the ability to search by last name...nothing fancy there. However, the users continue to forget to click the Find Client button and instead just type what name they are looking for in the LASTNAME control thus changing the record that they are...

Currently the system where I work is set up so that everyone has their own front end on the local network. I would like to change this because updating all of them takes a lot of time for me and skill level for users is too low for me to trust them with updating it on there own. My question...

My problem seems simple but I have a feeling this is going to be a bigger issue that I think. Lets say, Form A has fields: ID, LN and FN ID LN FN 1 A F 2 B G 3 C H 4 D I 5 E J Form B has fields: ID, LN and TR ID LN TR 1 A Y 2...

I have the following VBA code that auto populates a word template: Private Sub Command24_Click() On Error GoTo ErrorHandler: ErrorHandler: If IsNull(Me.REASONFOREXIT) Then MsgBox "Reason for Exit needed" Exit Sub End If If Me.TRAININGSTATUS = "COMPLETED" And Me.TRAININGPROVIDER = " "...

I am running in to a brick wall with this. I have an unbound text box with the control source set to =IIF([text42]=0,0,[text42]/[text44])*100 and in continues to return a #name? error. I am not sure how to get this expression to work. I have even tried to put =[text42]/[text44] and I still...

I am attempted to create an IIF AND function in a query field. I have the following expression but for some reason the AND will not work. Expr3: IIf([EXPR1]=1 And [EMPLOYED]="YES","YES",IIf([EXPR1]=1 And [EMPLOYED]="NO","NO",IIf([EXPR1]=0,"NA"))) The last section {IIF([EXPR1]=0,"NA")} works...

I am creating a database for users that no nothing about access nor do they want to learn. So the database needs to be as simple as possible. This being the case I would like to avoid users from creating/editing querys. I would like to have a form that would run the append query. The query...

When my database application is closed a parameter box pops up asking for parameter from text16 but only if the Navigation Pane is hidden. Some information: The application starts with a login screen that has a hidden text box (text16) that allows me to limit what users can access throughout...