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 derfloh 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. gianina

    Application

    It worked. Thanks PHV
  2. gianina

    Application

    Private Sub Command1_Click() On Error GoTo Err_Command1_Click Dim stAppName As String stAppName = "Excel.exe m:\QA\QUALITY MANAGEMENT SYSTEM\QUALITY COMPONENTS INTERNATIONAL\SUPPORTING DOCUMENTS & FORMS\CFM-EN 003 Engineering Change Notice.xls" Call Shell(stAppName, 1)...
  3. gianina

    Application

    Hi, I am trying to create a button which will run an aplication....opening an excel file and I always got en error message that "file "aaaaa" cannot be found. I am using Excel.exe m:\path of the file Can someone please help me ? Thanks. G.
  4. gianina

    Calculations

    Hi Remou, I read the topic created by misscrf but honestly I don't know what to do ? Help....
  5. gianina

    Calculations

    Hi Remou, Thanks for your response. I am not sure what to do with your code, I'm not very good with Access. Can you explain please ? Thanks.
  6. gianina

    Calculations

    Hi Everybody, I created a database in which I would like to do a calculation. My database is about "calibrations" and contains data about different tools. Included in the database are 2 fields called "Last Calibration" and "Next Calibrations". These are date fields. What I would like to have is...
  7. gianina

    Query issue

    Thank you all..it worked. I appreciate it. G.
  8. gianina

    Query issue

    My table is called "NCR Database" and the field where the ID's are stored is called "NCR #" So I did something like this: SELECT [NCR Database].[NCR #] FROM [NCR Database] ORDER by Val(NCR #); and an error poped up: "Syntax error in date in query expression 'Val(NCR #)' What should I do ...
  9. gianina

    Query issue

    Hi Lespaul, Thank you for your reply. I am not an expert of Access, therefore I need to ask you to tell me where should I put this: "ORDER BY VAL(ID) HTH " Thanks again...
  10. gianina

    Query issue

    Hi All, I have a problem with my query and I hope I can find some answers here. I created a query which shows all "new" ID numbers created. We got to ID number 99 and then we created ID number 100 it didn't show right after number 100 in my query. Instead ID 100 got placed after ID number 10...
  11. gianina

    Report Question

    I replaced the query with the one you suggested and I have the following message: "Undefined function "Format" in expression" What should I do ?
  12. gianina

    Report Question

    Hi Alex, Here's the query: SELECT Count([ECN Database].[ECN #]) AS [CountOfECN #], [ECN Database].[Submit Date MONTH] FROM [ECN Database] GROUP BY [ECN Database].[Submit Date MONTH]; Yes, the month field is a text field. Can you tell me how can I add a field to the query to sort on ? I've...
  13. gianina

    Report Question

    Hi All, I have a problem with a report. A insrted a chart into a report which shows total ECN's by MONTH. The problem is that the chart contains the MONTH not in order (ex: January, February, March, etc). It shows like (February, January, March). This cannot be sorted (ascending or...
  14. gianina

    Query

    Thanks Randy...it works fine. I appreciate your help.
  15. gianina

    Query

    I got it guys... But, when I press the button for sending the report via e-mail a small window pops-up asking me the NCR #. Even after I enter the selected NCR # the report will show the entire database (ALL NCR #'s...all 20 of them). ANd I want to show only the one NCR # selected. Is it...
  16. gianina

    Query

    randy700, Your suggestion with the brackets was good. It works. However, I'm still confused with the query: " In a query... SELECT FieldName1, FieldName2 FROM TableName WHERE NCR = forms![NCR formx]![NCR #] " I'm keep looking at my query and I don't know where to enter the above ! Please...
  17. gianina

    Query

    Thanks randy700, I entered the code behind the button which opens the report: docmd.OpenReport "[ReportNCR]",acViewNormal,,"NCR = " & forms!NCR formx!NCR # and an error message pops-up: "Compile error: Syntax error" and th entire code is highlighted in red. Where's the problem ? Also, can...
  18. gianina

    Query

    Hi All, I created a form which pull-up data (fields) for a certain NCR (non-conformance report) selected. There is a designated field called NCR Number. There are several NCR Numbers in the table. On this form I created a button which which e-mails a report to users selected. This report...
  19. gianina

    E-mail via Access

    Yummy 7, Can you be a bit more specific ? Thanks.
  20. gianina

    E-mail via Access

    Hi All, I am not sure that this is possible so please let me know. I have a form (called "NEW NCR") which contains a "tab option" (with several tabs). I use this form to enter data into my table. What I would like to do is to be able, by the press of a button, to e-mail the current data that...

Part and Inventory Search

Back
Top