Search results

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

heres another

see if this is useful

Another methods in the after update is Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmComments" stLinkCriteria = "[ClientID]=" & Me![ClientID] DoCmd.Openform stDocName, , , stLinkCriteria Set the record source of frmComments to the table that has the comments field. Set...

I tried =IIf(chkActive, "Occupied", "Vacant") but im getting #Name! could it be because chkActive is in the subfrom.?

I have a unbound textbox on the parent form to show either VACANT OR OCCUPIED depending is a chkbox is yes in a field on the subform. Im using a continueous subform to that is automatically checked when a dateout is entered. How can I get the textbox to show Vacant if the yes/no is has a tick in...