Search results

Open your report, got to 'File' then to 'Send' and then choose your format. Then the report should appear in an email as an attachment. Then send it to whoever you want. Or were you after something more than that?

Maybe something like this would work. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If me.DateIn = me.DateOut Then me.DateIn.ForeColor = vbRed Else me.DateIn.ForeColor = vbBlack End If End Sub Or you could highlight the whole field by using BackColor rather...

I just look at the contents and index bit in Access under Type Mismatch. Could this be your problem? Verify that the criteria you specified is for the same data type as the data in the underlying table or query. For example, the field ReorderLevel has a Number data type. Therefore, if you type...

I think the problem may be with this line "WHERE (([HotelPrices tbl].[HotelID]) = " & Me.[cmbHotelName] & ") ") You have 2 of these brackets (, but 3 of these brackets ). This won't help with your problem, but you need to un-set the recordset. Type this set rst = nothing just before end...

Should there be an apostrophe in front of the Else?

There's nothing wrong with being pedantic - I looked at my db where I've used Dlookup and saw BeforeUpdate but then looked at emfc's post and saw AfterUpdate in there, and just typed that. I do have a brain! Somewhere...............:rolleyes:

You could try using Dlookup on the AfterUpdate event and maybe have a messagebox appear to tell the user that they need to use another ref (if it has already been used). Change the set-up so that they can add a new ref, without losing their data. HTH

OK Create a form (you can use the wizard) Put your fields on there monday start monday finish Call them txtMondayStart and txtMonday Finish In Properties make sure these are set to a time format. Add an unbound text box call it txtMondayHours Make sure the format for this is set to...

What are the fields in your list? Text? Number? You could have the fields set to number (actually, date/time is probably what you want - dir), and have input masks for each day period on your entry form eg, Monday morning - 00:00 to 11:59 Monday night 12:00 to 23:59. Then you will keep the work...

How are the dates/prices stored? It might be best to have a separate table which has 'date' and 'price'. So june 4th - £50, june 5th - £55, june 6th = £56. Maybe then you could calculate the correct price for the stay. HTH

Yeah, Ally is right, use =Date(). But if you use =Now() and set the format to say, Long Date it does only show the date and not time. It works, but is it better to just have =Date()? I presume so, but what difference does it make?...

Could you not reference it by using the actual field name which appears in column 1 rather than the column number?

Just add a new textbox and put this in as the control source. Then choose the date format you want. =Now() HTH.

One of my problems is with datasheet view, although that doesn't trouble me greatly. My main problem was with tabbed controls in a subform and that neither would resize. However, I think I know why this is. I have a main form with a subform control in the centre. In the subform control, a number...

Thanks for the help so far. The problems I am encountering can largley be overcome, but I am still having trouble with one aspect - subforms which contain tab controls. What is happening is nothing - the tab control stays the same size as what it was developed at. Font size is the same, and...

Hi If you have both the name of the field you want as well as the ID number (value that you spoke about?) in the SQL, it may just be that you have the combo just looking at the ID number column. If that's the case, change it so that the column you want (name) appears (type the column No into...

Maybe you could try something like the code below. Just change IncidentNumber to whatever your control name is. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If me.IncidentNumber = "0078" Then Me.IncidentNumber.BackColor = vbYellow else me.IncidentNumber.backcolor =...

Cheers Hayley At least I know I'm not the only one. It also affects subforms in datasheet view, which is a real pain. Guess I'll just have to redesign a few things. Thanks Tay;)

Hi How are your tables set up? I presume you have a 'make' table and a 'model' table, and you have an ID number for each make and model. tblMake tblModel 'Make' MakeID 'Model' ModelID Ford 1 Galaxy...

I have some users who are using different screen resolutions to myself. After searching on here, I found some fantastic code which automatically resizes everything to allow for this problem. I have attached a link to the sample db. http://www.anauz.clara.net/access.htm On one thread I...