Search results

Thanks llkhoutx about the info on the book. I just ordered it from amazon.com. But in the meantime there isn't a quick fix to this.. something that I would have to alter the VB code to? The reason is because my manager needs this to be deployed by the end of the week and I won't have the book...

I searched the forum on custom navigation buttons and found great posts about it. I downloaded 3 samples and the one that fit what I needed was SJ McAbney's dbNavSubform.zip. sfrmNavigation I imported sfrmNavigation per SJ McAbney's on the post into my database. I didn't want to start a new...

Thanks it worked! Finally after struggling with it all day. When I created the new database I truned off the Name AutoCorrect check boxes under: Tools | Options | General as instructed on the website and that is what seemed work for me. It imported it once I did that. Thanks again! :)

I did as you suggested. I held down the shift key will trying to open the db and it did open but if I click on anything.. forms, tables etc. it tells me that access encountered a problem and it shuts down.

Hello, I have been working on a database back and forth and home and at work. Today I saved my database from home and onto my computer at work. The database is not opening here at work. It works fine at home. When I attempt to open it, it tells me Access has encountered a problem and needs...

Another thing that I noticed while using this is when you first enter the form it says 1 record not 1 of 10. But if you click on it to go to record 2 it then changes 2 of 7. Why does it only say 1 record when I first open the form? Thanks for any help.

SJ McAbney - Making smarter customised Navigation Buttons SJ McAbney I downloaded your code and imported the form into my form which is just wonderful. I have a question on how to modify your code. I'm not all that great with VB. I didn't need the slider so I commented out...

I ran the Find Duplicates Query Wizard and it found multiple duplicates. Now how do I go about deleting these duplicates?

Thanks, that's what I thought. Since I'm not too familiar with the Access security.. Whenever the user opens Access it will ask them for their username and password? Because when I ran a sample it asked me for my username and password each time I opened access or any database. I just want it...

Using Access's User and Group Accounts or Using a Login Form to access database? I've been researching on how to make a database secure. How to create User and Group Accounts on access, I see the step by step instructions and tried it out myself. I also saw some sites where they give an...

Is it possible to attach an email in a field of a form? We have a database that keeps track of technical orders. We get e-mails on what we are supposed to implement on a particular tech. order. Is there anyway I can attach or make a copy of this email or something to have it in a field of my...

Ok I now have the results that I need. I created 2 temporary tables which I imported my spreadsheet data into. I created 2 append queries. From my temp tables I appended to the my "real" tables and I now have all the info that I need.

PatHartman: How about I create multiple append queries to obtain the results that I need? The relationship between tblTorders and tblItems is as follows: From tblTorders the primary key is TONumber so there is a one to many relationship from tblTorders and tblItems with TONumber as the...

I'm trying to perform a massive data dump. I have about 1,000 records that need to be added into my database. This is coming off an Excel spreadsheet. I don't know if this is possible: I have a table, tblTorders, which is linked to the table, tblItems. When I open the tblTorders, I can click...

Hello, I had a database on a server. The serve went down. Now when I attempt to open the database I get the following error: Unrecognized database format 'S:\6277_Database_Tracking_Log\6277_Database\Scanning_Database.mdb. Is there anyway I can recovery this database? I do not have a...

Ken, Thanks. I understand that the FK is in the tblTO. What I was unsure of this tblProductDirectorate ProductDirID (PK) - Autonumber ProductDirectorate tblTO ProductDirID (FK) or tblProductDirectorate ProductDirectorate (PK)...

Ken, If I want to do the PK/FK thing when for instance I create a Product Directorate table, should I make it the Product Directorate the PK or add another field ProductDirectorateID and make that the PK?

I've been doing a lot of research and reading on databases and normalization and things of that sort because I need to create database from scratch. I've been maintaining a db that someone else made, but it turns out I will have to recreat the whole thing because it's not useful anymore and the...

Thank you Jon K. You've been a tremendous help. I really appreciate it. My reports are running great now.

Thank you again Jon K I replaced it with DCount as follows: NumberOfWorkDays: [Date Approved]-[Date Received]-(DateDiff("ww",[Date Received],[Date Approved],7)-(Weekday([Date Received])=7))-(DateDiff("ww",[Date Received],[Date Approved],1)-(Weekday([Date...