Search results

I don't think the error has anything to do with 5. I first started with 8 (the last ID) and got the same error only 8. So I need to reset the variables to make them start with 0?

And Here It Is!: Private Sub CrossTransfer() Dim strSql As String Dim strSql2 As String Dim AID As Long Dim NID As Long Dim CDt As Date AID = Me.Parent.fAccountID '0 NID = Me.Parent.cboFullName.Value '1 CDt = Me.Parent.CkDate '2 Nm =...

I have it working (even the date ;)). But Tom... I'd like to more about StringFormatSQL. It doesn't seem to google. Do {0},{1} just refer to the variables and their order? I notice Northwind uses it extensively but I need more info.

I'd like to insert a record: strSql = "INSERT INTO tblTransactions" & _ " ([fAccountID]" & _ ", [fNameID]" & _ ", [CkDate]" & _ ", [Num])" & _ " VALUES" & _ " (" & Me.cboAccount.Value & _ ", " & frm.cboFullName.Value & _ "...

Thank you so much, Arnelgp. It works great!

Private Sub btnSplit_Click() WriteCheck 1, Me.Filter End Sub Public Sub WriteCheck(iMode As Integer, Optional strWhere As String) 'acAdd = 0; acEdit = 1 Dim strWhere2 As String If strWhere & "" = "" Then strWhere = "" Else: strWhere = " AND " & strWhere End If...

Probably an oft repeated question but I can't seem to find the right question to get an answer... I have FormA based on a calculated query. When I call FormB using FormA.Filter, the filter uses FormA query field name which doesn't work on FormB query field names even though they are both using...

Thanks to you all I got it working. However, you cannot use the codes that show on the color picker. Here is the best information: https://cloford.com/resources/colours/500col.htm Private Sub Form_Current() Dim frm As Form Set frm = Forms![frmAccounts]![Register].Form [SelectedID] =...

i'm using hex...

Another quick question... is the back color a string? Because that gives me a type mismatch

Oh you are so right! Thank you.

I have a form of Accounts with a subform of register. The subform is Parent/Child Account number. I'd like to tie the register background color to the account color. I can't figure out which event to use. Change of account triggers the Parent/Child connection. So I tried the Current Event...

Well nuts! you had me worried. It works fine to close the form from another. Tested. Worked.

Hmm... Ok button makes invisible... Go back and close form. (y)

@MajP With your training, piece of cake: DoCmd.OpenForm "popDate", _ WindowMode:=acDialog If CurrentProject.AllForms!popDate.IsLoaded Then dtstart = Nz(Forms!popDate![begDate]) dtend = Nz(Forms!popDate![endDate])...

um... nevermind... I see there are other people with the same issue that's been answered. Thank you!

@MajP posted this function for retrieving values from popup forms: Public Function getValueFromPopUp(formName As String, PopUpControlName As String, Optional MyOpenArgs As String = "None") As Variant 'FormName: Name of the popup form 'PopupControlName: Name of the control on the pop...

@arnelgp Finally! an answer that helps. I was playing with this and you have just fleshed it out. Thank you so much!

I don't need to know the clickable button's size or location. I need to know the name of the field I'm occupying when I shortcut key the transparent button. It could be one of two options on each subform. The previous control works but it's dangerous? Not dependable?

Oh big misunderstanding. Not hidden but transparent. Can't see it but it's there.