Search results for query: *

You are preaching to the choir. I am not the admin for this particular database and I am trying to work within the confines that I can get away with. It is a classic problem in a lot of companies, if something is working nobody wants to fix it. This particular log really is not being used to...

I thought I would give you a star because if I had a little more flexibility, you have given me several different solutions. Thank you, Jonathan

Very cool, but I can not use VB within a table, can I? It would have to be on a form, right? Thanks, Jonathan

No, it is a quote log that was set up as a table. Again, another great thought. It would be easy to use VB to apply logical arguments to a textbox. Thanks, Jonathan

Yes, unfortunately the user can make up a new value out of the whole cloth. I did not originally design the database and it is far from normalized. I am trying to quietly manipulate this entry without trigering an act of congress, meetings, etc, to streamline the input. A table would require...

It's an good thought, but there are too many and there are circumstances that a note is required. It would be perfect if I could just prohibit that one value. Kind of like a NOT logical statment. I'm thinking that it may be that as simple as it sounds, there may not be a way to do what I am...

I want to prohibit ###-## (Ex: 123-10), but I want to allow all other values. Is this possible? The problem I am having is that users frequently enter ###-## (Ex: 123-10)when the correct format is ##-### (Ex: 10-123), or a number of other codes that we have set up. There is no consistancy to...

OK, too long winded. I will try to better develop my question and re-post it. Thanks

I am starting a new database. The fields are as follows. I have 3 products, which come from 3 different vendors, in 3 different sizes, and in 3 different colors. The size dictates other values such as shipping wieght so I would like to have a table that only has a size and a shipping weight...

Thank you, great advice. I figured out my problem with your help. I was trying similar things, but I need to also include "or is null" because is was not coming up with records with null values. Thank you.

How do I run a query where I do not want records where one fied is equal another field? Thank you

Like '*3"*' That's the one. Thank you very much to both of you. JO

Jim, That works a little. It pull up an entry that starts with " I can not get it to pick up anything else though. Like 3" or 10"x3"x6" Any ideas? I tried expanding on you suggestion, but I am just creating errors. I think you are on the right track though. Thanks, JO

Yes I know, I spelled query wrong in my question. Sorry.

How do I enter the criteria for the a singal quotation mark with a wild card before and after. For example. My data set may be: steel 3" flange steel 4" flange steel 300 pound flange I want my query to return anything with the 3" in it. So if designed properly the query would only return...

Thank you to all for responses! I am glad I asked as I was thinking that a stand alone application could be developed using access. That leads me to another question that maybe should be asked under a visual basic thread. Can a standalone database application be developed using just SQL and...

PHV, I will also look into the free Access RunTime package. I was unaware of that. Thanks

Thank you Steve, Your suggestions are a good start. I will look into MDE. If anyone wants to expand on this or has any other suggestions, I look forward to your remarks. Thanks, Jonathan

Once an application is developed using Access, is there a way to package it for distribution, so that it can be used on computers without Microsoft Access? Perhaps an .exe file? Thank you