Search results

Dlookup Hi thanks for your help first of all The item number does reside in both of the tables the actual Item # so to speak is a yarn number and each 'style' can use up-to 13 of these yarn numbers in an individual style... The reason for a Yarns Table and a Style Table. For example 8783-61...

Dlookup I understand what you are saying, however I need the description to show up immediately after they enter the item description, the item description is in a table called yarns, the item # is in a table called styles. The form I am referring to is using the records source of stlyes. Is...

I have a form that has lets just say an item number description, in another hidden field I have a Dlookup to lookup in a seperate table the description for this item number (for reference purposes only), on exit of the field I run a refresh to update the Dlookup, is there some easier way to do...

I have an Access table with 220 fields in a table, there are others invloved but this is the biggie. The problem I am having is that new records added mto the database are getting corrupted (all kinds of strange fonts and the like). I am beginning to suspect that when another user is in the...

WOw this is an ugly one I have an Access 2000 database that has been created on my server, the table has approxiametly 235 fields (if not mistaken access limit is 255). If I add records to the databse on Windows 2000 PC, running Office 2000 No Problem. When I enter records from a Windows...

Thanks alot for your time, this is the greatest Access forum I have ever run across. In all the classes I have attended on Access no one has ever mentioned this little solution Thanks Again :cool:

I am wondering if there is a way to avoid entering a record if 2 fields are the same rather than one. ie Item Number (can contain no duplicate) Description can contain duplicates but not 2 with the same item #. This may seem rather elementary, but I can't seem to come up with a way to avoid...

Thanks for your help this seems to have worked, although it occasionally crashes the macro due to the database still being open. And if I try to close the current Db, it doesn't close early enough for the macro. Oh Weel, Thanks Again Dave Thomas

I posted this in Macros and here, please forgive me, I wasn't quite sure which one would be best. I am looking for a way to open a specific Excel workbook, over a network connection from a button click in Access. The problem being on top of not figuring out how to open the path file is, the...

I am looking for a way to open a specific Excel workbook, over a network connection from a button click in Access. The problem being on top of not figuring out how to open the path file is, the Excel workbook imports the data from the access database that the button will reside in, so at some...