Recent content by marco02

Hi, I have a form retrieving a table's data. I added to this form a TEXT_BOX + COMMAND_BUTTON for filtering purposes. 1) The user enters his filtering criteria in the TEXT_BOX (filter to be applied to the form itself) 2) Then the user presses the COMMAND_BUTTON to launch the filtering...

Yeah Schroeder, actually that's what I'm gonna do: dump the table's data into a Form and work from there. The user will just have to change his habits and do what I tell him !! [hammer] Now, who's the master he ? [pc2] ... but if somebody knows how to "retrieve directly the CurrentRecord...

Thank you Jantie and Foada BUT, -> Jantie, your code looks like what I want to do but I'm using a Table. My user visually scans a table and selects the row he is interested in in the table directly. Then launches the code. That's when I want to retrieve the RowNumber he selected in the TABLE...

Hi guys, For my application I need to retrieve the record/row the user has selected. How do I do that ? Let's say the user chooses to launch the code on record 49: 1) he opens the table 2) he clicks in record/row number 49 3) and clicks command button "Launch" of my form or...

Hi, For my application I am linking a lot of tables to my database (from other dbs). After a while of importing/deleting/importing/etc those tables, my database is enormous (+60MB) even though I barely store any data in my database. - Why is the size of my database increasing that much if I...

Hi I'm trying to append a NEW FIELD on an existing table. My table has 2 fields and I want to append a 3rd one. With the code below my field DOES NOT get added to my table. Dim fld As DAO.Field Dim tbl As DAO.TableDef Set tbl = CurrentDb.CreateTableDef("Table1") Set...

... no wonder why my boss looks at me with this funny face ... I AM REALLY STUPID ! Thanks CClint for your constant effort on my question, it works now (why the heck is there so many different ways to do the same thing in VB ???) marco.

uuuuuh it was to good to be true >> db.Querydefs().Delete is not valid... :-( thanks anyway, marco -desparated- ;-)

Thanks CClint but my connection is there and the DROP statement only works for TABLES and INDEXES... >> Set db2 = DBEngine(0).OpenDatabase(path2) >> db2.Execute "DROP TABLE QueryNameToDelete;" Doesn't work to delete my query. I'm working with DAO btw. "DoCmd.DeleteObject&quot...

I am working from an open database (db1). Can I delete a query sitting in a closed database (db2)? How ??? I hoped: DoCmd.DeleteObject acQuery, db2.Querydefs(NameOfQryToDelete) would work but it does not :-( I would like to delete this query without opening db2 if possible ... i could open db2...

Thanks CClint! Very clear explanation thank you, everything works fine now. ...except now that i can't manage to append a Field to an already existing table ... Set fld = tbl.CreateField("FieldName", dbText, 30) tbl.Fields.Append fld bugs,... Error tells me : "The database...

Hi I need to work with tables in two different database, I can't manage to refer to my second database, Both databases are open... #DAO declarations Dim db1 as DAO.Database Dim db2 as DAO.Database # this line is OK Set db1 = DBEngine.Workspaces(0).Databases(0) # this line BUGS Set db2 =...

Can I retrieve directly the number of recordset in a query without looping through the entire recordset ? Why doesn't the .RecordCount work on a query ? Is there a similar property for a query ? thanks so much, marco

IT WORKS !!! sorry for the late answer guys i got sick .... For the next guy, here is the complete detailed procedure: 1) In a Form (whatever form) Toolbox -> More control -> put the "Microsoft Common Dialog Control 6.0" control somewhere in the form. 2) Go in Access VB...

IT WORKS !!! sorry for the late answer guys i got sick .... For the next guy, here is the complete detailed procedure: 1) In a Form (whatever form) Toolbox -> More control -> put the "Microsoft Common Dialog Control 6.0" control somewhere in the form. 2) Go in Access VB...