DoubleD
Last Activity: Feb 25 '16, 07:59 AM
Joined: Jun 9 '15
Location:
-
Thank you mbizup. I will give it a try. -
Continuous Form do not allow updates until button click
Hi,
I have a bound continuous form which I filter on load. I have the following 2 questions:
1. Can I disable the automatic Add/Update until I click a button?
2. On button click can I only Add new records or update only the records that have been edited? -
Thanks for your input Seth. You put me on the right track. What I did was to add a column to the header table called "Printed" which I flag with either a 1 or a 0. In the report query I then add a clause where printed = 0. So basically when the user creates the PO, it sets the printed flag to 0 and after the report prints, I set the flag to 1 so it won't reprint older purchase ordersLeave a comment:
-
That makes sense. Now how would I go about getting the PO numbers in to a list? My PO numbers are all formatted like this PO00001, PO00002, etc.Leave a comment:
-
I am filtering on the header id. Let me explain the process:
I have a continuous form (let's call the stock sheet) with all the items on and their respective linked vendors. The user chooses which items to order from the stock sheet by adding a quantity to order in a text box. The user the clicks a button which creates the header and details. The header and details are linked by PO Number.
This then opens another continuous...Leave a comment:
-
Hi Seth. I have 2 tables, one for the header and the other table for details. I have already set up the query for the report to join the 2 tables and only show the data that I need, i just can't figure out how to filter the query to only show the purchase that i just created on the report. The report only shows the last purchase order that was created even though i have created 2 purchase ordersLeave a comment:
-
Reports for multiple records
Hi,
I am very new to reports in Access 2007.
Here is what I currently have:
I have an application (Access forms) where users create purchase orders. Users can create multiple purchase orders from one form (i.e. order multiple items from different suppliers. The system only creates one purchase order per supplier). I have also designed a report and I can call the report from the form
What I need:... -
Great! This works exactly the way I need it to. Thank you so much Seth!Leave a comment:
-
Having it stop on that record will be helpful.Leave a comment:
-
I need it to check if the arrival date has a value and for each line that does not have a value, it must throw message box stating that no date was entered.Leave a comment:
-
Hi Seth,
The form that loads gives me a set of data based on what was entered in a previous form. I need the validation to happen in the click event of a button on this form, because it needs to run a few insert, update and delete queries.
I need it to check that the arrival date for each line on the continuous form is filled in before it can continue doing everything else.
Doing the validation in the form's...Leave a comment:
-
Validate values of controls in continuous form
Hi,
I am struggling to find the right solution for my situation. I am still very new to Access, continuous forms and VBA, so excuse my ignorance
I have a continuous form in Access 2007. One of the controls on the form is a text box with an expected arrival date. This control can be edited by the user. I need to validate that this control is not blank before running my insert and/or update SQL queries.
... -
Thanks Seth. I will go look at the Northwind Sample, but it sounds easy enoughLeave a comment:
-
Time to revisit this question as I finally got m continuous form to work the way I need it.
By the way, I am using Access 2007 and am still very inexperienced in Access
I have created a POHdr table and a PODtl table. The POHdr table will have the Document Number, Vendor number and Name, Date Created, Delivery Method and Document Totals. The PODtl table will contain each item on order line by line, which includes Item Number,...Leave a comment:
-
Thanks Rabbit and Seth. I did add the field in the table and this resolved my issue.Leave a comment:
-
Thanks Seth. I can't have the control in the header or footer as it needs to form part of the data.
I tried adding a blank column to the query, but that does not allow for user input.
I'll have to find another way to do this then.Leave a comment:
-
Continuous form replicating unbound textbox to all rows after update
Hi,
I am using Access 2007 and am very new to continuous forms. I am trying to figure out what I'm doing wrong or maybe I'm going about this the wrong way.
I have a continuous form that gets it's data from a query. The query is getting data from 2 tables that are linked using a Left Join.
All of the text box controls on my form populate as expected. I then placed an unbound text box on the form which... -
This sounds perfectly normal. The tables in MS SQL where I will insert my data are called tblPOHDR(holdin g the PO header info, date created, document type, document number, vendor info) and tblPODtl (stock item, quantity ordered, cost, etc).
I guess i should go back 1 step and tell you how i get my data and what my idea is to create the purchase order from Access.
I have created a continuous form in Access that is based...Leave a comment:
-
Hi Seth,
As this is a new application that we're designing for the customer, I haven't even started structuring the tables for the purchase orders yet (I agree that it should be more than one table).
The idea is to dump the data into a temporary table/s and from there write it into 2 MS SQL tables. I'm just not sure how I would go about creating a purchase order for one vendor with associated items and at the same time a...Leave a comment:
-
Grouping data when inserting
Hi,
I need some assistance or ideas on ho to group data when inserting to a MS SQL table.
I currently have a continuous form that an "overview" of my inventory including vendor details, stock levels and sales history.
I now need to create a routine that allows the creation of purchase orders directly from the continuous form. Example, when a user selects item 1234 to be ordered from vendor 1,...
No activity results to display
Leave a comment: