Search results

Nah it's down to the fact that I repped you on something else recently.

ooooh very smart layout Ken. I'd add to your rep if only the forum would let me!

try this: Private Sub PayBox_Exit() Dim gotFullValue as Variant ' check PayBox for Value If Me![Paybox].value = "" Then ' if no value then set figure to deducted Me![total].value =Me![payable]![deductedValue else ' otherwise add paybox to deducted...

Insert: FormatCurrency(gotFullValue) before your MsgBox()

d'oh! As easy as that huh? Lovely, thanks.

Hi there. The dataase I'm working on is to hold information on the plants that my place of work sells. It will eventually have several thousand entries in it's main table. As users enter the main name of the plant in the data entry form, I'd like to be able to display existing current matches...

I can try! The idea is generally that rather than store the image in the database, you store the path to the image. When the image needs to be displayed (on a form or report), you tell access to display the picture that is in that path. SO the first thing to do is create a field (in the table...

In the OnFormat event of the Detail section of the report, place the following code: Me.txtAmount = "Please submit the commission amount of " & Me.sCommission & " to the following address:" where sCommission is the name of the field which your text box is based on and Me.txtAmount is a text...

If the label of the background is set to transparent, set it to the same colour as whatever is behind (if possible!). I've had problems with transparent label backgrounds in forms before.

Check the file is readable in other programs. Try resaving it as a new jpg file. (Consider changing the file extension to jpg rather than jpeg). I'd also try to avoid storing 4000 OLE ojects in a database. See this kb link for an alternative way of displaying images in forms and reports.

I'm sketchy on the exact details, but yes this is possible with either ASP or PHP. There's an example in a thread on the utter access forums. (You'll need to sign up to get access to download the example).

Stab in the dark here - have you tried setting the AutoResize property of the form to 'No'?

I solved this particular problem by setting a public variable, rather than using a bound combo box. The report then simply calls the variable.

Thanks Wayne. My preferred plan was to have a form with 3 buttons. Each button would close the form but return a value to the function that called this form. I think I'll go with the global varial after all. Using InputBox would mean specifying the user typed '1 for option 1, 2 for option 2...

I know that you can use myvar = MsgBox("Some prompt", vbYesNo) to get an input from a user to dictate subsequent actions. However, if you would like input but need more freedom than yes/No Ok/Cancel Abort/Retry/Ignore, then how do you go about doing this? I thought that you would simply use...

Good points Bob, it's difficult to get the balance between allowing newcomers to give reputation without abusing that facility.

OK this has been bugging me slightly for a while. I regularly give reputation points, as soon as I find a hepful post, even old ones from the archives, that have pointed me towards something. I also only post a message if I feel I have something worth saying - if it adds to what is already in...

Here ya go. I just did what i set out for you in the above post. You'll learn more if you do it yourself of course, but I needed to check I hadn't mislead you as to how easy it was. I picked Avery mailing labels J8163 which are 2" x 4". Doubtless you'll need a different size to that! And I...

VERY Briefly this could be accomplished easily in Access by taking the following steps: Create a table with the required fields Using the wizard, create a form based on the table. You can use this form to enter the data Create a new report, select a 'label wizard' and base the report on the...

Sorry for not emailing, but it's better for future users if the answer (and any subsequent correspondence that might further identify problems) is written in the thread. Depending on how you've set your prefs you should receive a notification email when others reply to this thread anyway. I use...