Search results for query: *

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...

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...

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...

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

Hi, I'm trying to pop up the FILE OPEN common dialog box for my user. The code below doesn't work! (comes from the "Developer's Handbook: Vol 1) Dim cdl as CommonDlg Set cdl = New CommonDlg cdl.ShowOpen Bugs at the first line. Declaration not accepted !! ... thanks for your help on this...

Hi, I'm trying to pop up the FILE OPEN common dialog box for my user. The code below doesn't work! (comes from the "Developer's Handbook: Vol 1) Dim cdl as CommonDlg Set cdl = New CommonDlg cdl.ShowOpen Bugs at the first line. Declaration not accepted !! ... thanks for your help on this...

Hi guys, is there a smarter way to retrieve the names of MY tables in my dtb with SKIPPING all those hidden and MSsystem tables ? This usually works but it's dumb, you will agree ... Set Dtb = CurrentDb For Each Tdf In Dtb.TableDefs If Left(Tdf.Name, 4) <> &quot;MSys&quot; And _...

Hi guys, is there a smarter way to retrieve the names of MY tables in my dtb with SKIPPING all those hidden and MSsystem tables ? This usually works but it's dumb, you will agree ... Set Dtb = CurrentDb For Each Tdf In Dtb.TableDefs If Left(Tdf.Name, 4) <> &quot;MSys&quot; And _...

Hi, I'm trying to gather info from two tables in a way that the info from the 1st table will occupy the first three rows and info from the 2nd table the next rows (say 4,5,6). It has to be Visual Basic coded because the database is +10000 records and changes regurlarily. Those tables are...

Hi, I'm trying to copy a Charts from a Worbook to an Add-in. This code below doesn't work, . IS IT POSSIBLE ? . HOW SHALL I DO IT ? > Dim c_Chart as Chart > For Each c_Chart In Workbooks(MyWorkBook).Charts c_Chart.Copy After:=wb_Addin.Worksheets...

Hi How can I work with Worksheets placed in a Add-in ? How can I show them to the user ? [History] I used to have my macros in a workbook, the initilization was automatic and I hid the workbook containing the macros in the beginning. When I needed to show information to the user or manipulate...

Hi How can I work with Worksheets placed in a Add-in ? How can I show them to the user ? [History] I used to have my macros in a workbook, the initilization was automatic and I hid the workbook containing the macros in the beginning. When I needed to show information to the user or manipulate...

Hi I have my Excel VBA program up and running :)) and i would like to make it an ADD-IN. I didn't manage so far. Could somebody tell me what are the steps ? I think i'm missing something. Or does somebody knows a weblink that would be helpfull? Thanks in advance, marco

Hi I have my Excel VBA program up and running :)) and i would like to make it an ADD-IN. I didn't manage so far. Could somebody tell me what are the steps ? I think i'm missing something. Or does somebody knows a weblink that would be helpfull? Thanks in advance, marco

Hi guys, I would like to run 1 or 2 DOS commands from in my ExcelVBA application. I red somewhere that: Shell &quot;COMMAND.COM dos_command_as_a_string&quot; should do it. It doesn't seem to work, can somebody help me on this matter? Thanks a lot, Marco PS: i want to convert a file from...

Hi guys, I am manipulating multiple TABLES in multiple DATABASES. I would like to remotely CREATE RELATIONSHIPS between IMPORTED TABLES. CAN I CREATE RELATIONSHIPS BETWEEN MY TABLES WITH VB ? HOW ? Thanks a lot in advance for your help ! Marco