Recent content by Hanss

Hi, I am wondering if there is anyway to do this with an access query: I have table1 with two fields and data: Temp: Count: 15 2 20 3 I would like a query that generates the following results: Results: 15 15 20 20 20 I would...

Hi All, Thank you for your posts! I was able to get what I wanted using the above link. Many Thanks!!!

Table1 contains 4 records: Red Black Green Pink When I put the following in the criteria of a query I get two records: “red” or “black” My problem: I have form1 with a texbox1. I put the following in the query criteria: Forms![form1]![texbox1] I type the following the textbox1...

Thank you VERY much for pointing me in the right direction! hanss

I would appreciate if someone could point me in the right direction: This is the data that I have in table1: Field1 Field2 Field3 10 20 30 40 50 60 I would like a query or vba that merges the data into this: Field1 10 20 30 40...

EVAL works. Thank you VERY much for your valuable help! Hanss

I have an access form with: text field "text1" text field "result" command button: "button" If I enter "2 + 5" in text1 and press the button I would like VBA to put the answer: "7" in the result field. This only puts the formula "2 + 5" in the result field: Me.result = CStr(Me.text1) Would...

Greg, Thank you also for this really short version. It works great! Hanss

Hi Greg, Thank you VERY much for your help! Your code works fine. If you do find the direct method, that would be interesting, but I can live very well with what you have given me. Kind regards, Hanss Zurich

Greg, Thank you for your interest! I want to return the name of the only file found there There is only one file in C:\test\ which was created by a scanner. For example: 081010200131.pdf With kind regards, Hanss

Hi, I have a form with a button and a field called "file" When I push the button I would like the code to find the name of an unknown file in C:\test\ and then put it in the field "file" What I have tried: Dim fso As Object Set fso = CreateObject("Scripting.FileSystemObject") Me.Name =...

I managed to figure out the answer myself. Simply put the form info where you have the "me". Many Thanks! Hanss

THANK YOU! This works! Just one more question: What should I type in the box if *text1" is on another form? For example if "text1" was on a form called "form2" If I type: Forms![form2]![text1] into the "where" box I get an error saying that the field cannot be found. Many Thanks! Hanss

I have a form with two text boxes named "text1" and "where" This code will put "2" in "text1": me.text1 = 2 Question: How can I do this? Type "me.text1" into the "where" box and VB puts "2" in the "text1" box, not the "where" box. Many Thanks! Hanss Zürich

Thank you both for clearing this up for me. I am slowly learning that not everything that works in VB also works in VBA... - Hanss