Hello everyone! This forum has been very helpful, thank you all! My database will be ready for use soon, but I admit it's present design is lacking. Below is my current setup and the form I'm asking about in this thread:
Here is the VBA I used to navigate the various forms so that a user...
Could someone recommend me a really dumbed down book to learn Access 2010 VBA? I have absolutely no programming experience aside from dabbling in HTML about a decade ago. I'm trying to create some databases for my office and have finally accepted that I simply can't do the things I want to in...
The code I'm trying to use:
Private Sub cboModel_AfterUpdate()
Dim stQueryName As String
Dim stFormName As String
stQueryName = "qryModelParameter"
stFormName = "frmDesktopsByModel"
DoCmd.OpenQuery stQueryName, acViewNormal, acEdit
DoCmd.Close acForm, stFormName
End Sub
What it's failing to...
Hello!
I'm trying to make a form with either button controls or a combo box that will allow a user to select a month and then display the results of a query on the form. I've tried using sub forms and list boxes but can't seem to figure it out, nor can I find by way of Google a tutorial to help...
Hello everyone!
I am trying to set up a scheduling system.
I have two tables with the following (pertinent to this question) fields:
tblStudents:
StudentID (PK)
ClassID (FK)
and
tblCPR_Date:
ClassID (PK)
Class_Date
Class_Month
Class_Type
Class_Time
I'm trying to generate a query that...
Hello everyone!
I am trying to set up a scheduling system.
I have two tables with the following (pertinent to this question) fields:
tblStudents
CPR_DateID
First_Name
and
tblCPR_Date
Class_Date
Class_Month
Seats_Left
Each Class_Month has several Class_Dates. Each Class_Date has 12 open...
Hello everyone! I have no formal education in Access 2010, only a lot of googling. I'm trying to design a fairly simple scheduling database for 5-8 users, ideally with potential for expansion so it can be utilized to archive records and generate various reports.
Some points that may matter...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.