Search results

Dear All, I have a form where I used the below filter in the AfterUpdate event of me.celev_combo: Me.Filter = "Year([tbl_aktivitas].[Akt_datum]) = " & Me.celev_combo Me.FilterOn = True and I got the following error: Enter parameter value tbl_aktivitas.Akt_datum (me.celev_combo is a numeric...

Dear All, I have a form where I have a text box where I can enter dates (me.aktkezdet_combo) After entering a date I have put the below code in the AfterUpdate event of the text box: Me.Filter = "aktkezdete >= " & Format(Me.aktkezdet_combo, "\#mm\/dd\/yyyy\#") Me.FilterOn = True (aktkezdete...

Dear All, I have a form where I turned off the AllowEdits property (Data, AllowEdits=No) Despite this I can still edit existing records in the form...very strange Could you please advise? Many thanks in advance

Dear All, I have a query the content of which I would like to send via email I would like each UserID to receive only their records I have the below code but the problem is that a mail gets created for each record and not for each UserID And the code covers the To field only, I would also need...

Dear All, I have the below code in a subform It is tied to a beforeupdate event of a field called HolidayDate When the code runs for the first time it is OK (displays the msgbox), but if I modify the HolidayDate then I get the Run-time error 3420 Object invalid or no longer set Could you...

Dear All, I have a query that has one output field, a date field. I need to check if the value of a field on a form is in the recordset or not (the field is also a date type) When I run the below code I get error message: "Runtime error 3077. Syntax error in date in expression" Private Sub...

Dear All, I have the below code that extracts user list from AD and displays it in the Immediate Window My problem is that I am struggling with putting the data in a table instead of displaying it in the Immediate window Could you please advise? Many thanks in advance Set objConnection =...

Dear All, I have a continuous form and somehow I would like to recolour/highlight those fields where a filter is applied (sometimes there are filters in even 5-6 fields and it is very annoying when you forget which fields you already applied a filter in) Any suggestions please? Many thanks in...

Dear All, I have a query that has multiple tables One field of the query is the product description I would like to have a table that filters on product description but not like including or excluding values but based on begins with text Example: I have a table that contains one field that is...

Dear All, I have a form that contains two subforms SubformA contains LogonID, SubformB contains the same but with a different recordset I would like that if I click on any records in SubformA, SubformB gets filtered to display records for UserID in SubformA I have put this code to SubformA...

Dear All, I have a table with a compound key I have a form with a button that adds new records each time pressed Code: DoCmd.GoToRecord , , acNewRec Me!sfr_LineManID.Form!ParticipantID = Me.user Me!sfr_LineManID.Form!StatusAlloc = "Pending approval" If I want to add duplicate values data is...

Dear All, I would like to know how I can make Access 2007 display a message if I open a database that contains macros but in the Trust Center macros are disabled I know that Access automatically displays a warning bar when doing so, but that is no good to me, I would need a msgbox that appears...

Dear All, I have a form that contains an unbound OLE object (xlsx file) I would need to send that as an attachment in an email In my code I use: olattach.Add Me.OLEobject but I get an error message that object does not support this property or method Could you please advise? Many thanks

Dear All, In case of an Access 2007 database, how can I see who is actually in the database? (username(s)) Many thanks ;)

Dear All, Which event is triggered when a subdatasheet is expanded/collapsed? Many thanks!

Dear All, I have a main form with a subform, both in Datasheet view I use the little + sign to expand the main form in order to see the subform If a control on my main form has a specific value I would like the subform to hide certain fields (datasheet view!) when expanded I tried using...

Dear All, I have a form that has 2 subforms The master-child fields are set In Simple Form view I can see both subforms but in Datasheet view I can only see the first one (I mean if I expand the records only the records of the first subform appear and those of the second one are not there)...

Dear All, I have a legacy database that contains a form that has a subform that has another subform, and there is a third one as well... (pls see screenshot) I would like to know how I can do a reference in VBA to the second and third subforms Many thanks in advance ;)

Dear All, I have a query that uses a dlookup function to fetch the previous record and it works fine DLookUp("ejfelig";"qry_report";"datum=#" & [datum]-1 & "#") I have another field: "Namefield" in the table that currently has only one value (eg. Peter) My problem is that if I add more values...

Dear All, I have a query that has one output field I would like to have a VBA function that if I apply in the second field (Field2) it just writes numbers from 1 to as many records there are in the query (I dont want to sort my data, I just want those numbers to be added) eg. Field1 Field2 Y...