Search results

The event I am using is on the subform itself. It is the On Key Down Event. I messed around with code to try to get it to delete the R after the messagebox was closed, but I couldn't figure out how to do that. Also, I was worried if I started to delete things that it may accidently delete a...

I understand what you are saying about referencing controls. However, do you think that is the problem considering it does reference the checkbox correctly and it is either suppose to open another form or a messagebox which it also does. The only problem is that it enters an R into the field...

I have a form with a subform. I am trying to add a shortcut key to a button which is enabled or disabled depending on whether a checkbox is checked or not. I need to put the code on the subform as well because the focus is sometimes on a field on the subform. The code works fine except for...

Never mind I figure it out. I didn't have Key Preview = Yes

I would like to be able to close a form whenever the user hits crtl + alt + c I know you can set the caption to &close but this does not work very well because I would like to allow the user to close the form no matter what field he or she is on including text fields. Thanks!

I am linking sql tables to an Access frontend. As a result all my table names start with dbo_TableName. I have to go back and manually delete dbo_ every time I relink the tables (for whatever reason refreshing the links does not work every time which is another issue in itself). What I am...

Got it . . . I was putting the where clause after the group by which is why it never worked and I thought I had to do something else. Thanks

Sorry . . . do what?

I have the following code: SELECT ClassID, COUNT(*) AS Total FROM dbo.tbl_Claimant GROUP BY ClassID The problem is I want to filter out PersonID <> 20 but when I do that I have to put PersonID in the group by and then it groups it by PersonID instead of just ClassID. So instead of...

Is there any way to pass multiple OpenArgs. I have a form that opens 2 different ways depending on what arguement is passed. However, I also need to pass the primary key from one form to another.

I have 2 forms. Form 2 opens as a modal pop-up form on top of Form 1 so when the user closes Form 2 the last record they were working on Form 1 is still there. I would like to do the same thing but close Form 1. In otherwords, if the user is working on record number 1011, it will pass this...

Thanks That worked . . . thanks!

I am trying to set validation on a date field as follows: If DateField > Now() Then Msgbox "You can not enter in a date greater than today's date." End If I would like the code to then delete whatever value the user entered and set the focus back to that field. I have tried the above...

Not sure about posting this here, but thought I would give it a try. I have a crystal report written from a stored procedure in SQL. However, the frontend is Access. I need to open the report via an access form. When the report was reading from access tables I used the following code to open...

Never mind I copied the requery code to the event code on the button to close the form and now it works.

I have a MainForm with a subform. On the MainForm you can open a popup form to add a new record to the combo list for the subform. However, I can not get the combo box to requery. If I close out the main form and reopen it the combo box shows the new record that was added so I know the record...

Oops sorry . . . yes a typo. The code on the click event on the main form is: Private Sub OpenSettlement_Click() On Error GoTo Err_OpenSettlement_Click Dim stDocName As String Dim stLinkCriteria As String If LastName.Locked = False Then DoCmd.RunCommand acCmdSaveRecord...

I have a main form that on the click event on a button it opens up another form. However, there may not be any records in the second table related to the primary ID of the main form so it gives me the following error: run- time error 2455 You entered an expression that has a invalid reference...

I have a combo box with 2 values the user can choose from. Value A Value B I need to prevent the user from choosing Value A more than once on a continuous form. For example, they may enter in 3 people on the form. Each person must then be assigned a value. However, only one person can be...

I have the following query: SELECT Format(CVar([Table1.F1]),"000000") AS TextNumber FROM Table2 RIGHT JOIN Table1 ON Table2.F1 = Table1.F1 WHERE (((Format(CVar([Table1.F1]),"000000")) Is Not Null) AND ((Table2.F1) Is Null)) ORDER BY Format(CVar([Table2.F1]),"000000"); There are 2 problems. 1...