Cheat Engine Forum Index Cheat Engine
The Official Site of Cheat Engine
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 


MS Access + VB coding (Need help setup)
Goto page 1, 2  Next
 
Post new topic   Reply to topic    Cheat Engine Forum Index -> General programming
View previous topic :: View next topic  
Author Message
asianking
Expert Cheater
Reputation: 0

Joined: 25 Jun 2008
Posts: 109

PostPosted: Fri Mar 04, 2011 4:15 pm    Post subject: MS Access + VB coding (Need help setup) Reply with quote

Here is a diagram I draw.



My goal: Use this as task checklist database. I know there's already a template, but not a checklist typo.

explaination:

Save: Save as new user. If user already exist; Reject save and tell user that it already exist so use Update button instead.

Update: Update existed data information with a warning are you sure incase of accident.

Search: search by either Name, Tag, or Service Tag. Doesn't have to fill-in all info here. Can just type the user name and search or etc...

Checklist: task such as install flash, install office, etc...

Checkbox: Uncheck as default and able to check it if task is done.

I like this to be more like a database type.[/img]

_________________
Back to top
View user's profile Send private message MSN Messenger
AhMunRa
Grandmaster Cheater Supreme
Reputation: 27

Joined: 06 Aug 2010
Posts: 1117

PostPosted: Fri Mar 04, 2011 11:25 pm    Post subject: Reply with quote

I would use asp and C# for this rather than VB. You can even put it inside a pretty page and either update it per event like click a check box the db updates instantly or wait until completion to update the form. You can use the ODBC adapter to have them talk to each other. Don't have an IIS server? There is an Apache ASP plugin, Mono http://www.mono-project.com/Main_Page that allows ASP to run on Apache web servers.

Otherwise try here.

http://www.vbexplorer.com/VBExplorer/vb_feature/june2000/Database_Beginner_ADO_DAO.asp

_________________
<Wiccaan> Bah that was supposed to say 'not saying its dead' lol. Fixing >.>
Back to top
View user's profile Send private message
atom0s
Moderator
Reputation: 205

Joined: 25 Jan 2006
Posts: 8587
Location: 127.0.0.1

PostPosted: Sat Mar 05, 2011 9:26 am    Post subject: Reply with quote

AhMunRa wrote:
I would use asp and C# for this rather than VB. You can even put it inside a pretty page and either update it per event like click a check box the db updates instantly or wait until completion to update the form. You can use the ODBC adapter to have them talk to each other. Don't have an IIS server? There is an Apache ASP plugin, Mono http://www.mono-project.com/Main_Page that allows ASP to run on Apache web servers.

Otherwise try here.

http://www.vbexplorer.com/VBExplorer/vb_feature/june2000/Database_Beginner_ADO_DAO.asp


You should avoid doing single updates per-event since you will stress the database a lot if the application lands up being used in large scale audiences. You should alter the database as little as possible with the fewest amount of calls for better performance.

@OP: What kind of application are you looking to write? Or are you planning on designing a website with this?

Edited to fix spelling mistake dur.. I shouldn't post until I've had coffee..

_________________
- Retired.


Last edited by atom0s on Sat Mar 05, 2011 6:32 pm; edited 1 time in total
Back to top
View user's profile Send private message Visit poster's website
asianking
Expert Cheater
Reputation: 0

Joined: 25 Jun 2008
Posts: 109

PostPosted: Sat Mar 05, 2011 9:56 am    Post subject: Reply with quote

not actually a website; just a database record of installing programs to pc for office users. This record tells me who got the pc with the service tag.
_________________
Back to top
View user's profile Send private message MSN Messenger
AhMunRa
Grandmaster Cheater Supreme
Reputation: 27

Joined: 06 Aug 2010
Posts: 1117

PostPosted: Sat Mar 05, 2011 10:06 am    Post subject: Reply with quote

We use a similar method in Access though we pretty much just enter the serial number of the machine, the branch it was sent to, the user, the ip assigned (for remoting lookup purposes), and the date it was issued. All the software setup we enter onto a separate paper sheet, and throw it away once the data is entered into the db.

Currently, I'm hacking together a barcode scanner so I can just scan the barcodes and track our inventory.

_________________
<Wiccaan> Bah that was supposed to say 'not saying its dead' lol. Fixing >.>
Back to top
View user's profile Send private message
atom0s
Moderator
Reputation: 205

Joined: 25 Jan 2006
Posts: 8587
Location: 127.0.0.1

PostPosted: Sat Mar 05, 2011 6:35 pm    Post subject: Reply with quote

asianking wrote:
not actually a website; just a database record of installing programs to pc for office users. This record tells me who got the pc with the service tag.


Is this going to be a program then? If so you can just create a web service to handle the database queries and connect to it via the application. Service binding in C# (and dare say it VB.NET) is extremely easy.

As AhMunRa suggested as well, if you plan to do a site with it, ASP.NET would be easy to work with to do a site for a front end like that too. MVC3 is released now which makes things like this fairly easy to whip together overnight.

Of course you can do all the same in other languages and so on, so which ever you are more comfortable with is up to you.

