Search results for query: *

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

I am trying to use the following code on access xp (SP3) and I get the complile error "variable not defined" at: Clipboard.GetData(vbCFBitmap) I would appreciate any help as to why this is happening. Do I need to upgrade my VBA? Many Thanks! Kind regards, Hanss Zurich, Switzerland My...

I just came back from vacation. Thank you very much for the suggestions! The only thing that worked was inserting "new page" controls into the form. kind regards, Hanss

Thank you VERY much for your reponse! I tried it out and "Keep Together" does work when the graph is on the main report page but it does not work when the graph is on the subreport. I did select "Keep Together" on both the main report and the subreport detail section. Despite this, the graph...

I have an access report with a subreport which includes a picture. When I print the report, the picture is cut in half instead of being printed on the next page. Is there any way of stopping this from happening? Hanss Zurich, Switzerland

Ben, Thank you for your answer! I surmised that it would not be possible since my searching did not give me any leads. kind regards, Hanss