Search results

I'll give that a shot.

Thanks for the advice. The data I'm working with is very basic, no calculations involved. I'll look into the information you guys provided me with. I don't think memory is the issue, but hey, you never know.

Great! Thats exactly what I was trying to accomplish. It works fine in the sample database that you sent to me, however when I import it to the main database that I have, I get the following error when trying to open it. "Invalid Procedure call or argument" and directs me to the form load...

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

That is what I have done. But my main concern is ease of use. The problem I am having is that my company has ove 100 different customers and each customer could have anywhere from 1-5 systems for example. So, worst case scenario, for my secretary to select a specific system to input data to...

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

Thanks for the help. Thats about as far as I was getting before. My problem is that I don't how to make the combo boxes replace the function of those two Record traversal tools at the bottom of the form.

Ok, try out the attachment. the form I'm working with is called "Add Service Visit" Its simply used to add the data from a service visit to a specific location for a specific system present at that location.

What I'm trying to do is input data from the user. The form looks something like the following: --------------------------------------------------- ___________________________________________ ADDRESS: XXXXXXX SYSTEM: YYYYYYY ________________________________________ DATA...

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

Bump......

Table Service Records: Date, Data, Data Data, COM1, COM2, COM3, etc... Table Comments: CommentNum, Comment I query the Table Service Records for several different records, then I order them according to date and query the top result (most recent date) for COM1, COM2, COM3, etc. Each of the...

That seems to work nicely, thanks for the help. One question. When I want to delete a record, I use the same idea of a form with no data entry and allow deletions, however when I delete all the data fields, the record is not delete, it is just erased, is there a way to have the record be...

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'm not sure I could effectively do that and make the data useful. The comments table is a list of predefined "responses." I want my service technition to simply add for example, a "1", and a "2" to the record for his current service visit and have the corresponding comment associated with...

The original idea was to only pass the indexes I need to the report and have the report simply access that table with the corresponding comments in an effort to reduce the amount of info in the query.

Well, it seems that I have run out of fields in my query so I'm stuck in a way until I can figure out how to get more data in there.

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

Problem solved.

Right now the query simply retrieves all results that match the system specified. I would like to keep it that way so I can use it for system review as well as data to put in a report. How do I use the TOP operator to specify I only want X number of results? Is it possible to do this TOP...