Recent content by stargate

Worked nicely! thanks guys..im in debted.

Ive base my subforms recordset on a query which uses the datediff function to find the total days. I have added a unbound field in the footer of the subform to calcuate the no of records greater than 60days and then pass the calculated value to another bound field on the main form. All I need...

sorry for the late reply..been on a training course. It works nicely. Many many many thanks! much appreciate. I know you are busy replying to many other posts.

I have two unbound fields on a form that I would like to display the result in the following way, similar to the record navigation at the bottom of a form. ------- of ------- Field names txtOf = ? txttotal = Count(*) Any help on how to do this would be...

Can someone please convert this to A97 for me. I'll will buy you are beer!!

your problems is simple. dont use [Table1.ID] as it is confusing. It should read something like this..eg PersonID. To me table 1.ID is a table not a text control. I would check all the syntax in the sample you are using make where ever Name ID or is mention lstNames is mention, changed it to...

here another good one. I have good library of search function. I these arent what you need I can send some more on Monday. Please note that you will need to alter some of control names in the code to your control name. Im assuming that your VB is basic but I could be wrong. I hope the...

Here is a sample Db that has some basic search function one of which is what u are after.

Thanks for that. I'll give that a try.

When I initially created the DB i didnt formalise it correctly. Now I understand the importance to do so. I know it needs to be normalise further but at this stage want to get the data matching correctly before normalising further. tblclient holds information on the client and jobs forwarded to...

There several search samples on this forum. Enter Search as the keyword and will see attached DB samples. Heres just a sample of what u can find. If when u use the filtered list box, double click and it will bring up the record.

Hi, Im using the following on a form (frmEmail) This work well but I was wondering if it was possible to make strLastName value carry over to email in Bold. Private Sub cmdEmail_Click() Dim strEmail As String Dim strMailSubject As String Dim strMsg As String Dim strLastName As String Dim...

try this version

Theres 2 ways that i know of the top of my head. The first one is an attached sample I did for your. Second way: you can insert a page break .I have a silimar problem where I have many fields on the one form. I added a page break after the last field and added a command to open page 2. place...

and another