_________________
- Retired.
Back to top
View user's profile Send private message Visit poster's website
asianking
Expert Cheater
Reputation: 0

Joined: 25 Jun 2008
Posts: 109

PostPosted: Mon Mar 07, 2011 5:15 pm    Post subject: Reply with quote

you mind given me a simple to start off. BTW, I have no experiences in C# or C++. I'm only familiar 25% with Visual Basic.
_________________
Back to top
View user's profile Send private message MSN Messenger
atom0s
Moderator
Reputation: 205

Joined: 25 Jan 2006
Posts: 8587
Location: 127.0.0.1

PostPosted: Mon Mar 07, 2011 5:20 pm    Post subject: Reply with quote

With Visual Studio 2010, here is a decent example of how to write a basic service and client to communicate with it:
http://sarangasl.blogspot.com/2010/09/create-simple-web-service-in-visual.html

_________________
- Retired.
Back to top
View user's profile Send private message Visit poster's website
asianking
Expert Cheater
Reputation: 0

Joined: 25 Jun 2008
Posts: 109

PostPosted: Tue Mar 08, 2011 5:36 pm    Post subject: Reply with quote

i would careless about the service and client. What i most concern about is how to design the code to restore and save the data I posted as picture.
_________________
Back to top
View user's profile Send private message MSN Messenger
atom0s
Moderator
Reputation: 205

Joined: 25 Jan 2006
Posts: 8587
Location: 127.0.0.1

PostPosted: Tue Mar 08, 2011 5:45 pm    Post subject: Reply with quote

asianking wrote:
i would careless about the service and client. What i most concern about is how to design the code to restore and save the data I posted as picture.


That all comes down to how you go about making the overall project. Like asked before, are you making a program or a website to handle this? You dodged that question before, but we can't help you 'code' anything if you have no specific idea in mind with how to implement this.

If you want to just directly access the database, which I don't recommend doing, you need to pick which type of database you want to use.

If you are designing an application:

If you are using MSSQL, you can use the provided namespace in the .NET framework to access the database:
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.aspx

If you are using MySQL, you will need to use a provider made by MySQL which you can download at:
http://dev.mysql.com/downloads/connector/net/5.0.html

The MySQL provider is designed to mimic the MSSQL one, so it should be easy for you to understand them both if you need to use both for the project.

_________________
- Retired.
Back to top
View user's profile Send private message Visit poster's website
asianking
Expert Cheater
Reputation: 0

Joined: 25 Jun 2008
Posts: 109

PostPosted: Tue Mar 08, 2011 6:58 pm    Post subject: Reply with quote

program. Not a web! I think i answer that already.

I'm assuming using visual basic alone making the database isn't possible. But I could have swear I saw someone did it before. Just that It save the info into text and when search by the user name; it would search that file and display that info in a graphical interface as the photo I draw.

_________________
Back to top
View user's profile Send private message MSN Messenger
AhMunRa
Grandmaster Cheater Supreme
Reputation: 27

Joined: 06 Aug 2010
Posts: 1117

PostPosted: Tue Mar 08, 2011 7:45 pm    Post subject: Reply with quote

You could make it as a standalone application in C# very easily too.
_________________
<Wiccaan> Bah that was supposed to say 'not saying its dead' lol. Fixing >.>
Back to top
View user's profile Send private message
atom0s
Moderator
Reputation: 205

Joined: 25 Jan 2006
Posts: 8587
Location: 127.0.0.1

PostPosted: Tue Mar 08, 2011 9:15 pm    Post subject: Reply with quote

You can do the same things in VB as C#, just port the code over. C# is just the more used language of the two as VB is fairly hated by most developers. (Not saying it's dead.)
_________________
- Retired.


Last edited by atom0s on Tue Mar 08, 2011 9:58 pm; edited 1 time in total
Back to top
View user's profile Send private message Visit poster's website
AhMunRa
Grandmaster Cheater Supreme
Reputation: 27

Joined: 06 Aug 2010
Posts: 1117

PostPosted: Tue Mar 08, 2011 9:43 pm    Post subject: Reply with quote

By no means is it dead, I still use it at work for tons of things. Like grabbing lists of installed software from remote computers, getting the currently logged in user on a computer. Those are just easier for me in VB than anything else.
_________________
<Wiccaan> Bah that was supposed to say 'not saying its dead' lol. Fixing >.>
Back to top
View user's profile Send private message
atom0s
Moderator
Reputation: 205

Joined: 25 Jan 2006
Posts: 8587
Location: 127.0.0.1

PostPosted: Tue Mar 08, 2011 9:58 pm    Post subject: Reply with quote

AhMunRa wrote:
By no means is it dead, I still use it at work for tons of things. Like grabbing lists of installed software from remote computers, getting the currently logged in user on a computer. Those are just easier for me in VB than anything else.


Bah that was supposed to say 'not saying its dead' lol. Fixing >.>

_________________
- Retired.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Cheat Engine Forum Index -> General programming All times are GMT - 6 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group

CE Wiki   IRC (#CEF)   Twitter
Third party websites