General :: Creating Invoice Button - Action Query Cannot Be Used As Row Source

Nov 29, 2013

I've created a simple database, with tables, forms etc but I've got stuck when I've tried to insert a 'Button' onto the HOME page which when pressed will display an invoice and give you the option of emailing to client or printing.

I think I've gotten messed up in my relationships or the macros which I've copied from another access template.

on the home screen, I click 'new quote' then 'view quote' when the window pops up and then when it tries to generate the invoice I get the error

'an action query cannot be used as a row source'.

I've put a copy of the database in my dropbox...

View Replies


ADVERTISEMENT

General :: Performing Multiple Database Action On Button

Jul 11, 2012

I am writing an application for my personal use. I have 2 Access databases, one contains the data tables and the other has the forms, queries, reports, etc.

So far, I have been able to use the queries in the Row Source property of my form objects to accomplish what I want to do. Now I want to have a button that appends records to a table, the data in the table comes from several different controls on my form. After doing this the button should requery another control to display the new records added.

The OnClick event for the button allows me to use a Macro builder, Expression builder or Code builder. If I choose to use DAO in VBA code to append the records, do I have to define the database to create a database object to use even though the database is already open? Can I use a Macro to do this? Can a macro reference the data that is in the controls on my form?

View 6 Replies View Related

General :: Button To Create Invoice Per Record On A Form

Apr 18, 2013

I am creating a database for a local mechanical garage, most of it is setup but i have an issue creating invoices, I need to create a button on a form which will create an invoice per record. Trouble I am having is if i have 1 record it will show just 1, but when i add multiple records they all show on 1 invoice sheet. It doesn't separate records, i but instead it adds the extra records before the page footer :/ causing 1 footer for many records. How to finish the functionality of this DB, i can certainly finish the design side. Everything in this DB is set accordingly, just the invoice system to do i believe, could some1 have a look and let me know? i have tried to upload it here but cant so its on this link [URL] ....

View 3 Replies View Related

General :: Opening Specific Invoice From Command Button

Jul 20, 2014

How to modify an existing database template to meet my needs.

I am trying to create a command button that sits on the order details page and that will open up a report i have created called 'picklist' which is basically the same as an invoice but with some different product information listed on it.

I want the command button to open up the picklist that corresponds to the order that i am on e.g picklist #2 for invoice#2

I have 2 issues/questions:

1) I have seen this code on the internet -

DoCmd.OpenForm "SecondFormName", , , "FieldName = #" & Me.ControlName & "#"

Would this work for me if i was to modidy it to:

DoCmd.OpenForm "PickList", , , "InvoiceID = #" & Me.[txtID] & "#"

2) Where do i input this code? If i click on the 'onclick' in the properties form I am presented with this page (attachment):

View 8 Replies View Related

General :: Control Source - Creating Image Based Off Drop Down Result

Feb 3, 2015

I am trying to create a image based off a drop down result. I have had no problem with setting up a image based off a static number. e.g 0456432 in the student id field will bring up students photo in the network share.

What I am having an issue with is the control source will look for a number instead of the name that the drop box displays. this is due to a separate table for the drop box.

what is the expression i need to make in order for the name to appear from the dropbox rather than the source id number?

View 3 Replies View Related

General :: Creating A Button Used To Sent Email

Jul 4, 2012

I'm trying to create a button who is able to send a email with an attachment.The attachment will be all the time the same file.The email address to sent to is one of the field of the database.I need a copy sent in my email address as well.

View 9 Replies View Related

Forms :: Creating New Records On A Form With A Query As Record Source

Mar 29, 2014

In my database I have a form who's record source is a query. That query is based on a table, and have set a criteria on one of the fields.

When I use the form to add a new record I want the value of the field in question to automatically be what I have specified in the query.

Instead, the record is added but without having that value in the field, and when I go back to the form it doesn't display the record because it doesn't meet the criteria specified in the query that the form is based on.

View 2 Replies View Related

General :: Creating Search Button On Form?

Jul 22, 2013

putting a search button on a form on my database.

On the navigation buttons at the base of the form there is a search facility where I can type a record id but I would like to get rid of that and search records either by turning the ID field into a searchable box or by adding a button where I can press it and get a search box up.

