abouddan
Last Activity: Jul 16 '07, 10:24 AM
Joined: Feb 13 '07
Location:
-
I did what you said but when quering the table the final result is as I put Now() like I discribe in my first post.... -
Thanks for your Advice I will change it.
I mean control source not row source, My mistake. Yes I know it won't save by itself, I am doing it by code when clicking on a button.
What do you mean by "You have to set the control source to the field and set the default value to your expression"...Leave a comment:
-
I have already tried this function but that is not good for my condition:
e.g. 1:
StartDate=1/3/2000
EndDate=31/12/2000
The result using DateDiff =9
but it must be 10 months instead.
e.g. 2:
StartDate=15/3/2000
EndDate=21/12/2000
The result using DateDiff =9
but it must be 8 months instead....Leave a comment:
-
Thank you Adezzi for your time I will try it,
But I think there is something about February. What about If an employee left on 28/2/2000 witch's not the end of the month, in your code this is not considered, cause you are saying that: if month=2 and day>=28 then condition=true, and that is not true in the previous exemple.
Many Thanks for your support...Leave a comment:
-
Thanks for the reply
But I am thinking about implementing this programm in another PC, is it logic to change the settings for all who will implement it?
Another thing let's say we did what you just said, If someone in the future changes by misstake this setting, this code become unusful. So I think there is something else.
Thanks...Leave a comment:
-
Counting months
Hi all
I have a table let's call it "Emp". In that table I have Seq as primery key, IdEmp, StartDate as Date, EndDate as Date.
The same Employe can have many records in that table. "Employe1" can starts work in 18/1/2000 and quit work in 25/5/2001, then restart work in 3/3/2005 and still working till now, So not having an EndDate for the second record. Clear?
Table should looks like the following:... -
Any Help?
10xLeave a comment:
-
insert short date
Hi all
I am trying to insert in my table "Table1" a new record.
This table contains a field "cDate". When using a form to insert in that table the textbox "txtDate' is filled automaticly (row source= date(now) ) and in its format I put "Short Date". The display is very good but when inserting to the table the date field is not short date, it's just as we put in row source "=Now".
So... -
I don't need An extra field in my table All my need of checkboxes is in that form nowhere else. The objective of the checkbox is not storing data it's just to do a paritcular job to some records, and another time do another job to others.
So the checkboxes must be related to this form only.Leave a comment:
-
CheckBoxes in Continous Forms
Hi all
I am trying to create a form 'Form1' that updates my database. Fist this form is based on a query that returns all the records in table 'employe'.
query1="Select id, name, salary from emoloyee"
Form1 is Continous and it shows me all the records and within every record I have a check box. In the form footer I have a button that increase salary of all the selected rows.
The problem is that when... -
Any Help?
I tried those solutions to create a menu in the form, nothing worked.Leave a comment:
-
Thanks for the explanation
What I ment is that Text2 is filled once at the openning of the report, true?
so how can he caculate the result of a query that returns many records?...Leave a comment:
-
Thanks Mary for the support
I tried what you said and it worked very well. But I want to ask: how did that happened? If you can explain. Knowing that Text2 is running once so I expect to calculate the last Record only....Leave a comment:
-
Maybe I didn't axplain well. In the detail section I have a text 'Text1' that calculates a value. It's row source looks like: =IIf(amount<100 0,amount,0)
The 'amount' is a field from the query.
Outside of the Details section, In the report footer I have an other TextBox 'Text2' having in it's row source: = Sum(Text1)
The summation is not working when in Text1 the data is calculated otherwise when Text1 is directly...Leave a comment:
-
Summation in a report
Hi all
I am using Access2000 and I am creating a report based on a query.
Query1=" select Id,name,Amount from Eployees"
This query returns many records, so in the report this result must be shown as if continuous. I did that by inserting a report header and footer. But the preblem is that I want the the summation of a particular field 'Amount'. So what I did is creating a text box in the report... -
Didn't work. Same result...Leave a comment:
-
First I think we should know the format of the field "Name" in the table "companies" . If it's a text so your query should be :
You just have to add a single quote after (name=) and another one in the end of the query. so it's : Double quote, single quote, double quote (" ' ") without any sp...Code:query= "select * from companies where name='" & Forms![Main Details]![CO_NAME] & "'"
Leave a comment:
-
Thanks Mry I think that's it
I am testing this function right now but I think It's OK
Many ThanksLeave a comment:
-
Thanks For the support
I did What ADezzi said, I maid the menu and I added the items needed and from the form properties/others/menu I added the new menu. But I think there something more, when runnig the form the menu appears all alone not as a part of the form. I want that menu to be attached to this form and nothing else.Leave a comment:
-
Thank you Mary For your support.
But this query is not answering my demands , there is something wrong :
- Let's say we are in January, How can this query give me all the records that have the month of the date < January. It's as you are saying give me all the records in witch the month=0.
- Let's say we are in 03/03/2007. And the last record done by Joe is 31/12/2006. This query can't be working here,...Leave a comment:
No activity results to display
Leave a comment: