Search results for query: *

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

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

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

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

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

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