Search results

Cogent1. I have tried getting the query data right but I am working with somebody elses database and haven't got the time or resources to redesign the tables. This is only a quick fix to address a particular need. To get the same data i needed to run 7 seperate queries which were all dependent...

I have a form which has been based on a table. I want the table to be created when I open a form and then I want to be able to delete the table programmatically at some point during an access session. The why's and wherefores of this are that I cannot get the data I want from a query. I've...

:confused: I have a Access97 database running in a NT4 environment which is secured by workgroup permissions (not my idea it is company policy). I have in the past been able to email the database to another site (who use Access2000) and they have been able to open it with no problems. This...

Gee Thanks maybe when I get back to work in a couple of weeks time I'll try the query route again. Thanks for the answer though.

A good question, I tried to get the query to work with the combo box but however I tried I couldn't, so some bright spark at work said why don't you create a temporary table, so I did. I suppose had i perservered with the query I wouldn't have to have posted this question would I. However...

I have built a database around a main form from which all other things are accessed. On the form there are some command buttons for reports etc, and some combo boxes used to find records quickly within the database. This form is called up at the database start up. However to run on of the...

I ahve created a sub form with 3 combo boxes to look for various data in some tables. They are only used to search and not update or edit. However, when I tested main form with the subform embodied none of the combo boxes on the subform work. However if I open the subform independently...

Thanks for the reply It does just what it says.

Is it possible to change the colour of buttons on a form if so how TIA.

David, I've created the popup form because I hate using ctrl F its two many key strokes or clicks and just looks naff. I'd prefer to do it with the combo boxes. Ive created the combo boxes but all I want is the info in the combo box I didn't use to select the data to keep track with the combo...

an example of what I want to do. I have an internal phone book table which comprises three pieces of data. Surname, Post Title and Phone number. I want to be able to find the phone number by using a dropdown list on either surname or post title. However if I use the drop down on post title I...

Does anyone know which is the quickest method of querying data. 1. Creating a query and then running that query using a do.cmd call. or 2. Actually writing the query code within a procedure.

I may not have explained myself very well. The two combo boxes are based on fields which have unique values. The value selected in combobox A will only have one record in the table. What I actually want to happen is that when I select the value in Combobox A the value shown in combobox B...

I want to put two combo boxes on a form which are linked to different fields in the same table so that you can filter the table. What I actually want to achieve is that if I select an item in combo box A then combo box B displays the correct corresponding data from the table, and if I then...

Its not the actual query part I have a real problem with, its how to select the criteria data itself ie the scrolling through 500 part numbers. Each part number is 14 characters long and not all are consecutive.

I have a requirement to produce a query, where a user needs to select from 1 to 500 (and any combination in between) products from a table of 500 part numbers. I want to use the selected part number(s) as the criteria for a query. I have tried using a multi-select list box and using the In()...

I have a VBA procedure which is run using the onclick from a button on a form. When the procedure runs it makes all the open forms invisible and then runs a query, the query takes info from hidden text boxes on various forms. After the query has run the procedure closes all the forms. The...

Does the above work in access97. I only ask the question because I use 2000 at home and 97 at work, and i'm not at work until next week and want to try it out before then.

I need to be able to delete the relationship between two tables. Delete a table, which is then recreated by a query and then re-create the same relationship. Anyone got any ideas.

I'm actually using access 97 and have seen the equivelant article. I have tried to use this method but cannot work out how to replace the typed in criteria with the criteria help in my string variable. I thought I had got it sorted but after leaving the query running for 1 hour nothing had...