Search results

Hi there, I'm struggling to get a query to select the right number of records based on field selections from 3 tables. Table 1 (tblEvents) has the below list of fields: Event ID Client ID Location ID Consultant ID Work Requested By Other work Date Work Completed Rate ID Rate Amount Any...

I found this code, but cannot get it to work. Option Compare Database Option Explicit Dim GrpArrayPage(), GrpArrayPages() Dim GrpNameCurrent As Variant, GrpNamePrevious As Variant Dim GrpPage As Integer, GrpPages As Integer Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount...

Is it possible to have a button on a form that simply opens up another database? I tried looking for something that does that but didnt find anything of use. If possible, it just needs to open the database like you would by clicking the .mdb file

I'm not sure if this is the right section, but here goes. How do I go about creating a simple login form, that remembers who you have logged in as, and then sets this name as the default value for a textbox on a form? A password for the login isn't really necessary, if that makes matters...

Hi again, Im obviously more of a novice at access than i thought because i cant wrap my head round what sounds like a simple concept, so I'm hoping the amazing people here can help. I have a table called tblRates which stores Rate ID (Number, Primary Key), Rate Alias (Text) and Rate Amount...

Hi guys, Im hoping you can help me here. Im currently making a database with several tables for clients, consultants etc. On the data capture form, Im using a combo boxes for client name (which links up to the Client ID when I use the lookup wizard, but still produces the name), consultant name...