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!

Recent content by teqtaq

  1. teqtaq

    1357293636.exe and azde3fy8.exe

    Turkbear, linney, THANKS! Downloading.....
  2. teqtaq

    1357293636.exe and azde3fy8.exe

    Hi, I have regular home Windows XP - however I couldn't find such forum here, so I had decided to ask. When I type msconfig - my Startup brings following weird items on startup: azde3fy8 in Temp folder azde3fy8.exe (I have 2 of those) and 1357293636 as 1357293636.exe in Temp folder I had...
  3. teqtaq

    Microphone stopped working

    No. no yellow marks. I had restored the system to the 12th of the month, I am reading and performing steps like in System "Sound, Video and Game Controllers" section - update driver. Nothing fixing it. Speakers are fine. Mic is not. I want to ask how is my voice getting heard by PC? Where is...
  4. teqtaq

    Microphone stopped working

    Hello there! I am not sure if this question belongs to this forum, if not, please, direct me to the right place. I have Realteck HD Front Green Jack microphone and it worked with Skype until today when it stopped. When I go to the Master Volume>Option>Properties and choose Realteck HD Front...
  5. teqtaq

    Last day of the previous month access

    Oy! Working, thanks so much!
  6. teqtaq

    Last day of the previous month access

    lameid, if you mean like this DateSerial(Year([Date()]), Month([Date()]) + 1, 0) it asks for the parameter...
  7. teqtaq

    Last day of the previous month access

    I need to have a text box with label: Report Printed as of and text box: last day of the previous month Thanks P.S. I wanted to use DateSerial(Year([MyDate]), Month([MyDate]) + 1, 0) - however I am placing it on form and i don't have MyDate. thanks again
  8. teqtaq

    attach report to email

    You can save it as .pdf using VBA code. Reaqd www.lebans.com - it tells you everything how to automatically save Access Report as .pdf file.
  9. teqtaq

    Too few parameters

    More info too my question. Data looks like following Details on what I want to accomplish: ID______Date________Scale 11____1/1/2002_______112 11____1/1/2003_______112 11____1/1/2006_______111 Use to be Details on what I want to accomplish: ID______Date________Scale___Action...
  10. teqtaq

    Too few parameters

    Thanks!!!! One m ore question. I had used code to step trough a recordset rst2.FindFirst "Action='PRO'" I do not have an Action field anymore and I need to use Max Date to start from. How can I change rst2.FindFirst "Action='PRO'" to rst2.FindFirst "Max([Date])" Thanks so much
  11. teqtaq

    attach report to email

    You have to Create an object depending on what type of email you are using. Let's say Create Outlook Object and go from there. I do not have an example of the code but it is a start. Good Luck! P.S. I am pretty sure you have to Print your Access Report into .pdf or Excel file and save in the...
  12. teqtaq

    Too few parameters

    I am running code: __________________________________ strSQL1 = "SELECT DISTINCT ID FROM Scales" Set rst1 = dbs.OpenRecordset(strSQL1, dbOpenForwardOnly) Do While Not rst1.EOF ' Open records for this ID, sorted by Date. strSQL2 = "SELECT * FROM Scales WHERE ID=" & rst1!ID & " ORDER...
  13. teqtaq

    Subreport

    I am not by any means is a wizard but if you go into property of the SUB - there is an Option - On No Data and you can write the code given to you above on this event. It worked for me, good luck!
  14. teqtaq

    Max row in VBA code

    Sorry for the confusion. My code has a line rst2.FindFirst "Action='PRO'" For new Report I do not have Action field anymore. Instead I need to have: rst2.FindFirst "Max(date) in a field called 'Dates'" and start from there. I am pretty sure it will work. Thanks a lot...
  15. teqtaq

    Max row in VBA code

    I was trying and trying and nothing works and all I need is to make sure that rst1!ID strSQL2 = "SELECT * FROM TBL1 WHERE ID=" & rst1!ID & " ORDER BY Date" is taken with a Max date. Please, help
See more

Part and Inventory Search

Back
Top