Search results

Hi there guys, I have a reference field in my DB that can either be CD followed by 7 numbers e.g. CD/1047294 DV followed by 7 numbers e.g. DV/1948402 IH followed by 7 numbers e.g IH/3742058 and MS followed by 7 number e.g. MS/0683723 Can anyone tell me of an input mask or validation...

Thanks ian! Works liek a charm :P Take care Daniel

Hi guys, its a really quick question that im guessinbg would be easy to do, but is it possible for me to apply any code so that when a "delete record" button is pressed a message box would appear saying something like: So when the Yes button is clicked it will perform the deletion and when...

Hi there guys, I created a password on my database by going to "Tools" >> "Security" >> "Set Database Password" But now, when I try and open the mail merge and catalog merges it says it cant connect to the merge fields. But when I unset the password, it works perfectly, is it possible for...

ahh, but im getting an error for some reason, I entered the following: Private Sub Command22_Click() Shell "C:\Documents and Settings\Daniel\My Documents\New Briefcase\2516\TheKingsHouseSystem\Test.html", 3 End Sub but i get an error saying: "invalid procedure, call or argument" Im guessing...

Hi there, Is there any VB that I can assign to a button to open an offline HTML page that I have created onClick? Thanks

Hi there, really simple question I just wanted to know if I could edit the access interface so that the access help options would not be displayed, but I can add a link to my own created HTML help files for the system I have created. Is it possible?

You know what guys, thanks for all your help honestly, but i just cant get it to work, i think im just going to pack it in and state it as a "limitation of the system". Thanks for all you guys' help and have a great weekend!

I entered: Me.Text86 = Me!Text73 but it now just comes up with an error saying "Microsoft office cant find the macro 'Me'. I also tried: Me!Text86 = Me!Text73 but it says "Microsoft office cant find the macro 'Me!Text86 = Me!Text73'. I then tried: Text86 = Text73 but it says "Microsoft...

yeah mike it did, again! lol http://www.fileden.com/files/2007/1/29/710875/TheKingsHouse.zip Theres the D/L link for the DB,the form in question is the "frm_income" form, the text box I am trying to use to put the calculated value in is near the bottom and is called "Text86" and has the label...

haha, my mistake, only problem is, Ive entered the below code into it, but its coming up with the error "the object doesnt contain the automation object 'Me'" =[Text86]=Me!Text73+Me![Debit/Cred income for day subform].Form![SumOfTotal Cost]+Me![Cheque income for day subform].Form![SumOfTotal...

sorry mike, sadly its not working :( i just dont know why

Would i create the event by going to build event > expression builder then entering the following?: =[onCurrent]=Me!Text73+Me![Debit/Cred income for day subform].[Form!SumOfTotal Cost]+Me![Cheque income for day subform].Form![SumOfTotal Cost]+Me![PDC income for day subform].Form![SumOfTotal Cost]

Sorry ken, how exactly would i set it to "onCurrent event" as i cant see the field in the "Events" tab oh and i tried to test it out on "on Enter" but when I click on the box and it gets focus i get the error "the object doesnt contain the automation object 'Me'" =Me!Text73+Me![Debit/Cred...

Ok, ive found something when i put me! it does not work at all, so eg: =me![Text73] does not work at all, and comes up with #NAME? error but when I use =[Text73] it works fine Im guessing its affecting the others in the same way, but i dont know how to fix it :(

Hi there guys, Im in a bit of a predicament, I have a main form with 3 subforms named: Debit/Cred income for day subform Cheque income for day subform PDC income for day subform and in each of these subforms, I have a field/text box (From a query) which is called "SumOfTotal Cost" and...

Thanks a lot Bob! :D your a living legend :D hopefully i wont run into many more problems haha Take care (and by the way, ive done your ratings :D)

Apologies, ill try and clarify With the code you have given It requests the product name that you want to find the sum of the quantity for which is not the intended way i would wish it to work Below is some screenshots of how it works currently: Requesting Dsum() function of product "slowww"...

Thanks a lot bob, but the problem im having is that I want it to display each calculated value for each product already when the query is opened without it having to request each time which "product name" i want?

Hi there guys, ill keep it short and snappy, Im trying to use the Dsum() function to add together the "Quantities" of specific products bought in transactions i.e. the total quantity for a product called "red t-shirt" and the total quantity for another product called "blue t-shirt". the...