Recent content by joepele

Hi Rabbie, Thanx for your help. But I got a Syntex error. Not sure what is wrong. Upz on your repo

OMG, So sorry to hear that. Do take care ya. Will be praying for her. GB

Actually, wouldn't that be similar to deleting the auto number field and creating that field again?

Thanx for the response, I managed to store them in the correct format when they are stored as individual fields. But when I were to combine them as 1 field... they went bonkers. See attached report, text 13 to see what I mean. Any solution around it?

This is a get next number function right? But I noticed that it "displays" the next number, but how do I fill in the field automatically?

Anyone? Bump

There were quite a number of posts on this... but being a newbie myself... I'm still trying to sort this out... But hope this will help you more than it did me. http://www.access-programmers.co.uk/forums/showthread.php?t=146404&highlight=dmax More posts on it...

*I know that this may not be the best way of resolving the problem but this is not the actual problem but my way to simplify of explaining the "problem". I have a Table with 3 fields. Field 1 - Auto Number Field 2 - First Name Field 3 - Last Name Initially, the Table was sorted via First Name...

:D Looking forward to your posts / help. :p

Thanx! Will try it.

Hope this gives a better pict. Pls see the report. Text13 to see what I mean.

I guess it'll be ok if it's in a text format. WYSIWYG. But this field is an Autonumber format. WYSINWYG :( Can the format be set for the report for 2 joined fields? e.g. Format : Field1(0000) & " " & Field2(MM/DD/YYYY)

Before joining or after? When this 1 field is alone, it's fine. But when it's joined as a report... all format goes bonkers. Anyway, is it a better idea to use a query to join the 2 fields into 1?

This does not seem to work very well with numbers. e.g. If the format of one of the field was 0001, 0002, 0003 and the other was ABC, DEF, GHI In the report, it will only reflect as 1 ABC, 2 DEF, 3 GHI. the prefix of 000 will be missing. Anyway around it?

Hi Rabbie, The person who does the work always hopes to do it the easiest way... But usually it's the person who "sets" the requirements have wonderful hopes for the application. If they could, they'd wished that the application can help them in the click of a button.