Search results

Hello. I've created a database of my company's suppliers (~400-500 entries). It has a continuous form (SupplierList) to search through the list of suppliers, along with search tools (keywords, categories, etc.). Originally, I worked off a flat table from Excel with suppliers in the format, Name...

Hi. I'm trying to write a generic function that can take in a table of any size and Trim and remove all carriage returns and line feeds from everything. The thing is while I know how to loop through every record and edit a specific record, I haven't done every field in every record before. Right...

I've built an Access 2007 application that lists our company's suppliers and creates purchase orders. In this application, I want to allow different users access to different things. Some of the things that I want to control access to include: adding suppliers deleting suppliers, editing...

Hello, So I'm working on an Access 2007 application for my company's suppliers list, but I am restricted to using a single Excel worksheet for the back-end. One of the fields, called [Files], is a list of files in .pdf format related to a supplier. The number of files can be 0, 1 or many. I...

Hello, I'm currently working on a small database for my company containing a list of suppliers/services and their information. One of the information fields is a distance field, which allows people in the company to search for approved suppliers/services within a certain distance from the...

Hi there. I'm a new member to Access World, although I've already gotten a lot of help in the past from reading posts here. Rather than a programmer, I'm actually a mechanical engineer just out of school, currently designing plastic molded parts for an automotive supplier. I do get asked to...