Recent content by ombadboy

Is there a place where i can get these VBA Codes? I guess they are standard ones, so it would be just c/p ?

Hello again. I would like to ask if there is a way to display the toolbar or custom toolbar options, when create a runtime distributalbe MS Access database. For example I would like to have the backup database option available, when i make my project as a distributable runtime program, as well...

I've completely re-worked it. Thanks alot. What i've done ive got a pre-existing list of values for the drop-box, and then a macro with conditions ( if [field]="offer" then openform offers ), etc.. and works like a charm. thanks again tho for the help

Am actually trying to make a drop-down box in a form, where it will 'select' the forms with those 3 names. The macro used after-update uses that to open the form. And on that note.. I just had an enlightment, and have a small idea that all this is unnecessary, but it would be easier to use...

here's the attachment

Here's the SQL, Ill try attach an image in the next post SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Name)="Payment Request") AND ((MSysObjects.Type)=-32764)) OR (((MSysObjects.Name)="Offer")) OR (((MSysObjects.Name)="Extra Items")) ORDER BY MSysObjects.Name; thanks alot

Is there a way to make a form/subform in datasheet view, be more 'compact' ? When I say compact I mean, smaller fonts, smaller 'boxes', etc? Excuse my bad english, I hope you understood what I mean.

Am having a slight problem here. Am trying to use 3 exact values as Criteria in a query, but it seems it not working, only 2 appear (the 1st two). I've attached a screenshot of how my query design looks like.

I get an "invalid or unqualified reference" error on this line: Function CalcRemainingDeposit(Deposit As Integer, DepositUsed As String, DepositDepleted As Boolean, totPriceIncVAT As Double)

So, let me get this right.. What you're saying is turning the field values into variables, use those for any calculations, and after all is done, replace the field values with the variables..

i've scrapped most of the code generated, and tried re-writting it my self. Unfortunately, am gettin errors when the code is executed. "Application Defined or object-defined error" Function Deposit_Deposit() On Error GoTo Deposit_Deposit_Err With CodeContextObject Dim...

here's the generated VBA code.. Function Deposit_Deposit() On Error GoTo Deposit_Deposit_Err With CodeContextObject If (.[Deposit Used] = 0) Then Beep MsgBox "Deposit will be used since this is the 1st time a Payment Request is generated", vbInformation...

never actually used public function etc etc.. only generated ones using the code builder after events.. how do you call the function? is it something like public function something() code code end function and call it from the event?

Am trying to write a macro to calculate some values, but for some reason am gettin an Automation Object Error (screenshots attached). I even tried to make a 'RemainingDeposit' field, in my table, and I still get the same error. Any ideas? Need help ASAP. Thanks in advance

Had a look at it, and implemented it into the program, but now am facing another problem. Since i have the date field using an input mask, the "diff" field now appears like: [thevalue]__/__/__ (am not sure if its the input mask causing the problem though) edit: ok, seems to eb working now, just...