View 1 Replies View Related

Creating An Invoice

Feb 18, 2006

I want to be able to produce invoices from my client database, and be able to have more than one item on an invoice. Probably best I attach the db. frmLayClientDetails is the main form with a sub form where I want to display a summary of that client's invoicing. A button on the form footer opens another form where I want to be able to insert multiple lines on one invoice, then a summary of the invoice is returned in the main form's subform. I am getting a message to the effect that I cannot add the detail on the invoice because there isn't a corresponding invoice number in the invoice table. So I'm not sure just where the invoice number is generated. I will also need a calculated field to sum the items on the invoice, but haven't got to looking at this yet.
Any help appreciated.

View 2 Replies View Related

Creating A Printable Invoice

Aug 21, 2004

I have a project for a movie rental company, and I need to be able to account for rentals. So, how do I create an invoice (form or report) that will show ALL rentals for a customer when they check out, AND print it? I have an invoice table, a customer table (customer ID used) and a movie list table, and that works for the form I've got, IF the customer only rents ONE movie, but what if they rent like seven? I'm not sure how to update the "invoice" table to reflect that, then get all of the information into a the required report for printing.
If more details are needed, respond and I'll post em, but I think that about covers it
thanks in advance for anyones help!
ttmmm

View 1 Replies View Related

Creating A Invoice Subtotal Totals Etc

Oct 24, 2007

i was wondering if there is any easy to follow information anywhere or examples with how to do..Specifically on creating an invoice??

The form would need customer details then a subform with the qty, price per unit, extended price then a section on the form which works out the subtotal adds it to freight charges
then gst and finally the total.These all automatically then being placed in there appropriate tables..i Managed to figure this out once before but i cant for the life of me figure it out again..I have spent weeks trying any clues???

View 1 Replies View Related

Forms :: Form Creating Credit Invoice

Dec 24, 2014

I have a form with a subform. The form shows an invoice and the subform the items to be invoiced. On this form I want to have a button that creates a credit of this full invoice.

My question is now how to add the existing invoice and details again to the same invoice table (query) and same details table (query).After clicking this button in the two tables should be the original invoice/details and its credit.

View 4 Replies View Related

Automatically Creating Invoice For Customers Based On Set Parameters

May 8, 2013

I have a database that I will use for invoicing, but I would like it to automatically create an invoice for customers based on parameters set for that customer (e.g., monthly, biweekly, etc.). I have tables containing the customer information, the item they are being billing, the price, etc. I want to be able to have access automatically create the invoices and add them onto the invoice table each month.

Maybe there is a better way, but I thought that if I created a query for all people that are billed biweekly and all people that are billed monthly, that I could run the queries when applicable and then somehow write a macro that would go through the list of customers and add each of them to the Invoice table and add an autonumber. That way I could click run query, run macro, and then do my invoicing. I don't know if that is the way to go or not.

View 8 Replies View Related

Tables :: Creating Invoice System With Subform Within Main Form?

Nov 24, 2013

I'm trying to create an invoice system with a sub-form within the main form. The issue I'm having is that the data in the sub-form keeps getting overwritten each time a new record is created for the main form. So when I go back to edit an older record, the data in the sub-form is changed to whatever the latest record had in it. Is there a way to lock in the data in the sub-form so that it stays with it's own record?

View 1 Replies View Related

Forms :: Change Records Source And Run Query - Onclick Event Of Command Button

Apr 8, 2013

I have a tabbed form in a navigation form with a chart on it. The records source of the chart is a query. The query runs when you click the tab and takes a long time. I changed the Row Source of chart to "" and that eliminates the query running on form load. I've read many posts on changing that row source when a command button is clicked. I tried

Code:
Me!Suspend_Trending_Dashboard![chart].RecordSource = suspend_trend_CHART

in the onclick event of the command button. This doesn't work. I've tried many variations of the syntax. I don't know if I have to tell the query to run after the row source is changed.

On a side note, the query criteria is based on beginning and end dates entered into text boxes on the form. This all works if the query loads when the form is opened.

View 6 Replies View Related

Help Copying One Field To Another With Action Button

Sep 1, 2004

Hi All , Im still quite new to access and would like some help with the following

