Recent content by myaccess2000

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

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

Thanks....it works....

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

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

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

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

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

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

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

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

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

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

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

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