Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. thembela

    How to look up for multiple records

    I have created a database with all our SAP users on Ms access.In the Username field of my query, in the Criteria text box, i tried to put in about 10 users(using their username) one by one.And it works fine, but it's time consuming.I then pasted the 10 usernames all at once in the criteria...
  2. thembela

    Import Spreadsheet Wizard not working

    I’m trying to import a spreadsheet from excel into access there’s customer number column that has numeric values and text values. But I have converted the entire column into text in Excel before importing it. It doesn’t seem to work cause not all data gets imported.Only the numbers get imported...
  3. thembela

    Duplicates

    I’ve just found out that some information has been entered more than once in the Customer Name & Plant Filed .So Now what I want to do is to write a query that will give me only the Customer names & Plant that were entered more than once. And leave out the Names that were entered once.This is an...
  4. thembela

    Formatting color in a query

    i'm doing this on a query.is there no way i can do it on a query
  5. thembela

    Formatting color in a query

    When i run my query, i got negative values for sales column.So i would like to format the sales values, so that negatives values will be red.Is it possible???Here's my SQL: select effmonth, s/man, sales from salestable.
  6. thembela

    Can I Read Data Directly from Access To Excel Without?

    Is there a way I can read data directly from an access query to excel without having to import it to excel??? If yes . How???
  7. thembela

    [B]UPDATING TABLE[/B]

    This whole thing works .I get the combination of all the Sales Man numbers and dates.But the problem is with the commissions.The commissions fields that had previuosly no value now get populated when i run the query.which gives me wrong amounts.For instance when I run a query.The monthly...
  8. thembela

    [B]UPDATING TABLE[/B]

    When I run a crosstab query based on the query created from TblMonths and Salestable with no join. It works but the problem is I get the same value for commission for every months S/Man/No Month Sales 21010 01/01/2005 $234 21010 02/01/2005...
  9. thembela

    [B]UPDATING TABLE[/B]

    I have a table that links salesman to 12 months of commission he made. when I run a query for 12 months of the year I realise that there are missing months for some salesmen. It’s simply because they didn’t make a commission in those missing months .And therefore those months in which they...
  10. thembela

    How do I link a Graph??

    Hi All Seeing that it’s hard to create a Graph in Access. I would like to create my graph in Excel, and then link it to Access. But How can I do this when my query that my graph will based on contains more than 100 000 records. How do I start??? I've tried it .My Graph has to be synchronised...
  11. thembela

    Update Error Message on my Form

    Hi All, tHERE'S a piece of VB code to synchronise my form to the value in the Combo Box. The VB code is attached to the After Update event of the Combo Box. And sometimes when I select a value on my Combo Box, I get the ERROR message. I suspect there’s something wrong with my code. I can’t seem...
  12. thembela

    Using Dcount between two dates

    Nope it doesn't work.Instead I get the ff: Month 2003 2004 2005 Aug 11,000 Aug 3,200 Aug 700 What I want is this: Month 2003 2004 2005 Aug 11,000 3,200...
  13. thembela

    Using Dcount between two dates

    I got a query that gives me the following results: Month 2003 2004 2005 Aug 03 11,000 Aug 04 3,200 Aug 05 700 What formula can I use to change the query into 1 line of August so I can have...
  14. thembela

    Making a Chart Clustered

    I’ve been trying to create a chart based on the below information. So far what I’ve been getting is, my chart is not at all CLUSTERED .For instance on the X-axis the months Aug’04 & Aug ’05 are at the opposite ends of EACH OTHER. Basically I want them to be side by side. And the Colour...
  15. thembela

    How can I remove duplicates on my Combo Box

    Broker No Broker Name Month Premiuns 1028811162 ABDOL,VE,MR 01/08/2005 3000 1028811162 ABDOL,VE,MR 01/09/2005 16692 1028811162 ABDOL,VE,MR 01/10/2004 48 1068787405 ABDUL,P,MS 01/08/2005 56100 1068787405 ABDUL,P,MS 01/09/2005 41376 1068787405 ABDUL,P,MS 01/10/2005 19092 I have a table...
  16. thembela

    Synchronising Form to the value in the combobox

    KenReay, everything seems to work perectly.Now the problem is when i enter the value that is not in the list .I want an error message to display that the value entered isn't in the list.And on top of that whatever value that was entered( not in the list must be deleted( reset to null) here's a...
  17. thembela

    Synchronising Form to the value in the combobox

    KenReay, there's something baffling me here.Why is it that the ApplyFilterAction on the macro couldn't work.I attached the macro to the After_update event of the ComboBox. Here's my macro to find a Record using the ApplyFilter Section: Action Action Arguments ApplFilter Where...
  18. thembela

    Synchronising Form to the value in the combobox

    Thanks KenReay, you are an absolute satr .it worked.
  19. thembela

    Synchronising Form to the value in the combobox

    I have a form with a combo box on it. I’m trying to synchronise the form to the value in the combo box. Here’s my code attached to the Apply Filter Action of the Macro. [Broker Number] = [Forms]![frmBroker]![CboFind] [Broker number] is the name of the field in the underlying table and...
  20. thembela

    YES/NO CHECKBOXES

    some have suggested that i can only manage to to get what i want if i my yes/no field is bit data type.what does that mean?? and how to do that??Since i would like to have these 3 checkboxes viz( yes/no/unkown)one of the checkboxes have to ticked depending on which one the user clicks on the...

Part and Inventory Search

Back
Top