Search results

Hi bjackson To answer your question, all 30 fields belong to the same recordset.

Hi, I used to have the same problem 'till I cahnged my code to look like the following: '------------------------------------ Dim objXL As Excel.Application Dim objWkb As Excel.Workbook Dim objSht As Excel.Worksheet Dim rst As Recordset Dim Msg, BoxTitle, DlgStyle As String '--- open the...

Any other takers on how can I perform my calculations using code? I have been searching the help system in Access but the examples are not close to what I want to do.

Hi, take a look at this posts and see if that's what you are looking for. I implemented it in my database to import an Excel file. It does everything you are asking for. It just works just great. http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=132175#post132175

Hi Rich, Can you elaborate a little more? Why shouldn't I store calculated results? Can I store the values though? How do I go about the Totals queries? Can this be done in code? Thank you.

A subform has up to 30 fields with user-entered-numerical-data, some of these fields will be empty at times. In separate fields I need to calculate: 1. The average for these 30 fields not counting those that are empty. 2. Count only those fields that contain data. Any takers? Thank you...

Yeah, you are perfectly right. I was suggested that approach some time ago but I couldn't implemented at that point in time but I'll certainly give it a try again. Now, regarding that "bunch of code and programming concepts", if you have them I'm willing to assimilate them. :D Thank you.

Thank you. That's exactly what I needed. :D

But I still need too tell the sub form where to get the source object from. The combo part is not the problem, I can cover that with If statements, my real problem is the right sintax for setting the SourceObject property with VBA for a subform. Thanks.

I have done a search on SourceObject postings but I'm still confused. I have a form with a TabControl wich has in one of its pages a subform. I want the SourceObject of the subform to change based on the selection of a combo box. I have tried the following: me.childfrmHigh.sourceobject =...

Ok, that sounds more like what I need. The other problem is that I don't have much knowledge of VBA so I have no idea where to start. Any pointers? Or where can I read more about it and have sample code? Thank you.

I have this code to import an Excell spreadsheet: '--- Declare variables Dim objXL As Excel.Application Dim objWkb As Excel.Workbook Dim objSht As Excel.Worksheet Dim rst As Recordset Dim Msg, BoxTitle, DlgStyle As String '--- open the workbook Set objXL = New Excel.Application...

That's exactly how I have it but the query is not pulling the data the way I want it. Don't worry though, the project has been scrapped. They are moving to a different database. Thanks to all.

I have 2 tables as follows: Table 1: Models (with other fields in the same table) Table 2: Makes (with other fields in same table) I want to select a make and then have the query return all the models in the other table. I already tried the sample in the Northwind DB but that form requieres...

You guys are amazin! Look at you, trying to make sense of my mess... ;) Harry, it's option 3: I want the query to return all records that contain makes of cars. PaulSpell, that is exactly what I want. Now, Rich's suggestion is something I was trying to do but could not work it the way I...

Ok, here is an example: If in the combo box, the user selects the item "cars", then the code will have the query look not for the wodr "cars" but for car models. If I was to use this "<>[Forms]![YourForm]![YourCombo]" then the query looks for the word "cars" and then it returns no values. Is it...

Yes, WayneRyan, my query works just fine the way you have it. The problem that I'm trying to solve is how do I change the query's criteria thru code so that it looks for values other than the one selected in the combo box. I know that there is SQL code out there that can do that but I just dont...

I'm not sure that approach will work the way I want it to. I believe that will require me to update the criteria manually or changing it with code which brings me back to the original question. Thanks though ;) Anymore ideas anyone?

Hi all, In a query, a field has a criteria based on a combo box in a form; when the user selects an item on the list, the code in the after update procedure runs the query. I need code that makes the query display results that are not identical to the item selected from the combo box. For...

Hi, I have this SQL statement "SELECT * FROM tblMain WHERE " & "Op Like " & """" & Me!cboSelect & "*" & """" & " Order By RunDate" How do I make it to look for this data between between two dates specified by the user in a form? ps. How do you pronounce "SQL"? Do you spell it out or is it...