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 Chriss Miller 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: jase2006
  • Content: Threads
  • Order by date
  1. jase2006

    Add values of two rows if certain column values match

    I have a table which contains LoginID, WC, ProjectID, Mon, Tues, Wed, ......,Sun. More than one row can have the same LoginID, WC and ProjectID and if that is the case then I want to merge these rows' value together. Can anyone show me a sample code of doing this? The Values in Mon - Sun column...
  2. jase2006

    Trucate text value in Select statement

    Is there a way to only extract part of the values from a column in a Select statement? e.g. "Name" field contain value "JOHN GRANT" and I only want to extract the first 4 characters "JOHN". Any suggestions?
  3. jase2006

    How to Group and Sum rows with matching column

    Hi, currently trying to group all the rows with a column containing matching dates and sum all the rest of the columns together. Can anyone suggest a good SQL sample to do this. The Data looks like this: Currently: 24/08/07 7 1 2 2 24/08/07 8 2 1 1 21/08/07 3 2 1 1 I...
  4. jase2006

    Emailing aborted unexpectedly

    I have this Access function to sent out emails to a list of people automatically using contacts in Outlook. When it try to send to a person with two different email address outlook would throw an error message but if I just ok that, the function would carry on happily. But for reason, when one...
  5. jase2006

    character count for textbox

    Can any show me a way to create a display for counting the number of characters being entered into a textbox (real-time) on a form.
  6. jase2006

    Good way to locate occurrence of table and queries, Form use

    Hi, I would like to locate the occurrence a certain table and query in all Forms. Is there a faster way than going into Form design mode and check the properties to see what table or query is used?
  7. jase2006

    VBA to create an EMAIL to show attachment as thumbnail

    Hi, can anyone please tell me how I can format an email using ACCESS VBA to show an attachment as thumbnail in the Body?? Thanks.
  8. jase2006

    Item not found in this collection error?

    Hi, I am getting the "Item not found in this collection" error when I reached the "problem here" part below. There is definitely records in the "tSkills Matched a" TABLE. But for some reason it is not working. Or am I mis- interpreting the error message? Dim dbs As Database Dim qdf As QueryDef...
  9. jase2006

    ACCESS SQL- Using 'LIKE' with a Field on a form

    Can any tell me how I can using the keyword LIKE to compare a table field with a textbox on a form e.g. X.user LIKE '* Form Text box value *' I've tried something like this (([Skill Import].User)LIKE '*' & [forms]![frmSkillView].[txtUser])) & '*' but does seem to work.
  10. jase2006

    No result when using CurrentDb.QueryDefs.OpenRecordset?

    When I run the query straight off it shows rows of results, but for some reason when it to the "If Not rstAssignments.EOF Then" It doesn't pass, which means it's empty? All the fields on the frmReportParam2 form is filled in (hence result when running the query straight off) But it should...
  11. jase2006

    Hyperlinking in Access 97 Frontend and Backend SQL Server

    I have created a table in SQL Server and linked it to ACCESS 97. I would like to have a field which allow user to store hyperlinks. How do I go around doing this? Thanks in Advance.
  12. jase2006

    Getting the New autonumber right after an update

    The "ID" field is an autonumber field. I am trying to get the new "ID" number right after a record is added. I manage some info online saying that you can read the field right after an recordset update and it should on the update row. However it seem to reset the position back to the first row...
  13. jase2006

    SQL Removing and merging results

    The query below suppose to find out some project info (resource id and project id etc) and work out the "last assignment date". However, it creates a problem when there are is a month change during the week e.g Jan 07 finishes on Wednesday and Feb 07 starts on Thursday. It should only give one...
  14. jase2006

    Optimising an nested SQL

    This query suppose to find all duplicates in the vContractDetails table. At the moment it is taking forever to process. Can any one spot any problems? Or help to optimise it? Thanks in advance ********************************************* SELECT DISTINCTROW vContractDetails.Start...
  15. jase2006

    How to locate Access Linked Tables in SQL Server?

    I need to change the structure of some tables on SQL server and I only know the name of these tables in Access as Linked ODBC tables. But the naming of the Access tables are really messy and I can't locate the tables with the corresponding names. Is there a way I can track these tables down...
  16. jase2006

    Using DoCmd.SendObject to send on a certain date

    Hi, I am currently using the function below to send a report through email. I would like to know if I can delay the sending date to the next day? *************************************************** DoCmd.SendObject acSendReport, ReportName,acFormatRTF, Email1, Emal2, "Report1", Me.txtEmailNarr...
  17. jase2006

    VBA Automation Error when Formating Spread Sheet.

    Hi all, please help. I keep getting a "Automation error: Server threw an exception" error each time it reached the '.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="(blank),2,3,4,5" ' line of code. (See full code below) The code was working fine...

Part and Inventory Search

Back
Top