Recent content by tblues87

Hi I need a little help with this filed property. For one field I set the property "Required" to Yes. When the field is null access gives me a warning massage box (You must enter a value in tblSopl.field) but I want to crate my own warning massage, can someone help if it's possible. Thanks

Hi I have a school report like in attachment and I need to fill all the blanks with data from my DB. I tried to put school report in background as picture and put the fields in the right place but when I print they aren't in the right place Please help

Hi Can someone help me with input mask. You can see on picture in attachment, I have a field OIB that consists of 11 digits. Each digit must be in it's own box. I tried to to that with input mask but there isn't enough space. I need that for printing a report, I putted the picture in...

Please can someone help me. Is it possible to export single or several unbound text boxes to excel. Text box contains this: =DCount("[Pitanje 1]";"[Query1]";"[Pitanje 1] = '5'")It is used to count answers of poll that are equal to 5. I have 5 question and 5 possible answers which means 25 text...

Hi I didn't know how to title this thread but the problem is next. I need a report that will be used as bill. First I made a form that is based on query that gives me information about person that pays. On the same form I made a sub-form for paying details like: paying date and amount of...

Thanks but I figured it out, on main form where is the check box I added the after update event Me!Subform1.Form!ControlName.Enabled

Hi can someone please help me with this I have a main form and a subform. In main form there is a check box. What I need is that when the subform is opened to look in main form if the check box is true or false and then the control on subform is enabled=True or False I wrote this Private Sub...

Hi can someone please explain me what this code means: File As: IIf(IsNull([Last Name]);IIf(IsNull([First Name]);[Company];[First Name]);IIf(IsNull([First Name]);[Last Name];[Last Name] & ", " & [First Name])) This query is record source for frmContactsDetails Thanks

I checked they didn't change. =oduzimanje([Iznos plaćanja];[Cijena tečaja]) I uploaded that test DB can you please take a look if you have some time Thank you very much

Thanks for answer. I changed the names of the controls as you said in property sheet and still the same. You can see it in picture

Hi Can someone help me with functions. I'm just starting to learn how to use vba with access. I wrote simple function that calculates difference of two fields: Public Function oduzimanje(IznosPlaćanja As Double, CijenaTečaja As Double) As Double oduzimanje = (CijenaTečaja - IznosPlaćanja) End...

Hi I've been struggling with this whole day can someone help me please. I need to calculate how much did the person pay in total. I attached picture on which you can see what is the question. Thanks

OK I can do that, but can you please write a code for what I'm asking because I want to learn how to do that and I's driving me crazy. thanks

Thanks for fast answer the tblPaying has 2 fields: PayingMethod, Price and also on form there are two same objects. field PayingMethod is lookup column that has: Cash, Cash on credit, Credit card, credit card on credit For each of these paying methods the price is different. The function...

Can someone please explain me how does function work with object in some form. I've been reading VBA books but I can't figure it out. I was working with functions and loops in c++ but I just can't with VBA and Access 2007. I need this. I have form from tblPaying in which are fields...