Search results

Answer Oh, yeah...I actually solved my own problem!!:cool: For those who might read this in the future, it is simple. Create your field as type: Autonumber. In the Format box, enter: "PREFACE"0000 Where PREFACE is the string you want entered before the autonumber. It is important to...

I am not even sure what that means, but here is my scenario: I have several "blocks" of training required by different personnel which I have split into seperate tables. The vast majority of the blocks are finite, so I hand-jammed the PK for them. However, I have a few tables that will be...

I am trying to build a table that's primary key is an autonumber, but want to add "SCHL" to the beginning for ease of import/employment in other tables. Trying to get each new record's PK to be: SCHL1, SCHL2, SCHL3, ETC... I could have an autonumber field then in the next field have...

Already started building a new DB. Gonna leave the old in place for the day-to-day. thanks for the help. I am sure I will have more issues as time goes on. I have read many threads and how-to's and at least I have an idea now. I am sure i will have a myriad of questions in the future...

I agree. I know that there is no comparison; however, I am building this DB (as does everyone) for the pruposes of reporting information. Since I already know that format of what is required as the end result, I want (actually NEED) to ensure I design the DB around the reporting requirements...

I completely agree with you about the road length. No offense taken. I realize that I am in WAY over my head with this one. Good news is I have a semi-functional DB for the day-to-day and about 4 months to build, beta, and deploy the final project. It satred out small, but worked so good for...

Based on this statement...my design is flawed. Here is more info on my specific goal as applied to training completion dates. I have the following types of training: 1. Permanent Certification 2. Fiscal Year Annual 3. Calendar Year Annual 4. Fiscal Year Semi-annual 5. Calendar Year...

Unfortunately, I cannot. The tables, even without the record info, contain information that I cannot release. I do thank you for your offer to help, though.

Unfortuately I cannot post it. There is info in it that I cannot release. I do thank you for your offer to help, though.

Another question would be for eaese of data entry. Is there a way to have a single form with tabs input info into multiple tables?

Believe me, I was shocked at the number as well. 876 and still counting. Staggering. That number is magnified exponentially when you are one of only two people who are being used for data entry/DB construction/administration. The boss gets what the boss wants, right?!? How do I set up child...

I am relatively new with Access, but am trying to learn. I am developing a DB for my orginization that stared off small and has blossomed from there. Without getting too far into the weeds with specifics, I have close to 1,000 fields needed per record. With a limit of 255 fields per table, I...

I am not sure what an .accde is. I read in one of the posts that for deployment, it is far better to use an .mde than .mdb. I am using Access 2003 file system with Access 2003 to try to create an .mde from an .mdb. I am not real well versed in Access, but I am trying to learn. Any info you...

I am trying to embed MS Word and Excel documents into my DB to help with distribution and maintaining format. Ultimately, I would like to have a "documents" switchboard listing all the printable forms. Any help would be greatly appreciated. Thank you.

Only had one module that i was not using anyway. I am not real big in VBA. I deleted it, compacted and repaired and still no good. Same version of access. I moved the FE off the server and onto my desktop.

I successfully split my database, but when I attempt to create an MDE, it tells me that Access cannot create an MDE database. I have compacted and repaired to no avail. Small database, less than 30 actual objects. Any ideas as to why this might be?

Thank you for your help. I will give that a shot.

I have a DB that 2 people currently use on a server. I am going to be adding several more users once the DB is done. I did this once before by splitting into FE/BE and it worked, but had issues. When I, as the adminitstrator/creator, accessed my link to the DB and made format/table/query/etc...

You, sir, are an absolute wizard. One day, I hope to be half as good as you. I can tell, you just wrote both of those within minutes of my request for help. Thank you for all of your help. I have been racking my brain for 3 days trying to get it done. I can't tell you how much you have helped.

That helps immensely. Thank you for your time and help.