Recent content by theserginhus

BTW, don't forget to set the button to SHOWN ON SCREEN ONLY, or it will print too.

I inserted a button on my report and added this piece of code on the ON CLICK: Private Sub Command10_Click() DoCmd.RunCommand acCmdPrintSelection End Sub Hope it helps!

I have a form that I use to look into my inventory online. I want to be able to size the picture I am viewing to the size of the frame, so they are about the same size. I have used the following to view the picture online. webber.Navigate (image_file) I need code to size the image within the...

Hello. I am trying to create a database where I can enter contributions from members of my church, in order to give them report at year's end. We are small number, about 70, but we collect offerings every Sunday. I tried on my own, but did not achieve much. I searched about many-to-many and...

Creating Information using another table I have a very simple batabase that I need to create new information for an item using the same SKU all the time. I have the basic information, but I am dealing with stones and they change the weight all the time. I need a table that will keep the basic...

new site Jon, I liked it. Looks simple and efficient. No popups is a great thing not to have at any site. I am new here, but so far I like it. Great job. :cool:

Append Query Willwork? Question, will something like this work on a query? I have an append query to eliminate items that are qty=0, but when I run it will check for duplicates, which I can't have. How could I do so it would transfer only records with qty=0 w/out checking for duplicates all the...

thanks Thanks PDX-MAN, you helped a lot. Have a great weekend!! :cool:

Put It To Work PDX MAN, I tried your code many times and it says "compile Error - Argument not Optional". When I use Raskew's code, it works fine! What is wrong? Also, if I want to call this function when I enter numbers in a especific FIELD, how'd I do that? Say I enter 555 on AMT and I want...

Letters to Numbers I take it it will work, but since I am not familiar with coding, I am in trouble. I guess I need to explain that I am NEW to access and learning on my own. If you could insert this into my form, that will call the changes will be greatly appreciated. Thanks...

I just need 10 letters, for the numbers from 0 to 9.

I'd like to know if anybody has a formula that I could use to transform numbers into letters to use on my costing codes. Say I have the letters BLACKWHITE and I want to give it values like B1 L2 A3 C4 K5 W6 H7 I8 T9 E0, and whenever I enter a price like 500, I get code: KEE on my code field. Is...