Search results for query: *

Hi mate, Yes i think i now see wot u r looking for. Here is the code attached to my PrintLabels cmd button that uses a query called qryMergeContacts to populate a temporary table called tblContactsForLabels. This temp table gets its field values from the main table called tblContacts. Hope...

To all still interested, Have solved this problem by merely reversing the entry of LastName and FirstName in the Row Source property grid i.e. SELECT DISTINCTROW tblContacts.FirstName, tblContacts.LastName FROM tblContacts ORDER BY tblContacts.FirstName, tblContacts.LastName; and using the...

Hi again i'm not sure i'm totally with you, but i think that u r selecting the values in the multi-select box and expecting the same selections to be picked up in your form/table. Am i right?? If so i think it goes back to what i was saying about what you want to do with the multiple...

Hi dulla wot u need is something like this: Insert a list box on to your form and then click the properties button on the toolbar, choose the "Other" tab and then "Multi-Select", choose "Extended" from the drop down list. This will enable you to press Ctrl or...

Nope, can't seem 2 get that to work at the moment. Row source grid is as follows: SELECT DISTINCTROW tblContacts.LastName, tblContacts.FirstName FROM tblContacts ORDER BY tblContacts.LastName, tblContacts.FirstName; After Update code event is now: Private Sub...

Thanks Eupher, Will give it a try. Ta very much for the help. Stu

Hi folks, I have a form in my db in which i store all my business contacts name, address, phone no etc. The components are as follows: frmContacts (the Form !!) tblContacts (Record Source) I have put a record selector combo box at the top of frmContacts with the following code attached to...

Ha, didn't think anyone would fancy delving into that one. Well for info i have fixed the problem, it lay in one of the fields of the query that populated the Temp table used to send the relevant contact details to the report that prints out the labels!!! Oh well never mind, learnt a lot in...

Hmmmm!! Heres a funny thing, I have just managed to get this to work by reversing the process i.e. i have attached the After Insert Event code to frmContacts rather than frmPlmkrs and this works fine, prints labels o.k. and everything!! Not sure yet if this is going to be a suitable solution...

Hi folks, Well here goes, i have a problem that has arisen out of a solution provided by responses to an earlier post of mine. The previous post was entitled "linking two tables???" and was posted a couple of days ago. Basically i wanted to be able to simultaneously input the same...

Hey guys i wonder if u r still watching this thread. If so i have a problem with willir's code method. I have attached the code below to the Forms After Insert Event procedure: """"Start of Code"""" Private Sub Form_AfterInsert() Dim dbs As...

Thanks very much to nrugado and willir, Sorry i didnt reply earlier but i've been away from pc for today. Will try your code out willir i assume this needs to be attached to the relevant text boxes in the form on their After Insert Event Procedure??? nrugado my e-mail is...

Thanks once again nrugado, Can you elaborate on this as queries are still an area that i am learning to master. Hope this isn't too much trouble, will understand if it is too long winded to relate. Just let me know if thats the case and i will try to crack it myself. Cheers mate All the best.

Thanks nrugado for your quick reply. Unfortunately the answer is yes i am locked into having two tables. The reasons for this relate to other elements and functions of the database i am working on. You are correct that what you suggest would ordinarily be the simple answer but to go down this...

Hi folks, Can anyone tell me if and how it is possible to enter some of the the same data from a form into two separate tables. For example: I have a Form called frmPlmkrsDbse that has a table called tblPlmkrsDbse as its record source. This table contains fields such as ContactID...

Is there no-one out there that can give me any clue as to how to achieve this. Even if someone can confirm that what i am trying to do is either impossible or massively complex i would be grateful. Thanks v. much.

Can anyone tell me how to adapt the following code to only send the report page/pages relevant to the currently visible record in my form. The code below unfortunately attaches the entire report of many pages in length and if possible i want to avoid this as it makes the e-mail message too...

Oh yeah and as you have probably realised by now i am a VBA novice!!!!! If you can help please dont assume too much knowledge on my part o.k. Thank You.

Evening all, Can anyone tell me how to adapt the following code to only send the report page/pages relevant to the currently visible record in my form. The code below unfortunately attaches the entire report of many pages in length and if possible i want to avoid this as it makes the e-mail...

Many thanks for your reply, i'm not yet sure whether what you have suggested is where i want to go but you have given me some ideas that will help anyway. Once again many thanks indeed.