Search results

There is no special code, just Parent!Ctl.BackColor = Rst!BckColor - where Rst!BckColor is a field in a table. The thing is that i can't believe it won't ask you anything, unless you are using setwarnings false, which i don't want to do.

Hey :) sorry for the late reply, but it's summer :D To sum everything up: -firstly, it is an accdb i'm working on, not mdb, and - i do change one textbox's back color property, but i need it that way. i want to show the color the user picked from the color picker dialog, which brings me to - i...

The setup: I have a main navform with a few navsubforms. In one of them, depending on what the user clicks, some textboxes turn red or green. Te problem: when i navigate away from the said subform, access is asking if i want to save the changes to the form or not. I want to disable this message...

I've tried that too. The only thing that worked was to remove all the DLookUps i had going prior to docmd.BrowseTo and that worked. For me, at least :) i had to write a custom dlookup which works fine if used before the blasted browseto. Thanks everyone for your help :)

Thanks but that won;t work in this scenario because the form isn't loaded until the browsetoform command, so there would be no control to set the focus to :)

Hi people :) I return with another question that has me stumped... I have the following setup: Main Form (A) -> NavigationSubform with two forms (B and C) -> SubForm B -> NavigationSubform with two forms (B1 and B2) -> SubForm C -> NavigationSubform with three forms (C1, C2 and C3) I...

Public Function ADO_InsertSQL(cColumns As String, cIndex As String, cLocTable As String, cExtTable As String) As Boolean On Error GoTo Eroare Dim Rc As DAO.Recordset Dim I As Integer Dim vRow As String Dim eSql As String Dim vSql As String Dim vValues As String Dim MaxAllowedPacket As Long Dim...

Wonderful after 13 years :)

i have. and it works. but what i needed was a big query with around 30 fields and over 6k rows, joined form 15 tables or so... i wanted to have a continuous form, shared by multiple users, and when someone started editing on of the rows (in a separate form) the other users would know by use of a...

I've made this simpler and still nothing: Private Sub Form_Load() Dim qc As DAO.QueryDef Dim rs As New ADODB.Recordset rs.Open "SELECT * FROM Locked", SQL_SVN, adOpenDynamic DoCmd.DeleteObject acQuery, "QQQQ" Set qc = CurrentDb.CreateQueryDef("QQQQ") qc.Connect = "ODBC;DRIVER={MySQL ODBC...

For the last 17 years i've been using DAO recordsets and i LOVE them, but recently i got a new project which has the BE on a MariaDB server. All fine and dandy until this issue: I have a simple "Select * FROM" passtrough query which doesn't see changes made to the underlying table. I've tried...

Thanks everyone. I'll close the thread since i understand there is no real way of doing this... i wonder why, after so many versions of office, they haven't addressed this issue yet....

Thank you :), but it doesn't... besides, i use new query all the time when i want to test sql strings, so that wouldn't really help. is there no other way?

Sorry, what?

Here goes another question, for you guys: is there any way (even if i need to modify the windows registry) to change the default size of the query design window? As it is, it opens all over the screen, and if i have the Properties window visible, it goes beyond that too...

I got this working: Public Sub CreateSQLValues(cColumns As String, cIndex As String, cLocTable As String, cExtTable As String) On Error GoTo Eroare Const MaxRows As Integer = 500 Dim Rc As DAO.Recordset Dim Qc As DAO.QueryDef Dim i As Integer, j As Integer Dim vRow As String Dim eSql As...

thank you. i'm a noob. fortunately, the server is internal with no access to the web

Wow :) It's nice having an account here... Should've done this 10 years ago :)))) Public Sub CreateSQLValues(cColumns As String, cIndex As String, cLocTable As String, cExtTable As String, nRows As Integer, Optional IdMin As Long = 0, Optional IdMax As Long = 0) Dim Rc As DAO.Recordset Dim Qc...

Hey. Thanks for the qucik reply. This is what the server says, but i don't think that this is the problem. "max_allowed_packet 1048576" As i said, the [tmpClient] table is local and [Clienti] is sever. I guess the question would be: can I in Access SQL Pass_through insert data from local table...