Search results

Sorry about this. Know it's a frequent question and I've searched the archives and got half the answer. I've a DLookUp that prevents a user entering an organisation with the same first line of address: If Not IsNull(DLookup("[Organisation]", "tblOrganisations", "[Organisation]= """ &...

Thanks for that. I'll give it a go.!!!! Cheers

To cut a long story short - I've a dynamically created query which labels are based on. The fields are Org Name, address 1, address 2, etc and Consultation Type. Organisations can have more than one consultation type so for example if I consult on Sheep plus Cattle that organisation will get 2...

This seems work.........I think, fingers crossed, etc. Private Sub Addd_AfterUpdate() Number = GetNextNumber(Me.Addd) End Sub Private Function GetNextNumber(Addd As String) As Variant Dim intFirst As Variant Dim intSecond As String intFirst = Me.Number intSecond =...

Can this be done? I've a continuous form with two text boxes, txtA and txtB. When a user enters a figure in B i want it to show in A. When the user updates box B I want it to automatically update A and so on. Andy ideas gratefully received.

Cheers Rich - I'll take a look at that one. Thanks again

Thanks for the help Rich - helpful as ever. How would the DCount/Sub report work. I just don't see how I can get the percentage figure.

This probably sounds very stupid. I've a query that aggregates the number of people who attend each course. In the same query ideally I would like to find out what percentage of total employees attend each course. Because of the table structure I can't do this though I can get a total no. of...

I've a main form and on that form you access another form by clicking a button. How do I make sure that a certain field on the main form has been filled in before going to the new form. I thought is must be something to do with IsNull but can't figure it.

Mr Robin - fantastic. You have no idea how much trouble I've had with this. Cheers

Been tearing my hair out on this one. To cut a long story short and for reasons too complicated (and frustrating) to explain some of my labels hold the same information on 2 lines. The two lines are =Trim([Report]![Name] =Trim([Organisation]) If they are the same I don't want the first line...

Thanks Elana. I put in ; DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdDeleteRecord Probably not quite the done thing but it seems to work!!! Bit hotch potch my databases! Cheers again

I've got a DLookUp on a form which prevents a user adding a name that's already in there. Each record also has an autonumber ID. When a duplicate is found the user has to exit. However, I've noticed that because of the autonumber ID field a record is still created in the underlying table. This...

Thanks for that Peter - the "mailto" still appears. I guess it's not a major issue. It'll just have to stay there!

I've this code that automatically puts adds "Mailto" to the email address. When I delete the address it leaves the "Mailto" in the field. Can I get the field to be completely empty if I delete the email address. Private Sub Email_Exit(Cancel As Integer) If Not IsNull(Email) And...

I've managed to get 2 list boxes on one form to work properly on a query, eg, they take any combinations I put in (at least I think they do) including if I leave one list box unset. My problem is getting the code to work for a third list box. Here is my code and any advice gratefully received...

I've 2 multi-select list boxes. Once the user has made his selections from the boxes how can I get a message to appear saying what he's chosen (simillar to the QBF). For Each varItem In Me.lstConsultation.ItemsSelected sConsultation = sConsultation & ",'" &...

Thanks for that, that's what I thought. However when I do a query on a table that has 4 records on a Y/N field and set the criteria to "Is Null" I get no records returned but when I change the criteria to "No" I get 4 records? I haven't made any entry into the Y/N field.

Quick question (probably a stupid one) but if you have a yes/no field but don't state a default value does it automatically default to no. It would appear to but I just want confirmation. Thanks.

Doc_Man - I just got it to work and I even managed to get it to work before your last tip. Its a useful tip to know this one. Thanks for your help again and a Merry Xmas to you!!!!!