Search results

It is. Should it not be? The goal here is to assign a customer a card number on this form. EDIT: Whelp...that worked. I guess that's all I had wrong hah. Thanks!!!

This SHOULD be a no-brainer, but for some reason it's not working for me. I had it working shortly, then I changed the query and it stopped working. So I changed the query back and it's still not working, so there's obviously something else going on that I'm missing. Another set of eyes would...

That did the trick! I put 'Call FormStartUp' after all records are being looked up and it worked just fine. Thanks a ton!

Any reason to believe those command could bug out the form like I've been having problems with?

Worked perfectly. Did a little step-by-step debugging and found that this is the function causing the problems: Public Function FormStartUp() DoCmd.NavigateTo "acNavigationCategoryObjectType" 'DoCmd.RunCommand acCmdWindowHide End Function The idea of this is to hide the menu windows...

There must be something else causing it. I changed it to rst.Close and I'm getting the same error: After clicking "Ok", frmRewards opens, but it opens to the first record in the table. This is the code behind the Command Button used to open the form to "new": Private Sub cmdCustomers_Click()...

Using your code (which fixed the problem with the Report BTW - THANKS!) is causing some other odd problems. Here is exactly what I'm using: Private Sub Form_Load() On Error GoTo Form_Load_Err FilterList Call FormStartUp: Call IssueRewards Dim CusID, rst As Recordset CusID = Nz(Me.OpenArgs...

Great ideas for some code, but I'm not 100% sure that's what I need. Thank you, though!

FIRST OFF - Sorry it's taken me so long to get back to this. I was out of the office (moving..ugh) and just returned. Here ya go: https://drive.google.com/open?id=1hU14aG_SdoHt_jEAGck1Xvzfng9Svsf7 I'm not popular enough to be able to upload yet, so all I have is Google Drive.

I'm not at all sure how to accomplish that :(

You're on to something there. That fixed the problem opening from another form. Here is the code for the two functions I created and call when opening that form: Public Function FormStartUp() DoCmd.NavigateTo "acNavigationCategoryObjectType" 'DoCmd.RunCommand acCmdWindowHide End...

It's set to "Yes".

I gave this a try using this: Private Sub Form_Load() On Error GoTo Form_Load_Err FilterList Call FormStartUp: Call IssueRewards Select Case Me.OpenArgs Case "new" DoCmd.GoToRecord , , acNewRec Case Else DoCmd.SearchForRecord , , , [ID] = Me.OpenArgs...

How would I do a new record with OpenArgs?

Just because I didn't include it earlier, he's the code for the list double-click: Private Sub lstCustomers_DblClick(Cancel As Integer) Dim PurchaseSQL As String Dim RewardSQL As String PurchaseSQL = "SELECT tblMembers.ID, Last(tbPurchases.PurchaseDate) AS LastPurchase...

Property Get ListQuery() As DAO.QueryDef If m_qdf Is Nothing Then Set m_qdf = CurrentDb.CreateQueryDef("", LIST_SQL) Set ListQuery = m_qdf End Property Private Sub FilterList(Optional criteria As String) criteria = "*" & criteria & "*" With Me.ListQuery .Parameters(0) =...

I have a form that serves as the central "hub" for my database. It's called frmRewards. Sometimes (when opening from Reports) I want the form to open to a specific record. Other times, I want it to open to a new record. The main issue lies within record navigation after I open the form using...

Hey there! I have a form: To the right of the form under PURCHASES is a subform which consists of a very simple datasheet that allows users to enter purchases. The issue I'm having is more a data coherency issue than any major database-breaking problem. As you can see when you want to...

I moved it up right after the Delete and I'm getting the same problem. Private Sub cmdDelete_Click() Dim Response As Integer On Error GoTo cmdDelete_Click_Err DoCmd.SetWarnings False If MsgBox("Confirm deletion of the record?", vbQuestion + vbYesNo + vbDefaultButton2, "Delete?") = vbYes...

It's not letting me, says the file is too large. The ZIP is only 1.9mb.