Bank Loan. Due Date Follow Up, Email Reminders
As our business is growing, we were handled a significant amount of money
from the bank. The money is collected each time we give the bank an oficial
document stating the value of the product we are commercializing.
In GP 8, what is the best way to handle these money loans?, they have a
termination date and we are obligated to pay the loaned money plus interest.
Is GP 8capable of sending reminders?
Thanks in advance
Sounds like this may be handled by the Payables module together with either
Revenue/Expense Deferrals or the Scheduled Payments. You should be able to
...Change date from mm-dd-yyyy to MMM-YY in Access
How do I change a field which contains a date in a mm-dd-
yyyy format into mmm-yy format.
For Example: Ship Month = 03/01/2004
Convert "Ship Month" value to display "Mar-04"
Set the Format property of the field, and/or the control(s) that are
displaying it, to
On Tue, 20 Apr 2004 12:01:52 -0700, "Vince"
>How do I change a field which contains a date in a mm-dd-
>yyyy format into mmm-yy format.
> For Example: Ship Month = 03/01/2004
> Convert "Ship Month&qu...i cannot use the mouse right click in excel. how to rectify?
i cannot use the mouse right click in excel. how to rectify?
Is this just when over the cells ?
Does it work on the title bar - windows options
Or on the Excel menus ?
On Tue, 19 Sep 2006 14:21:01 +0100, j <email@example.com> wrot=
> i cannot use the mouse right click in excel. how to rectify?
Unless the right-click button is frozen, I'm sure you can use the mouse
right-click in Excel
Just hit the right-click button.
Now...........................the real issue
What are you right-clicking on and what doesn't happen for you?
Does the right-click no...Using exchange server 2003 as an smtp server outside of the domain
For the life of me I cannot figure out how to setup exchange server as
an smtp server so that I can use it to send mail from outside of its
basically i want to be able to send email from any computer not on the
domain by using mail.mydomain.com . I'm not sure if the issue is
actually related to something on exchange server 2003, or if it's DNS
related issue. we do use OWA so wthat when we type in a web browser
mail.mydomain.com it takes us to OWA.
Right now if I try setting up a POP3 Account in Outlook and use
mail.mydomain.com for incoming and SMTP servers it err...Grid view buttons
I have added a button to account grid view. this button would open a new
There's submit button in the custom page. when i click that button the same
custom page gets opened.
this doens't occur if i change the winmode of this button to 0. for 1 and 2
values this scenario occurs. the issu is that i cannot use the 0 option as
the window.dialogargumants return as undefined.
How can i stop this new page being opened?.
...Calc date one year from today
Im trying to calculate a date range that will monitor
warranty (364 days) from date of purchase order ??
Thanks for the help
It will even cover the difference between Leap Years and non-Leap
years which your 364 has a problem with.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Ken" <firstname.lastname@example.org> wrote in message
I have an interesting problem (maybe its not so interesting to the gurus who
frequent this board :) ). Here is the back ground information:
I have a form that contains tab controls and several sub forms. The main
form contains a control that dictates what data is displayed on one of my sub
forms via parameters in the query (data source).
So, I have added some code to the "after update" event that looks like this:
I have also tried:
-----------...Datagrid width on a Web Form
I have a datagrid in a web form and I want to be able to determine the
width of the datagrid at runtime.
I have tried both of the following
// Get the width using the datagrid width attribute.
double datagridWidth = 0;
datagridWidth = dgProjects.Width.Value;
// Add the widths of all columns
double dgWidth = 0;
for (int i = 0; i <= dgProjects.Columns.Count - 1; i++)
dgWidth = dgWidth + dgProjects.Columns
Neither of these returns the wi...Using CIPAddressCtrl in stead of an edit control
If I use a CIPAddressCtrl on my property page it does a great job of
handling the 4 bytes with periods but how do I get the address in and out of
the property page in the DataExchange function? Do I have to handle the
DWORD as the exchange data?
DDX_Text should work...
"Rob K" <email@example.com> д���ʼ� news:3zgsf.10739$SM6.firstname.lastname@example.org...
> If I use a CIPAddressCtrl on my property page it does a great job of
> handling the 4 bytes with periods but how do I get the address in and out
> the property page in the DataExchange function? Do I have to handle th...using one combo box to determine content of a second combo box
I have been trying for several days to figure out how to use one combo
box to determine the content of a second combo box.
I am creating a database listing equipment by manufacturer and model #
I would like to create one combo box that gives a drop down list of
Then, based on the manufacturer chosen, I would like to have a second
combo box which gives a drop down list of model #'s offered by the
It seems like a fairly simple concept, but I have poured through the
"using access 2003" guide with no luck
Access version I'm using: 20...Image in Form
Some forms templates in acc 2007 has image to create forms, on the top, it
looks a web page.
Unfortunately I can not manipulate these images to customize. The images are
Somebody else knows where can I find images, similar pictures?
...Date reference in an IIF statement
The following statement works well. It is the default value for a payment.
However, every year I have to go in and change the year.
I would like to have it look at 3/31/(of whatever year it is) so I dont have
to reprogram this every year. How do I change the date reference?
Thanks in advance.
On Wed, 7 Apr 2010 09:16:01 -0700, Presto wrote:
> The following statement works well. It is the default value for a payment.
> However, every year I have to go in and change the year.
> =(IIf(Date...Highlighting just one record in an unbound form
Long time user of Access, First time programming it.
I have an unbound form that takes employee ID's and work order job
information. When they arrive on the job they call in and I run an app to
enter the timestamp of when they arrived.
I may have a list of employees with jobs. My question is how do I or can I
highlight (Bold) the records that I have already timestamped? I have be
trying to use FontWidth but I keep getting all or nothing Bolded.
I tried to look at the Arrived field and if it has no value yet to regular
text. If it has a value then Bold.
Th...error with the form when using asp.
I get this error, when i submit the form. The error comes up and some
technical advisor from my host company told me to change it to ASP Email but
i don't understand what he was talking about. Can someone provide
Server object error 'ASP 0178 : 80070005'
Server.CreateObject Access Error
/WebAppSub.asp, line 9
The call to Server.CreateObject failed while checking permissions. Access is
denied to this object.
...I don't know which formula to use?
I need help understanding which formula I should use. . . I have built a
table similar to the one below on a sheet of my workbook. On a separate
sheet, I need to be able to input ONLY two variables (state and fruit) and
return information (the cost) defined in the table below.
As an example: Inputting the variables of Texas and Bananas should return
$4.00. I need to be able to change Texas to Florida and the formula should
immediately update to the value to $6.00.
Another example: Inputting the variables of Texas and Bananas should return
$4.00. I need to be able to ...dynamic forms (i.e. form with hidden text boxes, calenders etc)
I have one form with 25 different text box, calenders and selection boxes on
the are all hidden except one showing at a time (its being used for users to
I need to put a progress bar, but as the number of input choices changes
dependant on what the user enters, its not as simple as '1 of 25' the other
idea is to put all the 25 catorgories on one side of the form and then
display what the user has entered as they go along. (problem here is that it
means 25 new text boxes !!) any one got any other ideas?
This would be very hard as you stated you never know how man...Please help me: Refresh pivot table using another source file.
My supervisor put an interactive spreadsheet (or pivot
table) on the web. Now he wants me to make changes to the
spreadsheet so that when you click "Refresh" on the
website, this spreadsheet gets new data from me rather
than from my supervisor. How do I do this? Thanks for your
...Add Collapsible data to report or form
I want to show a report with the following levels:
So within each asset class there will be options then within each
option will be dealer groups. Easy enough. Now what I want to do is
somehow show something like this..
[-] Asset Class
[-} Investment Option 1
Dealer Group 1
Dealer Group 2
the [-] are collapsible levels. So I want to initially display all
asset classes and how much is in them, then allow the user to click on
the report, or form and then display underneath the asset classes the
investment ...Payment Terms for specific date
Our client needs to have Payment Terms for specific date. For example, they
want it to be Jun 1, 2009
They sell product but customer doesn't have to pay until June of 2009
Can this be accomplished using GP functionality? If not, what is the best
way to customize/make it work?
Not sure how you would do this without a customization, but here is what you
I assume your customer is running 6-months no interests, no payments type
thing for the month of December (again, just an assumption).
1) You could conceivably setup a payment term called JUNE012009,...Can't remember which Product Keys I have used
Operating System: Mac OS X 10.5 (Leopard)
Hi-I have Microsoft Office 2008 for Mac (Home & Student Edition). It came with 3 product codes. I used one of the product codes and I think that some of my family used one or both of the remaining 2 codes. The problem is that I am not able to verify if this is true or not. <br><br>So my questions is - HOW DO I DETERMINE WHICH PRODUCT CODES HAVE BEEN USED AND WHICH ONES ARE STILL AVAILABLE TO USE FOR MY SOFTWARE? <br><br>Thank you to anyone who can help!
...Duplicating data according to Dates
Well, that's the best description I can think of anyway.
I need help with a solution. I have a set of data (vehicles) that I
have managed to extract a complete history for. This dataset shows the
month and year of every inspection that was completed on the vehicle
according to the location that it was at when the inspection took
place. Here is an example:
Vehicle -- Location -- Year -- Month
Car1 -- Location1 -- 2006 -- 9
Car1 -- Location2 -- 2006 -- 12
Car2 -- Location1 -- 2007 -- 2
Car2 -- Location2 -- 2006 -- 11
Car2 -- Location3 -- 2007 -- 5
Car3 -- Location1 -- 2006 -- 9
My goal is...Need To Add VBA Tools Like A Date Picker
I have written a couple of VBA projects for my company.
Most of the computers run them all fine but some do not.
About half of the computers are running Windows XP Pro w/
Office XP Small Buisness and the other Half are running on
Windows 2000 Pro w/ Office 2000 Small Business. My problem
is that some of the office 2000 computers do not have Date
Pickers in there VBA so they get errors when they try and
run the programs. It says something like error: project
cannot be found. I want to know where I can update my VBA
tools from. Any help would be greatly apprecitated.
...Unable to use Microsoft Outlook
I'm using a Dell 4700C, Windows XP Professional, Internet Explorer 6.0.
I am unable to send or receive mail in Microsoft Outlook.
Thank you for your help,
"meadow" <email@example.com> schrieb im Newsbeitrag
> I'm using a Dell 4700C, Windows XP Professional, Internet Explorer 6.0.
> I am unable to send or receive mail in Microsoft Outlook.
> Thank you for your help,
tis is a little bit less information to help you.
What Outlook version?
Do you use Excha...go through the records in a form from code
i have a table tblPay for Payments and a tblEmp for employees (i have a lot
more but this are the ones involved in my problem) when i go through the
records in the form for employees it auto fills a yes/no field to know wich
ones are overdue in their payments, based on tha tblPay, this works fine
except that it doesn't get filled UNTILL i go through the records 1 by 1 with
the form, if i add a new payment and open the table Employees it doesn't
shows it, i have another form where i need to use that yes/no field so i need
a way to open the frmEmp and make it go through all the records a...Emailing from a form using recursive query results
I am trying to create a button on a form (form name is [BG Paper Info]), when
cliking the button it should do the following things:
1. Activate a query [BG Email from AE Code] that uses a Control [AE Code]
that appears on the form (which can change from record to record), in order
to generate an Email address ([EmailAddress] in the query)to which to email a
The report is generated using another query [BG Reminder letter] that
contains a memo field with the text of the letter, the text depends on a code
[Reminder Type] that appears in the form.
The two queries and the report operate ...