Recent content by jackyaz

Hi there, The Event ID column in each of the tblEvents and tblNonClients are ID numbers for the rows in each individual column. Theyre not linked in any way, perhaps my fault for calling them the same thing! With a subreport, would it bunch all the tblNonClient entries at the end of the...

Hi Mr Smin, One consultant can have many records in tblEvents and many records in tblNonclient. Jack

Ok I'll give that a go. Quickly though, what relationships do I need in the query? I assumed 2 outer joins between the tblEvents and tblNonclient and the tblConsultants would be right, but I get an error about ambiguous outer joins???

Hi Mr Smin, I was trying to build the query so it could be used in a report. The same duplicate issue arises even when I set the Consultant name as a section header, so I thought I must be doing the query wrong! Regards, Jack

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

Consultant name. I made it work, i changed the "as variant" to "as string" and added in a hidden field with control source =[Pages]. Sheer guesswork, but it works!

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

how do i use that? im a total rookie

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

Thanks, I found an example which I have got to work perfectly, using some customization of course!

Ok then, cheers, I shall have a search

oh okay then, i'll have a go with that edit: just seen what that does. some of the computers we'd be accessing the database from have usernames such as "Shared", as they are a shared user. On another database I've seen there is a form at the beginning with a combobox that lets u select a name...

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

No worries, Im not even sure what a table level lookup is, im essentially a novice at databases, but I can put together impressive-looking ones, although they are fairly simple.

ah i got it to work, one of them wasnt lookign for an ID, once i changed it, it works perfectly! thanks again guys!