Search results for query: *

Hi... I have set up a report with 4 fields that come through from the query. I have them as a list on the report. However, if some of the names are a bit too long they go down onto a second line. Now usually if this is the case, the field below just shifts down a bit so that they don't...

Afternoon all.. Here is my scenario: I have a form - frminvoice - which has a field on it called invoiceamount which simply stores a monetary value. I also have a subform on here that for each row has an issueamount field (number field) I have another textbox on the form frminvoice - Total...

Hi... I have a form - frmIssues - which is based on a table - tblissues. TblIssues is quite a large table with a lot of fields, so frmIssues allows the 4 most important fields to be entered in a row on continuous forms. After inputting those 4 crucial fields, the idea is for the user to...

Hi... I have a combo box on a form that is populated with a list of names. The user can type in the combo box and it obviously auto fills in the rest of the name if there is a match. the problem is, some people have the same name. And instead of users having to type in the name, then click on...

Hi, here is a nice and easy one for you guys (hopefully!) I have a field called 'CreationDate' in a table called 'tblIssues'. I want the 'CreationDate' field to contain the date that that particular record was created on and I want to lock the field so that it cannot be edited/deleted. I...

Hi... What I would like to be able to do is this: I have a 1 page A4 Word document (.doc, Word 2000) that I want to be able to save as an image file so that I can imbed it in a report in a database (Not Access). I want the image to retain the .doc files original A4 size. We do have a...

Hi... I have a worksheet with 4 columns. Columns B and C are text columns. In some rows, the values in columns B and C are identical and I want to be able to flag up these rows somehow. I am using Excel 2000. Many thanks in advance Dave

Hi... For some reason, a load of dates in a spreadsheet are being displayed as 5 digit numbers. Is there a way of converting these 5 digit numbers into dd/mm/yy??? Any ideas would be most appreciated. Cheers, Dave

Hi - hopefully this is quite a simple question that someone can help me with. It seems that if you protect an excel spreadsheet it will stop the hyperlink from working? Can anyone tell me if it is possible to have a hyperlink that will work in a protected cell. I have a range of cells...

Hi... First of all, apologies if this is a double post. It doesn't seem to have shown up on the list I have a database that is used as a catalogue. On each page is a short description of each item and a picture of that item. The Picture is an imbedded OLE object. The problem is, having...

Hi... I have a database that is used as a catalogue. On each page is a short description of each item and a picture of that item. The Picture is an imbedded OLE object. The problem is, having populated the catalogue with the pictures it is a huge .mdb file with each item taking up nearly 1Mb...

Hi, I'm sure that this is really quite straightforward, so any suggestions would be great. I've got a table in excel that has two main categories. One category - Budget area, is defined in a column at the beginning of the table. I've also got all of my fiures split into months, this category is...

Hi all... I have a list of 700 email addresses on a spreadheet all in cloumn 'A'. I need a way to get all the values in these seperate cells into one cell with the format "EMail1, EMail2, Email3, EMail4, EMail5... EMail699, Email700" so that I can copy the contents of this single cell into my...

Hi... I have a list of dates in Excel 97 that for some unknown reason have been formatted to Serial date strings, where each date is represented by a 5 digit number. I need to find a way though to convert all these 5 digit serial dates into dd/mm/yyyy because I really don't want to have to...

Hi... I have the unenviable task of trying to sort out a database that somebody else has started and made a mess of! I have a table where all the dates are for some reason stored as a text string in the 5 digit figure on my tables/forms rather than the infinitely more useful dd/mm/yyyy...

Hi... I have opened up a spreadsheet that I have been working on, but it seems to have eaten the first column. The column headings now start with column 'B' so the 'A' column surely must still be on the sheet, and I definately haven't deleted it. I have tried rightclicking and selecting...

Hi - I've got a feeling that there is probably a very simple answer to this, but it's driving me mad at the moment so I'm hoping that someone can help... I'm trying to write an expression in a query which will do the following for each record within a table called "records": If the field...

Afternoon all... I've looked for it in Tools - Options but I can't seem to find a way to turn off the 'clicks' every time you click on a link on a webpage in IE. Does anyone know how to disable this annoying little noise??? Many thanks in advance. Dave S.

Hi... Is there a way that in XP you can produce some kind of map or structure diagram that visually represents the structure of a drive??? I've got a nagging feeling there is but I've no idea how... Any ideas or suggestions would be greatly appreciated. Many thanks in advance, Dave S. Ps...

Hi... I am writing a database that keeps track of Staff members and their contracts etc. There is a screen in the system that shows the names of people whose details are still on the system, although they left the company over 3 months ago. The purpose of this is so that we keep all old staff...