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. myaccess2000

    All lights for that port keeps blinking

    Hi, I have a PC which has a onboard LAN Port. So i need to connect my PC to the router which place at about 15 metres away. When i hook them up, at the router side, all lights for that port keep blinking (link light, 10/100Mbps, FDX/COL). So i disconnect and replace the PC with my notebook, and...
  2. myaccess2000

    Tab Control for data entry

    Hi, I have a few tabs in the tab control and each serve different purpose of data entry. How do i reference the textbox in different tab? I appreciate if someone can help me. Thks Regards Irene
  3. myaccess2000

    Combo box default value from table and list from another table

    Thanks....it works....
  4. myaccess2000

    Combo box default value from table and list from another table

    Hi, I would like to show the default value on the combobox that is in the table. And there are a choice from the list that i can change the value to. e.g In the table Name Department Albert Account Jane Material So when i open the form, it will show name "albert" on the textbox...
  5. myaccess2000

    Eliminate record if both field has the same value

    Hi, I have make a query from a table. This sum up the total amount of money spend and total amount of money paid on item 1, into two field respectively. item total spend total paid 1 1100 1100 <- Do not show on query. 2 1200 1100 How do i eliminate the record if both values are the...
  6. myaccess2000

    How to display default value on Combo Box?

    Hi, It doesn't seem to work. I think i have to phase my question again. In the combobox name section, i need to put in things like All, account, payroll..etc. Then in my table i have this record section &quot;account&quot;. So i will put &quot;account&quot; as my default text and there is still...
  7. myaccess2000

    How to display default value on Combo Box?

    Hi, I have a table that contain Name and Sections. In this form, i am allowing people to change the section to one of them in the available list in the combo box which came from a list of sections. But before that, i would like to display the default value of section before the user change the...
  8. myaccess2000

    How do i solve this problem?

    bingo!!...thanks! it really works!!! You are real fast in responding. :)
  9. myaccess2000

    How do i solve this problem?

    Hi, i have the error pop up and the error is &quot;data type mismatch in criteria expression&quot;. It shows that there is something wrong with my SQL statement and i can't figure out what is wrong with that. date1.text is the value in my textbox and i intend to use the date in the textbox to...
  10. myaccess2000

    How can i extract data base on month?

    Hi I would like to know what needs to fill in the criteria in the queries under the short data format named date in order to extract out monthly data. Is it possible to do so, just by allowing the user to input the month and it will process all the date with the month stated by the user? Pls...
  11. myaccess2000

    How to extract month data in query?

    Hi, I have problem in extracting out data entered by user in month in the query. The date is in the short date format and i would like to extract the month data. So what do i need to put in the criteria? Regards irene
  12. myaccess2000

    Summing a textbox

    Hi, I have problem in summing a textbox. The textbox control source contains &quot;=IIf(IsNull([sum_debit]),Sum([debit_amount]),Sum([debit_amount])+[sum_debit])&quot;. Due to the condition in the IIF, i could not do it in the query. I have to do the summing in the report. Would appreciate if...
  13. myaccess2000

    Please help me!

    Hi, Thanks for your quick response I can't do so. I have do summing in the query and in the report, i have to do the summing again with the summing that i do in the query and value appear in the reply. That's the reason i need to check the null before i do the summing. It works on the...
  14. myaccess2000

    Please help me!

    Hi i have a problem in calculating the grand total. I have a textbox that calculate the subtotal. the textbox name is &quot;sum_of_debit&quot;, but the control source, i have entered an expression &quot;=IIf(IsNull([sum_credit]),Sum([credit_amount]),Sum([credit_amount])+[sum_credit])&quot...
  15. myaccess2000

    Can anyone help me?

    Hi, The format that i want is not that way. It should display result as below. result of key 1 in query 1 result of key 1 in query 2 result of key 2 in query 1 result of key 2 in query 2 regards irene
  16. myaccess2000

    Can anyone help me?

    Hi, I need to generate a report based on two queries. First query is retrieving data based on start date and end date. The second query is retrieving data before the start date. The report will base on common key name &quot;code&quot; to display the results in the report. I try to join the two...

Part and Inventory Search

Back
Top