Outlook starts countdown when sending email (1 Viewer)

[azlan]

Dear Gina,
The problem is with test query. Please see the DB file on the link;

https://drive.google.com/folderview?id=0B4XWxrfIVqpteEpsVDJfdlV3bEk&usp=drive_web

 

[GinaWhipp]

You are getting the message because you have joined Text to Numeric. The Assets table is joined to the Marka table. The field is Autonumber in Marka but Text in Assets. You cannot do that, they must be the same Data Type Number to Number or Text to Text.

 

[azlan]

Dear Gina,
I am joining the field "MarkaKodu" from Marka table and it is text. I do not understand?

 

[GinaWhipp]

Look in your Relationships window not the query grid window.

 

[azlan]

Dear Gina,
I have solved the problem but, what I need to do is concatenate 4 fields in one field and record the result in to BarcodeNumber(this field is already created in Assets table) field in Assets table.
So this is how I will be generating barcode number. Is it possible? If so how?

 

[GinaWhipp]

Do you have the Font? You will need this to show a Bar Code number on a label or in a Report.

 

[azlan]

All those are already done. My problem is, as I explained on previous message,
"I need to do is concatenate 4 fields in one field and record the result in to BarcodeNumber(this field is already created in Assets table) field in Assets table.
Is it possible? If so how? "

 

[GinaWhipp]

Then in your Report for the Control select the Bar Code Font and set the Control Source to

="*" & [your concatenated field] & "*"

 

[azlan]

Dear Gina,
Not in the report actually, first, I want to store concatenated numbers in the Assets table in BarcodeNumber field.

 

[GinaWhipp]

You cannot show the Bar Code in the Table, it will only show in the Report. And there is no need to store the concatenated value as you can pull it up anytime. Just use it in a Report.

 

[azlan]

Not the actual barcode, just the numbers like "001232310011" , still not possible? like calculated field...

 

[azlan]

Is it possible to do this with vba code in after-update event of BarcodeNumber...

 

[GinaWhipp]

Yes, you can use an After_Update event of a Control in a Form but again, why? You don't need to store it since you can get it anytime you want in a query?

Oh, but if you are asking can you do this via a Table, then you can use a calculated field I never use them but it is possible. Have a look at...

http://office.microsoft.com/en-us/access-help/create-a-calculated-control-HA010108354.aspx

 

[azlan]

Dear Gina,
I have come to the end of this project but I have one last problem to solve,
there is a code supposed to run behind the BarcodeNumber field on the main form to generate eancode, which is;

Private Sub BarcodeNumber_AfterUpdate()
Me.eancode = code128(BarcodeNumber)
Me.Requery
Me.Refresh
End Sub

but it is not working.
I also attach the Access file. Please help.