Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-07-2019, 02:44 AM   #1
mba_110
Newly Registered User
 
Join Date: Jan 2015
Posts: 280
Thanks: 58
Thanked 0 Times in 0 Posts
mba_110 is on a distinguished road
Delete Command Button Event

Hi Everyone,

I am writing cmd button event for delete in my data entry form before deleting the records i am storing the information in delete table and updating it with delete date in order to do that i have divided the sql in three portions (INSERT INTO, DELETE, UPDATE).

Please review the below code, I think i am missing some delimiters in the code which generate the errors of syntax & Too few parameters.

Code:
Private Sub CmdDeleteEntry_Click()

Dim VBAnsw As String

If Me.cboEntryNo > 0 Then

VBAnsw = MsgBox("You are about to delete the entry and its underlined transactions" & vbCrLf _
& "If you click yes, you won't be able to undo this delete operation. " & vbCrLf & vbCrLf _
& "Are you sure you want to delete this records?", vbYesNo, "Warning")

If VBAnsw = vbYes Then
'Append the Entry details before deleting.
CurrentDb.Execute " INSERT INTO tblEntries_Deleted EntryNo, EntryDate, EntryType, EntryHeading" & _
" SELECT tblEntries.EntryNo, tblEntries.EntryDate, tblEntries.EntryType, tblEntries.EntryHeading" & _
" FROM tblEntries " & _
" WHERE EntryNo=" & [Forms]![frmCashBankEntry]![cboEntryNo]

'Append the transactions underlined the entry
CurrentDb.Execute " INSERT INTO tblTransactions_Deleted TransactionID, TransactionDate, EntryNo, TransactionType, AccountNo, TransactionMemo, Category, [Currency], CurDebit, CurCredit, ExchangeRate, Posted, PostingDate, PostedBy, Void, VoidBy, VoidDate " & _
" SELECT tblTransactions.TransactionID, tblTransactions.TransactionDate, tblTransactions.EntryNo, tblTransactions.TransactionType, tblTransactions.AccountNo, tblTransactions.TransactionMemo, tblTransactions.Category, tblTransactions.Currency, tblTransactions.CurDebit, tblTransactions.CurCredit, tblTransactions.ExchangeRate, tblTransactions.Posted, tblTransactions.PostingDate, tblTransactions.PostedBy, tblTransactions.Void, tblTransactions.VoidBy, tblTransactions.VoidDate " & _
" FROM tblTransactions " & _
" WHERE EntryNo =" & [Forms]![frmCashBankEntry]![cboEntryNo]

'Delete Entry from tblEntries (Main table)
CurrentDb.Execute " DELETE tblEntries.EntryNo, tblEntries.EntryDate, tblEntries.EntryType, tblEntries.EntryHeading " & _
" FROM tblEntries " & _
" WHERE EntryNo= " & [Forms]![frmCashBankEntry]![cboEntryNo]

'Delete Transactions from tblTransactions which is associated with above entry number
CurrentDb.Execute " DELETE tblTransactions.TransactionID, tblTransactions.TransactionDate, tblTransactions.EntryNo, tblTransactions.TransactionType, tblTransactions.AccountNo, tblTransactions.TransactionMemo, tblTransactions.Category, tblTransactions.Currency, tblTransactions.CurDebit, tblTransactions.CurCredit, tblTransactions.ExchangeRate, tblTransactions.Posted, tblTransactions.PostingDate, tblTransactions.PostedBy, tblTransactions.Void, tblTransactions.VoidBy, tblTransactions.VoidDate " & _
" FROM tblTransactions " & _
" WHERE EntryNo =" & [Forms]![frmCashBankEntry]![cboEntryNo]

'Update the deleted tables with dates & user
CurrentDb.Execute " UPDATE tblTransactions_Deleted LEFT JOIN tblEntries_Deleted ON tblTransactions_Deleted.EntryNo = tblEntries_Deleted.EntryNo SET tblTransactions_Deleted.DateDeleted = Now(), tblEntries_Deleted.DateDeleted = Now() " & _
" WHERE EntryNo =" & [Forms]![frmCashBankEntry]![cboEntryNo]
End If
    End If
    Debug.Print VBAnsw
