Programming experience, but no access experience

[redfox1160]

Hello,



I want to make an access database for users at my office. Currently I have the databases set up, but I don't know how to make a GUI. I want to have buttons that will only display certain data from specific tables when clicked. I also want user's to be able to add, and/or change data, if they press a separate button. I have some experience programming in C# and Python, and thought it might come in handy when making this database. I am not certain what I should do to implement this, and my googling skills haven't really helped me thus far. Thanks for any help!

[redfox1160]

Hello,

I want to make an access database for users at my office. Currently I have the databases set up, but I don't know how to make a GUI. I want to have buttons that will only display certain data from specific tables when clicked. I also want user's to be able to add, and/or change data, if they press a separate button. I have some experience programming in C# and Python, and thought it might come in handy when making this database. I am not certain what I should do to implement this, and my googling skills haven't really helped me thus far. Thanks for any help!

Also, I have tried to look at the code/database for this database app (from these forums): https://www.accessforums.net/sample-...tion-7564.html
but I don't know how to edit it. It just seems to open up as an application. Thanks again for any help

[ajetrumpet]

fox,

C# and Python aren't going to help you much here. The syntax is completely different. That's like night and day. And actually, there are so many tools built into the 2010 version of access that you probably don't even need to do any programming. You have to start with the objects. Forms, etc...

what do you know about those?

[redfox1160]

fox,

C# and Python aren't going to help you much here. The syntax is completely different. That's like night and day. And actually, there are so many tools built into the 2010 version of access that you probably don't even need to do any programming. You have to start with the objects. Forms, etc...

what do you know about those?

I don't know anything about them, I have no prior experience with Access... do you think I could do this knowing nothing about access? Where would you suggest I go to find out how to do this? Thanks again!

[redfox1160]

I figured out how to open the database located here: https://www.accessforums.net/sample-...tion-7564.html
(Hold shift when opening)
What language is the code written in? Is it visual basic?

[ajetrumpet]

I don't really know, fox. Access has always come natural to me, and that unfortunately makes me a terrible teacher. But I can tell you that I've seen beginners say anything from 1-10 on the ease of learning this program. Some say it's a piece of cake, and others come back and ask 50 questions if they have 50 tasks to do.

In my eyes, this is not difficult, and would obviously take someone like me, or some of the other guys here, 20 minutes to do. But...the things you need to know about this program are: the objects, properties of those objects, and the interface menus and functions. If you know where to find and use those 3 things, chances are you won't even need to write code.

I forget, is Python a server language? I remember it being very high level. You could probably understand Basic very easily because Python has a lot of similar concepts that use the same wording. C# however...NO.

[ajetrumpet]

What language is the code written in? Is it visual basic?

Actually, the program I believe is written in C, but the code that access can execute is VBA. That is not visual basic, but it's extremely similar. It's just a very small extension. The only differences between it and VB itself are the qualifiers and object oriented actions. Qualifiers are very different, only because all VBA programs sport different objects.