Search results

I have tried to write a query as an exercise. I am trying to sort cars from trucks, yellow, green or red and 6 or 8 cylinder. I can sort on 6 or 8 cylinders or on colour or trucks and cars. However, I can not seem to teach it how to sort on Trucks that are green and 6 cylinder, whenver I try...

strZ is globally declared as it is referenced throughout the code. Yes the code is option explicit.

I give up… I am totally baffled by this. I have a report, which produces messages, depending on the values of the report. For example if txtCyn = 1 and should equal 2 it says strZ=”Please add another one”. I use a sub called Print1 (strZ) to process the messages. Essentially it says if...

I have the following code behind a form. The code is cut and paste and I don't hve all the lines broken out quite like this. If IsNull(memMail) = False Then DoCmd.SetWarnings False DoCmd.SendObject acSendReport, "rptMailComment", acFormatXLS, "dps@tpg.com.au", ,, "My...

I am a little confused by your question. You say you want to go to the previous record, and yet when the form returns to say patient ID 1 you say that is not what you want? You imply that you are trying to return to a previous field not a previous record is this waht you are trying to do?

Detail is set to grow and shrink, there are no overlapping controls or horizontal lines. It seems to me that if say 7 points take say 7/8 of a page then I don't get the second page, almost like the final 8 shrink to an unspecified height, which causes a page overrun.

I have a report which produces a recipe depending on selections. This all works fine. As the program runs the report it populates upto 15 text boxes with appropriate messages. However, if say only 7 text fields are required and they take up a full page the report prints a second page...

My help file is a little temperamental, and on this question it throws a wobbly and tells me to repair it. When I repair it it asks me to repair again etc etc. My question is I want to control entry to a field called first name. I want to ensure that a name is entered and not just initials...

For some reason when I look up recordsets in my help file, my help file crashes and says I need to repair it. When I do and repeat the question the sequence repeats. Unfortunately it crashes on any question on recordsets, so I am forced to ask here what is probably covered in help. I was...

Some people will disagree with this approach, however, it works well in short queries, where the data produced is limited. Dlookup("[myField]","[myQuery]")

I have an application which is under evelopment in the final stages of testing. The other day I was requested to make a cut down version for another purpose. So I thought I would simply copy the other database and delete the bits it doesn't need. I found that the modules aren't working, so I...

The data source was set to =[BusinessName]

Yes the fields BusinessName, BusinessAddress etc are bound to a table. I have a work around for now, which is reliable, using code to populate instead. However, the other method is supposed to be more reliable?

The report is actually based on an sql statement. The fields are directly inputted for this part of the report in the business details sections. The rest of the form is populated from open forms.

I have a report which is producing recommendations based on input from the user into a form. From the form, the report analyses in VBA and then produces a list of actions. This is all working fairly well. (in debug, testing now) However, there is a mysterious anomoly which I do not...

What is the call stack and how do I access this?

I have been working on a project for a few weeks now, and am down at the final logic debug stage. In short the systems work fine for Product A, Product B and Product C. However, when I run Product D, everything runs fine until the very end when the three forms close, but one reopens. I can...

Mark, this type of work is handled by a query, and is best handled by a query.

Okay, I thought this was really simple, but there must be something Iam not seeing. QryResults lists the results for an individual client. For every third result I want chkClarifier to be true, that is enable dose. This code should set chkClarifier to true on every third record but it is not...

I have been considering how to solve this problem. I thought before I spend anytime on it I would ask for some feedback, from more experienced developers. I have a dbase, with several thousand names, addresses. These are to become mailing labels, this is easy enough. However, I would like to...