I have a sub form for a help desk database i have created which states the username and Pc name

i want to be able to press an action button that will copy these 2 fields from the sub form the the equivilent fields in my main form.

i guess i just dont want to have to keeping pressing Ctl c and v each time .


can this be done ?
many thanks in anticipation

View 1 Replies View Related

Command Button To Perform Popup Action

Aug 29, 2005

Hello,

I am having trouble making a command button do what I want. I have a subform within my form, but I only want it to appear when I click the button. I tried using the wizard but there is no option to open subform, only open form. Any thoughts would be greatly appreciated!

View 1 Replies View Related

Forms :: How To Do Some Action After EXIT A Command Button

Mar 25, 2014

Code:
Private Sub Command124_Click()

On Error GoTo Err_Command124_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "PRINTSQUARE 1"
DoCmd.OpenForm stDocName, 3, , , , 4

Exit_Command124_Click:
Exit Sub

Err_Command124_Click:
MsgBox Err.Description
Resume Exit_Command124_Click

End Sub

An command button would open a form to display some query result, and how could I do something after user exit that form!! I have tried to put some action afater the Docmd and EXIT_COMMAND124_CLICK:, both didn't work!!

View 3 Replies View Related

Modules & VBA :: Button Action On Double Select

Jun 2, 2015

I've got a continuous form, with a button (cmd1) on each record. Each record has a unique primary key, RecordID. cmd1 is clicked to open a form (frm1) based on the RecordID using the following code:

Code:
DoCmd.OpenForm "frm1", , , "RecordID = " & Me.RecordID

I want frm1 to open, ONLY when a user clicks on cmd1 while it's already in focus ON that specific record.

View 14 Replies View Related

Opening Specific Invoice From Command Button?

Jul 20, 2014

I am trying to create a command button that sits on the order details page and that will open up a report i have created called 'picklist' which is basically the same as an invoice but with some different product information listed on it.

I want the command button to open up the picklist that corresponds to the order that i am on e.g picklist #2 for invoice#2

1) I have seen this code on the internet -

DoCmd.OpenForm "SecondFormName", , , "FieldName = #" & Me.ControlName & "#"

Would this work for me if i was to modidy it to:

DoCmd.OpenForm "PickList", , , "InvoiceID = #" & Me.[txtID] & "#"

2) Where do i input this code? If i click on the 'onclick' in the properties form im presented with this page (attachment):

View 6 Replies View Related

Forms :: Copy Record Button - Command Or Action Isn't Available?

Jan 13, 2014

I've rebooted my copy record button and just used the macro wizard for now, it seems to work as far as I can tell but there is something strange about it.

I've added in some text boxes so I've got some confirmation, but when I click this copy button I get the following error;

"The command or action 'RecordsGoToNew' isn't available now."

View 1 Replies View Related

Modules & VBA :: Using Access 2013 To Create Action Button In PowerPoint?

Nov 22, 2013

I am using VBA in Access 2013 to make a PowerPoint presentation using data from the access database. know if it is possible to use Access VBA to create a button in the presentation that runs a procedure itself?

View 1 Replies View Related

Comparing Date Field And Trigger Action When Button Clicked?

Jan 9, 2015

I have a table to store "issues" with fields Issue name(text), target date(date) and status (combo box-active & pending statuses). default status for new issue is active. when clicking a button i want to change the status of every record to "pending" status (combo box value should be pending) if the target date<current date.

View 2 Replies View Related

Button Action To Display Information From Contact List On Click

Jan 21, 2013

I would like to know how on a report to make a button action that when i click it present information from contact list (full contact details).

View 1 Replies View Related

General :: Log Every Action

Jan 19, 2013

i would like to log every action any member does on my database.i will have a log in screen(passworded) and i would like to record every button clicked. the only thing is i would like to include other things in the record aswell. like record changes. is there a neat little trick to do this or is it just going to be very labour intensive.

View 11 Replies View Related

Forms :: Save Record For Invoice Before Saving Invoice Items From Subform

Jul 30, 2013

I have a main form and subform. The main form is bound to a table of invoices and the subform to a table of invoice items. I'm picking up the invoice number from the form to save it to the invoice items table, so I need to save the record for the invoice before saving the invoice items from the subform.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved