Search results

I see what you are saying, I fliped the relationship. This is where I planned to store the data. The Comment IS the answer for this database. tblDropdownOption 'holds (Yes, No and NA) tblComment 'Holds the comments for the question (answers) I hope I am not confusing anything, I am really...

This database will not have a data entry form; users will never use the lookup option. I just need to be sure that the Yes, NO, NA is associated with the correct questions from the Excel import. You are saying that I need to remove the FK and not have a relationship with the tblSMRForm?

Updated my post

Ok so this is what I came up with! I think this will work but I figured I would check in and see what you think tblSMRForm SMRFormID (PK) ApprovalID (FK) VersionID (FK) StaffID (FK) SiteID (FK) FileName ' Used for nameing the records (Form1,Form2 etc) tblComment CommentID (PK) SMRFormID...

As I feel that this question is not only related to Excel I have created another topic dealing with Normalization at http://www.access-programmers.co.uk/forums/showthread.php?p=1016173#post1016173

Normalization Issues INTRO: http://www.access-programmers.co.uk/forums/showthread.php?t=36545 I found the above article but I wanted to see if I should be following the same layout. I posted a question in the excel section of this website but it sounds like my issue is with normalization...

Thank you for your feedback sounds like I have a lot to learn!! What direction should I go in order to resolve this, I can do the research but a kick in the right direction will help :) Should I be looking at how I import data from excel? You make it sound like I dont need to update my...

Hey guys, I have found a solution for an import issue I was having with Excel to access but I am finding a flaw, where I am unsure if there is an easy fix. We have a excel document that is a form for QA to use when auditing a facility out in the field, each excel form is then emailed into the...

Whoa, thank you all for the help!!! I was sick the last few days and just got back to work. Thanks! Works just fine now!

This seems simple but when I searched with google and also local on this site I could not fine the info. I just want all my fields to be locked/Diabled till a user presses a button. I just need a little VBA tip. Thanks for the help!

Thank you for helping me, unfortunately I was not able to get this to work. Not because of your code, but because I hit my deadline for the project :mad: I will try a second time when my next shift bid comes around. Thank you for all your help!

Thank you for puting this together for me I will give it a shot and let you know if it works!

Good point, I understand what you are asking me to do but I don’t quite know how to implement it within VB. I will continue to research this but any more info will be appreciated. P.S. I am a Noob with VB but an expert with google :)

Hey guys, I am trying to limit what my users can choose when filling out a shift bid. This is a VERY simple database and will be tossed when the bid is over. I have two tables "Shiftbid" and "tblOptions" In my form I have a list of combo boxes that have their datasource set to "tblOptions"...

Thank you for that! I do think I can change the code to fit my needs just need to play around with it. I am not sure who will have access to the control just yet but I really hope that this dosent turn into a management nightmare. Anyone one have any other tips before I spend a few hours...

Hey guys, I need some ideas on how to create a control panel that my company’s leadership can access to make custom permissions, or change the default permissions. Currently I am working with Access 2007 and I have created the basics of the DB already. It is a full Management DB that my...

To start off I did search lol, I am useing the Quicksearch demo project, everything is running great! Now the only issues I am running into is that when you have two fields that are the same the Quicksearch form will not pull the new record, it will just use the data from the first record...