Recent content by vree

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...

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...

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

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...

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...

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...

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...

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

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...

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...

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...

LOL well can't spell today! Feynman Lives!

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

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

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...