End Sub
Many thanks in advance for your help and cooperation.

mba_110 is offline   Reply With Quote
Old 02-07-2019, 02:55 AM   #2
Gasman
Enthusiastic Amateur
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,105
Thanks: 421
Thanked 753 Times in 731 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: Delete Command Button Event

You don't learn do you.

On numerous occasions, by numerous people you have been advised to put the sql string into a variable and Debug.Print that variable.

That will almost always highlight all these errors that you keep getting, but rather than do the work yourself, you would rather someone else do it for you.
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is online now   Reply With Quote
The Following User Says Thank You to Gasman For This Useful Post:
MajP (02-07-2019)
Old 02-07-2019, 03:03 AM   #3
essaytee
Need a good one-liner.
 
essaytee's Avatar
 
Join Date: Oct 2008
Location: Melbourne, Australia
Posts: 512
Thanks: 9
Thanked 123 Times in 119 Posts
essaytee is on a distinguished road
Re: Delete Command Button Event

For starters, you are missing the trailing semi-colon ";"

I haven't dissected the rest of it.

__________________
Steve.

I know UNIX, PASCAL, C, FORTRAN, COBOL, and nineteen other high-tech words.
essaytee is offline   Reply With Quote
Old 02-07-2019, 04:05 AM   #4
Gasman
Enthusiastic Amateur
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,105
Thanks: 421
Thanked 753 Times in 731 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: Delete Command Button Event

Quote:
Originally Posted by essaytee View Post
For starters, you are missing the trailing semi-colon ";"

I haven't dissected the rest of it.
I think that is optional Steve, I never use it unless I have pasted code from the QBE SQL window.
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is online now   Reply With Quote
Old 02-07-2019, 04:12 AM   #5
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 1,802
Thanks: 34
Thanked 544 Times in 516 Posts
MajP will become famous soon enough MajP will become famous soon enough
Re: Delete Command Button Event

I see several possible mistakes, but follow Gasman's advice and print back and we would all have a chance to debug.
MajP is online now   Reply With Quote
Old 02-07-2019, 04:16 AM   #6
essaytee
Need a good one-liner.
 
essaytee's Avatar
 
Join Date: Oct 2008
Location: Melbourne, Australia
Posts: 512
Thanks: 9
Thanked 123 Times in 119 Posts
essaytee is on a distinguished road
Re: Delete Command Button Event

Quote:
Originally Posted by Gasman View Post
I think that is optional Steve, I never use it unless I have pasted code from the QBE SQL window.
Hmm, it's something I've always done, but I may stand corrected. I'll now have to test it, but won't be until tomorrow.
__________________
Steve.

I know UNIX, PASCAL, C, FORTRAN, COBOL, and nineteen other high-tech words.
essaytee is offline   Reply With Quote
Old 02-07-2019, 04:18 AM   #7
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,431
Thanks: 112
Thanked 2,855 Times in 2,601 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Delete Command Button Event

The semicolon is definitely optional though I still always include it. Old habits

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 02-07-2019, 05:42 AM   #8
mba_110
Newly Registered User
 
Join Date: Jan 2015
Posts: 280
Thanks: 58
Thanked 0 Times in 0 Posts
mba_110 is on a distinguished road
Re: Delete Command Button Event

I can understand you guys are professionals and can tell anything you like if its not presented correctly or missed something, but every effort need time to get mature not immediately once its initiated, also please note i don't pressurize anyone to do my work.

Below is my try to make as you guys suggested, if not correct then let me know i will change it.

Code:
Private Sub CmdDeleteEntry_Click()
Dim Asql As String
Dim Bsql As String
Dim Csql As String
Dim Dsql As String
Dim Esql As String

Dim VBAnsw As String
If Me.cboEntryNo > 0 Then

