Search results for query: *

Hi, This one has me really baffled! We're using SharePoint 2003. I browse to a file on one of the Team Services sites, and open it (Edit in Microsoft Excel), make a change, and save the document. No problem. When another user tries to do the same thing, and she goes to save it, it displays...

Hi, I'm trying to do something very simple here, and I need to get it done really quickly, so I don't have time to go through the usual learning curve / trial and error. We're accredited with many large organisations, and I need to make their logos fade in and out on our home page - fade in...

Hi, We're using SPS 2003, and in the last few days it has started hanging when I try to open Word / Excel files from the site - not all files, though; here's the difference : When I click on a file and get the message box with the title 'File Download', in the format >>>>>>>>>> Some files...

Hi, I don't know if I'm posting in the right place, but maybe someone here can help. I have a sybase database, and want to read certain records to be displayed through a browser. At the moment, I have created an Ms Access database and linked to the relevant tables using ODBC. (I've done it this...

Hi How can I skip to the next iteration of a for next loop? Eg. I'm on iteration 5 but certain criteria mean I don't want to execute the remaining code, so I want to skip on to iteration 6. I thought the keyword was 'Continue' but apparently not. I can only find 'Exit For' which is not what I...

Hi, I have a number of date fields, and the users of the system want to be able to enter dates without having to enter separators. When I enter dates in that format (150404) I get an error saying "The value you entered isn't valid for that field". Any way round this? Thanks Jennie.

Hi I've declared a global variable in the General, Declarations, section of my code window (Public gv_Dealer as Integer). I set the global variable when I select a dealer from a dropdown list on a form, and want to use in to show selection criteria at the top of a report (This report is being...

I want to select records where a particular field is empty. I am using the following code : ******* lv_Criteria = "C_Pre_Requisite_T = '115'" If IsNull(rs_Emps.Fields("E_Area_Specialist")) Then lv_Criteria = lv_Criteria & " AND C_Specialist = ''" Else...

Hi. I have a form / subform, and I want to populate a variable with the value of a field in the subform (if the user tries to delete a record on the subform I need to do some lookups based on the value.) This needs to happen for every record, regardless of whether it's the first record, a new...

I have a form that I use to create training records for employees to go on courses. When attempting to put an employee on a course, I want to check that they have completed the pre-requisite courses (or are at least scheduled to do them). I have two recordsets - one to select the...

Hi - when I display a message box showing an error, how do I prevent focus from moving to the next field? I have the following code (thanks to MakeItSo!) : If DCount("Emp_Id", "qry_Employee_Passed_Course") > 0 Then MsgBox "That employee sat and passed this course...

Hi. I want to do a query as part of validation, and am not sure how to do it. To explain - I have a Training_Hdr form, and a Training_Dtl subform. The Training_Hdr record shows, among other things, Course_Id and Course_Date. The related Training_Dtl record shows Emp_Id, Test_Score, etc...

Hi. I have a Query that displays employees for a specified dealer - when I change the Dealer field on my form, I 'Requery' the Employee field. Now I want to do the same thing in another form, but the criteria in my query is hard-coded to read the Dealer code from the first form. I can't figure...

Hi, I'm trying to update a date field in a table when a user enters a date on a form. However, the date in the table is being updated incorrectly. I enter 05/Jan/04 on the form, and the date in the table shows up as 01/May/04 - the day and month are being switched around. Here's the code I'm...