Search results for query: *

Whenever I click on a link that results in a new window opening, the new browser seems to hang. It appear on the task bar and the rim of the browser appears but the page never fully loads. I'm using XP with IE version 6.0. Any help appreciated.

Hi I've got two spreadsheets in the one workbook which have linked cells (ie changes in a cell on on worksheet are automatically reflected in a cell in the other worksheet). Is there anyway inserting a row in one sheet can result in a row being automatically inserted in the corresponding...

I'm using Excel 2000 which only appears to give you contents, objects and scenarios as things you can select to protect.

Hi Well the title explains it all really. When I protect the worksheet it's not possible to adjust the column width. Is there any way I can do this? Thanks meliorexi

Hi All I've created a spreadsheet template which uses data validation lists. I've placed these lists in the column adjacent to the column with the lists. However, when I copy and paste data into the spreadsheet, Excel places data into the hidden column which then throws everything out of whack...

Hi The first page of my report prints out fine, but subsequent pages push the text down the page a couple of inches as if a large blank header had been inserted. Any ideas what could be causing this?

Hi When I try to save a new record from a form in my Access Project is returns an "Invalid Object" (along with the name of the object) error and won't let me save the record. If I type the record directly into the table I can save it no problems. Any suggestions?

Hi I am attempting to create a form that will accept a date and return all reports with the same invoice date. I have created the form and now need to enter the criteria in the query underlying the report (as per step 9 in Help in Access XP). As the database is an adp I have to explicity name...

Sorry, I should specify that I am using SQL Server with Access XP as the client (therefore it is an Access Project, not an Access database).

Hi I need to calculate an invoice amount using information from various tables in my database. I prefer to do it in Expression Builder but can't seem to access it. When I right click on the Invoice Amount control (in design view of the form) and select Build Event (it does not allow me to...

Hi This is pretty hard to describe. I have a form which contains a subform in a 1 to M relationship. In the main form the user creates a flight. In the subform the user has to allocate multiple crew to the flight. I am looking for some way to validate whether the crew are in fact the correct...

Worked a treat. Thanks!

Hi I'm trying to output fields in a report (actually a sub-report). I've used the =[Cus_First_Name]&" "&[Cus_Last_Name] method but it has still left several unwanted spaces. Oddly enough, I've output similar information in the super report (the main part of the report) without any...

Hi I have created a form based on a single table. Two of the controls are related and I want one to return a result on one control based on the selection (from a combo box) that the user makes on the other. For example, if the user selects COMM from a combo box in one control, I want the other...

Yes, you're right. I was talking about controls. Many thanks for your help.

Hi I am trying to develop a report that outputs customer information. Trouble is the field sizes are not changing automatically according to the size of the value, leaving large spaces between, for example, first and last name. I am aware of the 'can grow' / 'can shrink' property, however this...