msamhouri
Last Activity: Feb 29 '16, 10:02 PM
Joined: Oct 4 '12
Location:
-
i am not going to but the employees information for all over the world, no its just an example, but my real project is different -
Outlook auto reply with attachement based on a subject of email received
I am new in VBA world and i have a question about connecting MS outlook to MS access (2007 or 2010). let me explain what i want exactly by telling you what kind of project i wanna do.
I have an access database with a lot of data and tables, when i receive any email with certain subject like if i receive an email says in the subject line "Emp 1232221" then outlook when see any email with subject start with "Emp"... -
thank you i found the solution in other website... have a good dayLeave a comment:
-
no i need it to do some justifications on the new table, can you help me with the code please?Leave a comment:
-
Copying the filtered data - StrWhere
I have a VB code to filter data and show the data in form and it works fine, My problem is how I can add code to copy this filtered data to a table??
...Code:Private Sub cmdFilter_Click() Dim strWhere As String Dim lngLen As Long If Not IsNull(Me.txtFilterType) Then strWhere = strWhere & "([AcctGroupName] Like ""%" & Me.txtFilterType & "%"") -
Okay, I believe in access project you need to put another formula to run this query, not like the regular ms access when you put this formula its working fine
Like [forms]![Main]![Text49]
and it shows you the correct data,
But in MS Access project - SQL it doesn’t work,
Can you please help me with what formula that I have to but in the criteria or give me the correct code??
...Leave a comment:
-
Query Search by date - SQL
I am working in access project, so the backend of the system is SQL, I tried to build a query to retrieve the data based on the date, the date appear in different form in a text box, so when I put the date in the text box and run the query I need the query to give me the data based on the date in the Text box. I tried to put in the query as following
Like [forms]![Main]![Text49]
but its not working like regular Ms Access query,... -
Hello everybody, according to the last email, I wanna put the code, can you help me to put formula when I determine specific date, the query shows the data according to this date??
I tried this formula and it not Working (Like [forms]![Main]![Text49]_)
the SQL code is :
...Code:SELECT TOP 100 PERCENT dbo.[1_Account_Types].AcctTypeID, dbo.[1_Account_Types].AccTypeName, dbo.[2_Account_Group].AcctGroupName,
Last edited by zmbd; Oct 18 '12, 04:45 PM. Reason: (NeoPa)Added the MANDATORY code tags. (Z) Stepped the SQL for easier reading...Leave a comment:
-
sorry but I spent all day long working at this query and its still not working?Leave a comment:
-
Criteria
okay sir, i have a form called Main and there is a textbox in this form called Text49, this form used to determine the date, so when you put the date and click enter, a query should shows the results of accounts matching the date in the text box, i used to do it in access without problem, but in access project is not working???
i tried to put this formula in the criteria (Like [forms]![Main]![Text49]) like i used to do...Leave a comment:
-
Date Query in Access Project - SQL
I am working in access project, so the backend of the system is SQL, I tried to build a query to retrieve the data based on the date which shows in text box. I wrote in the query the following
Like [forms]![Main]![Text49]
but its not working, can you help me with this formula please?
Thank you in advance for your help -
Thank you, That has solved the issue!
I appreciate it. I spent hours trying to figure this out.
Thank you so muchLeave a comment:
-
still i dont get it can you correct the formula for meLeave a comment:
-
Okay, the formula is in textbox in a form, this form filtering the data, so I need to get the total amount (Dsum) when I filter the data, for example when I write expenses the formula give me the right no
but when I filter the data based on a part of the name such as (expen) the filter is working fine...Code:(=DSum("[AcctGroupID]","2_Account_GroupQ"," [AcctGroupName] = '" & [txtFilterType] & "'")Leave a comment:
-
Dsum for partial match
Please i need help with this formula, I just dont know whats the problem?! it keeps give me error?Code:=DSum("AcctGroupID","2_Account_Group"," [AcctGroupName] = *" & [txtFilterType] & "*") =DSum("Column","Table"," [Column] = *" & [textLabel] & "*")Last edited by zmbd; Oct 9 '12, 06:20 PM. Reason: When posting XML, VBA, SQL, etc... please format it using the <CODE/> button. -
Thank you for all replies, but DSum formula shows the total based on the data in the table not the data in the form after the filter is applied. So in the previous example the total if I apply Dsum formula will be 3200, so this formula is reflecting the amounts in the table not in the form, because it should be 1200.
On the other hand, the sum formula works fine in the form but when you apply the filter it shows Error, so it doesn’t...Leave a comment:
-
Thank you for your reply.. But I don’t want to count the number of record which is I know that it shows in the navigation buttons. I need to create a text label in the footer shows the total (sum) of the amounts based on the filtered data.
For example
No, AcctGroupName, AccTypeName, Amounts
1 Car Expenses Expenses 500
2 Computer Expenses Expenses 400
3 Phone Expenses...Leave a comment:
-
Please i need the answerLeave a comment:
-
okay, I have a table which has the following :
No, AcctGroupName, AccTypeName, Amounts
I made the filter for this table based on AcctGroupName and AccTypeName, (it’s a continues table) it works perfect
My question is I need to add a textlabel in form footer to show me the total amount based on the filtered data.
Sorry about that but I am new in vbaLeave a comment:
-
Get the sum of strwhere table - Filter
I have the following codes which is show me a filter of data from a table, it works fine. My problem is when i run the query in the form i can't get the total based on the filtering data.
MY question is how i can put a text label shows me the total of the filtering data? i need the code for the label?
...Code:Private Sub cmdFilter_Click() Dim strWhere As String Dim lngLen As Long
No activity results to display
Leave a comment: