Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BLSguy
  • Content: Threads
  • Order by date
  1. BLSguy

    Help streamline my code?

    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...
  2. BLSguy

    Recommend a good 1st VBA Book?

    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...
  3. BLSguy

    Why isn't this code working?

    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...
  4. BLSguy

    Controls to update Queries on a Form?

    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...
  5. BLSguy

    Query or Macro for this function on a form?

    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...
  6. BLSguy

    Referencing Totals from One Table in the Fields of Another

    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...
  7. BLSguy

    Put together some forms with controls and queries

    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...

Part and Inventory Search

Back
Top