Threads Replies Last Post 152 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Save and Close Button I am designing a database containing patient information. On the main report screen I have a drop down to choose the patient. I also have a button that opens a form to add a new patient if needed. My question is how do I add a button to "Save and Close". the new patient form after the information is added? Rab... 3 12/24/2008 2:15:38 AM Stock Level subtract Order Quantity? Hi, Im designing a database for a large adhesives company, and I need help in writing a query to subtract the quantity of an order which will be specified in a form from the stock level in the product list table. Thanks in anticipation, Merry Xmas, Sam... 2 12/24/2008 2:03:55 AM Controling database size I created a database for the office and they had a graphic designer spiff it up. But in so doing they more than doubled the size of the database. Two things that were done was using an image embedded I switched them to links and that reduce it some. The other thing that they did was open and close forms and reports with Macros instead of Code. Will the macros add size over code? i.e... 2 12/24/2008 1:00:30 AM Long Descriptions for Fields I just want to know if anyone can help me figure out how to incoroparte long descriptions for the fields in the table. The field description I have are over 500 characters long and I want to be able to show the whole description when that field is selected in a form or else I will run out of space on the form to fit everything. Help please. ... 7 12/24/2008 12:58:25 AM Recursive Table Please help with my recursive table design. tblCategories CategoryID CategoryName ParentCategoryID FK to Category ID How do I Parse the table and bind it to some kind of control so a user can select a top level category and then have it display the child categorys of the selected one and continue doing this until a "leaf" or last level cat is selected. then i need to store this "lea... 2 12/24/2008 12:06:44 AM Column Naming Too Long I am designing a database consists of questions as column fields in a table. My problem is that since the coulmn fields are the the questions, the questions are very lengthy and won't fully fit in the column headings in the table. I tried naming the columns by numbers but then when I export the data onto excel, I can only see the numbers as columns headers and my goal is to be able to s... 5 12/23/2008 9:49:12 PM Hyperlink to open specific record Is there a way to have a hyperlink that opens to show a specific record on a form? If so, how? Thank you.... 1 12/23/2008 9:41:10 PM Database Design I have a small furniture company. we manufacture about 500 different stock peices of furniture. I am building an ASP WEB site and need to design abd build a database to store product information. Each product will need - Part Number, Title, Description, Price, Category and and unknown number of sub-categories, group or room (office, living, bedroom etc.), sytle(contemporary, mission, tra... 7 12/23/2008 7:44:01 PM Default selections in a table Hello, Suppose Columns A and B in Table 1 contain an industry name and industry code, respectively. I then create a Table 2 which has drop down lists in Column C to select industry names from Column A in Table 1. Can Access automatically fill in the corresponding industry code into Column D of Table 2 that matches the industry name I selected in Column C? Hopefully this makes sense... 2 12/23/2008 7:19:46 PM Problem with Access 97 lookup query decimals In a database that has a front and back end (mde), we have a lookup in a subform that retrieves cut sizes from a table in another database (linked). The size format is Standard / 4 decimals. I've managed to set the format of that particular field in my database lookup field to Standard 4. I make the mde and when I use it, I get 2 decimals instead of 4. I went into the query (of the dro... 1 12/23/2008 3:43:01 PM event help I am in access 2007 and I have a table called inventory with the following fields included: I have a field called [restock level] and it is numeric a field called [current purchases] which is numeric and a field called [current inventory level] which is numeric I created a query and included a calculated field called todays inventory which subtracts [current purchases] from the [current ... 18 12/23/2008 2:53:01 PM Math Question I have a section of my database that is based on the "Glasgow Coma Scale" an explanation can be found here "http://en.wikipedia.org/wiki/Glasgow_Coma_Scale" It is a way of determining someones level of consciousness by evaluating certian signs and assigning each a score. There are three different criteria each with a text description and a score. How can I place the text description ... 2 12/23/2008 4:15:40 AM Table Question I am attempting to build a database for patients. So far I have it set up like this; tblPatients patientsID patientsFIRSTNAME patientsLASTNAME patientsPHONE ect... all the normal info (Its a long list LOL) Anyway what I need to be able to do is set up a Medication list for them. I would like the database users to be able to select a drug from a drop down list have it somehow add t... 2 12/23/2008 2:33:45 AM query results show in form three days, on a very simple (i'm sure) set up. I have three tables... Service/Client Registration (Client ID, Lastname, address) PK Client ID Action Plan (multiple Action Plan to Client ID - PK ActionPlanID Service_ALL(ServiceID, Action ID) PK ServiceID lists all the services in seperate table I have a data input form ready to go....however, I want to put in a control at the top of... 2 12/23/2008 1:49:42 AM redundant data - help with Contact Database I have a database that has one table right now, called "Contacts". That table has fields like Last_Name, First_Name, Address1, City1, State1, Zip1, Organization, etc. Many of our contacts work within the same organizations (i.e. California State University Monterey Bay, Monterey Bay Aquarium, etc.) I want to avoid entering the address for these organizations for each contact we have w... 7 12/22/2008 9:37:22 PM Event Help I am in access 2007 and I have a table called inventory with the following fields included: I have a field called [restock level] and it is numeric a field called [current purchases] which is numeric and a field called [current inventory level] which is numeric I created a query and included a calculated field called todays inventory which subtracts [current purchases] from the [current ... 9 12/22/2008 7:11:03 PM Unbound Subform in a Switchboard I am building a database to handle multiple departments of our organization. I want a switchboard to constantly be visible with a subform in the middle which would load the appropriate forms depending on the options selected on the switchboard. My subform is unbound when the switchboard first loads, and i change the subforms source object whenever the user selects different functions. Al... 3 12/22/2008 1:10:00 PM Two Databases Sites I've have designed a database which I have Connected to Autocad, which I use for Document control. However I have two other sites using the DB, however from time to time I need to copy sections of tables between my local DB & the External DB's, which is causing problems. The problem is that the Autocad Documents store a Document_ID which is an Autonumber in Access. So when Drawings ... 7 12/22/2008 7:27:10 AM Auto Dial And DSL How can I have the auto dial function use my internet broadband connection instead of the modem to place a call from within access. It works fine with a modem but I would prefer it use my DSL connection since I am never connected to the modem ... 2 12/21/2008 4:41:01 AM MS Access metadata repository generation query, matrix generation query, table-generation query, array-generation query. Hi: In 2002 I asked the microsoft.public.access.tablesdbdesign group a question about how to "automatically build tables from field defintions rows in another table". I never received an answer that fit my needs, but the topic has come up again in my work. Other terms that might describe what I'm looking for are: metadata repository query, matrix generation query, table- generation que... 2 12/20/2008 7:23:28 PM Junction Tables The examples for handeling many to many relationships (Access 2007) show the creation of a junction table that includes 2 primary keys in one table, how is this done? -- Andrew H.W. Lochner... 3 12/20/2008 7:21:42 PM Use VBA to set Format Property of a Field I need to create a field using VBA which will display with 2 decimal places. I can do it manually using the type "Currency" and the format property "Fixed". I can create the field with the currency type using the VBA CreateField function below. I can't seem to figure out the code needed to set the format property to "Fixed". I understand that the property needs to be created, but I'm missi... 6 12/20/2008 6:56:11 PM import from excel help I am importing part numbers from an excel spreadsheet. For some reason the part numbers which are generally 12 digit numbers, sometimes import in scientific notation format as exponents. It seems very random. It obviously happens in the excel spreadsheet also prior to import. If I click on the field and look at the number in the formula bar however it appears normal. Here is the questi... 5 12/20/2008 3:24:02 PM Table Splitting Questions I have a table with way too many fields, and I am trying to use the table analyzer to split it. I'm not sure how to approach this, and I'd appreciate some guidance. I would like to break off a group of fields into a table called “ShipTo”. So I separated my group of fields such as companyname, address, city, country, etc., created the new table “shipto”, and created the query ... 8 12/20/2008 1:19:19 AM Random number query question Is there a way to have a query generate random numbers and then use that to populate a table? I need to have 70 random 3 digit numbers each quarter and I'd like to click a command button instead of write the numbers one-by-one. The table to populate is 64EmpSurveyNumbers. ... 9 12/19/2008 9:55:00 PM 152 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>