Search results

Thanks Allan, I still get a variable not defined error.

Thanks again Allan 57, I have tried to use the syntax you gave me (Set rst = Form_TheNameOfSubFormHere.RecordsetClone) but it still doesn't work, I tried as well with an other syntax and it is not working, here is the code: Private Sub Form_Load() Dim rst1 As Recordset Dim rst2 As Recordset Set...

cheers guys for your reply, I am not sure how to work the time event for this situation, I think I also understand the recordset method but I am non sure how to apply it to my situation the record that can be not available is inside a subform and I don't know if I got enough programming...

Is it possible to reference a field on a form via code that as no record available on the loading event of a form. On the loading event of my form I have tried if TxtEssai="" then ...or if txtessai=null... but it tells me that I have entered an expression with no value which is making sense...

Hello, I have a small problem, I have just been struggling for the last 2 hours to be able to use the command "Find Record". I just wanted to enter a "number" in a txtbox and get the form to go to the corresponding record (where the drawing file is the "number" in this case) Private Sub...

Yo Rich, thanks for your advice, I just found what was wrong with the function with a bit of more searching in the forum: My module was saved with the same name than the function, I got it working now.

I see what your saying Rich, so how do I get my fields to be equal to the parameters?

Cheers Stevens, unfortunately, I still get the same error message without the GROUP BY Function of the SQL.

Thanks for your repy, I have indeed change my function to a public function, but when I try to run the query, it tells me that the function is undefined. I have put the SQL below to show what I have done: SELECT TblLine.LineID, TblLine.LineType, TblLine.LineDim, TblLine.LineShape...

I have written a simple function that I would like to use in a query. The function would return a value for each record where the parameters equals 2 different fields of the same record. Private Function FctConvertInch(LineDim As String, LineShape As String) 'To Convert a String to a value and...

Thank you very much, It is working now, it is a bit embarassing: atxlim10 was an add in I tried a while ago to import exel document, I forgot about it and didn't desatcivate it, now it's done and it's working...

Thanks for your reply, yes we're all using the same version of access. Here are the different libraries I am using: -Visual Basic for Application -M.A. 10.0 object Library -O.L.E. Automation -Microsoft Active.x Data object 2.1 Library -4txlim10 I think the one missing is 4txlim10, Can I sort...

Hi, I have been designing a database on my computer which seems to be working fine; 2 more users in the company should be able to use the database.In order to see if everything was working properly on other computers, I have put a copy of my db on the server and tried to open it on the other...

Thank you very much for your reply, I understand what you are saying with the link between TblEnquiryDetail an TblChildItemCost which makes sense but it means that I can't keep an history of my enquiries. If the price of an item is changing over time, the price of assemblies for past enquiries...

I don't know if there is much point but here is my final code with a working demo. Only weight and material are needed, all the other different variable are taken from three different tables using DAO. Public Function FctCastPrice(Weight As Double, Material As String) As Currency 'Code to get...

Eh....You're not going to believe it but I was getting the same "Invalid use of Null" error. I then realised that I was only getting the error when the weight looked up in the initial price table was not a multiple of 0.5 or 1.0.Yes...I kept getting the error because the weight in the table was...

Reclusive Monkey, here is a sample with a form that shows all the data needed in the code and a calculation button. As you can see Min and Max are defined in tblNickelPrice. I am pretty sure that the first part of my code is working because if you go through the record and the item is made of...

Thank you so much for you r patience and your time guys, I have done the modification and I get a different error which seems a bit odd to me: "Invalid use of Null", any ideas why? Public Function FctCastPrice(Weight As Double) As Currency 'Code to get the Price of casting just by knowing its...

Hi, I am trying to implement my Database with an enquiry (or quotation) table and I am not sure I am heading in the right direction: -We use assemblies made of components and the data are held together in the database with a 'Bill of Material' set up. -A typical assembly is made of 1 or 2...

I have changed my code slighly by adding a looping funcion to check the record of 1 of my table as ReclusiveMonkey as suggested, I get the error :"object invalid or no longer set", did I forget something? Public Function FctCastPrice(Weight As Double) As Currency 'Code to get the Price of...