Search results

yes B. Records prior to August 1, 2021 and just two month before not more.(JULY AND JUN )

Month no. is matter not the date.. Filtering is based on month number .all date were updated in process at the beginning the month : 08/1/2021 or 09/01/2021 or 10/01/2021

you are right , how to exclude the records ? is my issue with this table .

What you are saying is not what i am looking . I want to turn on each record flag with an update query then delete them . in the picture below , the max month is 8 . i want to delete records for 05,03,... by marking their flag. this table changes every moth .So i need max month no. and 2 month...

no just for a table with 1500 records .I added flag as Yes/NO ,when the max month identified , records with 2 month diffidence updated to yes.

Hello I have a table with two fields ( date and flag) I need to find the max Month no. then update flag of the records with 2 months older than max month . ex ; 08/01/2021 then max month is 8 update flag for records with month less than 6 could you give me a hint how to do ...

I really appreciate of your reply ..my issue was solved .thank you very much

Thank you so much .I appreciate .I have one question? *- how can I add action to append bottom to append selected table in checkbox ?

I am new in VBA .How you add this code to your combobox..can you send me a sample ?I appropriate that

Is there a way that I can have a form in Access show the user a list of the tables that are in Access as a drop down list? What I want to do is let the user view data based off the actual table it is in.However, also don't want to show ALL the tables, just ones with a name prefix like "Data_*"...

HELLO I have a databse with a table to give access user to login .but it have an error that i can solve it ,anyone can help me to find the issue ? Private Sub Command1_Click() If IsNull(Me.txtBnumber) Then MsgBox "Please enter your Bnumber to proceed." Me.txtBnumber.SetFocus Else...

Thank you very much.it worked properly .:)

yes both are Date/Time data types.

Yes ,update events ? what do mean .? this part of code is useded to import .. For Each varFile In .SelectedItems Name = varFile FileName = Dir(varFile) Workbooks.Open(varFile).Sheets("Report Details").Activate Dim i As Integer i = Cells(Rows.Count, 1).End(xlUp).Row ActiveWorkbook.Close False...

Yes i tested .It doesn't work .i have no error on it but no message pops...

yes two fields in one table ....

One table with two date fields .if return to service date < event occurrence , then pop a message

I have this code to import from Xl to Access records by record . how can i add a control here ? For Each varFile In .SelectedItems Name = varFile FileName = Dir(varFile) Workbooks.Open(varFile).Sheets("Report Details").Activate Dim i As Integer i = Cells(Rows.Count...

it is better to check all records .but if it could find the first one should pop a message..I really just need the notice to pop out .