Search results

it marks the line Rst.FindFirst "[HolidayDate] =" & Format(Me.HolidayDate, "\#mm\/dd\/yyyy\#")

OK, I have put rst.close after nomatch as well, but unfortunately it still fails Please find the whole code below: Private Sub HolidayDate_BeforeUpdate(Cancel As Integer) Dim Rst As Recordset Set Rst = Me.RecordsetClone Rst.FindFirst "[HolidayDate] =" & Format(Me.HolidayDate...

I have added rst.close to the code, still the same error Dim Rst As Recordset Set Rst = Me.RecordsetClone Rst.FindFirst "[HolidayDate] =" & Format(Me.HolidayDate, "\#mm\/dd\/yyyy\#") If Rst.NoMatch Then Else MsgBox "Ezt a napot már korábban felhasználtad!/You have already taken this day!"...

If I delete Exit Sub then I get another error message as my code continues opening another recordset any suggestions pls? cheers

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

Thank you very much, it works like a charm!!

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

Thank you very much, it works fine!!! :)

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

Thank you very much, that is a great solution!

No code, user right clicks on the desired field and chooses filter This is done on multiple fields and I would like Access to somehow indicate on each field if filter is on Thx!

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

OK, that sounds great, but how do you input the results of a multiple selection listbox to the criteria of a query?

the table containing the prefixes will be on a form as a subform, so users could freely enter any prefixes they want (from a combobox) currently the desc field is joined with the description field as left join

I would like to use a table as there will be more criteria as well (so not only I would specify eg SFCO but also SMPF, DSEFG, etc etc)

SFCO is written in a field called Desc in a table and I need to use this table to filter a query where product descriptions start with SFCO I tried putting like "[desc]*" but did not work

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

Thank you very much! That is a similar method to solve the issue Cheers!!

I am sorry I overlooked that In the meantime I figured out a solution: insert a textbox to the main form that refers to the ID in subformA then set the filter property of subformB to the textbox (ID=textbox)! so VBA was not needed at the end! Thank you

Dears, Please find attached the database frm_adminmode is the main form sfr_adminusers is subformA sfr_admintraininghistory is subformB so what I would like to achieve in the OnCurrent event of subformA is that subformB gets filtered based on LogonID field in subformA = ParticipantID in...