Search results

Serial Imports is the Key I am going to answer my own question by reporting a work-around that I found; maybe someone will get some use from it or can explain to me why I have this problem and why this works. OK, here is the background. I have a database that I created in MS Access 97...

Well, I'm stumped. I have been working on pulling an existing database from ACC97 into ACC2K. Everything seems to work alright until I get to the forms. I established a Developers group and a SuperUser account and closed down the Admin on the new database and opened up the permissions on the...

RE: Security 97 to 2K Thanks for both comments. I change permissions on the old database and that helped some but I clearly have additional problems outside the security realm that I need to resolve in order to proceed. With regard to the Security FAQ, I had previously worked through Jack...

I have created this spiffy db in Access 97 and must now move it into Access 2000. When I try to import it, I get an error message that says I do not have privileges to import, link, or do anything else to the tables. I created the db! Why can't I import it?

I am trying to write my first user-defined function and, of course, things are not going well. The function I wrote is: Public Function BinData(dValue As Double) As String If (dValue > 0) And _ (dValue < 1) Then BinData = "Group 1" Else If (dValue > 1) And _ (dValue < 2)...

Pat, I do not have it all worked out yet but your suggestion is clearly the way to go. I cannot thank you ehough for all the help you have given me over the last few months. You have provided wonderful insights to what can be done with this tool. If I undertand your idea, once I have the...

Len, Thanks for responding. So the procedure is to use a series of queries to pick out the information I need. I feared as much. I was hoping for a function or group of functions that might do some of this for me in a few queries. Looks like I better get started writing queries. Thanks. Steven

I have a data set that contains plant operational data and I would like to make a histogram of it. Initially, I made a query based on that field, gave maximum and minimum values for the interval of interest and let the query return the count of the number of values in that interval. This...

I tried your suggestion early on and could not get it to work (at least in my hands). My original surmise was correct: I was making a simple problem far too difficult. I did find a solution that worked and it is dirt simple: 1. Create a new query based on the table in question; 2. Add a new...

I am having trouble doing a data type conversion. I have a legacy table that contains numeric data in text format and I wish to convert it back to numeric. I looked through some of the examples in here but cannot get them to work. The approach I would like to use is to add a new column to my...

I have been developing a power plant database and want to give the user two entry routes. One route lets the user select a power plant from a list on a form and then loads a tab control with all the information about that plant in various categories. Selecting different tabs presents different...

Pat, I was redirected to other work (my fame as an Access jock is spreading slowly) but now I am back. I spent most of yesterday working on your scheme for using the combo box in a form to slect specific records. For the most part, I think it went quite well. The information I want to present...

Jon K, Thanks for your advice. It worked as soon as I dentified the right fields. Slowly, I learn. Steven Ross

This ought to be really simple but I must be having a mental block. I want to run a query on a table with a field containing letter codes and I wish to count a only one of the various codes possible. It seems to me that I should be to set up the query using SQL aggregate functions (COUNT) and...

Pat, Thank you for your response. I have had to be away to handle other issues for a couple of days but now have returned. I'll try your approach although I have not work with either subforms or subreports (yet another opportunity to learn something new). Thanks, again. Steven...

I have been developing a database containing power plant information and I want to be able to retrieve information in two ways. The first is by information category such as plant administration, plant description, plant fuel inventory, and so on. This information is presented in several forms...

Thanks for the additional advice. I shall have to spend some time sorting out everything but you have given me a good starting place and direction. Thanks. Steven

Thanks for the advice. I am beginning to undestand this a bit better thanks to your comments but I am not sure what a junction table is. I expect I can figure that out. I how I can reserve the right to ask further questions. Steven

I have a question on multiple relationships and my search did not turn up anything connected to my issue. I have two tables, tblPlants and tblOwners. In this case the plants are nuclear power plants: big, complex, and very expensive. As a result, each plant has several owners. Worse yet...

Thanks for the explanination. I have always understood that queries were a major tool for relational databases but most of what I have done was to load data into a table and call it back in a form. It is only now that I am starting to add more complexity in my thinking and design of data...