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...

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...

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...

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...

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...

Hello again, I hate to ask for help a second time, but it helped out so much last time its hard not to. I have been able to do pretty much everything I have tried to so far, but I've hit another road block that I just keep banging my head against. I have a "Search Form" that I'm using unbound...

Hello guys, I'd first like to thank everyone for all their informative posts, I have only been working with access for a couple days but this fourm has already been a life-saver for me. I'm usually pretty good at figuring stuff out, backwards engineering peoples examples, but I'm having...