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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: vree
  • Order by date
  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...
  16. vree

    Access 2000 Error help needed

    In trying to insert a subform in a main form I receive this error, "Your code contains a syntax error, or a Microsoft Access function you need isn't available." If the syntax is correct, check the Control Wizard subkey, or the th Libraries key(?can't find) in the Microsoft Access...
  17. vree

    Microsoft Access 2000

    While using Access 2000 for a couple of years now, I am still a high-end newbie, low-end intermediate user. I have a question, over at www.mvps.org/access/ they have an article about Never using Lookup Fields and why. I would like to know though, IF you don't use a lookup field, how do you...
  18. vree

    WinXP Pro/Win 98 Floppy disk error

    I have an enduser on a network who does the initial work on a WINXP pro machine, saves a Word 2000 doc, to a floppy disk to take home to work on, brings back to the office to WinXP Pro machine, and she receives this error: "No ID Address mark was found on the floppy disk." HOWEVER, if...
  19. vree

    Must Reader be uninstalled before full version is installed?

    Not only do you suspect it is the case it is. Any version before Reader 6.0 should be uninstalled before installing 6.0. A great place to stayed informed is to get on the mailing list at www.woodyswatch.com and sign up for the office watch. You will learn of problems hopefully far enough...
  20. vree

    PDFWriter Printer does not appear

    In Version 5, you must install PDF Writer, as a Custom Install, it is not installed as part of the Typical Installation process. Go thru the installation process, just like you normally would, but when you get to the type of installation screen, choose Custom Install, and clear all of the check...

Part and Inventory Search

Back
Top