Form to populate table issue

I am using a form to update invoice entries.  The form pulls info (the 
funding source) from a different table, based on a parameter query.  When I 
enter the parameter info, the query populates the funding fields 
automatically from the funding table.  This works great.  My problem is I 
then enter invoice info (amounts) in the form for each funding source.  When 
I check the invoice table, the amounts are there, but the funding source info 
is not.  

Somehow the table is only taking the info I am typing in on the form, but 
not the info that is being supplied through the parameter query for the form. 
 Can anyone help?  I need the amount as well as the funding source info to be 
saved from the form.
0
Utf
2/11/2008 2:17:06 PM
access 16762 articles. 3 followers. Follow

0 Replies
494 Views

Similar Articles

[PageSpeed] 34

Reply:

Similar Artilces:

GP 10 Payroll YE issue?
I am searching to find out if there is an issue with GP 10 Payroll and I have been on Partnersource looking for information. My client successfully closed the PR year end. We installed the update for 2010 payroll and are now entering PR for the first pay run for 2010 15 Employees had previously been setup with a Garnishment deduction and each of these employees met the “lifetime” amount (the amount was reached in 2008 for the lifetime deduction for all the employees in question). The summary screen on the employee card for this deductions reflects this as well. We build a ba...

Lock a Table
Hi All, Is there a convenient way to programatically allow the current user to have full access to a table in the current db, while preventing other users from accessing it until the program releases it? -- Mac C. Thanks Larry, I should probably be more specific. The table is used for temp storage of records that will be accessed by another application (MsWord via merge mailing). A form in the database is bound to the table. When the form opens it invokes a public procedure that deletes all records in the table and rebuilds it from scratch. After that proc returns, the form requi...

Pivot Table
I've got a Pivot Table with a dimension called GLGroup placed in the row position. Within GLGroup, I've got the descriptions Sales, COS, Expenses, Other. Is it possible to create a calculated item based on your selections within GLGroup? For example, I would want a calculated item called GrossMargin for the GLGroup(Sales) less GLGroup(COS). Is this possible? Maybe a visit to Debra Dalgleish's site: http://www.contextures.com/xlPivot06.html will help. I often add extra columns to the original data and add formulas there. Then I use those extra columns in my pivottable. K...

