Search results

"Because the whole process is sooo archaic and paper-centric that it makes my teeth grate if you really want to know." Ya mine too, I unfortunately don't have the power or pull to change it though. Thank you for your help in this matter. I will try what you suggest.

Pat, just out of curiosity why does it matter as to why we do it that way? I've tried to explain and here it is again. The number we track is just a reference # in a book. In this book is a 2 column list of numbers. The first is the reference # which is what we issue to people. The second...

Q. if, for example, the people using 01A, 04A, 34B, and 42C have been deleted, you want to keep those numbers in your EmpNum table (this table never changes) and reassign them to new people? i can't help thinking this should be done manually. I want to keep those records in the table until the...

Example number: 01A, this number is just a number that an individual uses to to reference a certain classified document. If the person leaves, there number is 'suspended'. At the end of the year the classified documents change but reference numbers stay the same. I need to create a function...

Pat, what do you mean? I need to reuse "index Numbers"every year in my "new" table by taking the remaining names that are still active from last year, sorting them alphabetically and than pairing them up with a new number. You're telling me that is poor practice? How would you suggest I go about...

Wazz thats what I'm trying to do but I can't figure out how to get Access to fill in the blank after the names have been removed. we only re-assign a suspended number come 1 Jan (I.E. 01A is suspended today, then it doesn't become reactivated until 1 Jan of next year and thats when I need to...

I've posted only a few times, and have gotten some great participation from the wonderful folks in this forum. I'm still relatively new to MS Access, I just took a course through my local college and found this program to have much potential. Now to the heart of the matter. I need to create a...

SO it can be done?? Thank you for your help Mr. Hartman you've been wonderful. I'm not familiar with code in Access YET, but I thought my answer might lie there. Now that I know it does, I shall pursue the challenge of educating myself in VB code for Access. I wasn't sure if VB code would allow...

Here's my problem We have a database now that was made back in 93 in DOS. It tracks "index numbers". These index numbers (01A01, 01A02 ...)are actually references to the actual "employee number". Every year our index numbers stay the same but the "employee number" changes. Mind you the...

Sorry its been awhile. Currently the program we have will take the individuals name out of the system if they are no longer required and it will print us a new paper copy and start itself over again. The employee number format is similiar to 01A01, 01A02, 01A03.... If bob had 01A02 this year...

Would there be away to program the database to re-assign the number say when a button is clicked. Manally re-assigning 1200 numbers to 1200 employees is a pain.

I do need to keep a history and once a year I need to be able to do a mass update. Basically if Bob has employee #1 but it gets suspended and now he's gone, at the end of the year we reassign employee #1 to Mike who was employee #2 the previous year. Does that make sense?

Yes one employee could have multiple numbers but only after his previous number was suspended. I'm thinking maybe a table with just employee numbers and another with employee #'s, names, sections. Does that sound right?

I need to make a database that Tracks employee numbers, who has them and if the number has become suspended. Would this be something that I be better off using a single table or multiple tables?

Gratouitous bump

Here is attached file Here it is, didn't realize I was wasting people's time, sorry for that. I thought I was giving all the info that I had. Guess I'm not as smart as others. :confused:

What do you mean by this: I'll also make note of the fact that you have a subroutine with a prefix that makes it look (to a READER, not the computer) like a table. If that's a typo, OK. If that's real, it is bad programming practice. It does refer to a table. I'm trying to setup a database...

Help...anybody....please....

Ok the error message I get when I run the code within the builder is as follows: Compile error: Method or data member not found The following line of the code is highlighted Public Sub tblReIndex() Can someone please help me? I don't know much about VB but am trying to learn.

This is just a bump