Search results

Okay, I am trying to create a database for my company, this is going to be a very important database that will be used for a long time to come, so I want to make sure I start this thing with the best design possible. I am by no means an expert with databases, but I am fairly competent. I can...

Yes, unfortunatly there can be multiple NCcodes per order, so then your saying its okay not to have a primary key in a table if you dont have any unique keys?

Thanks for your reply Husky, But I guess I still dont quite uderstand.. Are you saying that my relationship is okay? without the primary key? I do have an NC Code feild too, it just wasn't shown on that model I have an updated database model if you dont mind taking a look at and telling me...

My problem is, I have multiple Nonconformances for each order, so I would need duplicate foreign keys to relate to the orders primary key, which it wont let me do.

Hello, I am very new to access, and don’t have any kind of training other than this forum and googling various things, I think I’m having a hard time wrapping my head around tables and relationships, how to set them up, and how to put into and pull information from them correctly. I am...

phew! thanks for the quick reply, I was freaking out! Holding down the shift key while opening the database allowed me to get into the database window and change my login form! thanks

Okay, Stupid question, What if you turn off your tool bars, then you cant change anything? I had the above function to turn off my menu when my form loaded, and if you logged into my database and had admin access, it would turn everything back on.. but that part got removed somehow, now i...

Hello, I've been tring to do this for a long time, and have never been able to figure it out. I'm using an example from the database samples section of this forum. http://www.access-programmers.co.uk/forums/showthread.php?t=99353 I was able to use the filter to make a report. Dim...

Hello, I have a quick question, I'm sure i can be done, I'm just not sure how. I have an auto Front End updater utility, and i want to link version text boxes throughout my database to the version feild "fe_version_number" in the table [tbl-fe_version] but i can't figure out how to set a txt...

I have a data entry form with a unique key, A SWO# I want to be able to search my table to see if a record exists for it, and if it does, change the number entered to the same number with a -1 at the end of it , then check to see if that number exits, untill it finds a unique number to make...

I know its been talked about a lot, but i can't seem to find the solution i'm looking for, I dont know why I can't just do something like this. it makes since to me but i can't make it work. Tried putting this in the form even load Public Sub Form_Load() Dim Counter As Integer counter = 0...

if I query for the [REASON] it doesn't just return one record, it will show a record for each [RESON], so instead of only showing 1 record, it shows 3 records. which is not what i need. i just want it to show one record but be able to search for any of the [REASON]'s

okay, I have realised I have no idea what i'm doing, but this is what i have managed to make work. My main table has my [Order] Information it is linked by [Order] to another table that uses a contious form to input any Non-Conformances([NC]) for that [Order] Likes this [Order]...

how would an IN function work?

Hey guys, quick question, I have a continous form that I'm trying to number like; 1 2 3 (ect..) I have came up with a way that works, but I'm sure that I'm over complicating it. I have a [recordcounter] field with a default value of 1, and a text box in the footer with the control source...

Thanks for the reply marleymanner1 but access really didn't like that syntax, My code works, but it only returns the first number. Say If I have my feild "1,2,3" if I do a search for "1" it will find that record,but not if i do a search for "2" I need a way for it to find "1","2",and "3"...

Hello, man.. this just keeps getting deeper and deeper.. Okay, heres what I'm trying to do... I have multiple numbers comma separated in a feild for my table (EI) 1,2,3,4,5,6 I have a search form building a filter for a query and I'm showing the matching records in a subform What I want to...

Please somebody tell me if what I'm trying to do is possible, I'd hate to be trying something that can't be done. I have 2 tables.. One table has my main order information. my second table has mutiple records that pertain to that one order. Table1 Order #1 Part# Lot# Order# Qty PO# ect...

Hello everyone, I have a form using text boxes to build a filter for a report, I have 2 charts inside the report. I can run the report through my filter, but the charts use the unfiltered data from my query!!! how can I run the same filter through my charts? or how can I make the charts use...

You can try to use a Validation Rule in your Text box Properties. Take a look here.. http://www.everythingaccess.com/tutorials.asp?ID=Validation-Rules May be a way to combine a couple of the examples to do what you want. Like "*[!a-z]*" Only characters A-Z Like "*[!0-9]*" Only Numbers...