Search results

  1. C

    Dates without years

    I'm creating a database to store a bunch of information on various animal species, and one of the peices of information I would like to store is the migration and breeding dates of the animal. I was wondering if there was a way I could use the Date type for this information, and be able to...
  2. C

    Complex forms as subforms

    I have a complex form (in that it contains a lot of VB code and events) to display the information of various articles in my database. I would like to add some browsing options to the form (like a list of all articles on the left, and some different back/forward options), but I also need to...
  3. C

    Updating Text Box when List Box selection changes

    I have a text box ('DescriptionText') which is supposed to display the 'description' text from an item that is selected in a list ('List6') which displays the name of a habitat, and has the ID and Description fields hidden. I am trying to use the following code to update the Description text...
  4. C

    Adding a value to Combo-Box with Query source

    I am trying to make a combo-box that determines the records shown in a list-box on my form (for navigation of a book database). The combo-box contains a list of all the categories that contain books using a SQL query. But I would like to add an 'any' category to the end. I just don't know how to...
  5. C

    Emailing Report For One Record

    Hello, I have a report designed right now that prints information about a company from my database and I need to design a few forms that have lists of companies, and where the user can select a company from the list and click a button to send the report for that company to someone via email...
  6. C

    Printing From Form, Items In A list

    Just another quick question, Ive got a form where I select an option from a combo-box, and then a list box is populated with a list of companies based on what I pick for the combo-box (ie. 'All Companies Exporting', 'All Companies Registered', Etc..). The list-box has 3 columns, the [Record ID]...
  7. C

    Splitting Names and updating

    Just another quick (I hope:)) question... I'm importing some information into a contact list from an old table, and I just realized that the names in the old table are stored as one string, while in the new one I need them in two seperate strings. I'm using an append query to bring over some...
  8. C

    Preventing Duplicates (while importing)

    I have a 'Contacts' table, which holds contact names and numbers for a bunch of companies and i'm brining this info over from a number of different tables. I need to allow the same name to appear more than once, but not associated with the same company. I'm using a (relatively) simple append...
  9. C

    Turn off confirmation boxes

    Is there a way to turn off the confirmation boxes when I run query? You know, the ones that say 'You are about to update/delete/whatever to blah blah blah.." with the OK buttons.. I'm making a bunch of automated querys run, and its really annoying to have to click through all those damn 'OK'...
  10. C

    'new contact' button???

    I've got a list of companies, and a form to edit their information. But I also have a list of communications with each company (with name of contact, date, etc..) in a seperate table. I'm trying to figure out how to create a button on my form that will bring up another form to add a new contact...
  11. C

    Automatically Selecting Values

    Heya all, just had a quick question (at least I hope its quick)... I've got a database I'm working on here that holds some information about companies, names, sales, etc... There's a specific field that holds a classification number (NAICS #). The NAICS Sectors (General Categories) and...
  12. C

    Filtering Using Combo-Box

    Hello.. I'm just getting a handle on all this Access stuff (thanks mostly to these kickass forums :) )... And I've run across a little problem... I'm updating a database that stores information on various companies, and the table that stores the company info has a field called [Company Sector]...
Top Bottom