Search results

  1. O

    2d Datametrix barcode font

    vgersghost, I just searched for barcode and found your request. Try the following link. There is a PDF417 complete and a DataMatrix works in progress. I have tried the PDF417 and my Symbol 904Pro reads it without problem. I have not implemented it in my access DB because I am the only one with a...
  2. O

    bitten of more that i can chew!

    mrbean, Have you looked at the "Northwind" database that is included in MSAccess? A good place to start. Also check out the "database creator", select "New" when you start up Access. We will be glad to help you with suggestions, but no one wants to do your work for you... jim
  3. O

    Newbie Duplicates question

    jaconat, This solution, thanks to CosmoKramer several years ago, works very well. Add a table to your database that only has one number field. Populate this table "Number" to contain sequential numbers 1 to whatever the maximum number of labels you would ever print. Add this table to the query...
  4. O

    Auto Add

    richard, Enter in column "B", next to your barcode column, if it is "A"; =COUNTIF($A$2:$A$25,A2) Where $A$2:$A$25 is the range of your barcode column, it will count the number of instances of the barcode. I forgot to add, it will give the total for each instance of the barcode. jim
  5. O

    error numbers and their descriptions

    just kidding. here is a link to list them http://support.microsoft.com/?kbid=268721
  6. O

    error numbers and their descriptions

    Yes!.......
  7. O

    Displaying data on a report from more than one DB

    wj, your table description; appears to have two primary keys of the same name. Your LLdata table should have a dataID field and a separate field with the custfile set to the same format as the custfile PK tblclientdata custfile (set as PK) name date address etc. tblLLdata dataID (set as PK)...
  8. O

    Newbie (collection template needed)

    keats, if you open Access and go to "file menu," New, databases there is a "Video" database set up. It is much easier than trying to do it on your own. OR if you really want to, create your own following the way the MS one is done. ie set up the tables, querys, relationships and forms by...
  9. O

    trying to create a report but wizard creates a new form

    21, Suppose your table1 has name address city your table2 has purchases When you create a report and the relationships are set on a PK Access creates a form to use as a Sumform to display the results. The Table 1 will display on the report as a list of the three txtboxes. The sub form will...
  10. O

    Cannot calculate percentages

    sanford, Double check to be sure the fields are formatted as number and not text.
  11. O

    Excluding certain records in a report

    bluke, try 0 for false or -1 for true Do not use quotes as it is a boolean field
  12. O

    Simple Problem?

    scott, Why not create a crosstab query and leave your table alone? The resulting query will display just as a table opened in datasheet view. jim
  13. O

    how would i do this (fairly simple I think)

    tom, In a blank field of your query grid type =IIf([yourfield]="distinction",-4,IIf([yourfield]="merit",-3,IIF([yourfield]="pass",-2,IIF([yourfield]="fail",0)))) You can use this same code as the recordsource of a textbox in a form or report. jim
  14. O

    Is it possible to have a calculated field in a table?

    Buddy, I would take any advise that you get from Pat Hartman as the final word on the subject! There aren't very many Access professionals that know more than he does.
  15. O

    Query

    rorac, I sure hope this isn't homework! Seems like a very unconventional way to select senority?? If you have your query made, in a blank field in the query grid type; =right([social security number],4) or whatever the exact name of the field is. then sort ascending in the sort box. If you are...
  16. O

    Calculate Due Date On Form

    je, DON'T STORE THEM!!!! Instead (as long as your [event_date] is a datefield) in your query in a blank field type [event_date]+7 in another [event_date]+55 and on to the next for 60 and 180. That way they are "Computed" and you don't need to store them. Just pull them out of the "fieldlist"...
  17. O

    Query... a little lost

    frodo, First and foremost! Your tables must be related to each other in order for the info to be useful. "one to many" "many to one" Referential integrity... Once relationships are accomplished the tables are used in querys to supply info to forms and reports. You can use tables as the "Record...
  18. O

    Sorry for simple question

    video db Lorded, Here is a zip of the video db jim (I don't see it on the msg. I'll send it and hope it is there.)
  19. O

    Sorry for simple question

    Lorded, Have you seen the sample "Video Collection" db in Access? It does say "VideoTapes" but I'm sure, with just a little effort and tweaking, you could change the name to DVD's. Add a "Director" field to the "Video Programs" table and you should be all set. I guess I should have added: I am...
  20. O

    Inspired Data Base Design

    I'll be sure and check this thread often. I have just such a project coming up in the next week or so. The nursing director just approached me this morning about a db that could work like Excel... jim
Back
Top Bottom