During testing of Manufacturing in GP10 a user processed a MO Receipt Entry
for 15000, then they processed a MO Receipt Entry for 10000 and reversed it
(using the shiny new Reverse MO Receipt function) and then they processed
another MO Receipt Entry for 10000 and reversed it.
Looking at the Manufacturing Item Transaction Inquiry screen for the MO the
Received Quantity is 35000, seemingly ignoring the reversals. I have been
looking around in the KB's and this Newsgroup to see if anyone else has
Has anyone noticed? Is this a "feature" or something else.
Tim ...events in forms
I have Form1() and inside it I instantialize Form2() wich is like tool
Form2() form2 = new Form2();
how can i catch button_click events from form2 in Form1().
A form is a class as any other class so you could expose whatever you want
by adding members to the Form2 class (if I remember you can even make a
member public in the propery window). That said, in this particular case it
might be beneficial to avoid exposing gory details i.e. it could be better
to handle low level events in the Form2 class and expose higher level
...Saving web form fields in Access DB
Today, if a customer completes a web-based form for training, the form
information is submitted via an email to an outlook mailbox. We would like to
develop a macro that parses this outlook email content to a Microsoft Access
Database. How would one go about this?
uh pick up a copy of DreamWeaver
and move to SQL Server
"sunflower" <firstname.lastname@example.org> wrote in message
> Today, if a customer completes a web-based form for training, the form
> information is submitted via an email to an ou...Form is appearing off the screen- how do I get it to come back?
I edited a Access form on a dual monitor machine, and now people with
smaller monitors can't see it- where is the property to determine
where it appears?
...How to select record in the subform and to show it in the main form? 09-27-07
I have subform with datasheet view and I need to know how to select
record in the subform and to show it in the main form?
Forget my last post. I misuderstood your question. The code I gave will
give the record "number" (sort o count from the table start) not the refered
> There are other methods but a simple one to use would be
> DoCmd.GoToRecord acForm, "MainFormName", acGoTo,
> Chan...Updating New Record form
I have two tables set up: tblDeals and tblEquip, they have one field in
common called: DealCode.
I have a query qryEquip that links the two tables based on the DealCode
field and adds other tblDeals fields like Customer, Description, etc, to help
identify the deal but only the DealCode is stored in the Equip table.
Form frmEquip is based on query qryEquip and it is working fine.
Here’s what I’m trying to do: When I add a new Equip record I want to be
able to look into the tblDeals for the right deal and then pass the DealCode
to the frmEquip, then have the frmEquip pull the rest o...How to reuse a form?
There are many forms needed and each one only has buttons, labels and
captions on it. Here is my design idea. I would like design one form and
reuse it with a different set of buttons, labels and captions.All these infos
can be retrieved from a table when a form is being built. Could you give me
some hints or your ideas how to do it
thank you so much for your help
One suggestion would be to use a tab control on a form. Have each tab
control to hold each set of labels and controls with their captions. Then
when you are ready to use the form, hide the tabs altog...Search by Form with Checkboxes
I have Access 2003. One of my Tables has multiple fields with the Data Type
Yes/No and a Display Control of Checkbox.
I have a query by form with multiple text boxes and a related query. One of
my query examples is listed below.
Like "*" & [Forms]![F_CatSearch]![txtGumChewing].
I need to be able to make multiple selections for my query's output. My
problem is in the form I have to put "-1" in the field for my query to work.
I want to be able to have a checkbox in my form so the user can check the
items they want selected in the query.
Can anyone help...Not able to add or edit records from an input form.
I have an MS Access input form that is based on a query that is based on a
table called Training. The Training table is actually an SQL Server table
that is linked. There are three fields in the table: ID (The primary key),
CustomerName and TrainingDate. I added three records into the table using
SQL Server Enterprise Manager and can add more. However, I can't add them
using my access form. I can view them but cannot add. I can't edit them
either. What setting do I make to allow edit and adding to occur? I posted
this question in the sql server forum and was ...Refering to control property on a form in VB
I am trying to simply my code in a application by using a sub routine
to amend the control properties of a form but I can't seem to get
basic to accept the control property being sent to the routine as a
The code I am using is :
Private Sub lSubControlPropertySet(stForm As String, stControl As
String, stProperty As string, varValue As Variant)
If IsNull(varValue) = True Then
Forms(stForm)(stControl)(stProperty) = ""
var...Forcing users to use a custom Contacts form OR removing Contacts
Using Exchange 5.5 and Outlook 2000
Is it possible to set it so all users use a cusom contacts form for new
items in their "Outlook Today" folders?
Or better still, is there a way to remove the Contacts folder, or make
it point to a folder in the public folders tree?
...Copying records from one (sub)form to another subform using Append
I have a mainform with products (and thier details) from a products table and
a subform showing ingredients (from an ingredients table).
I wish to select existing ingredient records from one subform and copy them
to so that they appear as ingredients in a new Mainform.
I have a selection box next to each of the ingredients to enable selection
but how do I "copy" these selections to the new record on the new mainform.
Do I use an append query to do this? Any guidance on doing this would be
great (not too experienced in this area).
On Tue, 9 Feb 2010...Popup form resizes itself
I have a popup form which resizes itself each time it is opened,
necessitating a manual resize so it can be used. I've changed the following
properties, but don't seem to be able to stop this from happening.
Scroll Bars - Vertical Only
Record Selectors - No
Navigation Buttons - Yes
Dividing Lines - No
Auto Resize - No
Auto Center - Yes
Border Style - Sizable
Control Box - Yes
Min Max Buttons - No
Close Button - Yes
Open the popup form in design view. Click on Restore button to make it show
in the "smaller" size. Resize the form to the size you want it to have wh...CRM for GP or SBF
Question that I think will be interesting for everybody.
Is there any CRM (microsoft, 3rd part) integrated with SBF or GP?
Any suggestion, because SBF is good but everybody wants more and more.
Microsoft CRM 3.0 integrates with GP 9.0 through the XML processing engine.
As for SBF, there are a few third party add-ons that are available, and it's
possible to integrate it with CRM 3.0 as well.
"Vitali V" wrote:
> Question that I think wi...Check if a form has changed since it was last saved
I am developing an application using an ms access front end and a
visual foxpro 8 backend. The application uses adodb connections to add/
update/edit data in the back end database. When a user clicks the
save button on main data capture form the user input is
programmatically inserted into a new record or an existing record is
updated by creating SQL INSERT INTO or UPDATE statements on the fly.
I was wondering if anyone knew of an efficient way of coding a
mechanism to check if the form had changed since the save button was
last pressed. I guess this can be achieved by capturing the On Chan...Clearing form to enter addl info but keep history
I have a form with billing info that includes Billing Date, Billing Reasons
and Billing Due Dates. The Billing information is on a tab on a form. There
could be multiple dates and reasons.
What I would like to do is have a way that once the billing info is
completed for a specific date, be able to enter another date and more billing
reasons, so that the fields on that tab are "cleared' however, I will need to
query for the information that was "cleared" for reports.
When I tried "adding new record" it goes to the next customer on the li...Query with Combo Boxes on a Form
I'm using QBF with about six different combo boxes using:
[forms]! [formmain]! [combo1] or [forms]![formmain1]![combo1] -like in a VBA
book. This is so users can select criteria on a form with the combo boxes,
and when they are done, they hit the search button, and it opens up another
form based on the query just performed by the combo selection.
This worked for about three combo boxes, but when I added another one, it
freezes up and opens up a blank page. It's supposed to open the new form
based on the query.
Is there a better way to do this?
Any help would...Update from previous versions to GP 10.0
Can I update GP 8.0 to GP 10.0 or I have to update first GP 8.0 to 9.0 and
then GP 9.0 to GP 10.0?
Please help me as soon as possible, I need to make decisions.
Put service pack 5 on version 8, then update from there to 10.0
Make sure you also immediately use sp1 for Version 10
"arielqs" <email@example.com> wrote in message
> Can I update GP 8.0 to GP 10.0 or I have to update first GP 8.0 to 9.0 and
> then GP 9.0 to GP 10.0?
> Please help me as soon as possible, I need to make dec...how to create simple forms
how do you create simple forms in outlook to use for surveys?
See http://www.outlookcode.com/d/forms.htm However, unless you know that =
every recipient is using Outlook, an Outlook custom form is not a =
solution for surveys.=20
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
"Kenneth" <firstname.lastname@example.org> wrote in message =
> how do you create simple forms in outlook to use for s...Need historical tracking of activity coming into GP via eConnect
Currently if transactions come into GP via eConnect then get deleted for some
reason, there is no audit trail of what happened to these transactions.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrows...Renaming forms tables and reports
Is choosing "save as" and making a copy and removing the original the only
way to rename a report, table, or form? I started with the Issues template
but I want to change the names of the objects. I can right click and rename
the shortcuts in the navigator window, but the name doesn't change and the
references are still under the old name. I do not want my shortcut to be a
different name than the reference name because then there will be confusion
for database maintenance.
I've also tried renaming the objects in their properties window, but I
couldn't find a na...Populate sub form
I have asubform that is linked to the main form via one field, multiples
entries are allowed in the sub form, but the linked field is the same for all
I can add new records manually in the sub form okay.
What I want to do , sactivate a query/programming etc that is done by
clicking a button that automatically adds several records to the subform from
a table that contains potential data items based on a field in the main form.
ie if the item in the main form is set to tru, then the sub form is to have
several specific records added to it.
how do i do populate the subform ...Problem with Analysis Cubes for GP 10 FP1
I got it installed but when I try to run the SSIS packages I get an error.
Error: Error 0xC0014049 while preparing to load the package. Cannot find
What did I setup wrong or how do I fix?
Microsoft SBF Specialist
Is the folder, in fact, there?
I recently installed it using as much of the default settings as possible
and had no problems.
Charles Allen, MVP
"Japheth Nolt" wrote:
> I got it installed but when I try to run t...Allowing and Saving Data in Form Fields
Operating System: Mac OS X 10.5 (Leopard)
I have created a Word document with form fields that is password protected. When I saved the document, I selected "Track Forms". However, my recipient is unable to save the data they input into the form field. How do I allow this?
I am not quite sure what you are doing, because your terminology does not
exactly match what I see in Word.
I suspect the issue is that the document must be protected for forms to
enable the form fields. If the document is not protected for forms, the
user cann...HELP:user-fill in form
I need a excel-file with 2 tabs.
In the first tab It must be able to fill a week nr. And then som
Then that values must automattically filled in, in Tab2 in the righ
column of that week.
If you can help me, please reply !!!
Thanks in advance,
Message posted from http://www.ExcelForum.com
You weren't very specific as to if this is from one cell on sheet1 or for
all cells in a column. In any event, you can use a worksheet_change event on
a worksheet module to this sort of thing.
"Stift >" <<S...