Search results

Neil, Wow. You went through a lot. Thanks. I read through your explanation and believe I have gotten the essence of it. qryPlant makes the link-up between the site name and the plant number and assigns that value to the variable UniqueNo. qrySite is used to order the list. This leads me to...

Thanks for your response. I fully agree with your assessment that I need to 'raise my game,' as you put it. At the moment, this is a clandestine project so I will not get any money or approval for training. What I ended up doing was writing a make table query that concatenated the text and...

======= Thanks for responding. I guess I am not too certain regarding using key fields and their benefits. You surmise that I am working at the table level and that is true. I chose to work there becuase I will need to use the coupled fields as the source for several other secondary tables.

I looked through the history of the Tables forum and could not find anything on this topic. I am either not asking the question correctly or just too ignorant to really understand what I am doing (hmmm … no surprise there). I would like to couple two fields of a table together so that when I...

Pat, Thanks for the tip. I downloaded the Security FAQ page per your suggestion and will start going over it. There is a lot there. I seldom use the Microsoft webpages, mostly because their reputation in this office is not good (I am guilty of allowing others to set my opinions - I should...

Thanks for the advice. I clearly have much to learn. I hope no one is in a hurry. Steven L. Ross

WOW! This is considerably more than I expected. A more detailed decription of my project is in order. I and my coworkers consult to a U.S. Government agency. We need to have quick access to wide variety of information regarding about 80 sites around the country but for each site, the...

I beleive the time has come for me to invoke some level of security on my database and am looking for ideas. However, as I look through the various forums, I do not see one for that topic. Am I just too dense to see the obvious or has some paranoid DB manager put the security forum in a...

GH Thanks for the suggestion. Unfortunately, I seldom have the luxury of investigatory time. I sneak it when I can though. I would like to reiterate Rich's question: you seem to advise against using the switchboard wizard. Why? Too limiting? Full of air in DC

Thanks for your note. I am guilty of not looking through the options thoroughly enough. However, I note that the list of properties under the format tab changes when one item or a group of items is selected. Most confusing. I wish Microsoft would stop protecting me from myself. Inhaling and...

Wow! More capability here than I ever imagined. For starters I would just like to change the fonts to improve the readability of the text. Thanks. Breathing Easier in DC

I thought that's what those funny thingies with the text nad the push buttons were called. Terminology aside, how do I manipulate the fonts on the switchboard? Breathless in DC

I am creating a really spiffy switchboard for my application and I do mean spiffy. I would like to modify the font of the text in the command box but cannot find a way to do it. The MA Access helps (I always go there first) have not been too helpful on this one. Any suggestions? Steven Ross

=============== Dave, Thanks for the tip. I'll give it a try. Steven Ross Old fisherman never die, they just small that way.

===== OK. That sounds reasonable and like it would be a lot fewer headaches. This revelation brings me to the subject of writing scripts. I haven't the foggiest notion of where to begin and any advice would be helpful. (See what happens when you try to be a good guy?) Breathless in DC...

I have created an early version of an Access application and it is time to test the sucker. I would like this application to be loaded onto a CD to make the software portable (Well, if I can't make a simple joke, what good am I?). The idea is to have be able to make changes and updates to the...

Editing Relationships 2 Pat, Thanks for your response. I looked at the foreign keys and, interestingly, there were fields listed that I did not assign. I deleted those entries. I did not find any foreign keys with the value 0. Even though I cleared these spurious foreign keys, the problem...

I am having a problem linking two tables so that the first provides a drop-down pick list for the second. The first table is a list of names that I use multiple times in each record in the second table. I was able to make the connections using the look-up wizard and edit the relationship to...

One other observation: the form is derived from a table. In table view, the OLE opens as desired when double clicked. That is the behavior I want when in form view. Thanks.

Thanks for your suggestion but, of course, I could not make it work. What I get is a small window with the horizontal and vertical ruler bars and a little bit of text, the upper left corner of the paragraph. The curious thing is that, initially, the application worked as desired and I would...