VBAnsw = MsgBox("You are about to delete the entry and its underlined transactions" & vbCrLf _
& "If you click yes, you won't be able to undo this delete operation. " & vbCrLf & vbCrLf _
& "Are you sure you want to delete this records?", vbYesNo, "Warning")

If VBAnsw = vbYes Then
'Append the Entry details before deleting.
        Asql = " INSERT INTO tblEntries_Deleted EntryNo, EntryDate, EntryType, EntryHeading" & _
        " SELECT EntryNo, EntryDate, EntryType, EntryHeading" & _
        " FROM tblEntries" & _
        " WHERE EntryNo=" & [Forms]![frmCashBankEntry]![cboEntryNo]
Debug.Print Asql

'Append the transactions underlined the entry
            Bsql = " INSERT INTO tblTransactions_Deleted TransactionID, TransactionDate, EntryNo, TransactionType, AccountNo, TransactionMemo, Category, [Currency], CurDebit, CurCredit, ExchangeRate, Posted, PostingDate, PostedBy, Void, VoidBy, VoidDate " & _
            " SELECT TransactionID, TransactionDate, EntryNo, TransactionType, AccountNo, TransactionMemo, Category, Currency, CurDebit, CurCredit, ExchangeRate, Posted, PostingDate, PostedBy, Void, VoidBy, VoidDate " & _
            " FROM tblTransactions " & _
            " WHERE EntryNo =" & [Forms]![frmCashBankEntry]![cboEntryNo]
Debug.Print Bsql

'Delete Entry from tblEntries (Main table)
                    Csql = " DELETE EntryNo, EntryDate, EntryType, EntryHeading " & _
                    " FROM tblEntries " & _
                    " WHERE EntryNo= " & [Forms]![frmCashBankEntry]![cboEntryNo]
Debug.Print Csql

'Delete Transactions from tblTransactions which is associated with above entry number
            Dsql = " DELETE TransactionID, TransactionDate, EntryNo, TransactionType, AccountNo, TransactionMemo, Category, Currency, CurDebit, CurCredit, ExchangeRate, Posted, PostingDate, PostedBy, Void, VoidBy, VoidDate " & _
            " FROM tblTransactions " & _
            " WHERE EntryNo =" & [Forms]![frmCashBankEntry]![cboEntryNo]
Debug.Print Dsql

'Update the deleted tables with dates & user
    Esql = " UPDATE tblTransactions_Deleted LEFT JOIN tblEntries_Deleted ON tblTransactions_Deleted.EntryNo = tblEntries_Deleted.EntryNo SET tblTransactions_Deleted.DateDeleted = Now(), tblEntries_Deleted.DateDeleted = Now() " & _
    " WHERE EntryNo =" & [Forms]![frmCashBankEntry]![cboEntryNo]
Debug.Print Esql

DoCmd.RunSQL Asql, Bsql, Csql, Dsql, Esql
        End If
    End If
End Sub




The Immediate window show this result.

Code:
INSERT INTO tblEntries_Deleted EntryNo, EntryDate, EntryType, EntryHeading SELECT EntryNo, EntryDate, EntryType, EntryHeading FROM tblEntries WHERE EntryNo=2
 INSERT INTO tblTransactions_Deleted TransactionID, TransactionDate, EntryNo, TransactionType, AccountNo, TransactionMemo, Category, [Currency], CurDebit, CurCredit, ExchangeRate, Posted, PostingDate, PostedBy, Void, VoidBy, VoidDate  SELECT TransactionID, TransactionDate, EntryNo, TransactionType, AccountNo, TransactionMemo, Category, Currency, CurDebit, CurCredit, ExchangeRate, Posted, PostingDate, PostedBy, Void, VoidBy, VoidDate  FROM tblTransactions  WHERE EntryNo =2
 DELETE EntryNo, EntryDate, EntryType, EntryHeading  FROM tblEntries  WHERE EntryNo= 2
 DELETE TransactionID, TransactionDate, EntryNo, TransactionType, AccountNo, TransactionMemo, Category, Currency, CurDebit, CurCredit, ExchangeRate, Posted, PostingDate, PostedBy, Void, VoidBy, VoidDate  FROM tblTransactions  WHERE EntryNo =2
 UPDATE tblTransactions_Deleted LEFT JOIN tblEntries_Deleted ON tblTransactions_Deleted.EntryNo = tblEntries_Deleted.EntryNo SET tblTransactions_Deleted.DateDeleted = Now(), tblEntries_Deleted.DateDeleted = Now()  WHERE EntryNo =2

