Dear Great arnelgp,
It's working perfect. How about editing the database. How to edit the current record in the MDB file.
Thaaaaaaaaaaaaaaaanks in advance
thanks for your fruitful reply; How about the index and search
Previously I was using the code:
rst.index = "index name"
rst.seek "=", "anything"
if not rst.nomatch then
How such code will be.
Sorry for any inconvenience
Good day!
I'm writing the following code in Word 2013 VB to connect to MDB database
dim db as database
dim rst as recordset
set db="db path"
set rst= db.openrecordset("Table Name")
In this stage I'm getting the error message :run-time error '4029' activex component can't create object"
I...
Good evening all!
I use the following Ribbon XML code in a UsysRibbon table. I got it from these forums.
I need to remove the (File) menu and also to remove the title that appears at the top of the database (which displays the file name and path).
Thanks in advance
<customUI...
this:
DoCmd.RunCommand acCmdFilterMenu
is a part of the function (Filterform)
this recalls the standard filter that's found just on the right top corner of a field. I think the idea will be clear only when you have a look on the database
Attached a sample database.
In form (expense), the combo box (expense_item) collates data from (expenses) table and (revenues) table.
There's a filter button on form header. it shows only the contents of (expenses) table to which the combo box is bound.
I hope it's clear now
Good day!
I use the follwoing code to filer a filed on a form
Public Function FilterForm()
On Error GoTo errlbl
Set SelectedButton = ActiveControl
Me.Controls(ActiveControl.Tag).SetFocus
Me.Recordset.MoveFirst
DoCmd.RunCommand acCmdFilterMenu
Exit Function
errlbl:
If Err.Number =...