Search results for query: *

A rowsource sql statement

I have a list box that displays the results of a query. Now this is a simple problem. When I look at the form there is a solid black line directly to the left of the text displayed in the list box. If I expand the list box enough then there is another solid black line the right of the text. No...

I have a form with a bunch of combo boxes and a few text boxes. When the form opens all but one of the boxes are disabled and I use the afterUpdate to enable the next box for all of them. I want a button that resets the form the its original condition where there is no data selected for the...

Cool, thank you! I just have one question. What is the + 5 for right after the WHERE ?

I guess it will be feeding a report. I have not made it yet. It is going to be a bunch of mailing labels.

As of now, yes there is a reason why I need to print the form.

I am having a problem with printing some forms. When I go to print them it just prints out the query, I mean it says the name of the query then prints all the rows not just the record that I was looking at on the form. Is there some value that I can change on the form to make it print the actual...

I am working on a form that has 2 combo boxes. The first in the first box the user selects a field from a table and then the second box the user selects one of the values in the field. I need to write a query to get the results of what the user selected. I have something like this: SELECT...

I am working on a form that has 2 combo boxes. The first in the first box the user selects a field from a table and then the second box the user selects one of the values in the field. I need to write a query to get the results of what the user selected. I have something like this: SELECT...

Okay great it is working now. I just want to know one more thing.... How can I get the JOB_DESC not the Job Description using VB code. Because if I do like Me!cmbox1 then it now returns "Job Description" instead of JOB_DESC... how can I get it back?

Thanks for all the replies. I just have one more question. The first combo box selects a field from a table the second combo box has all the values from that field. I just am wondering how I can write my query to make sure there are no duplicate values in the second combo box. Thanks - Lenni

SO I have my query like so: SELECT Attendee.Category, Attendee.JOB_DESC, Attendee.PROF_DESC FROM Attendee ORDER BY Attendee.Category; and to get it to display I would write Job Description:Attendee.JOB_DESC or like Attendee.Job Description:JOB_DESC because I have tried a lot of combinations...

This is probably an easy question but I am writing a query to get the field names from a table for a combo box. I know how to do this. The question I have is I don't want to use the exact names that are in the table. Example - in my table a field is called "JOB_DESC" I want it to say "Job...

Okay thanks. I understand the enable part just fine. But could someone explain in a little more detail how to do the querry part? Thanks.

I neeed to make a form with 2 combo boxes. Ex. cb1 cb2 I want the 2nd combo box to be disabled until someone makes a selection in the first combo box. Then, after they make a selection I need the second combo box to become enabled and have selections based on what was selected in the first...

I have read so many different things. I even have an Access 2000 book which goes into how to set up the user/group - level security. I have followed the steps in depth but still getting the same problems. I think I need to somehow change the permissions on the modules in my database but I do not...

Hi, I am having some issues while setting up the user level security in access 2000. I have ran the user level security wizard and it worked amazingly well but on all my forms where I module object it says "invalid username or password" and I click end and it opens the form. But it works fine...

Where would I put that? In a module in my database?

Hi, I am developing a database for an organization and they recently requested me to implement a user level security system. I have run the User Level Security wizard and I set up the different groups and created usernames and passwords for the diffent group users. When I enter an invalid...

Hi, I am developing a database for an organization and they recently requested me to implement a user level security system. I have run the User Level Security wizard and I set up the different groups and created usernames and passwords for the diffent group users. When I enter an invalid...