Search results

Guess it happens quitte often?

VBAINET FOR PRESIDENT!!! :D Thank you very much!!! But how did you notice it?

you open up Pano (the form) you'll see a list. when you click on a FileNo textfield (the coloured ones) the 'Detay' form should appear at the selected record. Instead you will receive the parameter prompt. At the 'Detay' form, you'll find the checkbox"invoiced the client(inspection)" when this...

Let me downsize it first though I don't think they would appriciate it if I put information on the internet.

We all use the Turkish version of the Office suite here. We even used the same installer. I looked at the extra features and such on the installed list even those are installed on the other system. I guess there is something wrong with the FileNo field because the backcolor changing doesn't...

It is open

You're quick figuring out its Turkish :) Pano is the main form its the form where you click the FileNo field. So it must be open to run the macro.

I assumed that formlar(same to the enlish object 'forms') directs to the object that contain all forms? The form Pano exists I can see it at the left side object list. also there is a textfield where the name variable at the properties window has a value of 'FileNo'

the parameter prompt shows: [Formlar]![Pano]![FileNo]

I send her the .accdb file that I run. The field text has an event handler when clicked op a macro runs. the macro has an openform action and the value at the second column is: Detay, Form, , [FileNo]=[Formlar]![Pano]![FileNo], , Normal Detay - the name of the second form formlar - forms pano...

wow its as easy as that is it :) Have a diffrent question about the same document. When I click the FileNo field the second form opens op the right record. I've send this to the PC of a colleague. She gets a parameter prompt. Why is this?

Private Sub Form_Activate() If Paid = True Then Me.FileNo.BackColor = vbGreen Else Me.FileNo.BackColor = vbRed End If End SubThis is the piece of code for the color changing Paid is the checkbox How can I add indents? Got it nvm :)

Here it goes, my first thread :) I have just started to use access in a more advanced way if I may say so myself. Using VBA and macro's. First of all the company I work for has a non-english license of Office so I try to translate things in hope it will be understandable, bear with me. When...

Hi there, Recently discovering the world of VBA changed my view of the office suit. Seems like the possiblities are endless, well if you don't know how stuff works everything you try seems like an endless ride. That's where this forum comes in :) I'm born and raise in The Netherlands, maybe...