Search results

i'm struggling to get it to a size that can be posted... ok, this might help... I've set up a qry with the following sql SELECT Max(Val(Right([job no],5))) AS [Max] FROM [Job Register and Report Log]; I called it qryMaxJobNo Then set the Default value of the JobNo Form to...

bump? sorry if this is not allowed

Ok, i've searched and found something very similar to what I want. Now, of the code: =Right(Date(),2) & Right(NZ(DMax("[EventNo]","[tbl_EmgCalls]","Left([EventNo],2)='" & Right(Date(),2) & "'"),"9900000")+1,5) so, the table involved is tblJobregister and the field is Job No set out as last 2...

Hi pbaldy, excuse my ignorance, but you you elaborate on your solution a little more? I'm a fairly novice access user :-) ta!

Hi all :-) I have another question. Our user use a form to work a table. One of the fields is the Job No field, with consists of the last two digits of the year followed by a 5 digit number. IE 08/10001 At the moment users have to input this field on every new record they create. What I...

PL456 I've set up both qry's and have tried running it twice. basically access is running out of memory during the qry - hugely resource intensive (1800mb ram usage maxing both cores). the error is that the max database size has been reached 2GB or there is not enough temp storage space on the...

Neil, I know exactly what you mean. I have created numerous databases using auto number PK's, this db was originally built by someone else... typical eh? gemma: The field is set to 7 and is text based field, however I believe you can't change the length of a field used as a relationship...

Morning PL456 Thanks for the quick response! I've set up a copy of the database to work on, this is a split database (front end and back end) I'm after a little more elaboration and what exactly I need to do. I'm not a fantastic access user, and seem to have adopted caring for this...

Good morning all. I have an issue with a large(ish) database. We use a primary key in our main table tblJobRegister called job_no which is a numeric field limited to 7 digits. There is a pre set format of xx/xxxx we use the first two numbers as the year and the last 4 digits range from 0001...