Search results

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

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

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

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