Search results

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!

By lookups I simply mean a table for things like Location, which stores Location ID, CLient ID and Location Name. It just serves as a row source for a cmobo box. Is this what you mean?

Yes, I looked at the sample, and understood how that worked. When I went to apply it to mine it doesnt work. Im currently checking the lookups in mine to make sure they're correct

For some reason its just making the combo box blank, not sure why this is?

this works great! so thats that problem solved. now, how do i make a text box named "Rate Amount" lookup the rate amount and display it, based upon the dropdowns selection? For some reason I cant make DLookup work, if this is even the right approach?

this will help pick up which clients use a special rate. however wont this only bring up the special rate and not the others? im not sure if its possible, but i need the combo to always bring up all 5 options that i mentioned before, default to rate 1 for all clients, apart from those which use...