Form repeating detail section

[CIIIHAN]

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 you enter design mode of a form or report you get these black lines.
The footer, details etc.
I assume they are called sections?

Now for the issue I'm posting for.
I have a table with over 1000 rows.
Each row contains a shipment.
A main form that shows all the rows, this is done with the use of repeating details section.
A second form that shows details of the shipment

Each shipment has a unique FileNo, when the text field containing the FileNo is clicked the second form is opened with the information of the selected shipment.

I want to add a paid checkbox.
This box can either be on the second form or as the first item for eacht row at the main form.

The textfield containing the FileNo on the main form has a red backcolor
When the box is checked the back color of the FileNo textbox is changed to green.

At the moment Access checks for the checkbox of the first row and applies the color changement to ALL rows obviously this is not what I want.

How can I get Access to check each row individually

Hope I made the situation clearly as possible
Thanks in advanced,
Cheers,
Cihan

 

[CBrighton]

I assume you are currently doing it on an event, possibly on click?

Try looking into conditional formatting.

 

[CIIIHAN]

Private Sub Form_Activate()

If Paid = True Then
  Me.FileNo.BackColor = vbGreen
 Else
  Me.FileNo.BackColor = vbRed
 End If
End Sub

This is the piece of code for the color changing
Paid is the checkbox

How can I add indents? Got it nvm

 

[vbaInet]

Try looking into conditional formatting.

http://office.microsoft.com/en-us/a...using-conditional-formatting-HA010208133.aspx

 

[CIIIHAN]

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?

 

[vbaInet]

What is the parameter prompt?

Does she have the same tables that you have?

 

[CIIIHAN]

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 - the name of the main form

the same issue occures on other pc's to

 

[vbaInet]

But what is the error message or the parameter prompt?

 

[CIIIHAN]

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

 

[vbaInet]

Are you sure the form Formlar exists?
Are you sure the subform Pano exists in the Formlar form?
Are you sure the field FileNo exists in the Pano subform?

 

[CIIIHAN]

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'

 

[vbaInet]

I assumed that formlar(same to the enlish object 'forms') directs to the object that contain all forms?

Well, I don't speak Turkish

The Pano form must be opened before you can refer to it.

 

[CIIIHAN]

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.

 

[vbaInet]

You're quick figuring out its Turkish

Google Translate is the key to my con

So it must be open to run the macro.

That's right. If it's not open it will bring up the parameter box.

 

[CIIIHAN]

It is open

 

[CBrighton]

Could it simply be that the other persons install of Access doesn't have the Turkish keywords?

Have you tried it with "Forms" instead?

 

[vbaInet]

Upload your db let's have a look.

 

[CIIIHAN]

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 occure on the other system either.

 

[vbaInet]

I can't diagnose your problem without seeing your db. A stripped down version will do.

 

[CIIIHAN]

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