Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by vree

  1. vree

    Crystal Reports 8 and GL question

    Now now no quarreling..LOL thanks you all. Thanks FVTraniner, I took home the PT DDF list to try to locate the fields I would need to accomplish the task. Since you dont know the PT accounting system, it may be a bit hard to explain, but the grouping levels are going to be the problem. PT has...
  2. vree

    Crystal Reports 8 and GL question

    Using Peachtree 2003 Complete and Crystal Reports 8 (I dont know if I am chasing my tail.) Please tell me if this is possible... In Peachtree we bill for services that are distributed to multiple GL's. The PT Invoice, prints each GL amount as an individual line item, which causes confusion with...
  3. vree

    NotInList question

    IF you look at this thread, at the very bottom I posted the code to do what it is I believe you are looking for: thread700-662265 vree www.groundworkssoftware.com "For a succesful technology, reality must take precedence over public relations, for nature will not be fooled." R.Feynman
  4. vree

    Need a basic Employee Time Card Management db

    You might take a look at the Time and Billing Database Template in Access 2000. It might be a good place to start, and may help you decide which items you want to track or not use. vree www.groundworkssoftware.com "For a succesful technology, reality must take precedence over public...
  5. vree

    Complex Table relationship question.

    If the relationship between company and address is "zero or one to many" (i.e. a company may have zero or more addresses) then you need a "CompanyAddress" table like TABLE COMPADDR lngOrgId (PK) lngAddressID (PK) I have this in OrgAddress table. The...
  6. vree

    Complex Table relationship question.

    For anyone else out there, who may not have a weekend life. I am trying to redesign a db, and improve the design, and am at a impasse. Need fresh ideas. I have table Companies, a table of all available Companies tblOrg lngOrgId OrgName I have Addresses, a table of all available addresses...
  7. vree

    Microsoft Access 2000

    First I needed to handle how to tell the user to double click an address field to add a new address: Option Compare Database 'Instruction on how to add new data. Private Sub Combo10_NotInList(NewData As String, Response As Integer) MsgBox "Double-click this field to add an entry to...
  8. vree

    Microsoft Access 2000

    Thanks will try. vree www.groundworkssoftware.com "For a succesful technology, reality must take precedence over public relations, for nature will not be fooled." R.Feynman
  9. vree

    Microsoft Access 2000

    OK! So far so good, but one error to clear up. Using the above tbl structure: frmOrgAddresses lngORGADDRESSID lngORGID OrgAddressType I put this code in the DblClickEvent of the lngOrgAddressID field: Private Sub Combo10_DblClick(Cancel As Integer) On Error GoTo Err_AddressID_DblClick Dim...
  10. vree

    Microsoft Access 2000

    Ok guys, here's the problem, in adopting my new "religion" NO Lookup fields, here's the deal. tblOrganizations tblAddresses tblPeople tblOrgAddresses lkuptblOrgAddressType lkuptblOrganizationType In my original db, i had a lookup field in tblOrgAddresses, to lookup the correct...
  11. vree

    Access 2000 Error help needed

    Hi Jim Yes to all of your suggestions! Have tried them all, (used to work in tech support, am ok at troubleshooting.) It did occur in new db. Have tried compact and repair. Have tried Office Repair. Have tried multiple db's on another pc, everything is fine. Also, is it against the rules to ask...
  12. vree

    Microsoft Access 2000

    LOL well can't spell today! Feynman Lives!
  13. vree

    Microsoft Access 2000

    Thank you all for you input, and kind words! Oh and by the way, Feynaman Lives! vree
  14. vree

    Database Creation

    A simple place to start in the Access Template, they have a decent Events Management Database that I have customized numerous times to run events. V www.groundworkssoftware.com
  15. vree

    Importing date field from Access into Word

    I believe sando is suggesting that at the table level, your field is of Date/Time type. Is that correct? IF so, the suggestion is that you change the field type to text. I believe in a mail merge, Word imports text "As is". However, if you choose not to change your field type in...
See more

Part and Inventory Search

Back
Top