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!

  • Congratulations TouchToneTommy 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: *

  • Users: noorani
  • Content: Threads
  • Order by date
  1. 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...
  2. noorani

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

    i have applied the following code to solve my task but i didn't get the results. my problem is that i'm trying to print information of Group footer right after the Detail section but in one condition that if the group footer size is more then the size left in page right after the Detail section...
  3. noorani

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

    Please help me to solve the error in my code i have a problem with initializing the loop. please give me some advise thanks in advance. My problem is, that i want to export data from Access into my Excel worksheet. where first 3 columns in my Worksheet will contain the Product No, Product Code...
  4. noorani

    Can't trasfer data into Excel using loop

    Please check this code i have a problem with initializing the loop in my code. please give me some advise thanks in advance. My problem is, that i want to export data from Access into my Excel worksheet using organized format, where Product Code and Name Of product will be trasfered vertically...
  5. noorani

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

    Hi, My problem is related with the RecordSet. i want to retrieve data from my table for specified period using some parameters, like 1) stock number 2) product number, 3) and between some user define period. At the starting part of my code every veriable is defined. R - is a Recordset...
  6. 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...
  7. 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...
  8. 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.
  9. 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...
  10. 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...
  11. noorani

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

    in my form i have 2 bound fields OrderDate (Date Field) , and the reserved days (Integer field). now i want to make an unbound field where i can perform the check and show the remaining reserved days , comparing with the current date and reserved days. here is the example for better...
  12. noorani

    How to cancel On Delete Event

    i have writen this code for On Delete event of my form, which is a child continous form, and this code suppose to delete the record when the del key is pressed. well problem is when i press " NO " at the moment when the message appears and ask the confirmation for deletion then this...
  13. noorani

    Export Excel worksheet To text format file with the fixed position

    Hi, i have a wroksheet and i want to export it in the text format file, with the fixed position and length in the text file. My worksheet contain. 2 parts of information. Clients and Inventory. every cleint have a unique number. and every product have a unique code. In the text file i want to...
  14. noorani

    OnDelete Event works in child form, but Stop other Events functioning

    I have writen this code for the " child form " in my order main form, for on delete event , this code work fine, problem is when choosing " No option " at the time of execution then the delete process stops successfuly. but other buttons on my main form stop...
  15. noorani

    Prevent access to folder on server by users, but they may change data

    we have windows 2000 professional server operating system, as a server, and users have different version of windows. I have split my Access database b/w FrontEnd and Backend. BackEnd database is on the server , and all the LAN users having the copy of the FrontEnd installed on there computers...
  16. noorani

    Backend is on the server, avoid deleteion of the folder by users

    i have split my database b/w front and back ends. back end is on server , and copy of the front end is installed to all the users individually. now the problem, i have created a shortcut to user desktop, and they can execute the front end which is linked to a backend on the server. and every...
  17. noorani

    date format problem, can not get dd/mm/yy in vb code,

    I have create a function, in my module. and i'm Calling this function in a report by using a macro, in the menu which i have designed for my report. now what this code is doing. when this code runs it change one of the field value to true in the table name as "order". and then it...
  18. noorani

    Delete reocrd in subform and show own message inspite of system msg.

    Hi, I want to delete records in my subform "which is bound to a table name as OrderDetails" using the Del key. i have writen code for on delete event for my sub form where my code will check the product code and orderID in the table name as as "Reserved", if record found...
  19. noorani

    combination of queries , and showing results in one column

    i try to explain my problem, i have 4 tables , first two tables name as 1) InvoiceMaster 2) InvoiceDetail, the other 2 name as 3) ReturnMaster 4) ReturnDetail in first 2 tables i store the information about product sold from stock, and in last 2 tables i store data about the products which...
  20. noorani

    Dlookup show null value despite of 0, how can i put 0 if no record

    I have a difficulties with Dlookup here is my syntax, =DLookUp("[sellinHP]";"SellinHPFinder";"([ProductID]= Reports!SellInReport!ProductID)") Note: SellinHp is the field i'm looking in the SellinHPfinder query, Product ID is the key to match the record...

Part and Inventory Search

Back
Top