Search results

Hi All, I've got an SQL table which has a start time, and start date filed in it, the format of the time is 01/01/1900 08:00:00 and the date format is eg 28/08/2009 00:00:00 - it's an awful way of doign it, but thats what in our product! I'm trying to convert the start time to HH:MM but...

Dear All, Please can you tell me if it is possible to have a word document as a report - with data in - so I could perform a glorified mail merge really? I tried doing a straight mail merge but it lacks the control and ability to query every time which record you want. Many THanks Graham

Hello All, I'm having trouble running a piece of VBA code - centering around the shell command. The code is below: Private Sub cmdOpenFile_Click() On Error GoTo Errhand Dim strfilepath As String strfilepath = Path.Value Debug.Print strfilepath Shell strfilepath, vbMaximizedFocus...

Dear All, I appear to be struggling to get the OpenArgs property of a DoCmd.OpenForm statement to work. The "calling" form's code is: Public Function lstUser2_Click() Dim intuserid As Integer intuserid = Forms!frmUsrQualSearch1.List0.Column(0) DoCmd.OpenForm...

Hello All, I'm trying to run the query Below on SQL Server 2000 and and getting the error "Line 4: Incorrect syntax near '=' " I wonder if anyone can offer assistance? UPDATE tblStaffQual SET Status = (CASE WHEN GETDATE() >= Expires_Date THEN Status = 'Expired' WHEN...

Hi Folks, I'm having a couple of issues with a query I'm running through MSAccess. It has in it a couple of "calculated" fields, for one of them, it all works fine, the second has some #Error data entries being returned it it. The Query is Below: ============== SELECT tblContractType.Type...

Hi All, I am building a database between SQL Server 2000 and MS Access 2003. I have a question in how do I go about creating autonumbers in my ID fields, becasuse SQL Server didn't have an auto number field type, so I've created all the ID's in my Back End tables as "bigint" data type, but...

Hi All, I have a question of the functionality of Crystal Reports. I presently have a database which is our course booker, which in it's front end has a Crystal Reports tool. Separately to that I have a second database which has a large number of modules, reports and tables to produces all...

Hi All, I have a database of our company's mobile phone users. In it are several tables, one - tblEmployeeList a complete employee list with each employee's perpetual Project code and task code. a 2nd - tblJobList table with 2 columns for all the possible combinations of project code and...