Search results

I have a combo box with 3 rowsource fields (ID, Category, Type) that I want 2 control sources. If a selection is made for a category type, the control source is the fCatetoryID. If the selection is an account type the control source is TAcct (transfer account). I made an If, then function...

I'm calling a detail form from a list form. Usually the detail form is called with a where condition and goes to that record. However, I also have a New button that calls the detail form in datamode:=acformadd. To add a new record there are a couple routines I need to run first, so on load : If...

I found this from Arnelgp: Sub ShowLastRows() With Me.Recordset 'use the recordset in the form, not the clone[/COLOR] .MoveLast 'move to the last record, shows at top of list[/COLOR] .Move -19 'move up 19, shows more records, last row moves down[/COLOR]...

I'm using a continuous form with all the columns using the filter Majp and Arnelgp posted https://www.access-programmers.co.uk/forums/threads/custom-filter-accmdfiltermenu.321050/ It's working great. However, I'd like to be able to clear all the filters with a button. The register below is used...

I run a check before closing the form to make sure 3 fields have data. The form has subforms so I preload a new record with autonumber. Everything I read says that data checking belongs in the before update event. However, a preloaded record with no data is not dirty so it misses the before...

This seems very simple but doesn't work. I have 4 textboxes with 4 buttons. When a button is clicked I want to copy the textbox content to another place. The code works if I place it in each click event but I'd like to combine the code into one function so I can add more. My problem is I can't...

From everything I've read, if you need calculations, and you create them and then create a left join, the recordset should be updatable. This one isn't. Is there a way I can fix it so it is? This is the transaction query I'd like to have updateable: SELECT tblTransactions.fAccountID...

I have a continuous form that's a check register and the query behind it is not updatable. Double clicking in any field transfers the record fields to unbound fields in the header. I have saving a new record working but I'm a little lost on updating an existing record. How do I make sure the...

I have a continuous form of transactions that has a button to open another form to split the transaction into different accounts. The transaction is completed when there is no amount remaining after the splits of the original amount. Each transaction has a field on the calling form showing the...

I have a check register with over 9,000 records. On a check form I keep a running balance (DSum) with a criteria of date and check number and a second field with a DSum showing cleared balance. The form wants to t-h-i-n-k and t-h-i-n-k when closing and occasionally crashes completely. Are these...

Ok... this is in reference to a previous post but that problem was solved so I'm starting a new one. I have a MAJP listbox popup form. On open the focus is set to a txtbox for typing in a search text. Before anything is typed in, you can tab to the list box. After anything is typed in you cannot...

I'm using MAJP's FindAsYouTypeListbox. I have a dialog popup where I select a record and then close and return to calling form. Wlhen the popup closes, the code goes to mListBox_Afterupdate which calls Unfilterlist. This code crashes the program: Private Sub unFilterList() On Error GoTo...

I am trying to use MAJP's FAYT on a list box and I keep getting a type mismatch. The only thing I can figure out is that it's a listbox instead of a combobox. Is there a difference? The error 13 is on this line: faytChild.InitalizeFilterCombo Me.lstChild, "Child", AnywhereInString, True...

Years ago when I knew even less than I do now, I used NAME as a field name in a small db. I'm updating the database and I've gone back through all the tables in the BE and removed or changed the name on those fields. I've also done a deep search on the FE and corrected everything I can find...

Everything I've read says to close the calling form before opening the new form. Private Sub btnEdit_Click() 10 On Error GoTo btnEdit_Click_Error Dim strWhere As String 20 strWhere = "[RecipeID] = " & Nz(Me.recipeid, 0) 30 DoCmd.Close acForm, Me.name 40...

Select Case Me!togMonth Case Me!togMonth = True Me.Visible = False DoCmd.OpenReport "rptMonth", _ View:=acViewPreview, _ OpenArgs:=Me.name Exit Sub Case Me!togMonth = False DoCmd.OpenForm _...

I have Form A that calls Form B as a dialog so that when it returns it can run code determining ID, etc. On form B is a button that prints one label. But because form B is made invisible for that one label, Form A thinks it's finished and pops up in front of the label. Is there no way of calling...

"INSERT INTO tblLabel (Line1, Line2, Line3, Line4) " & _ "VALUES " & _ "(""" & Company & """, " & _ """" & FirstName & " " & "" & LastName & """, " & _ """" & Address & """, " & _ """" & City & " " & "" & State & " " & "" & ZIP & """)" I am so bad at...

I use a dialog form to edit and add new recipes. The following code is from the calling form. Private Sub btnEdit_Click() On Error GoTo btnEdit_Click_Error Me.Visible = False DoCmd.OpenForm "frmAddEdit", _ windowmode:=acDialog, _ OpenArgs:=Me.name 'When you get back...

I have the following form for editing various lists: When form is first loaded or when using the option to switch lists in the first subform, the first item will not select until I've clicked on another record and then back to the first. It's not a deal breaker but not very professional...