Search results

Jon, it is gonna take more than a like query because I have a set of fields I always want the list box to show but I want to filter that list based on one criteria either in the text box or combo?

Dim appPPt As PowerPoint.Application ' Set a reference to the PowerPoint Application object. Set appPPt = New PowerPoint.Application If appPPt.Visible = True Then ' Close the previous presentation. appPPt.ActivePresentation.Close ' Quit PowerPoint appPPt.Quit ' Close the object...

Dear all, I have a form with an unbound listbox on. I have 3 combo's I have 2 text boxes. What I want to do is let a user select an entry from 1 combo or enter data in 1 of the text boxes and then on an event like keyDown only return/populate records to the listbox that match the criteria. I...

if your code creates four numbers then y dont u just create 3 numbers?

You can use a query and just return the top 3 values. How and where do u create the 4 numbers?

You can do a couple of things: Create a yes/no field in your orders table called returned and if something is returned then just go to that record/order and enter a yes in the returned field. That is fine for returns if they are only every so often. If you are likely to have many daily...

Put the fields in the query and in the criteria under the surname field type smith abd it will return all with a surname of smith. Look up the Like statement and also criteria in expressions.

How do u record a positive result? You can work out a % based on questions answered positive against questions answered and then set the query to only show results over a certain %. Post the db for a look?

Pat, Thanks oh great one! One last thing how do I make my subreport print at least 3 rows of detail when near the foot of the page else send it to the next page?

I'll try that tommorrow thanks

Why dont you create a query for your answer and then a sub form linked on Part_Nbr?

Thanks but I have looked into all them things before and they do not do what I want. My subrpts are set to can shrink! keep together on subreports dont hold true if the subrpts have headings. What I need is some way to check each subreport has data and move the reports up to the bottom of the...

Dear all, I have a report that contains upto 8 subreports in the detail section. I have minimized the sub reports as much as possible. So I have as followsin the detail section: ________________________________subrpt1 ________________________________subrpt2...

Dear all, I have many projects each with their own unique ID number. I also have an NT Folder with a seperate folders for each ID number. eg ProjectID = 200, NT Folder called 200 I store in the NT folder all documentation for the ProjectID. What I want to do using Acc97 is to create a form...

Are the forms entering the data directly to Oracle via ODBC? I am not an expert in this area but if you give a little more info on the data flow then I am sure one of the real tekkies will solve it!

You really need to attach a zip db so we can look at other criteria in the db to work out your request. To get a two week period when the users were all in the top range we need a value to base the range on?

Format(YourDate, "dd, mm yyyy") Format(YourDate, "Long Date") Format(YourDate, "Short Date")

Nice queries Harry

you have made the subform out of the table that you are populating?? post it here!

ok now