Yes, this is the right data but for the money part, is there a way to get the result based on the month we are in. example, if we pay monthly $1000.the result sould be $4000.00 for the above example.
The respns is that we have alot of recurrent requests for year long that we pay monthly...
I have a query that I would like to run to get how much money have we paid in a period of time.
SELECT ProjectAct_tbl.StartDate, ProjectAct_tbl.CompletionDate, ProjectAct_tbl.Rate, ProjectAct_tbl.AmountReimb, ProjectAct_tbl.Quantity
FROM ProjectAct_tbl;
Example:
Start date completion date...
yes. It is a specific design that looks very strange. The background of it looks like the globe in top of someone's head. I am not trying to be funny. but that is what it looks to me. The combany wants all thier reports to come with this type of background. I thought about making copies and...
All,
I have a company template that we must use in reporting. I can not use anyother design. I want to see if I can use this temlate to be part of access database. is there a way to do this?
I would like to create custom autonumber that will contain the following:
firstletter from firstname
first letter from lastname
dateof birth.
John Smith 04/05/2008
JS04052008
How can I go about doing this?
Thanks
Hello,
I have an invoicedetail_tbl that has invoiceDetaildescription field (Memo). I see before the text some time and at the end of the text </div>. some time I see
<div> </div>
it happens randomly. Sometime, I do not see it at all. Some time when I open the form, I see it
Any...
Hi All,
We have several people in our office with different screen size. Some use laptops. Also, some people because of vision problems, the font size is very large and the resolution is not the same like the rest of the people.
Now, the Access database we use appear different from once screen...
Thank you for all the feedback and suggestions.
JBinQLD (Programmer): That is exactly what I am looking for (Principle) since I know how to use access by itself with a little, very little in the coding side.
fneily (Instructor): If I knew about the course when It was offered, , I would have...
Hi ALl,
I have been looking for classes to teach VB for access to improve my skills, but everything I see is in the .net area. Do you suggest any school or on line courses, good books. I took access classes but usually I do not learn anything new in them.
Hello All,
We have several scheduler in the office who schedule for different people work orders. I want a msgbox to appear if one scheduler try to schedule same employee for different work order that falls between or on the same two dates. (startdate and enddate). It is Ok to schedule, but we...
It worked perfectly. But one problem is that he combo can be left blank which will not work. If the purchase date is not null, making a choice in this field must be mandatory.
Thanks
Hello,
I have a combobox that have yes and No value. The row source is Value List. The name of the combo is shippingneeded
I want a message box to pop if someone chooses yes. The msg will be “Call shipping dept at 222.” If no, then nothing happen.
I truly value your suggestions!!
Hello,
I have the following codes in the load event. If the purchase date field is not null, the user must choose something from the combobox (shipping needed). Right now, the box pop up but if we select Ok in the msgbox, it close the form. I want to be able to have the cursor set in the...
Hello
I have a calculation formula in a field, [workdays]-[offdays]-1. the result sometime shows negative number. I want to include in the formula if the total is negative, the result will be zero.
Any Suggestions!!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.