Search results

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

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

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