Search results

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...

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

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

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...

Hi I'm wondering if it's possible to add data in record through form and then save it in list or combo box. Let me explain on my example: I have tblStudents and tblPayingMethods. Now student can pay in cash or with Credit Card. If he's paying with Credit Card it can be on Credit (during...

Hi Can someone help me with this. I have a tblStudents and need a query that can search that table by First and Last name of students. Result of query should be only one student because there can't be two same students. Thanks

Greetings, is it possible to make such query which result will be one of the before filled Forms. If it is can someone explain. Thanks.

Hello, I'm new here and also with Access 2007 so I have question. I need to make database for one school. First I made one table with persons who attend school and I have ID number for each person and it is primary key. Second I made table with foreign languages which school has. Next I made...