User Profile

elak6 · Mar 16 '12, 01:33 PM

Hi Mike,

I just tried it and it isnt working.
For parts that dont have matching internal part number and matching revision, it displays Revision Change instead of Not in database

Thanks for helping me

elak6 · Mar 6 '12, 09:01 AM

Hi NeoPa,

Thanks for helping me realise my errors
The code runs perfectly now :)
Thanks for all your help,
Really appreciate

Regards,
elak6

elak6 · Jan 9 '12, 03:28 PM

Hi Neopa,

Yeah i just saw the chnages you highlighted, was testing and tweaking the code and didnt even realise the changes i made.
Currently, i am using Access 2007
I have corrected the code and ran it again but is still giving me the error about the Dirty property
I guess i need to go back to the the foundation/beginning and figure out how i went wrong

Thanks for all your help,
Really appreciate...

elak6 · Jan 9 '12, 09:45 AM

Hi Neopa,
Happy New Year to you and hope you had a good holiday
I ran the code exactly as you put it and it is still giving me errors. The code i ran is shown below:-

Code:

Private Sub Form_Open(Cancel As Integer)
    With Me
        If Date = .txtSendDate Then     ' Now option
        If Date <> .txtSendDate Then      ' Deferred option
        RetValue = MsgBox("NextUpdate is in the future/past",

...

elak6 · Dec 19 '11, 01:49 PM

Hi Neopa,
Thanks for all your help
I ran the code posted above but i seem to be encountering a problem
Everytime i close the form and then reload it, it never saves the value of the next update text box
Please can you help

elak6 · Dec 12 '11, 12:02 PM

Hi NeoPa,

Sorry for the long delay in replying, i was bogged down with work
I was able to sucessfuly implement it using the method you suggested
Thanks so much for you all help and once again, sorry for all the stress i have you

This is the code which i used below:-

Code:

Private Sub Form_Open(Cancel As Integer)
With Me
If Date < NextUpdate Then
RetValue = MsgBox("NextUpdate

...

elak6 · Dec 7 '11, 10:23 AM

Hi NeoPa,

Thanks for the reply
I think the best approach to this matter is the one you suggested above
There are just some points that I don’t understand fully

I am guessing if I was to write the VBA code, it will be something like:

Code:

If Date  < Send Date
Then Do Nothing 
ElseIf
Date= Send Date
Then Call Command Msg    ‘which is the command that

...

elak6 · Dec 6 '11, 08:59 AM

Hi NeoPa

Thanks for your reply and I am sorry if my earlier post offended you.
I finally understand what you mean more clearly
I think the frustration of the code not working out was clouding my thinking and do I apologize for any inconveniences I have caused you and i really appreciate all your help

I did read your post and you suggested you using an outlook reminder without code
Let me give you...

elak6 · Dec 5 '11, 10:01 PM

Dear Neopa,
I appreciate the fact that you are not getting paid for this service and you are doing all of us a favour. I do know it can be very frustrating when you are trying to help people and sometimes their question just contain too much dilly-dallying and not getting straight to the point but some of your comments in post 4 were quite hurtful.
I guess it's my fault cuz i went in to much detail thinking it would aid the whole process...

elak6 · Dec 5 '11, 04:44 PM

Thanks for the reply NeoPa
The main aim of having a deffered date is that i want a reminder email to be generated every 3 months without any inut from me to remind to update sections of my database
What i really wan
The deffered date is not the same date i run the code
The code is going to run continually everyday
But what i really want is that that i set a date as a benchmark and 30 days adter that benchamrk date,...

elak6 · Nov 28 '11, 03:50 PM

NeoPa,
Thanks you so much
So sorry about my foolishness
After going back and reviewing your code, did i just realised the major error on my part
Thank you everybody for all your help
I really appreciate it and all the good that the forum is doing

elak6 · Nov 28 '11, 03:02 PM

Hey Neopa, This is an the code that i ran and it still giving me teh same error

Code:

Private Sub Command3_Click()
 With Me
'my code
Call ImportFromExcel
Call .Command3.SetFocus
    .Command3.Enabled = False
    End With
End Sub

The import from excel calls out my file dialog box and DoCmd.TransferS preadsheet codes.

elak6 · Nov 28 '11, 02:15 PM

Hi Neopa,
Thanks for the speedy reply

Using your method does not comply for some reason with my command button in vba

I tried running the code above and it gave me an error:
Compile error: Method or data member not found
And it highlist this section of code

Code:

Command3Next.SetFocus

elak6 · Nov 28 '11, 01:56 PM

Hi Smiley Coder
Thanks for the speedy reply
I just tried running the code and it gives me the error;
Run-time erroe '2164'
You can't disable a control while it has the focus

Thanks

elak6 · Nov 28 '11, 01:34 PM

Hi giuys,
Thanks for the speedy reply
I have tried again using the macros wahy and it is still proving difficult.
I know i can easily convert all my macros to vba using the database toolbar in ms access
But i still dont know how to run the macro once per session using vba either
Any help you can offer would be highly appreciated
Thanks

elak6 · Nov 28 '11, 10:28 AM

Thanks NeoPa for all your help
Fially figured it out

User Profile

Profile Sidebar

Leave a comment:

MS Access SQL (Not Equal To)

Leave a comment:

Running Parameter Query Via A Form and Encountering Problems

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Automated Mail Delivery Time Using Table Data

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Access Macro To Run Only Once

Leave a comment: