error in entryfield

  • Thread starter Thread starter Jean-Paul De Winter
  • Start date Start date
J

Jean-Paul De Winter

In an entryfield I get an error when I write
="Aantal uren dat dit vak gegeven wordt " & [uren]

uren is a numeric field form a table

What am I doing wrong?
Thanks
 
I don't understand what you mean by 'entryfield' or where you're 'writing'
this, and some detail about what the error says would be useful, but it's
worth trying...

="Aantal uren dat dit vak gegeven wordt " & cstr([uren])

.....to convert the numeric field to a string.

If that doesn't work, can you provide more detail on what it is that you're
doing?
 
sorry if I explained it a bit confusing... I wrote teh question when I was a
bit in a hurry.
It all has to do with an entryfield on a report.
[Uren] is numeric
So now I wrote (like you suggested):

="Aantal uren dat dit vak gegeven wordt " & cstr([uren])

on the preview of the report I now get:

Aantal uren dat dit vak gegeven wordt Error 0

now what???
also... when [uren] is 0 I don't want the line to be printed... can you
please explain how?

Thanks



Rob Oldfield said:
I don't understand what you mean by 'entryfield' or where you're 'writing'
this, and some detail about what the error says would be useful, but it's
worth trying...

="Aantal uren dat dit vak gegeven wordt " & cstr([uren])

....to convert the numeric field to a string.

If that doesn't work, can you provide more detail on what it is that you're
doing?


Jean-Paul De Winter said:
In an entryfield I get an error when I write
="Aantal uren dat dit vak gegeven wordt " & [uren]

uren is a numeric field form a table

What am I doing wrong?
Thanks
Click to expand...
Click to expand...
 
No. Still don't get what you mean. What is an 'entryfield'? It's not a
standard Access term. Before you preview the report, where have you
typed...

="Aantal uren dat dit vak gegeven wordt " & cstr([uren])




Jean-Paul De Winter said:
sorry if I explained it a bit confusing... I wrote teh question when I was a
bit in a hurry.
It all has to do with an entryfield on a report.
[Uren] is numeric
So now I wrote (like you suggested):

="Aantal uren dat dit vak gegeven wordt " & cstr([uren])

on the preview of the report I now get:

Aantal uren dat dit vak gegeven wordt Error 0

now what???
also... when [uren] is 0 I don't want the line to be printed... can you
please explain how?

Thanks



Rob Oldfield said:
I don't understand what you mean by 'entryfield' or where you're 'writing'
this, and some detail about what the error says would be useful, but it's
worth trying...

="Aantal uren dat dit vak gegeven wordt " & cstr([uren])

....to convert the numeric field to a string.

If that doesn't work, can you provide more detail on what it is that you're
doing?


Jean-Paul De Winter said:
In an entryfield I get an error when I write
="Aantal uren dat dit vak gegeven wordt " & [uren]

uren is a numeric field form a table

What am I doing wrong?
Thanks
Click to expand...
Click to expand...
Click to expand...
 
sorry, i probably use the wrong translation...
I mean... take the objects-tools, the object next to "label"....
place it on the report design and then enter what you suggested...

OK now???? pfffffff I never buy an office version in my native language any
more...

Thanks for your understanding
JP

Rob Oldfield said:
No. Still don't get what you mean. What is an 'entryfield'? It's not a
standard Access term. Before you preview the report, where have you
typed...

="Aantal uren dat dit vak gegeven wordt " & cstr([uren])




Jean-Paul De Winter said:
sorry if I explained it a bit confusing... I wrote teh question when I
Click to expand...
was
a
bit in a hurry.
It all has to do with an entryfield on a report.
[Uren] is numeric
So now I wrote (like you suggested):

="Aantal uren dat dit vak gegeven wordt " & cstr([uren])

on the preview of the report I now get:

Aantal uren dat dit vak gegeven wordt Error 0

now what???
also... when [uren] is 0 I don't want the line to be printed... can you
please explain how?

Thanks



Rob Oldfield said:
I don't understand what you mean by 'entryfield' or where you're 'writing'
this, and some detail about what the error says would be useful, but it's
worth trying...

="Aantal uren dat dit vak gegeven wordt " & cstr([uren])

....to convert the numeric field to a string.

If that doesn't work, can you provide more detail on what it is that you're
doing?


In an entryfield I get an error when I write
="Aantal uren dat dit vak gegeven wordt " & [uren]

uren is a numeric field form a table

What am I doing wrong?
Thanks
Click to expand...
Click to expand...
Click to expand...
 
Strange. Hopefully I have what you're saying right that you're using the
text as the control source of a text box... but if that is the case then I
can't persuade Access to give me the same error.

I'd tend to switch things round a bit and use a query to add the text... so
if you create a query based on your table and add a column...

Uren2: "dssddf "&[Uren] (you shouldn't actually need the CStr)

you can then just base your report on that. And if you add a criteria to
check that Uren doesn't equal 0 then it will skip those records.


Jean-Paul De WInter said:
sorry, i probably use the wrong translation...
I mean... take the objects-tools, the object next to "label"....
place it on the report design and then enter what you suggested...

OK now???? pfffffff I never buy an office version in my native language any
more...

Thanks for your understanding
JP

Rob Oldfield said:
No. Still don't get what you mean. What is an 'entryfield'? It's not a
standard Access term. Before you preview the report, where have you
typed...

="Aantal uren dat dit vak gegeven wordt " & cstr([uren])




Jean-Paul De Winter said:
sorry if I explained it a bit confusing... I wrote teh question when I
Click to expand...
was
a
bit in a hurry.
It all has to do with an entryfield on a report.
[Uren] is numeric
So now I wrote (like you suggested):

="Aantal uren dat dit vak gegeven wordt " & cstr([uren])

on the preview of the report I now get:

Aantal uren dat dit vak gegeven wordt Error 0

now what???
also... when [uren] is 0 I don't want the line to be printed... can you
please explain how?

Thanks



"Rob Oldfield" <[email protected]> schreef in bericht
I don't understand what you mean by 'entryfield' or where you're 'writing'
this, and some detail about what the error says would be useful, but it's
worth trying...

="Aantal uren dat dit vak gegeven wordt " & cstr([uren])

....to convert the numeric field to a string.

If that doesn't work, can you provide more detail on what it is that
you're
doing?


In an entryfield I get an error when I write
="Aantal uren dat dit vak gegeven wordt " & [uren]

uren is a numeric field form a table

What am I doing wrong?
Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top