i need your help to complete code in excel user form button (save data\new)
the user form is to record data in it then when press button (save data\new)
the data export to access data base and clear all data in user form to new record
thanks alot
i need your help to complete code in excel user form button (save data\new)
the user form is to record data in it then when press button (save data\new)
the data export to access data base and clear all data in user form to new record
thanks alot
Last edited by onejan; 08-03-2019 at 04:43 AM.
An easy alternative is to build your table in Excel. Link it to Access. No need for any VBA to transfer the data. You enter your data in the excel sheet and it automatically updates the information into Access and can be used for queries or reports.
https://support.office.com/en-gb/art...d-e084913cc958
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
thanks alansidman
but i need putting code in excel form
the form to use from many users
can you help me
thanks
Last edited by onejan; 08-03-2019 at 10:05 AM.
Hi !
Why don't you use directly Access for the data entry ?!
As the better way is without any code like the link from Alan …
As Access can import text files, so a beginner easy way is to save Excel data as .csv for example …
ok as i said before
the user form in excl used from many users
and this form to inter data on it by many employee using deferant pc
and i want to save what employee record in access data base
thanks
I'm with Marc on this issue. Having many users trying to use the same form in Excel will only cause issues, while you can build a form in Access and have an almost unlimited number of people logged into the Access file with out any disruption or duplications or errors from multiple people in the same program. I believe that the direction you are attempting to go will lead you to many issues in the long run. I speak from experience here. Excel does not work well when many users attempt to share a file.
"We've always done it that way," is never a valid reason not to make a change. I'm with the others: choose the right tool for the job.the user form in excl used from many users
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. As you have so few posts here, I will provide the links for you this time.)
https://www.accessforums.net/showthread.php?t=77825
https://www.mrexcel.com/forum/micros...data-base.html
Hi AliGW
i apologize for this but i put subject in many site to reach for quick answer
i need this project
Need desperately
If you are that desperate for help, perhaps go and ask on a site where you can pay someone to look at it immediately.
This is not one of those sites. Those who help here are volunteers, and in order that their time not be wasted, we have a rule about cross-posting. You have to abide by this rule even if you are desperate for help.
Please read the forum rules: https://www.excelforum.com/forum-rul...rum-rules.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks