Search results

David, My form properties are already as you explain, sorry if also misspoke in my forst post. Anymore ideas? E-mail me if you can have a look at the actual DB. Scott.

Here is the structure: Tables Personal(Name(k),Address, etc) Jobs(Job Title(k)) Unit(Unit Name(k)) Name_Unit_Job(ID(k),Name(lookup),Job Title(lookup),Unit Name(lookup)) I have a form based on Personal with all fields included. Within this there are two subforms. 1)Has a single field of Unit...

Hi, I have a main form with two subforms. Details are entered on the main form, then options selected from sub form 1 and sub form 2. In the subforms (shown in datasheet view) when I try and select a value from a combo (only 1 field) I get a message "This property is read only and can't be...

Thanks for your help. I have actually worked it out myself this morning. What I did was change the 'Path to image' field from text to an OLE object. For each record I right clicked the field in datasheet view and clicked select object. I then browsed to the relevant image and selected it. I...

Lala, Go to tools > options > Edit/Find and in the box titled 'Confirm' ensure that all three options are ticked. If they are not, then it will not confirm. If this isn't the problem (i.e. they are already all ticked) then i'm not sure I can help. Scott.

I have a table called Units. In it there are various fields related to the unit. One field is called 'Path to image'. This contains the network path to the image that relates to that record. I have a form based on the table. I have all the fields displayed, apart from 'Path to image'. I would...

Select a field and go to Format > Conditional formatting and from the first combo on the left select 'Field Value Is' and type in 0 and select a colour. Do it again for 1, with the other colour. Do the same for all fields you need to do it with. HTH Scott.

Great thanks Rich, it worked a treat! Scott.

I have two tables that look like this: 1) Employees Employee ID (key) Employee Name [other irrelevant fields] Holiday Due (this is the entitlement per year) [other irrelevant fields] 2) Holidays Holiday ID (key) Employee ID (lookup in above table) Notified (date) Start (date) Finish (date)...

Go to the table that the form is based on and make the field type 'Memo' insterad of text. This allows you to write more in the field. HTH Scott.

If I interpret your question correctly, you need to use a parameter query. In the criteria row of the year field type [Please enter a year:] as it looks above. Then run the query and you will be prompted to enter a year. All matching records will be displayed. You can then base a report on...

Thats more trouble than its worth. I haven't got time with the coding. I am only tweaking little design deficiancies. I would rather leave it as it is. Thanks anyway, Scott

I have several parameter queries. What I need to know is how to change the title of dialogue box that pops up asking the user for criteria. It currently shows "Enter Parameter Value". How can I change this? Thanks. Scott.

After and hour and a half playing around with it i have solved this myself. For future reference: Step 1: Create a query based on the pervious query (see above). Include all the fields. Step 2: In the criteria row of the 'Days service' field type: Between 355 And 365 Step 3: Sort this field...

OK, gave it a try Geoff and that expression shows the number of days each employee has worked. I still need: 1) How do I make it show Days, Months and Years - instead of the number of days? 2) How do I narrow it down to make it just show people with a '5 year service anniversary' coming up in...

I have worked out how to show how many years service an employee has had using another thread. The SQL looks like this: SELECT Employees.[Employee Name], Units.[Unit Name], Employees.[Started Work], IIf(DatePart("m",[Started Work])=DatePart("m",Date()) And DatePart("d",[Started...

I have a staff database. Within this there is a table that holds employee details. One field is called 'Start Date'. I need to be able to see a report of what employees have got 5 years service, 10 years service, 15 years serice and 20 years service coming up. I appreciate this are likely to...

Two options: 1) Go into design view and move the fields around to where you want them on the page. 2) When you create the report use the auto-column wizard. HTH Scott.

Great thanks. What do you think about html emailing?

Thanks.