Search results

the procedure stops and the error message is Run-time error '70: permission denied

I am using the SendKeys command (Sendkeys "%ha%n") . It is working on my Windows 7 Access 2003 but it is giving error on Windows 8. Any suggestions? :confused:

never mind i went around and inserted some IFs and Elses and all worked out.

sorry jdraw but i had to get back to you. i have a new issue with the code. while it is working when all fields have values, it is failing when one or more don't. one or more fields in the quote form have no value because the relevant fields in the lookup table also have no value. i guess the...

thanks jdraw, this last code is working like a charm. :cool: and this should put an end to my long night :)

Year1 and Year2 are long integer, Product is a text

tks for your efforts. actually my SQL statement is copied from the row source of a combo box on the subform (frmquotesauto). the SQL is working in the combo box but as you know the result will not be posted until you chose it, and i want to get rid of this box. I used your version and i got an...

i don't know how this is going to help me. i did it before and all i am getting is the SQL string in one line, no value, and i could not see the error tks :)

I have a form (FrmAddQuotes) with a tab control and two pages ( quotes for insurance). I am trying to automatically fill the rate field on the quote subform (FrmQuotesAuto), by a rate from the rates table that meets 4 contditions with an SQL statement. here is my code: Private Sub...

Wonderful. I am not a novice but not an expert either. Yes the one line code did the whole trick. Just for the records so others like me know that this code will hide any section in a report conditionally. Just replace the section name and the field name. I tried it with the Report Footer where...

And they say " curiosity may kill " :) not in this case. with the new line of code the report came out also perfect, same result as with the code from Bob. Also for any visitor who faces this problem, the following code is as good as Bob's : Thanks to both

Stopher thanks for the try. just out of curiosity i tried your code. while it solved the problem of the empty lines, it created something weird (see the attached, 2 pages). I think with some tweaking it might do the job thanks again

The good news is that the code worked but only after a little modification. I ran the code as is and i got to the very first report that I attached with my original post, extra empty lines were still there. I added one line, setting the Detail section height to 0 and voila, it is perfect. I am...

I apologize for missing your quote. I have set the Can Shrink to No in design view and got a new look (report attached). While the code took care of the extra lines in the Main Test part (under Chemistry) which originally was the problem, it also suppressed the rest of the lines having valid...

Thank you for the efforts. The control HEIGHT did not give the needed results. In the code I set the height to 0 and in design view I set the Detail section CanShrink to yes. In the printout, the part with the sub-tests more lines were added and the part with main tests, the Can Shrink did not...

if i do that in design view, all fields without data will shrink and the borders will disappear and the report looks bad (see attached). I believe the only way is to set the canshrink property with VBA which is not allowing it... The code worked with the ForeColour and BorderType but not the...

I am using Access 2003. I have an application for a medical lab and all is working fine except when it comes to printing the test's results. The problem is with formatting and not with getting the data into it. There are two sets of groups of tests : Main tests (Mtest table) and Sub tests (Stest...