Search results for query: *

It worked. Thanks PHV

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)...

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.

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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