Recent content by reel knotty

Ok I have eveything as listed above and its a bit more clear to me now but I am getting "undefined function 'prevrecvalc' in expression" error 3085. Any ideas on this one?

I think I read that in Microsoft Access 97 developers handbook. So I have learned to confuse access by having 2 queries and beating the system. BTW I am self taught in access which would explain my unconventional solitions to problems ;)

Norm I don't think you should have any troubles. When you create your main query add the student query and your grades table and just make the relationship right there in the Query. showing all data from student query and only the grades that apply.

I've got the same issues! I really need to go through and get rid of things.

Ok let me make sure I have this straight... The code should read: Function prevrecvalc(Keyfield [trans] As String, KeyValue, _ field to getzip As String, Tablenameshipmentlookupwcode As String) The red being the actual text after deleting the description. where I am confused is what the...

Trans actually is the unique value and Primary Key for that table. Ok I tried to adjust according to what you posted and here is what I have now: Function prevrecvalc(Keyfield As String, KeyValue, _ field to get As String, Tablename As String) And the expr in the query...

I see that if you open it through the search form you don't get the error. The search form must be open and data selected so the report (chart) to retrieve the data it needs. Although I have not been able to populate the chart with any data it could be I am using the wrong parameters.

Ok Rich, I got the Method or Data member not found issue figured out. I had to change Dim rs As Recordset to Dim rs As DAO.Recordset. But now I have a new issue. I think I am messed up with the Source. here is what i have in the module: Function prevrecvalc(Trans As String, KeyValue, _ Zip As...

I guess I have to ask why you would want to have duplicate data? If you can put a relationship together to copy the data why couldn't you leave the data where it is and attach it to data in the other table via relationships?

I run into this quite often. I simply import the tables with the live info into my copy and adjust the fields as need then move the whole access file onto the server. (Note: Lock everyone out of the live copy before importing data and untill you get the new version back up)

you can't edit or add text through a query with more than 2 tables directly attached. you can however create another query then create a main query from the other query where you would only have 2 tables or queries in the main query and it should work. IE design a new query [studentsubquery]...

just create a macro in the "after update" control in your fields properties to close the form.

That might work to Pat. See I have an API that I is returning miles. Currently on my form I have point to point miles for several stops on a trip. I would like to total the miles for the trip at the bottom of the page. So the 3 ways I can accomplish this is by A) call the API from the query so...

Ok Rich, Got it all makes sense. but now when i debug it stops at "FindFirst" and tells me Method or Data member not found. which doesn't make any sense because it works in PrevRecVal. I do have the DAO 3.6 object library active.

I think that would do it because then I could call the API from the query as well then its all down hill from there. (I think) I have several ways I can get this data but I can't get any of them to work :(