Last edited by mba_110; 02-07-2019 at 05:49 AM.
mba_110 is offline   Reply With Quote
Old 02-07-2019, 06:23 AM   #9
Gasman
Enthusiastic Amateur
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,105
Thanks: 421
Thanked 753 Times in 731 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: Delete Command Button Event

I am not a professional, enthusiastic amateur at the best. Which is probably why I am more critical of your postings, as I am in the same position, perhaps just a little ahead of you in usage of Access.

So when I offer you some code, sometimes it is because I have created something similar to what you are trying to do, note 'similar', not the same. It is offered to show you how I approached the problem, and might well not be the best way, but it works.

On other occasions I myself need to Google to get the correct syntax, or a way to do what you are asking. In fact that is how a lot of my code is obtained, snippets here and there and then amended to suit, with a lot of help here.

If I can do it, I see no reason why you cannot.? You are after all being quite adventurous in your projects.?

Re your current query, I would post each of those generated sql statements into the QBE SQL window and then switch to the design window, or a see what it complains about.

I would also try each in turn and not throw them all together and hope for the best. You were, quite a while back, shown the the SQL2VBA utility to assist in coding statements like these.

My SQL is certainly not up to identifying what you have got wrong in that last code window.

I have also learnt to use F8 to step through the code and set breakpoints to inspect variables as well as copious use of Debug.Print.

Carrying out these steps will allow you to become more proficient, rather than getting someone else to do the work all the time. You will learn very little with that approach.

That is just my 5 cents.
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is online now   Reply With Quote
The Following User Says Thank You to Gasman For This Useful Post:
NauticalGent (08-08-2019)
Old 02-07-2019, 06:47 AM   #10
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,419
Thanks: 162
Thanked 1,734 Times in 1,704 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: Delete Command Button Event

To add to Gasmans's very good advice - this line won't work;

DoCmd.RunSQL Asql, Bsql, Csql, Dsql, Esql

What you need is

Code:
CurrentDb.Execute Asql 
CurrentDb.Execute Bsql 
CurrentDb.Execute Csql 
CurrentDb.Execute Dsql 
CurrentDb.Execute Esql
However you could avoid all this if you added a field called DateDeleted and simply added that to the header record. Exlcude any records from all your reporting, processing etc where the DateDeleted field is not null.

No need for additional tables, complicated updates and deletes. And if someone "deletes" a record by mistake, you simply remove the deleted date and it magically gets included back into all your systems.

I also thought from another thread you were marking records as VOID - which also seems to make this entire process a bit fruitless ?
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 02-07-2019, 08:58 AM   #11
mba_110
Newly Registered User
 
Join Date: Jan 2015
Posts: 280
Thanks: 58
Thanked 0 Times in 0 Posts
mba_110 is on a distinguished road
Re: Delete Command Button Event

Thank you very much for all your comments and suggestions.

each button has its rule to play DELETE,EDIT,VOID etc and all these are required to give user options in database.

I have to complete this code by any mean, sql2vba is not that much effective in sql this work fine for list box events or select event etc, i did try this sql also but it is giving too many parameters error, I am not a full time access mady nor learned or take any classes for that all this what I have created is on my own and offcourse support of Google guru.

I don't know how this feels but I am not feeling good right now.

Last edited by mba_110; 02-07-2019 at 09:04 AM.
mba_110 is offline   Reply With Quote
Old 02-07-2019, 09:13 AM   #12
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,419
Thanks: 162
Thanked 1,734 Times in 1,704 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: Delete Command Button Event

