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

I've attached the file - thanks a mil, J.http://www.datapac.com/flash/accreditations.fla

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

...and this morning, it's back to hanging again. Nothing has changed, either on the server or on my own machine. What's going on?? Rgds, J.

Hi, Not all on the same computer - the files I'm trying to open are on the SharePoint server and I'm trying to open them from my own machine. Yes, they are all located document libraries - various different doc libs, within IE Version 6.0.2800.1106.xpsp2.050301-1526 Office 2003 Windows...

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

Thanks a lot - I did the skip option. Am I correct in thinking there used to be a Continue option - or am I thinking in a different language? From memory, Continue would go on to the next iteration, and Break would exit the loop - please tell me this thinking has some basis in reality, and I'm...

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

Thanks for that Ken, but the field is not an unbound field being saved to a table - it is a database field. I don't like input masks either so I'd rather stay away from them. I've always used separators myself, so I was never aware of this problem. I just went into Excel and formatted a cell as...

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

Perfect! Thanks John. Jennie.

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

Me again - sorry, silly mistake on my part. rs.movelast only moves the pointer to the beginning of the last record, not to the end of the file. I've changed to code to rs.move(rs.recordcount + 1) and it's now at eof. Jennie.

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 John It wouldn't allow the Emp_Id.SetFocus line (Error - you must save the field before you execute the ... SetFocus method), but moving it into the Before_Update event and setting Cancel = True sorted it. Thanks for your help. Jennie.

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

MakeItSo - that's exactly what I need. I've been trying all sorts of complicated stuff and all the time the answer was *so* simple. Thank you so much! [bigsmile] Jennie.