A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 39
Search took 0.18 seconds.
Search: Posts made by: shirl
Forum: Running & Setting Up Queries November 30th, 2012, 09:27 AM
Replies: 0
Views: 6,569
Posted By shirl
Days and dates query

I am hoping someone can help me with this.

My database contains events/courses with a start date and an end date, the start date could be say 1/9/12 (UK dates) and the end date could be 1/8/13, the...
Forum: Running & Setting Up Queries April 22nd, 2012, 09:04 PM
Replies: 0
Views: 2,111
Posted By shirl
Find a date between two date fields

I have a database which contains an events table, fields a
Event Title, End date, Start date, Start time, End time, Frequency (this is a combo for weekly, daily, monthly, one off)

What I want to...
Forum: Worksheet Functions November 7th, 2010, 07:22 PM
Replies: 0
Views: 1,820
Posted By shirl
Calculate cost according to date (problem with January)

Ignore my message, below I have managed to solve the problem

8/11/10

I have a spreadsheet which will be used to calculate printing costs for each person each month. Column A is formatted as a...
Forum: Database Design May 16th, 2010, 01:12 PM
Replies: 3
Views: 490
Posted By shirl
Thanks for you help, have finally got it...

Thanks for you help, have finally got it sorted.
Shirl
Forum: Database Design April 30th, 2010, 10:25 PM
Replies: 3
Views: 490
Posted By shirl
Access ID

Hi

I have a database that was set up very quickly a few years ago, it is for recording the booking out of equipment to staff at a college.

The database now has over 1500 records and I would like to...
Forum: Database Design April 30th, 2010, 10:25 PM
Replies: 0
Views: 268
Posted By shirl
Access ID

Hi

I have a database that was set up very quickly a few years ago, it is for recording the booking out of equipment to staff at a college.

The database now has over 1500 records and I would like to...
Forum: Database Design February 11th, 2010, 10:14 AM
Replies: 8
Views: 636
Posted By shirl
Thanks for the replies, she has now got round it...

Thanks for the replies, she has now got round it by exporting to RTF and puting in Headers and Footers.

Shirl
Forum: Database Design February 10th, 2010, 09:45 AM
Replies: 8
Views: 636
Posted By shirl
Access 2007 Table Header and Footers

Hi

A colleague wants to know if it is possible to put a header and footer in a table in Access 2007, she used to be able to do it in previous versions.

I have had a look and cannot find a way of...
Forum: Publisher October 23rd, 2009, 10:23 PM
Replies: 3
Views: 481
Posted By shirl
No it's not a silly question and sorry this is a...

No it's not a silly question and sorry this is a long answer. FYI I am in the UK.

I am working on a project with teaching staff, giving audio feedback in electronic assignments, mainly Word and...
Forum: Publisher October 19th, 2009, 11:47 AM
Replies: 3
Views: 481
Posted By shirl
Sound recorder in Publisher

Hi

I want to record a voice in Publisher using the sound recorder. I can do this by Insert object and selecting Wave Sound, but when I do this the sound icon does not appear even if I tick the...
Forum: General Discussion October 15th, 2009, 05:01 PM
Replies: 3
Views: 89
Posted By shirl
Hi I have a colleague who is looking to do...

Hi

I have a colleague who is looking to do something similar to this original posting. We have tried both of the suggested solutions but keep getting error messages. We are using Excel 2007 with a...
Forum: General Discussion August 8th, 2009, 11:56 AM
Replies: 0
Views: 167
Posted By shirl
Prevent Word documents from opening in browser

Hi

I know how to change the settings in Windows XP so that when downloading Word documents they do not open in the browser window. However, I am now using Vista and cannot find where to change this...
Forum: General Discussion August 8th, 2009, 10:18 AM
Replies: 1
Views: 221
Posted By shirl
I have had the same problem, if the file is saved...

I have had the same problem, if the file is saved as a .zip file then extracted it contains xml files and not the Word document. However if the zip file is renamed to .doc or docx then it opens as a...
Forum: Mailmerge February 13th, 2009, 09:25 PM
Replies: 4
Views: 100
Posted By shirl
Thumbs up Peter Thanks for the reply, a colleague has also...

Peter

Thanks for the reply, a colleague has also found a similar response and we will report it to the exam board, I suspect that whoever wrote the exam paper did not test using a query for a mail...
Forum: Mailmerge February 13th, 2009, 12:42 PM
Replies: 4
Views: 100
Posted By shirl
Hi It is just a simple Access query with the...

Hi

It is just a simple Access query with the critera Like A* to find all the postcodes which begin with A.

Shirley
Forum: Mailmerge February 12th, 2009, 03:12 PM
Replies: 4
Views: 100
Posted By shirl
Question Mailmerge from Access Query - Data missing in Word

Hi

I am using Office 2007. I have a simple database which contains about 20 records. Have created a query to find people who live in a certain area. This query is then required to be merged to a...
Forum: General Discussion September 11th, 2008, 03:02 PM
Replies: 2
Views: 74
Posted By shirl
I have a colleague who had the same problem in...

I have a colleague who had the same problem in Outlook 2007.

Open the message containing the distribution list this should be an attachment (don't open the attachment), then open your contacts in...
Forum: General Discussion September 6th, 2008, 06:41 PM
Replies: 2
Views: 134
Posted By shirl
Smile Dave, Thanks it works, simple really. Shirl

Dave,

Thanks it works, simple really.

Shirl
Forum: General Discussion September 6th, 2008, 02:06 AM
Replies: 2
Views: 134
Posted By shirl
Checkboxes in Excel 2007

I am using Excel 2007 and want to create a survey form for staff using checkboxes (form controls) and I want to use a countif to count the number of cells which contain a ticked checkbox. eg...
Forum: General Discussion May 19th, 2008, 04:25 PM
Replies: 12
Views: 248
Posted By shirl
Talking I have spent ages on trying to solve the same...

I have spent ages on trying to solve the same problem in Office 2007, turning off the text wrapping solved it.

These forums are great
Forum: Running & Setting Up Queries April 25th, 2008, 12:08 AM
Replies: 4
Views: 87
Posted By shirl
John Thanks very much, all sorted now. Shirl

John

Thanks very much, all sorted now.

Shirl
Forum: Running & Setting Up Queries April 23rd, 2008, 11:36 PM
Replies: 4
Views: 87
Posted By shirl
John Thanks for the reply, I have done what you...

John

Thanks for the reply, I have done what you said and it worked, the only problem I now have is that I want to show the hour in the 24 hour clock, ie 1pm in the afternoon should display as 13.00...
Forum: Running & Setting Up Queries April 20th, 2008, 08:50 PM
Replies: 4
Views: 87
Posted By shirl
querying time

I have been given a database, which has been used to record incoming calls, the user enters the time someone phones in, the department name and person they were put through to.

They now want to be...
Forum: Page Layout November 17th, 2007, 01:33 PM
Replies: 4
Views: 131
Posted By shirl
Talking Lene Thanks ever so much for your help. I have...

Lene

Thanks ever so much for your help. I have logged in remotely to my work PC and installed the Macro and it worked.

Thanks again
Shirley
Forum: Page Layout November 14th, 2007, 05:33 PM
Replies: 4
Views: 131
Posted By shirl
Lene Thanks for your reply, sorry not to have...

Lene

Thanks for your reply, sorry not to have got back to you earlier, but I only just remembered to check for replies.

I have done what you suggested and it still does not work.

Any other...
Showing results 1 to 25 of 39

 
Forum Jump

All times are GMT +1. The time now is 12:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.