ms access 2003
in [Tables]
|
From: John W. Vinson on 30 Jan 2010 01:49 On Sat, 30 Jan 2010 01:27:04 GMT, softy <softus(a)gmail.com> wrote: >The database seemed to have run out of job numbers for 2009. All job >numbers start with the year prefix i.e 08xxx or 09xxx. >We gave up using it around August 09 as new jobs entered were gone next >day...and when logging in, a message popped up saying > >QUOTE > "The job ID is not using the current year as count prefix, do you wish >to update it to the current year" This is not a message from the Access program itself, but from some very specific code that your contractor wrote to assign new job numbers. If this is the only critical problem that you're having, and if you're willing, I could take a look and see what's giving the error. You could send me the database by: 0. MAKE A BACKUP!!!! <you should routinely have the database backed up but it's particularly important when you'll be doing something drastic like Compact) 1. Opening it while holding down the SHIFT key to bypass any startup code 2. Selecting Tools... Database Utilities... Compact and Repair Database from the menu 3. Exit Access, and in Windows Explorer, right click the .mdb file and choose Send To... Compressed (zipped) Folder; or if you have WinZIP or a similar utility, use it to create a zipped file 4. Email the file to me at jvinson <at> wysard of info <dot> com (edit out the blanks and edit in the punctuation) I can't guarantee when or if I can get it fixed but I'll be glad to take a look at it, free of charge. -- John W. Vinson [MVP]
From: dasadler via AccessMonster.com on 30 Jan 2010 14:36 Softy, I would be happy to take a look also. I am not an Access or VBA wizard but I have created a database with a similar (I expect) numbering scheme for my jobs. If you want to zip it and send it then I will take a look free of charge. I only ask that if you get it fixed through this forum that the actual problem and solution be written up so that others might benefit. Dan softy wrote: >Guy's and Gal's > >I have a database that is based on MS access that I am having trouble >with. I actually paid someone to create this for me but they refuse help >as they have gone out of business! (wonder why-) > >First, before I show that I am a complete idiot and describe the fault, >** am I in the right group for that type of help ** ?? > >Softy -- Message posted via http://www.accessmonster.com
From: Gina Whipp on 30 Jan 2010 16:03 John, Thanks, I would have extended the offer but I have to folks from the newsgroup who I am helping for free already! -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message news:q8l7m5l5hpnm1ju9ssg2a4kfae1smujj2e(a)4ax.com... On Sat, 30 Jan 2010 01:27:04 GMT, softy <softus(a)gmail.com> wrote: >The database seemed to have run out of job numbers for 2009. All job >numbers start with the year prefix i.e 08xxx or 09xxx. >We gave up using it around August 09 as new jobs entered were gone next >day...and when logging in, a message popped up saying > >QUOTE > "The job ID is not using the current year as count prefix, do you wish >to update it to the current year" This is not a message from the Access program itself, but from some very specific code that your contractor wrote to assign new job numbers. If this is the only critical problem that you're having, and if you're willing, I could take a look and see what's giving the error. You could send me the database by: 0. MAKE A BACKUP!!!! <you should routinely have the database backed up but it's particularly important when you'll be doing something drastic like Compact) 1. Opening it while holding down the SHIFT key to bypass any startup code 2. Selecting Tools... Database Utilities... Compact and Repair Database from the menu 3. Exit Access, and in Windows Explorer, right click the .mdb file and choose Send To... Compressed (zipped) Folder; or if you have WinZIP or a similar utility, use it to create a zipped file 4. Email the file to me at jvinson <at> wysard of info <dot> com (edit out the blanks and edit in the punctuation) I can't guarantee when or if I can get it fixed but I'll be glad to take a look at it, free of charge. -- John W. Vinson [MVP]
From: dasadler via AccessMonster.com on 30 Jan 2010 16:50 Oops - my name is Don... not Dan dasadler wrote: >Softy, > >I would be happy to take a look also. I am not an Access or VBA wizard but I >have created a database with a similar (I expect) numbering scheme for my >jobs. If you want to zip it and send it then I will take a look free of >charge. I only ask that if you get it fixed through this forum that the >actual problem and solution be written up so that others might benefit. > >Dan > >>Guy's and Gal's >> >[quoted text clipped - 6 lines] >> >>Softy -- Message posted via http://www.accessmonster.com
From: softy on 4 Feb 2010 03:19 Thanks for the offer... will do BUT how do I decipher your email address Jeff Thanks SoftY On 31/01/2010 6:36 AM, dasadler via AccessMonster.com wrote: > Softy, > > I would be happy to take a look also. I am not an Access or VBA wizard but I > have created a database with a similar (I expect) numbering scheme for my > jobs. If you want to zip it and send it then I will take a look free of > charge. I only ask that if you get it fixed through this forum that the > actual problem and solution be written up so that others might benefit. > > Dan > > softy wrote: >> Guy's and Gal's >> >> I have a database that is based on MS access that I am having trouble >> with. I actually paid someone to create this for me but they refuse help >> as they have gone out of business! (wonder why-) >> >> First, before I show that I am a complete idiot and describe the fault, >> ** am I in the right group for that type of help ** ?? >> >> Softy >
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 Prev: Scheduling Database Template Next: database for pest control |