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

    Unbound Listbox give null value to unbond Text box

    thx PHV , now it's work out, i use it in my code and every thing is perfect, thank you very much PVH, and Remou.
  2. noorani

    Unbound Listbox give null value to unbond Text box

    ...0 ,Balance limit balcurrhol = 0 , Current Balance balcheckhol = 0 , Balance limit check 'Store Balance limit ballmthol = CS!ballimit **A** 'here i have error i always have null value balcurrhol = Me.Balancelist.Column(1) 'store the available amount for reservation...
  3. noorani

    Unbound Listbox give null value to unbond Text box

    Thx Remou for your reply, you are right, but i still didn't get the value. as i understand untill the list box is not selected or not get focused, i'll not get the value in my text box field automaticaly, i'm still looking for the solution.
  4. noorani

    Unbound Listbox give null value to unbond Text box

    Hi, I have an unbound Listbox based on a calculated query as row source, i can see the data in my listbox but when i try to get this data to one of my unbound text box field i get null value. here is the example. List box data: Customer_ID Balance 1100 -4993,22 now i want to have...
  5. noorani

    How to reformat and change report detail and and group footer section

    ...1 ' Counter to check the Products record Function ResetCounter() RecCntr = 0 End Function ============================================= Step 2 *** 'Detail Location Function it suppose to move the last Detail section record if the footer section needs to print in next page. Function...
  6. noorani

    Transfer data from Acces to Excel, Initializing loop, Compare record

    Thanks Smuckers for your detail explanation i really appreciate it, today i'm going to work with your solution and let you know the results. Once again thank you very much for spending your crucial time on my question and i'm sure that your explanation will going to put me on right track...
  7. noorani

    Transfer data from Acces to Excel, Initializing loop, Compare record

    ...Code" .Cells(2, 3).Value = "Product Name" End With currentRow = 3 currentColumn = 1 Set prodlist = dbs.OpenRecordset("select * from products where (VenderID = 4)ORDER BY Hp_ProductName", dbOpenDynaset) If prodlist.RecordCount > 0 Then Do Until prodlist.EOF...
  8. noorani

    Can't trasfer data into Excel using loop

    ...currentRow = 3 currentColumn = 1 'Now i'm retrieving products code and sending 'data to Excel. Set prodlist = dbs.OpenRecordset("select * from products where (VenderID = 4)ORDER BY Hp_ProductName", dbOpenDynaset) If prodlist.RecordCount > 0 Then 'Variable i is defined for future...
  9. noorani

    RecordSet is not Retrieving Data if i use Date period in my statment

    Thanks Roy Vidar it's really worked out.
  10. noorani

    RecordSet is not Retrieving Data if i use Date period in my statment

    ...format of date field is set to a short date in both table and form. here is the statements, 1) --------------- Set R = dbs.OpenRecordset("select * from jrn where (stock = 6)and (productcode = 214)and (jrdate > Me!start_date) and (jrdate < Me!Me!end_date)", dbOpenDynaset) ----------------- i...
  11. noorani

    Why Attachments in Outlook Express are disable

    thank you very much it really worked out.
  12. noorani

    Why Attachments in Outlook Express are disable

    my problems is that now when i receive my email using Outlook Express i found attachments with my emails are disable, but if i use microsoft outlook i can see these attachments enable and can easily open these files. i have been using Outlook Express since last 6 months and every thing was...
  13. noorani

    Automatically insert data in the subject field of the of e-mail.

    Is it possible to automatically insert some information in the subject field of the e-mail from the report. I'm sending the report and i want to show the order number and the client name automatically inserted to the subject of my e-mail from the report, i'm sending this report using macro...
  14. noorani

    what is inetinfo.exe file and why it's taking 98% CPU Resourse.

    Thanks, it really worked out. thank you very both of you.
  15. noorani

    what is inetinfo.exe file and why it's taking 98% CPU Resourse.

    I have windows 2000 server, every thing was wroking fine but today our server is working very slow, and i check the task manager, and found that the file Inetinfo.exe is taking 98% of CPU process, our network is working very slow. how to solve this problem.
  16. noorani

    multiple sub forms in Microsoft access

    Give name to your subforms like child1 , child2 ... suppose you have main form were client ID field is the same as client ID field in child1, you can easily linked both of them now if u want to link your child1 form with the child2, then in the child2 form properties you need to mention the...
  17. noorani

    Front-end database is running deny another copy to be opened

    Hi WildHare , well i like both of your suggestions, i guess that you have been experienced with the basball advise, and got a gun shoot in return and luckily you are alive my congratulation. but i'm not brave enough like u to go for your first suggestion, but i do prefer the second one by...
  18. noorani

    Front-end database is running deny another copy to be opened

    my problem is that, if One copy of my Front-end database is running then how to deny another copy to be opened and show message that program is already running. some time user working on the Front-end database, they open another copy of the same front-end to work on different functions of my...
  19. noorani

    Convert Access BackEnd Databse to MS SQL Server BackEnd Database,

    Hi, Has anyone tried to use MS Access as Front end on SQL server BackEnd Database? I would like to know more about it. Can any one redirect me to some usefull links or give me some advice about whether this is a good idea ore not. i have started seriously thinking to convert my Access Backend...
  20. noorani

    when form opend ,perform the check with the date for unbound filed

    Hi friends i have solved my task by doing the following. i have declare the variable in the &quot;On Current&quot; event of my form, and perform the check. here is the code. note: tmleft is the variable to hold the value which i have declare in my &quot;On Current&quot; event. tmleft =...

Part and Inventory Search

Back
Top