Recent content by UncleHuckleberry

I've experimented with joins but the criteria I add in the WHERE statement filters the employees and doesn't show them all. I guess i'll have to apply the join after making the WHERE statement, but i'm unsure how to write this in SQL. "When the going gets wierd, the wierd turn pro" - R. Duke

I'm having problems writing the SQL to Join a query with a table to show all employees for a particular company. I have the following query so far: SELECT Country, Region, Company, FullName, EmpNo, Sum(Total) As Total1, LRTime_Stamp, LRSupervisor_EmpNo, LRSupervisor_Name FROM qSel_All_Data_2...

Thanks predamarcel, thats perfect. "When the going gets wierd, the wierd turn pro" - R. Duke

I'm new to javascript and i'm trying to create a validation function that will check if the string input is correct. The string should only be numeric values seperated by commas e.g. 12345,23456,34567 can someone please suggest the best way to approach this. Thanks. "When the going gets...

Hello, I have a question about syncronising front ends on an access database split. I would like to implement a structure which has a back end database storing the data tables and several front ends which allow the users the ability to add additional queries and reports. I have seen several...

I have a table called tblCodes: ItemNo, CodeNo, DateEntered 1 1 12/10/2004 1 2 13/10/2004 1 3 14/10/2004 I want a query that shows the latest DateEntered for each ItemNo and the corresponding CodeNo to go with it. If I have a MAX on date entered...

Yep, all references present and correct "When the going gets wierd, the wierd turn pro" - R. Duke

I'm trying to reference the access object library from vb and I need to use AccessObject to reference the dependencies for a query. This code is producing errors, any ideas why? Dim ObjAccess As access.Application Dim objParent As access.AccessObject Set ObjAccess = New access.Application Set...

Try this code I got from somewhere on the web, call the sub with the relevant parameters. It works for me. 'Public Sub SendNotesMail(Subject as string, attachment as string, 'recipient as string, bodytext as string,saveit as Boolean) 'This public sub will send a mail and attachment if...

Hello, I've got a corrupt access 2000 database, I've got a backup but its a few days old and I've lost numerous reports, forms and coding. Does anybody have any techniques for salvaging aspects of corrupt access db's. I don't really want to spend the sort of money it takes to buy a specialist...

Thanks for your help. I've bought a brand new HP toner cartridge but its still doing the same thing. I can't find a cleaning cartridge utility, is there anywhere I can download this from?

Hi Ken, I meant without opening the database or the reports, just getting a list of whats there.

Is it possible to programatically get a list of the reports for a database without opening it? Cheers.

Hello, I've got a problem with a HP Laserjet 1200 series printer. The first few pages it prints are a complete mess with excess powdery ink covering the page in the form of whatever is being printed, each page is then less and less of a mess until finally it stops. Any Ideas?

Hello, I am trying to produce a Cross Tab query in Access and wondered if what i was trying to do is possible and if it is if somebody could point me in the right direction. My Data is: ApplicationID Successful Date Group 1 YES 01/02/04 Group1 2 NO...