Search results

i think the new msgbox coloring/bolding can only be done on form events directly "Expression" on the Event of the form. like in the case of your Current Event and On Close event: =Msgbox() that way Access will Evaluate the expression, same as using Eval("Msgbox()") you can't produce it using...

you are using 4-5 arguments (parameters) of the msgbox (modern look) + the @ sign. while on the normal msgbox, you only use 3.

overlapping or tabbed, doesn't matter on: win 11, 25H2 office 2024 x64 1920 x 1080 (screen resolution) 125% (scale)

didn't he mention in post#1, he is using A2003?

that will only work on Single Form, not on Continuous form. if you need Continuous form, you saved a .bmp image to your field.

convert your image to .bmp then "insert" the bmp to your blob field. see form, Pictures. the form doesn't have any VBA.

that is the default. all controls that can receive focus are assigned starting from suffix 0, then goes even 2, 4, 6, etc.

i think it still opens even if you "Cancel" the opening form, unless you DoCmd.Quit if the validation fails. it can be also in autoexec macro not only on form.

you mean when you just do a click or scroll through the list and the record is shown on the left pane, you cannot edit it?

export all objects: Public Sub ExportAllObjects() Dim obj As AccessObject Dim dbPath As String dbPath = CurrentProject.Path & "\TextExport\" 'Create folders if they don't exist CreateFolderIfMissing dbPath CreateFolderIfMissing dbPath & "Tables\"...

if you will be using form, you can adapt Mr.Stephen Lebans RowNum() function as RowSource of your Assignment textbox. ' Credit to Stephen Lebans for the function ' Public Function RowNum(frm As Form) As Variant On Error GoTo Err_RowNum 'Purpose: Numbering the rows on a form. 'Usage...

google SaveAsText/LoadFromText method of Application object.

be in peace with your solution then. you dont get what we are saying about autonumber field.

you should ask AI again. when I double-click on a grand-child, it freezes the listbox.

it is the same as using Dmax(ContactID). again it will give you the highest autonumber (if contactID is autonumber) but does not guarantee that it is the "most recently added member". since there is known issue with Autonumber being "jumpy". meaning, you can manually insert an autonumber (using...

i asked Copilot and it suggested to use Last() sql function. to confirm if CoPilot is right, i created a test table (Table1) with following fields: ID--------AutoNumber Field1---Numeric (Long) i open the table and add 3 new records (ids are 1, 2, 3) created a query to use Last(ID), and it...

maybe you mean ReportView? so again i tested it both in print and report view and it does filter the report in both views. even when the FilterOnLoad is set to No.

you can call SetFilter on the Open event of your report and it will filter the report. Private Sub Report_Open(Cancel As Integer) DoCmd.SetFilter , "EmployeeID = 1" End Sub

i am sorry, you only need to "show" the media from your query. see query1 and also your form. you don't need to add another field to your subform table.

you can use the Current Event of your subform: Private Sub Form_Current() Dim rs As DAO.Recordset Set rs = Me.RecordsetClone If Not IsNull(Me.Parent!Media) Then If rs.RecordCount <> 0 Then With rs .MoveFirst Do Until .EOF If IsNull(!Media)...