Search results for query: *

Hi - Thanks for all your help - things are getting better. I've had a slight change of plan and am now merging all the documents from access - Example below «sales_commission_header» «Sales_Commission_clause_1» «Total_On_Target_Earning» «sales_Commission_clause_2» «OTE»...

Hi Unfortunatley that's the format my MERGEFIELD are setup as. My problems lie I suppose around having a number of clause together, if they are all referenced then it looks OK but when they aren't the spaces between the clauses group together. Perhaps the answer would be to write a VBA...

Hi I'm compiling a merged contracts document in Word 2003 fed from an Excel spreadsheet. I'm using the if ..then ..else functionaility to ecide whihc clauses have to be included in the contract. My problem is if a there are a numebr of clause in a row which an employee isn't eligable for...

Hi - If anyone is interested, I sorted it in the end by creating a File DSN in Administrative Tools Data sources(ODBC)instead of a System DSN - The File DSN method allows you to add UIDs amd PWDs under the advanced function. Cheers Jon

Hi, Yes I tried that out, but it didn't seem to make any difference. I'll try again though. Cheers

Hi I've created an application in Access 2003 which links tables from an Oracle ODBC database (9.2home). A number of queries are scheduled the results of which are auto mailed, however The problem I have is that unless I'm already logged onto ORACLE I get promted for a User Name and Password. Is...

Hi, I'm a bit confused (which isn't that strange for me) If I open an excel spreadsheet and type a date in it and then select another cell there doesn't seem to be a problem and I haven't had to press enter or use navigation keys

Hi Sawedoff To help prevent user intervention all cell are protected apart from those which I want them to enter data into. In testing situations it was possible to navigate between cells using the tab button, but it was found that most of the users wanted to try and navigate by clicking from...

Hi wander if anyone can help. I have an excel spreadsheet which has a cell into which I enter a date. This cell has data validation to make sure it is within a range. After typeing the date into the cell I want to navigate to another cell using my mouse, but this causes the validation rule to...

Hi Miller, I presume you are using the org chart wizard to create the your chart from an Excel file. You will be given the option to either specify which information to display on each page by choosing the employee at the top of the page and the number of levels below. Or alternativley you can...

I have designed a database such that when I click my 'create letter' button in the form it auto open word and mail merges the data from that record, I have a problem that sometimes the word macro opens another instance of access and therefore not selecting the record I was viewing in the form...