Firstly although I do this (and a load of other "stuff") for a living, I'm not professionally trained in any way. I have learnt everything through trial , error (lots of errors) , google and reading here. What you have undertaken is not something a beginner should ever start with as a project, but you have your reasons.

Let's assume you want to continue to move these records to another table.

This is a step by step "How to debug your SQL guide"

You are already producing the SQL strings required in the immediate window.

Copy and paste the first of the individual queries into a new blank query designer SQL window. Run it. What error do you get?

If it makes no sense to you even with some thoughts about the error, paste that one query back here with the error code. And we'll see what we can see.

Rinse and repeat, one at a time!
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 02-07-2019, 09:20 AM   #13
Gasman
Enthusiastic Amateur
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,105
Thanks: 421
Thanked 753 Times in 731 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: Delete Command Button Event

Quote:
Originally Posted by mba_110 View Post
i did try this sql also but it is giving too many parameters error,
Well there you go, that is a start.

Count the fields both sides, those being updated, with what is updating them.

Delete query only needs * not field names as you are deleting the record, not individual fields.

Get one query working at a time, then move on to the next.
You might want to use the second parameter as well, to try and keep the data intact on failure.?,
https://docs.microsoft.com/en-us/off...ute-method-dao

It might be slower, but will be more beneficial in the end, those are my thoughts on the issues.
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is online now   Reply With Quote
Old 02-07-2019, 09:48 AM   #14
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,431
Thanks: 112
Thanked 2,855 Times in 2,601 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Delete Command Button Event

Just like Minty, I've never had any training in the use of Access.
I picked it up over many years by trial and error and lots of research.
Where I worked, nobody knew anything about Access.
It was also never my main job but I voluntarily took on a huge whole school task to organise an enrichment week which had 200 staff and 1500 students dependant on me succeeding. There were many times when I regretted doing so and many sleepless nights...but I did succeed and never looked back.

However as I was learning in my own time as well as doing a full time job, it was several years before I began to feel completely confident in Access.

Unlike you I had nobody to warn me that my first project was far too big a task to start with.
In your case, everyone here recommended you should not do your project at all but purchase a ready made application.

You have had a huge amount of help here from various people, not least myself. I stepped back because I felt you were being far too reliant on forum members to do much of the work. That may sound harsh to you but I know I'm not alone in that view

I recommend you put this project to one side until you are more experienced and work on more manageable projects for the immediate future.

Good luck whatever you decide
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 02-08-2019, 02:07 AM   #15
mba_110
Newly Registered User
 
Join Date: Jan 2015
Posts: 280
Thanks: 58
Thanked 0 Times in 0 Posts
mba_110 is on a distinguished road
Re: Delete Command Button Event

There is no question on giving up or keeping aside, I could run a append and update queries but in order to avoid bunch of queries in my project I decided to go with sql, every achievement need time and patience if I where struct like an ice from the beginning then probably it was better to give up, but its not like that in my case I have learned lot through Google and offcourse from you guys I can't through away just like that I have friends back in India who develop the software I could ask them also and it will be done easily, but why I am not doing so because my project will be mine with limited help from others and i do love to take challenges this project is not an required for anything, rather its my personal satisfaction and learning which I love to do.

I am not getting that much time due to my double Jobs in a day otherwise it wouldn't be a matter, I am not that much young now to give separate time for learning and developing the project life is so short now days you have to make efforts rather than waiting for correct time.

mba_110 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Event procedure for command button moori Modules & VBA 14 02-09-2012 07:50 AM
More than one Event on Command Button Click irunergoiam Forms 5 10-05-2009 01:59 PM
About Command Button Event Pioneer Forms 2 08-14-2008 09:16 AM
[SOLVED] command button save event suriya6in Forms 3 10-16-2003 06:37 AM
click event of a command button reena Modules & VBA 2 07-19-2001 05:37 PM




All times are GMT -8. The time now is 12:40 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World