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 bkrike 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: grendal
  • Content: Threads
  • Order by date
  1. grendal

    Append Text to Outbound Messages

    I've just migrated from ALT-N's MDaemon to MS Exchange 2003. One of the good modules of MDaemon was the ability to append text to outgoing messages. I've tried without any sucess to find a similar option. Does this option exist within MS Exchange 2003? Cheers s-) Some girls mothers are...
  2. grendal

    OUTLOOK - CAN'T OPEN THIS ITEM

    I've moved our compnay users from an Outlook Internet Mail service to an Outlook MS Exchange mail system. All is well except a percentage of the (internet mail) will not open. The message displayed is 'Can't open this item. Operation failed.' I've reinsatlled Office 2003 twice without any...
  3. grendal

    #NUM! Error

    HI, I've a formula as follows:- =([JANSALES]-[JANCOST])/[JANSALES] This caluculates the profit margin on a Sales report. However when faced with either or both fields containing zero's - I get the #NUM! error. Is there a way around this. Cheers s-) Some girls mothers are bigger than other...
  4. grendal

    Negative Value based on Field Value

    I have a report which lists stock tickets bassed on status, with a value for each ticket. Where I have a negative status e.g. Missing Stock, how can I make the value of that status group report as a negative value, ensuring my overall stock value is not over inflated. Cheers s-) Does the body...
  5. grendal

    Subform total show error on main form

    Trying to get my head round this problem. I've created a customer account sub form with 12 sales period columns, each of which has a column total within the forms footer =sum([Period1]). When the subform is viewed on its own, the total works fine. However, when I place the subform into my...
  6. grendal

    SAVE NEW RECORD COMMAND

    I've just created a new entry into my form. When I select my command button to print preview this particular entry, my report opens, but does not contain my new data. As this command works O.K. for existing data, I assume I need to update the form somehow. My existing command is as follows:-...
  7. grendal

    count formats

    I know how to count the number of cells in a range that contain a letter. But, is it possible to count the number of cells in a range that are formatted, say, yellow?
  8. grendal

    Win98 Network Neighbour Error

    I manage 65 pcs on my network. All users log onto a domain on a NT4 server (which contains a logon script). 3 win98 pc's logon onto the domain succesfully, but cannot be seen via NN (network neighbourhood). These machines have access to all domain services and can also see other users via NN...
  9. grendal

    Scroll bar property within Access Web Page

    I've converted a form into an access web page, which runs ok except for a problem with a memo field. I'm trying to make the field read only, but the user still needs to be able to scroll through the field. Does anyone know which property controlls the availability of this item. Cheers s-)...
  10. grendal

    Auto populate form field

    I've two forms, Call Details and New Customer. Both forms have a Call Number field. The Call Details form has a command button which opens up the New Customer form. The On Click event for this command button reads:- call number=FORMS!call details!call number When I click on the command...
  11. grendal

    Column Sort Within Combo Box

    I have a customer database with a combo box to help search on customer name. For some reason the data in the combo box has a primary sort on my account number column. However, if I look at my customer database within the table format, its sorted by customer name. Has anyone any thoughts...
  12. grendal

    Tab form start field

    I have a tab form which has 10 fields. When entering data, I do not always need to goto the last field to complete my transaction. When I click on "next record", the cusor is on the field I was in, on the previous record. How can I ensure that the cusor always picks up field 1...
  13. grendal

    Max value report

    I'm currently writing a dbase to monitor labour efficiency. Each worker may spend time in different departments. I need to be able to list the department they spent the most time in, only. I know how to create a max summary value report based upon the time spent, but it does not show the...
  14. grendal

    Form and Subform link

    I've a Main form which holds employee details. The Subform has details of the work they produce each week. I currently have a database for each weeks worth of data (too much work). I've tried to insert a combo box on either form which would enable me to select a week number, which would...
  15. grendal

    Opening a Detail form, based on Main form field

    I have two forms Main (customer accounts) and Sales (per account). I've created a command button in the Main form to run a macro. The macro is an Openform action. the form name is "Main" and the condition is "[Account]=[Sales].[Cust-acc-num]. When I hit the command button a...
  16. grendal

    Two way remote update of Access Dbase

    I have a Sales Contact Dbase set up on my server (two tables, main & sub) Three sales reps (initially) have an exact copy on there laptops. As each of us updates our Db, we wish to import/export new information to each others db. Is this possible, if so could someone point me in general...
  17. grendal

    Acess Sub Reports - Brain Hurts

    Hi all! I've created 2 forms (main and sub). I've then added the sub form to the main form using the wizard - works fine. I've then created separate reports from the main and sub form, again using the wizard. However, when I add the sub report to the main report using all of the wizard...

Part and Inventory Search

Back
Top