Recent content by Varvaroudis

Thanks, rexmorgan for this great tool! I finally managed to create a working kml out of a client query, but I have one problem I can't solve... My clients' names are in Greek (Non Unicode). When I export a kml with vba and open it in GE, it shows the points correctly, but messes up the names...

I don't know if this helps, but I had a similar issue with the date format. Somewhere I read (and please correct me if I'm wrong) that in VBA code, we must use ONLY the american format mm/dd/yyyy. So, if you want to get a date right, you first have to use the Format command as: Dim CalcDate as...

Nope, the wizard has only 6 options for record navigation (Goto first, last, next, previous record, find (which call the Find window, as Ctrl+F) and find next). With the code above, you can navigate to a specific record (p.e. the one where "James Brown" is in the name textbox, or "67" is in the...

Thanks!!!! Worked like a charm! You were right about the Setfocus stuff! Here's the code I used: Dim CustomerNumber As Integer CustomerNumber = txbClientKey.Value DoCmd.OpenForm "Form2", acNormal Form_Form2.txbClientKey.SetFocus DoCmd.FindRecord CustomerNumber, acEntire, True, acSearchAll, ...

Hi! I have two different Forms with the same Record Source table and I'm trying to set a button in the first form which opens the second form at the same record. So far I tried the code below Dim test as integer test = 27 DoCmd.OpenForm "CustomerForm", , , "[CustomerID] =" & test The test...