dawn123
Last Activity: Oct 5 '10, 04:55 PM
Joined: Nov 28 '09
Location:
-
Exporting to PDF
Is it possible to set the print range in Access 2007 when exporting to PDF, I know you can manually but is there a way to do it though code. I can only get it to export the whole report. Thanks -
Thanks for the help! I was wondering if you knew if it was possible, when you are export a report to PDF in access 2007 that you could specify the number of pages of the report you want to print. (ie. of a 5 page report only print pages 1-3) I know how to do it manually by going into the Options of the export to PDF but I can seem to find how to do it through vba. -
Printing Report without Opening it
I have a form that has 5 check boxes as well as two buttons, a preview and a print button. Each checkbox corresponds to a different report. I have the preview button working fine, whatever checkbox is select the report will open showing the user. However when I'm selecing the print button I can get the correct report to print fine but I have to open the report and preview it then it will print. I would like to be able to not even open the report... -
I am also using Access 2007 on Windows XpLeave a comment:
-
Alright. I'll try and explain better :)
My first table has a species field and diameter field and i need to find that same species and diameter field in the second table but the second table also has the volume which is what I need. The volume table has one species a number of time with different diameters, So i want the species and diameter that is the same in the first table. So for example:
Table 1 has: (two fields)...Leave a comment:
-
using look up table with query
I am trying to create a query to run to look up values in another table. I came across Dlookup but I don't know if what I'm trying to do is possible.
I have two tables. One table has a two fields (tree names and the other diameter of the the trees) The second table has three fields the tree name, diameters, and volume. So I need to find the tree name and diameter from the first table in the second table and then take the volume that... -
Thanks for your reply! Thats what I used and it worked. But I also figured out why it would't work the other way in the first place.. Pretty simple and stupid of me but I have never had it happen before so I did learned from it. It was that my query was to long for one line.. I got it working now so thats what matters! Thanks again for all the help! :)Leave a comment:
-
How to Update Query using Total Count
I have two tables.. I want to update one table with the count of each colume from the pervious table. I have been able to do it using the query bulider and when ran, it works but I want to take the SQL statment and copy it into my moduel however it won't work. It will not let me format the SQL statment and remove put the whole statement on one line. I'm new at this so I don't really understand why I am unable to do this. Below is the code I have.... -
Nevermind. I got it working..Leave a comment:
-
If Statements
I have a program that allows the user to enter data I am using if statements that only will allow the user to enter integers and numbers if its greater than other and that works fine if the number or value is incorrect then a msg box appears. I have it so that if the number is wrong it takes the invalid number out of the test box.. I need to have it so that the user can enter the values over and over again. so the text boxes need to be cleared after...Last edited by Frinavale; Dec 23 '09, 02:57 PM. Reason: Please post code in [code] ... [/code] tags. Added code tags. -
Don't allow text to be entered in a text box
I have a text box that I only want a user to be able to enter integers. I have it so that if a number with a decmail place is enter a error message comes up. But when i was testing the code, I entered a letter in and i got a runtime error.. I was wondeirng what I would use give an error if a letter what typed in. -
Excel Formatting in VB6
I am making a program that will write what the user input to Excel and I was wondering how to format a number so it only has two deciamal places in excel and so its also bold.. This is what i have for code but it doesn't seem to be working. Any help would be great. Thanks in advanced.
ApExcel.Cells(2 , 1).NumberFormat = "0.00"
I also tried it with "############.# #"
but nothing works. -
Odd Numbers
How would I use a IF statement only allowing even numbers..for example.
I have a form that the user enters number, but the numbers can only be even, I want to be able to have it so if the users enters odd number then a message box come up saying an invalid number was eneted.. How would I go about doing this.. also only a number up to 70 can be added. Thanks -
find the number of duplicate values in array
I have a 2-d array that the user enters tress species and diameter so it looks something like:
sm 10
rm 18
bf 12
sm10
sm10
rm18
and so on.. I need to be able to seach though my array and find all the duplicate values and know the number of each dupliate value so sm 10 would be 3 and rm 18 would be 2 and so on.. until the end of the array. I then will take that array and seach for a value in another... -
reading a text file with spaces
I have a text file containing many lines of numbers seperated by spaces. example:
1234 34332 12
1235 3543 12
I need to read the file into a 2-d array I dont know how to do this becasue of the spaces. I need to replace the spaces in that file with commas, so i can do this. or anyother way that is possible..
No activity results to display
Leave a comment: