Search results

it has been 5 months since..

maybe you can save the selected records (IDs) to a textbox (text9) and use the value of textbox as filter to get your records. see this demo, open Mainform and Click on the Recordselector of the subform. you need to clean the values of text9 (remove leading and trailing commas).

ahhhh, i see that it is closing because on the Load event you are really closing the form. you can separate the closing from the Load event also: Private Sub btnNo_Click() CloseMe End Sub Private Sub btnOK_Click() CloseMe End Sub Private Sub btnYes_Click() bYN = True CloseMe...

i updated the Attached db and is now Not using any API. pls download it again.

see the Format Property in Design view.

unfortunately the demo did not work when i tested it. i modified the code (VBA) in "Open Form1 (Modal)" button to somewhat make it stop.

see this demo and open MainForm. this will make Form1 (dialog or not). see the code of the two buttons. there is a basMakeFormDialog, that does the Modal thing.

yes I have seen the screen shot. the problem is when you open the form (DoCmd.OpenForm) and you specify acDialog, the Titlebar will get re-instated. try opening your form normally: DoCmd.OpenForm FormName:="YourFormName" you will notice that there is No Titlebar. Now open it using acDialog...

you can Remove the Label/Box from your form. or you can Set their Visible Property to No. you can pass an OpenArgs parameter when opening a Form as acDialog: DoCmd.OpenForm FormName:="YourFormName", WindowMode:=acDialog, OpenArgs:="Dialog" then on the Open event of YourFormName, you check if...

it does work for me, though.

.bat file is an ugly, Jurassic approach. very easy to pry into. it's your approach anyway.

anybody can mess with a .bat file. they can see where the Fe is being copied from. they can explore and what else they can do. so, yes, i miss what is the purpose of your .bat file. for what you know, it can copy a rogue db.

i am serious with my answer and what is your problem?! recommendations have already been given to the OP. and this came from CoPilot: The recommended replacement for Microsoft.Jet.OLEDB.4.0 is: ✅ This provider is part of the Access Database Engine (ACE) and offers several advantages: 🔧 Key...

starting from Access 2007, connection string has shifted to Ace.Oledb.12.

try: HoldIt = Format((Nz(DMax("ID", "Tbl_Equipment"), 0) + 1, "T0000")

equivalent code using DAO: Public Sub CreateTable(strPath As String) Dim db As DAO.Database Dim td As DAO.TableDef Dim fld As DAO.Field On Error GoTo Err_handler ' check if the database exists If Len(Dir$(strPath)) = 0 Then ' databas does not exists, create it...

it is a New db obviously there is no table yet on it so your conn.Execute will not work.

it is already working as you said, so obviously no need to add any Reference (reference already in placed).

you double check the spelling of your createobject(), should be: set regex = CreateObject("vbscript.regexp")

similar as above but using textbox. Open demoBorderPaintEvent form and see the instruction and VBA code behind the form. there is another form, demoBorderConditionalFormatting, that uses Conditional Formatting.