Search results

  1. K

    Table and Query relationships - what uses what

    In Access 97 (I have 2010) I created a small database to analyze the table that can be created using the Database Documenter. This allowed me to look at what Tables and Queries are being used by the other Queries in the database all at once and on one page. Basically it allowed me to take a step...
  2. K

    Add an asterisk to the front and back of a number

    I've got a table with a five character part number. I would like to add a field that contains that part number with an asterisk at the front and back of the part number. 12345 becomes *12345* This is to create a barcode for scanning using a Free 3 of 9 font. Here's the catch - I'm using...
  3. K

    Convert table with only one column into a table with several

    I have a machine that spits out data like this: C00 28894 C01 0805-05 C02 Res, 10_ohm C03 FALSE C08 8mm C081 TAPE_MAG # C00 28897 C01 0805-05 C02 Res. 1k 1/8w 1% C03 TRUE C08 8mm C081 TAPE_MAG # C00 28898 C01 0806-05 C02 Res, 2.21K_ohm C03 FALSE C08 8mm C081 TAPE_MAG # C00 28899 C01 0805-05...
  4. K

    Putting an internet window in a form

    I'd like to put an internet window into a form that takes me to a specific URL and then lets me browse from there. I know how to open an IE window from MS Access but have no clue how to open one up in a form. Please help Kip
  5. K

    Pass Word Problems

    I'm working with a database where everyone is allowed into and they are allowed to use most of the database. Changing and altering the database is allowed by only the administrator. Is there a way to set up the database so that it skips the password screen and goes straight into the database...
  6. K

    Naming things on a form

    When making command buttons in forms, such as a button that will open a form named Form B, I would name the button Open Form B - that is if I remember at the time. Similarly, if I'm using a text box that displays a field named Price, I would name the text box Price and the label would be named...
  7. K

    golf database

    I am creating a golf database. We play match-play, which means that instead of looking at the final score, each hole results in a win tie or loss and winning the game is based on how many holes were won. So the hole-by-hole scores must be entered into the database. The approach that I’m...
  8. K

    Chart Scale

    I am trying to create a chart in access. The chart will contain anywhere from 5 to 5,000 points out of around 428,000 depending on the query. I’m having problems with the scale - I’d like the chart to automatically use the minimum value charted as the min Y scale and the maximum value...
Back
Top Bottom