Search results

thanks but I think I realized it's 2000 I tried what you said and it said query too complex and it made me remember that I had called Microsoft in past and they said that 2000 would not hold as complex queries as 97 so there lies the root of my problem. I just wonder if new versions are equal...

Need help on this one. We have Access97 and Access2000 and here is the problem. 1. We are trying to import a form from a database in 97 to 2000 and it says that the underlying code is corrupt and therefore won't let us import. 2. However, we use the 97 database program everyday and it works...

Okay, thanks--nobody told me that till you. appreciate that. smwabill.:)

Thank you all for your suggestions. But trying not to be redundant, I will try to re-explain what it is I am trying to achieve, because--perhaps, I have not made myself clear enough. I already have a table with a combo box lookup and if I key on the first few letters of the workers name it...

macro for default value Thanks for your idea, but perhaps you overlooked my text that said I was working in a query. But I will consider your idea if I can't program some macro keys to insert a default value while working in a query or datasheet Thank you. smwabill:)

default value macro Actually that is the way I have it right now--workers name with a combo box. I am working in a query where I am doing a batch of receipts with the same name and do not want to select their name each time I put in a new record. The workers name changes with each batch and...

How do you make a macro in Access 2000 to set a default value in a table field example: Table field=worker I want default value for worker to be 1 of 8 names shft-F1 would set worker field to "John Smith" shft F2 would set worker field to "Sally Smith" etc.. Thank you--hope I haven't over...

Still does not work comes up with compile error and rscat as variant comes up hightlighted and says user-defined type not defined maybe I'm overlooking something but your coding seems straight forward. Both solutions have same error? any more suggestions? smwabill

joining combo boxes to jfgambit: the solution you gave me does not seem to work. Dim rsCat as Varient rsCat = DLookup("[CatagoryFieldName]", "VendorTable Name", "[VendorFieldName] = '" & Me.VendorTextBoxName & "'") me.CatagoryTextBoxName = rsCat perhaps if I give you the exact names you...

Let say I have a form called Petty Cash Entry which ties back to Petty Cash Query which ties back to Petty Cash Table. This form has two fields. Field 1 is called Vendor and Field 2 is called Category. Both fields are a look up from the table back to Vendors table. What I want to be able to do...