Outlook 2003 / Exchange Find issue with Shared Calendar
Hello, Here is the set-up and the issue: There is an Exchange 2003 server (with RPCoHTTP). There are 3 users accessing the Exchange server with Outlook 2003 on Windows XP SP2. One user has a calendar, which is shared, and owned by the two other users (The users do _not_ want to use a public folder calendar, since some PDA software they use cannot sync with a public folder, don't ask). Since the calendar is owned by everyone, everyone can make changes. Issue: If the user whose calendar is shared tries searching his calendar for, say, all entries with 'xyz' in name, he sees all of...

Could not delete from specified tables. (Error 3086)
I have a delete query that works as select query, but will errors when changed to a delete query. As part of the query I have the table I am deleting the records from as well as a query limits to records to be deleted. The main table contains invoice attributes with a multi-field primary key (invoice number & revenue category). The query may list multiple invoice numbers, but always unique. So the relationship is always many to one. I ran into a similar situation with update queries, but once I converted the limiting query into a Make Table Query and used the results of the new...

setfocus between the datasheet and form on a split form
Hi, I have a textbox on my form and using the split form view. I would like to switch the focus in vba. Is there a way to do this? Thanks, Sue ...

help needed in printing contents of a form view
hi all I am working with formview . I want to put all the content that i am displaying on the formview to the clipboard so that i can print it from there. I tried to put contents into clipboard but problem is that all the screen is now get printed. i only want the view area to be get printed. sorry for my english. can any one help me . with regards Harish Harish, I'm sure I have answered this one :-) To recapitulate: If you looked at the code on Joe Newcomber's site, notice that you select the window from which you create your bitmap, so: void toClipboard(CWnd * wnd, BOOL F...

Login Issue to CRM
We've enabled access to our CRM server from an external IP address, but when people try to login, they are forced to put in the domain (domain\username). Is there a way to ONLY sign in with a username & password? Thanks ...

Pivot Table ... Stacked Col & Area Graph
Excel2003 ... I have a Pivot Table "Stacked Col" Chart reflecting operators & the time they charged to a part ... Sometimes an operation is completed by 1 operator (sometimes multiple operators) ... So far this part of the Chart works fine ... Now I would like to add the "time" the operation "should take" ... & I am thinking I could do this as an "Area" Graph behind the Stacked Cols. (note: if my operations were completed by a single operator then I can put the Area Graph behind a Col Graph & all is fine. However, when I hav...

Linking tables with forms
Hi, I'm still a relative beginner with Access, but I've not done too bad :P However, I'm finding one thing very confusing. Here's the scenario: I am writing a multi table db, and I need to link them all up via an index, so one form can easily display data from the others. For example: I need to display a name, located from one table, and then in a seperate table, store values from yet other tables. For some reason, I am finding this a little bit of a pain to do - I can't seem to get the values loaded correctly. It's no problem if they are simply from a table, but t...

Date Major issue
If we have one data base for everything how do users enter the dates? In Americas they use mm/dd/yy in the rest of the World dd/mm/yy. If the data is in the data base and I want to enter a parameter into a query of 12/2/06 what date does the data base give me? Feb 12, 2006 or Dec 2, 2006. I think it depends on the date format specified in Organization Settings. That should reflect across the system. HTH, Niths "Efrat" wrote: > If we have one data base for everything how do users enter the dates? > In Americas they use mm/dd/yy in the rest of the World dd/mm/yy. >...

Camapign tracking issues
Hi this is my problem: I send off a campaign email and everything goes off well. campaign responses get tracked etc. However if I send off an external email (not incl in campaign invite) and that individual replys to it, it gets tracked with the campaign token...why is this happeniing. If I exit outlook straight after sending the campaign invite, this doesnt happen. ...

GP Setup Checklists or Forms
Is there a good source somewhere for help in getting an implementation started? I'm looking specifically for forms or checklists that can be given to the customer for Vendor Setup or Customer Setup or any other module setup. My customer showed me some input forms she got from an MBS competitor when they went through that implementation and she thought it was helpful. I've been creating my own but it's time consuming. Thanks! Look for this on PartnerSource: Microsoft Dynamics GP Consultant Toolkit There's a lot in there. If you're looking for a specific thing you...

Why aren't dates always available to group in pivot tables?
I download data that gives me sales number by individual day. I build a pivot table to get total sales by day and then group the process day by month or quarter. Sometimes this works perfectly, while other times I get the message 'Cannot group that selection'. Has this happened to anyone else? Is there a limit to the number of rows or columns that can be grouped? You'll see that error message if the date field contains a blank cell, or text entry. There's a bit more information, and some workarounds, here: http://www.contextures.com/xlPivot07.html#Problems JLM wr...

Combobox populated
Hi, Before I print a report by clicking a command button [btnPrintRpt] I select a record from a combobox list [cboCandidates]. This is then the basis of the report. Firstly: How do I make the command button check to make sure that a record is selected Secondly: Is it possible to make the combobox empty again when the command button is clicked to print to prevent the user accidentally printing off multiple records. Here's hoping Regards John Sure. Private sub cmd_Print_Click if LEN(me.cbo_YourComboName & "") = 0 then msgbox "Select an item from th...

How to dynamically populate series for an XY chart?
Hi, Here's what I'm trying to do, and if you can help me get it to work, well, I'll be thrilled... I have a sheet in which users enter up to 48 tasks. Each task is prioritized as 1, 2, or 3 (Column A), and has specific X-Y information (Columns B and C) for plotting the task on an XY chart. I would like to graph these as separate series such that all the 1's are one series, all the 2's are another, etc., so I can use separate markers to differentiate them. The problem is that *any* given task can be a 1, 2, or 3, and there is no limit or expectation around how many of ea...

Calendar issue?
I have a user who's outlook locks up while accepting a meeting request. We have Exchange 5.5 server. He is currently using Office XP (so Outlook 2002) but we also tested by putting his email profile on another PC with outlook 2000 on it (like most of the rest of the users) with the same result. This only happens when dealing with meeting requests. After either outlook is terminated or the request finally goes through (sometimes taking 40-50 minutes), things work pretty much normally. He may have to exit and go back into outlook to work in the calendar OK. It is only for thi...

how to create a chart in a form of a triangle
OK, I need to visualise a composition of a mixture of three components. I need an isosceles triangle, each side from 0 to 100% of A, B and C. Then a point inside to mark (visualise) cmposition of three components. Doable in Excel? Thanks in advance for advice. Hi, Here are some links, from previous postings, on ternary plots. http://www.sfu.ca/~marshall/ternplot.htm http://www.uni-wuerzburg.de/mineralogie/links/drawing/ternary.html http://www.geologynet.com/programs/ternplot.xls http://www-sst.unil.ch/perso_pages/jfurrer/Applications/Trixcel/Trixcel.htm http://www.agri.upm.edu.my/~chris/ta...

Gift Voucher issues
We just had (yet another)POS crash when trying to tender a sale. Normally we can make the adjustment for cash/credit/debit at closing but this time it was on a Gift Certificate and the system doesn't grok that and even though it shows the items as sold, it did not subtract the sale from the GC and now shows the GC balance as 164.54 higher than it should be. Also I just realized that Gift Certificates seem to be double entering in Sales, as Sales includes the GC being sold initially AND then again when the GC is used. Meaning that our Total Sales Volume could be thousands of $$$ off. Any ...

Temp Tables in FUTA/SUTA Reports
Hello: Since the FUTA and SUTA reports are built on temp tables, is it possible to modify them in Report Writer? The client would like to add the employees' department to the FUTA and SUTA monthly and quarterly reports. But, I cannot build the necessary relationships in Report Writer--it won't let me. This is probably because the reports are built on temp tables. Would Crystal have to be used? Thanks! childofthe1980s Nevermind! I figured it out! Sorry for the bother! "childothe1980s" wrote: > Hello: > > Since the FUTA and SUTA reports are built on te...

Help Needed with a Tricky Validation Issue
I have a text field in a database that the only formats that can be entered are as follows: v99.9 , 999.9 v99, v99.99, 999, 999.99 the 9’s can be any number ex: v34.6 or 234.5 or v45 or v34.55 etc what is not acceptable is 79.90 How can I check the data being input to make sure it is in one of the allowable formats? The data is entered in a textbox on a form in an Access 2007 database Thanks! AB Hi, The simplest way would be to use this as the Validation Rule on the appropriate column in the table: Like "v##.#" Or Like "###.#&...

Load Excel data in a SQL Server table
Hi all, what's the simple way to read an Excel file (always in the same format and name) in my WinForm and pass this data to a SQL Server stored procedure? Thanks in advance. Luigi "Luigi" <Luigi@discussions.microsoft.com> wrote in message news:D5FCDFDA-7BFD-4358-858F-15A391C19B7A@microsoft.com... > What's the simplest way to read an Excel file (always in the same format > and > name) in my WinForm and pass this data to a SQL Server stored procedure? http://www.google.co.uk/search?aq=f&sourceid=chrome&ie=UTF-8&q=Excel+OleDb ...

Find and Replace against set of rules in 2nd table/worksheet
Looking for a tool, or code that does the following. Edit [partial cell data] in Sheet1, if [partial cell data] meets criteria in Sheet2, COL1. Sheet2, COL2 has the REPLACE WITH information. Presently there are 59 criteria on Sheet 2, and I have to perform this against 19 sites. So doing this manual via Find and Replace takes forever. VBA code, or something similar would be great. (Wanted to write an Update Query Access, but Access sent me here.) Thanks in Advance TBL1 COL1 Mari Johnson Jim Evans Charles Stanley Jerry Straight TBL2 COL1 COL2 Mari Mary Straight Strait See,...

CSplitterWnd issue
I've got everything in place for a static splitter window. The left pane has a CLeftView, and the right pane has a CRightView. Everything works great so far (i.e., both views display what they are supposed to and they interact accordingly). My question is about the original CView referenced in the app's InitInstance() method. It's not used but I'm not sure what to do with it, if anything. Any ideas? Thanks, DC David Crow [MCSD] wrote: > I've got everything in place for a static splitter window. The left pane > has a CLeftView, and the right pane has a CRigh...

Linking many EXCEL tables into a long WORD document
Would anyone have direct experience with linking lots of Excel tables into complicated Word reports - say 100 tables into a 100 page document? I tried this years ago shortly after OLE came out, but the document's links got confused, with Excel occasionally getting confused about which worksheet tab and range belonged in which Word table. This was not a case of my error, nor of corrupted files due to crashes, but was confirmed as a problem with Excel by a person knowledgable of its codes and bugs back then. Needless to say, I stopped aiming at having these live links in my docum...