Search results

Actually I am using an BeforeUpdate line. Do you think that may be the problem? I will wait to hear before I change it or set a breakpoint.

Thank RV for your response. Here is the SQL statement envolved. SELECT tblClientData.ClientID, tblClientData.* FROM tblClientData WHERE (((tblClientData.ClientID)=[Forms]![frmHospitalSearch]![List54])) WITH OWNERACCESS OPTION;

I have written a simple query with one table that does not work. The first column is an asterisk and the second is the primary key of that table, using an expression referring to a pick list out of a form. When I am in the query design window and run the query it works. When I go to the pick...

Thank you Pat. That does make sense to me. I am going to get on my client's network, which is another city, this weekend and do just as you wrote. I do not know exactly what the new or different additions were/is but I suspect some Office 2000 or Windows Update that I did a few weeks ago. I will...

I am not sure what happens when macros are converted to modules. I can see in the Modules window that new modules are created. Does the program then "read" these instead of the macro? Can I delete the macros from the macro window, and reduce the size of the program? And what am I not realizing...

OK Pat, on this reference issue, I just received information from my client that the computers on which the aforementioned problem occur are not running Windows 2000, the OS that is on the data server. Could this be a problem when running apps written in Access 2000? And yet another problem...

How do I know what the missing reference is? I see the first four in the list that are checked, but I do not know which one is the one in question.

I have developed a front and back end program for a client with a 10 computer network. The front end is well proven to work. One routine, to select one record from a pick list, click and run a macro that opens a form with a query filter, now does not work on one of the networks computers, and...

I have a client with a ten computer network running Win 2000. A tried and true program, identical copy on each work station, data on separate server. On one of two of the computers, one of the macros does not work. It calls up just one selected record to be returned in a form, that is the same...

I have done a little research, and to rephrase the problem, it would go like this. I have data on individuals in several tables. The main table contains their demographics and other static data. In other tables are their ID Codes and other attributes. I have a main data input screen with...

I am trying to show a group of people using a form with several subforms. I have written a query with say five fields as a filter. When I run the query, it works, but when I run the macro that calls for the form to be used with the query, I get a ??Certain field code??. When I type in the...

Thank you DBL. That is exactly what I needed to do.

I have an existing table with two fields, ID and Modality. This table has 13 records and is static data. I want to rearrange the order in which the 13 records are, keeping the same ID with the Modality. Neither field has an index. Access seems to want to either sort by ID, which is a Long...

How do I open a linked table with the OpenRecordset method? In Access 2000 the help files suggest creating an empty table, linking it to frontend, then opening it using the OpenRecordset method thereby eliminating the necessity of Jet engine to open and close database repeatedly (recreating...

I have a client that runs MSOffice 2000 on Windows 2000. I have written apps for him that access data tables on a server from separate work stations. The data is so large now that retrieval is slow. In Access help files, it suggests that I create an empty table in data, link that table from db...