Fspinelli
Last Activity: Mar 7 '11, 07:56 PM
Joined: Aug 25 '10
Location: White Plains, NY (USA)
-
Thank you.
I tried to offer as much detail so that it was understood.
Simply looking for suggestions (like if I should separate The Company from it's Contacts and relating them to the company and call log). Not looking for someone to design it.
Perhaps I need to learn more about relationships in tables. I must be doing something very wrong with relationships if my queries can't pull data properly....Leave a comment:
-
Fspinelli started a topic What is the best way to create a contacts database which will have queries?in AccessWhat is the best way to create a contacts database which will have queries?
Hi,
I was given two huge excel sheets; one is of Companies (which includes types and contacts), the other is of Consultants. There are about three thousand company records. A few hundred of the consultants.
I need to create a database with forms for easy end-user entry or viewing. I also have to create a form which allows the user to choose query parameters (if possible)...els e I'll just give them boxes and a button... -
What is an Ambiguous Outer Join?
Hi All!
I have just received thousands of records which were supplied to me all on one excel sheet.
So I imported the entire spreadsheet into one table of Access and added an ID field set on Auto-number to give each record an ID number. The table has company name, address, some other info about the company, who the contact is (might be more than one), and what type of company they are (to us and could be more than one).... -
Same version. Uhg.
Yes, the record ID (recID) is the primary key. I'm not familiar with passing filter strings. What does that mean?
Thank you TheSmileyOne!Leave a comment:
-
Why reports won't print out fully in Access for end users?
I am having a problem getting a report to print out completely.
I have a report that has half a page with client data and half with lines on it so the end user can write on it. We call it a "call sheet". Only problem is when an end user prints the report only the top half of the report prints.
If I go in, open up a record, and print the "call sheet" I get everything. When other end users (two so far) do...Last edited by Fspinelli; Feb 1 '11, 09:36 PM. Reason: had another question along with this one...related -
Thank you very much, beacon!
I'll give it a try!Leave a comment:
-
Here's a screen pic of my form.
p.s. I've added a subform (where the results should show up). Hence, why I have not mentioned it...
Thank you for all of your efforts!...Leave a comment:
-
Beacon - found it!!
attached is a sample of my query. There are 16 "status" options but I just put three down. At least you catch my drift (i hope.)
Thank you Thank you Thank you!!...Leave a comment:
-
Yea, I tried that code you gave me and I still get those input boxes. Perhaps I have things in the wrong area of the query? In the query I have the 16 options but also, next to them unchecked rows with that code in it.
Example:
BD is from contact_types. cb1 is the name of the radio button for BD on the form. BD shows in my query and checked so we can see it. Next to it is a colum but with this code:
(IIf([forms]![Query_Window]![cb1],[BD]=True,True))...Leave a comment:
-
your attachment is exactly what it looks like! every single control on the form wants me to do something like that! lol...
I am missing a big thing in my code, I'm sure!Leave a comment:
-
no, it's not a query prompting for an end user to enter anything.
This is a form where they can make choices and run the query. The choices are radio buttons (16 of them). One or many could be ticked. Also on that form is a text box in case they want to query companies that have certain letters in them. Then there are also combo boxes. The combo boxes would be state, country and priority.
If the end user ticked...Leave a comment:
-
Query not working
Hi and Happy New Year!
I have a QBF and a big challenge. I can't seem to get it to work...
I have two tables:
Contact
Contact_Type
I have a form:
Query_Window
On that form end users should be able to tick radio buttons (one or many - there are 16 of them) and/or use a text box where they can enter a full or partial word (one of these), and a few drop down boxes (three... -
i got it! I had to put this code in the query:
IIf([forms]![frmCB]![cb1],[FoF]=True,True)
I had CB1,2,3,4,5 checked but next to them I inserted a colum and entered that code above for each check box (CB). Not checked for viewing.
CB1 also = FoF so when I clicked on CB1 all records that had their FoF (cb1) ticked would show. Same with if I clicked on FoF (cb1) and NHF (cb2) - only records with those CBs...Leave a comment:
-
Extracting records based only on check boxes ticked
I have a table with various information (company name, address, etc.) plus five check boxes. One or more of those check boxes may be ticked as it relays a type of status to the end user.
I have a query based on the table's five check boxes plus the Company Name and Record ID #. In the Criteria area I have the word True (no quotes) under each of the check boxes on seperate rows.
I have an unbound form (frmCheckboxes)... -
Nothing was working. So I started from scratch (before seeing your post).
Query name is "PortStat"
My query has the company name plus the fields/controls
(NH, SM, FC, CO).
I then opened a blank form (design view), bound it to the PerfStat query. I then selected the checkbox in the menu area then dragged over the controls. Easy enough.
This time the form opens just fine....Leave a comment:
-
It happens when I try to open the form up. I can only open the form in design view. If I try to open it up, like a user would, those parameter boxes come up.
Ah I see what you mean on how to post SQL, I will remember that next time. I appreciate the revision.
I am trying to create a form that the user can check the boxes (choices) to run a query. I have the form with the checkboxes. I have the query (SQL). But...Leave a comment:
-
What I'm trying to do creat a form where the end user will click on the checkboxes (it could be more than one checkbox) and have the query run based on those choices. The query's table will pop up with the name of the company. I also need to generate a report based on the results, too.
Here is the SQL that I have in my query:
Criteria:
...Code:SELECT Contacts.Company, Contacts.FoF, Contacts.[NHF], Contacts.[SM],
Leave a comment:
-
Why does "Enter your parameter value" keep coming up?
By putting forms![name of form]![name of checkbox] in the criteria area and in the criteria row putting TRUE runs a query for me off of check boxes.
However, "Enter your parameter value" boxes pop up for each check box when the form opens. Why is that and how do I avoid it?
All I want is for the end user to check the boxes and then press the button to run the query.
Thank you! -
I got it!
By putting forms![name of form]![name of checkbox] in the criteria area and in the criteria row putting TRUE it works!Leave a comment:
No activity results to display
Leave a comment: