Search results

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.

Thanx for the tip so far, The "Pri key" that was requested was this, MMYY-0000 Where Jan 2009 will reset the 0000 back to 0001 again. e.g. 2008 0108-0001 to maybe 1208-5460 When it become 0109-0001 again. The MMYY is there so that the (Autonumber) does not need to be "unique" Basically the...

Thanx for the code. But I thought that was what I did? But I still got an error. :( Anyway, I think I need to stop hi-jacking this thread... I have posted more details of the request here. http://www.access-programmers.co.uk/forums/showthread.php?t=146404 Hope to hear from you gurus...

Errmmm... Ok, I gotta admit, I am a newbie when it comes to access. As a sample, I created this table to better show what I need help with. The form here is supposed to "Auto complete" for the Serial ID field in here and the Date MM YYYY field. But like what you mentioned earlier, the Serial...

Thanx. I think this is also a very good validation rule. Here's a sample of what I did. I have created a table with 3 fields. - Serial ID (As mentioned, to use DMAX) - Date MM YYYY (Have tried to use the above but I need this to show automatically) - Case (Just Details) Currently, what I did...

I am not sure what I am doing wrong but there was an error that popped up with this. Hope you can help. Thanx.