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

    Group Record...

    Thank You that worked perfectly!![bigsmile]
  2. tamer64

    Group Record...

    Thanks for the tip, but I tried using the TGML tags and I made sure it was checked and it doesn't seem I can get this to format correctly. I don't need to sum any totals. The second record for "MIKE" the amount $7,000 is actually a WonAmt and that goes the same for the last record in the...
  3. tamer64

    Group Record...

    How would I do I group my records into one record for each month? SELECT Montly_Rpt_Table.REPID, Montly_Rpt_Table.Rep, Montly_Rpt_Table.MonthAbb, Montly_Rpt_Table.LostAmt, Montly_Rpt_Table.WonAmt FROM Montly_Rpt_Table WHERE (((Montly_Rpt_Table.REPID)=2)); REPID REP MonthAbb LostAmt...
  4. tamer64

    Help witn Syntax

    I dont why "..." kept showing up in the post. But this is what worked. strBody = strBody & "<a href=http://wwwapps.ups.com/WebTracking/track?loc=" & TrackingNumber & ">TrackMe </a>" I think before I had some spaces in where they shouldn't have been. Again, Thank you. And for SKIPVOUGHT...I...
  5. tamer64

    Help witn Syntax

    Got it to work! thank you both for all your help.
  6. tamer64

    Help witn Syntax

    Once I click on the button on the main form, it runs the code above and creates and displays the outlook email, it places the Link on the new email. When I click on the Link it does open the browser to USPS website but it is not displaying the tracking number on the website. It should look...
  7. tamer64

    Help witn Syntax

    Thanks for the reply! I forgot to mention I had already declared the variable. The module is contained on the form itself. I tried placing the variable inside quotes but I receive compile error Private Sub Command1752_Click() Dim strBody As String Dim Contact_Email As String Dim OutlookApp...
  8. tamer64

    Help witn Syntax

    Hello, I'am hoping someone in this forum can help me. I having some trouble with the syntax below. I am using MS Access 2010 and I have a form which generates an email through using Outlook.Application. When I outlook generates the email and I click on the Link the website indicates it cannot...
  9. tamer64

    Ranking Date and Time in Text Format

    Sorry posted in wrong forum. I want to do this in MS Access query. Thank you thought I would give it try!
  10. tamer64

    Ranking Date and Time in Text Format

    Hello, I have an excel file which I have imported into an access table. There is a field Called Time_Lapsed which is in Text format. Is it possible to someway to sort (rank) these from oldest first? The fields look like this: 08 day(s), 2 hour(s), 39 minute(s). 04 day(s), 13 hour(s), 6...
  11. tamer64

    Help with opening a dat file and trim characters if necessary.

    Hello, I need help with writing a script that will open a dat file in my temp directory and then check a specific column's field "USER_ID". if the column USER_ID field is more than 6 characters I would then need the script to trim from the RIGHT of the "USER_ID' column to be within the 6...
  12. tamer64

    Ranking

    Thank You PHV. Let me give this a try.
  13. tamer64

    Ranking

    I need some help on ranking and hoping someone can assist. I have an EmployeeID field "EmpID" which is a number field and an Hours field which is a Text Field. I would like to create a ranking column to rank the the employee with the highest amount of hours. Is this possible to do in a query...
  14. tamer64

    Macros Disabled

    I am hoping this is the right forum for this question. We will be migrating to windows 7 with Office 2010 from Windows XP Office 2007 in the next few months. We have imaged one of our test machines and have found out that our MS Office products have had some restrictions placed on them through...
  15. tamer64

    Round a number.

    Duane, I got it to work! Thanks again for your assistance!
  16. tamer64

    Round a number.

    Duane, Thank you for assisting! It's the way jobs are billed here. If an employee performs a job and takes him 1.21 hrs the vendor is then billed for 1.5 hrs. I have tried to run the query Billed: RoundIt([LinkTime]) but I am receiving the following error message: "Wrong number of arguments...
  17. tamer64

    Round a number.

    Hello, I need some assistance with rounding up. I have a field in which the data type is a Number and the field size is set to double. I am look for a way round up to the nearest quarter. Example: 1.32 round up 1.75 0.07 round up 0.25 48.54 round up 49.0 1.15 round up 1.25 2.21 round...
  18. tamer64

    Help with a query?

    Doing a little research...I understand. Problem solved.
  19. tamer64

    Help with a query?

    Can someone explain to me what this mean and how do correct the query? "You tried to execute a query that does not include the specified expression "Barcode Assignment" as part of the aggregate function" SELECT Test2.Barcode_Assignment, Format((Sum([...
  20. tamer64

    Odd occurrence with a report??

    Pure Genius! That was it "Auto Hide". Dhookom, Thank You!

Part and Inventory Search

Back
Top