Search results

Hi all. This is the code that I have used in my NotInList event Private Sub Suppliers_NotInList(NewData As String, Response As Integer) On Error GoTo Err_Suppliers_NotInList '-- We may need to add another Product Response = MsgBox("[" & NewData & "] is not yet a valid Supplier..." & vbCr &...

yeah that seems to be exactly the problem. sorted now thanks for that

also i can't see the default value option for a unbound text box in the properties pop up. where is it?

well like i said it has always been set in the control source and worked fine until a week ago and still works fine when opening from access 2003. it just doesn't work when opening from 2000

Hi all. Within my report i have an unbound text field with its control source set as =Date(). However when the report is opened, the following error appears, #Name?. This error only happens when the database is opened using Access 2000. It is fine however when opened using Access 2003. The...

There are two tables. Main table is where the main info is stored for each reference i.e 3000 and this is the primary key. The valuations for each reference are stored in another table called "valuations" and this has a reference field which links to the reference field in the main table. hope...

Hi all. I need to know if there is a way to show the last entry for a record. In my database there is a set of numbers i.e. 3000, 3001, 3002 etc which have multiple valuation figures with them i.e. 3000 could have valuation 1 £1000, valutaion 2 £1245. So as mention what i need is my query to...

Hi again all. Here's the problem. I have about 5 or 6 reports which I would like to be able to email all at once. They all need the same parameter but not sure how i can use this. Any ideas.

Hi all here is my problem. In my report I have two fields, one titled "risk" and the other "action". The problem i've got is that both fields have properties set as can grow but if one field grows in size the corresponding field doesn't grow to the same size thus making the report look untidy...

a blank record was a bit misleading. I want the record to automatically be added because some fields pull in information from other tables so they wouldn't really be blank records

Hi all, here's my problem. Within my form I have some tabs with subforms on them based on various tables. What I would like to know is if there is a way that when I add a record to one of the subforms, a blank record is automaticlly added to the rest of the subforms. Thanks

Thanks works fine

Thanks thats it works fine now. Hopefully people will be a bit more satisfied now!

Hi again, my problem is that on a report I have a row of dates i.e. 10/10/2006, 11/10/2006 etc. However, people would prefer to see Monday, Tuesday etc. Is there a way to show the date as the day name. The date fields are all based on the Date() expression then +1, +2 etc so are always changing...

Hi all i'm not sure if this can be done but if it can it would be really helpful. In my database there is a date field showing when a document has to be completed by which gets printed out in a report. However, some documents need to be assigned a return date of "ASAP". I thought about simpley...

Sorry I didn't look at the link above clearly. It does sort of help, but any more ideas would be helpful

I tried all sorts of searches like I said in my message but none gave any clear answers, just lots of speculation and ways to insert lots of other stuff, which I have no interest in. Again, i'm only interested in being able to open a template at the click of a button, nothing more!

Hi all, I have done a search to try and find an answer to this question but haven't found quite what i'm after. I have an email template saved and all I need is a (hopefully very simple) command button that when pressed opens the outlook email template. I don't need any addresses filled in or...

Hi all i'm really confused. I have tried to use the user-level security wizard to set my database security which works fine from my computer. However, when someone else logs into the database through my shared area where it is kept, they do not encounter any of my security settings that I set up...

don't think i explained myself well enough. My query at the moment has the name, trade, company, rate, hours worked and cost (rate x hours worked) for each person. The report shows all records (people) for a company and needs a total showing how much is to be paid to that company which is the...