Search results

I feel like I'm misunderstanding something basic here. I have a report that lists systems for my desired customer in the detail. I leave some blank space next to the system name so that my techs who are out in the field have room to write in data by hand for their service. next to the blank...

I'm trying to build a form based on a query to use for data editing/entry purposes. The only way I can think of to do this is to use a query to get data that is particular to my specified customer. The first problem I have run into is that one query does not contain enough fields to retreive...

In order to find the most recent piece of data for a particular customer I need to query my table in 3 iterations. I have a TABLE with data in it pertaining to all customers. QUERY 1 orders all the records in TABLE by date. QUERY 2 plucks all records related to specified customer from QUERY...

I have a table that contains records with 25 fields. Each record represents a list of locations. These lists of locations represent a route for a service technician. I want to be able to press 1 button, and print a separate report for each field in the record so that the service tech has an...

I created a database a while back. It was complete to my standards at the time. I split it FE and BE to protect the data. Since then, I have made several changes on my machine to the user interface and some of the back end tables and queries. How do I insure that these changes are seen on...

I have 2 tables, one has a list of comments indexed by numbers. The second table will be populated with numbers that correspond to the first table based on usage of the form that I'm about to describe. The form contains several check boxes. Each corresponds to a comment from the first table...

The database displays/prints service reports which include numerical data and comments about the quality of my customers water. Right now, the comments are input by the secretary based on a predefined list (she just enters the numerical values that correspond to a specific comment and the...

I have several pdf files I want to have on my website that should only be available to my customers. Is there a way to password protect them from being downloaded by just anyone?

I created the database on my computer. I added security and split the database to put the tables on the the server. Everything works just fine on my computer. However, when I try to copy the 3 files for the front end of the database to other computers on the network, it won't work. Perhaps...

I setup my security (or lack there of, hehe) and split the database. I relinked the tables. Now, Access gets hung up when I try to create an MDE of the FE to distribute. It starts the process, asking me to select a folder and file name, I do that, and it gets no further in the process...

I have a nice report that I have developed as I learned how to use access 2003. I'm finding that in the working environment of the project, I need to be able to add some custom comments in the form of text to the report just before I print it out. The report is based on a table. Is there a...

I have access 2003 installed on two different machines. One machine was built 6 months ago with the best hardware available. The other was an older slow IBM. For some reason, I am experiencing what appears to be some serious time delay (talking in the range of seconds, sometimes tens of...

I have built an example of a form that I am working on. My original design used the default record navigator bars that are setup when you use the wizard to create the form. I would like to remove those bars and use the linked combo boxes that I have placed onto the form instead. My end all...

I have a few forms in my database that I used the wizard to design. They work as intended however the default control that access uses is horrible. Is there a way to modify the control of these forms without building them from scratch? I'm afraid I wouldn't be able to build it from scratch...

I have a table of information. I have created a form to input all the data necessary in order to add a record to the table. The form is not currently based off of the table and is simply a bunch of text boxes with labels. The reason why I didn't create the form based off the table is because...

I have a report based on a query. The query contains a few fields that store integer numbers. Each field contains one number. I also have a table of comments which are indexed by integer values. I'd like to access the data in that table according to what numbers show up in my query results...

I'm trying to build a table structure for this database. Heres some background information about the business: The business is a service business. We visit the customer's location and run tests on whatever water systems they have. Each customer is unique in that they could have any...