Database Form Query

[mogul0212]

OH ok. so that simple change will fix it?

One day I'll grasp this foreign to me language!

Now, how badly do you want to beat me up for being such a newbie?

 

[KeithG]

You know need this extra check because the clear button assigns a zero length string to the controls.

 

[mogul0212]

What about the check boxes and the text boxes?

 

[KeithG]

You will need to add the extra condition for the text boxes and combo boxes but not the checkboxes.

 

[mogul0212]

Once I added "and len(me.[ComboName])>1 then" to the combo box Code, I get results back, but not all results. I'm assuming I need some more coding to the check box and text results, but I see a "len" statement.

Any ideas?

 

[KeithG]

You do for the two text boxes. Do the same thing as you did for the combo boxes.

 

[mogul0212]

Ok, I think I got it working ok now.

 

[KeithG]

Don't get discourage because you are a newby. You are making a pretty advanced form.

 

[mogul0212]

Well, was totally discouraged until you started helping me out. I guess I thought it was going to be much easier then it turned out to be to create what I wanted. I've come to think of Access now as a sado-masochist type of thing, and enjoy it a bit now, if that isn't scary. I mean, banging my head into my desk for some time now tring to figure all this out. But now that I'm seeing my idea working finally, I think I'm getting a kick out of getting kicked like I have been. Having a problem and finding help to solve it.

Now, that I have the knowledge you've given me. I think I can create one more form to search a Drawing search I'm creating. Identical ideas behind it like on the "Tooling" one, just for AutoCAD drawings.

Again, thanks so much for all your help. I truly appreciate it.

 

[mogul0212]

Ok, next question I have is switchboard related. I've created a switchboard with the appropriate links I want on it. In design view there are extra lines that I don't need created by the wizard, but I can't delete them without a bug issue coming up.

Any ideas?

And why can't this be edited in design view, only in the Tools/Database Utilities/Switchboard Manager

 

[KeithG]

Are you talking about extra buttons? I don't really like the switchboard function I usually make unbound forms instead of a swithcboard.

 

[mogul0212]

Well, just want an easy to use interface that people would just click on to open a particular function, i.e. add a new record, view all records, search records.

That way they don't see the tables in database window, etc.

Ultimately, would like the database file itself read only and password protected so only a few with password could make any changes but anyone can view it. Many people will be using this database, but only want 2-3 people with password to make any changes.

With having the switchboard open at start up off the database, it just makes it user friendly.

 

[mogul0212]

KeithG...

Here I thought I had learned something and could do another search form on my own with all the help you gave me.

I swear I did everything you showed me, but for some reason, when you hit the "search" button on the new form (Drawing Search), it opens the Drawing Information form, but returns every results no matter what search criteria is selected. I'm assuming the drop down box criteria aren't being used at all, but I can't for the life of me figure out why.

I've posted my newest database here if you want to take a look.

Thanks.

 

[KeithG]

You need to change the Record Source of the form to Query2.

 

[mogul0212]

You need to change the Record Source of the form to Query2.

Which form?

 

[KeithG]

Drawing Information

 

[mogul0212]

KeithG...

Oh ok, got it working. I swore it had to be simple to fix and it was. Thanks again.

So I guessing you're a database administrator, or how do you know so much about Access?

 

[KeithG]

I wish, I am an Analyst at a Mortgage company. I mainly write macros (not Access macros) and do a little database development. I hope one day to get a job being a DBA or at least where I work more with database devolpment. That is why I like this forum I get to improve my skills why also helping other people outbecause Access is what I like to work in. What do you do?

 

[mogul0212]

I wish, I am an Analyst at a Mortgage company. I mainly write macros (not Access macros) and do a little database development. Although Access is what I like to work in. What do you do?

I'm a CAD Drafter for a manufacturing company. Just started here about 2 months ago. Moved to allow my 1 1/2 year old daughter be close to both sets of grandparents.

Again, thanks for all your help. Hope I wasn't too bothersome.

 

[KeithG]

No problem, your boss should be happy with the finished project because you are putting togther some pretty advanced forms.