Recent content by arnelgp

see the title, it's about google map itself (not a db with webbrowser).

sorry, which form? and what Group does not have a subgroup?

run test() sub on Module1.

you will need a recordset to do that and for what? something like this: Private Sub t() Dim db As DAO.Database Dim rs1 As DAO.Recordset Dim rs2 As DAO.Recordset Dim arrValue(1 To 4) As String Dim i As Integer Dim sql As String sql = "Select Top 1 * From...

i tested and it is ok, maybe what you mean is the word "Desc" since it is used in Sort Order, but also can be used if you enclosed it on square brackets.

maybe.. 'xlBook.Close savechanges:=True xlApp.Visible = True

maybe: ..Forms!FrmPreRetailJobs!CboxSupplier & "' AND " & Format$(Forms!FrmPreRetailcharges.tbChargeDate,"#mm/dd/yyyy#") & " BETWEEN [StartDate] And [EndDate]"), "")

also you can try to put the formula i provided on Cell A2. then to create a "spill" effect, click on cell A2 and hold Shift-Ctrl, then press Enter key (while still holding Shf-Ctrl keys).

if you know how Excel work, then you will find same with Google sheet. you can "double click" on the "dot" and the formula will fill-down.

the formula on A2 should be (and copied downward): =SUM($B2:$B$7)

here is the modified function: 'arnelgp Public Function fncRecCount(ByRef f As Form) Dim ctl As Control Dim strCaption As String Dim i As Integer For Each ctl In f.Controls If TypeOf ctl Is SubForm Then strCaption = ctl.Parent.Caption i = InStrRev(strCaption, ")") If...

i am not sure, chatgpt, on most occasions, don't know the answer. you need to Test and verify it's answer. there is a suggestion on post #6 and another on post #2, so you can always google for real people's experiences.

i never experimented on sqlite so i cannot answer you. i also have tried before, but cannot find the correct odbc driver. if you will google, you will see that many people also tried but never get any results.

many have tried, but failed.

because that is the proper declaration in win32 api. Win32 API | Access World Forums (access-programmers.co.uk)