RE: Saving Form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi, DistrautMan.

I'm not sure what you mean by "saving" it. If your form is bound to
table(s), it already is saved. You can pull that record up at any time to
look at the information or edit it if necessary. A hard copy can be printed
at any time by printing a report that is based on a query that filters your
recordset by the currently displayed record.

As far as deducting quantity purchased from available inventory, I'm not an
inventory expert, but there have been plenty of threads on this topic here
that you can search. Basically, I believe you would run an update query on
your inventory table.

Hope that helps.
Sprinks

"DistrautMan" wrote:

> ok well first how can i put my form fields like drop boxes on to a report if
> i cant edit things on a report and second, each invoice contains, customer
> name and number, and what they buy, i need to be able to save that so that
> at anytime i can pull that information up and see what they bought. right
> now i have a perfectly fine template in word but i need to make one in access
> so that one, it tallies up totals automatically and i did that, and two it
> automatically subtracts from the in stock value from my table when i put
> something in the quantity text box for the product, and i havent figured that
> out. but now ive run into the problem about being able to save it so it
> looks like it does when i print it with all the information about the sale.
>
> "Sprinks" wrote:
>
> > DistrautMan,
> >
> > I forgot to mention that since you can recreate the report, or look at the
> > record on a form at any time, why would you need to store a copy of it?
> >
> > Sprinks
> >
> > "Sprinks" wrote:
> >
> > > Hi, DistrautMan.
> > >
> > > I suggest you recreate the form's look in a report, and use a command button
> > > on your form to output it in rich text format to a document. You can set the
> > > filename in your command button procedure, or ask for a filename to be input
> > > using the InputBox function.
> > >
> > > Base your report on a query that contains all necessary fields, and has
> > > selection criteria referencing the currently displayed record:
> > >
> > > =Forms!YourFormName!YourPrimaryKey
> > >
> > > Dim stDocName As String
> > > Dim stFilename As String
> > >
> > > stDocName = "YourReportName"
> > > stFilename = "YourFileName" ' or use InputBox to get a filename
> > > DoCmd.OutputTo acReport, stDocName, acFormatRTF, stFilename
> > >
> > > See VBA Help on the OutputTo method for further details.
> > >
> > > Hope that helps.
> > > Sprinks
> > >
> > > "DistrautMan" wrote:
> > >
> > > > ok i have a form that i use as an invoice at work. i need to be able to
> > > > export it out of access in a seperate folder called customer invoices. two
> > > > problems: one it doesnt keep the layout format i have, it trys to convert it
> > > > and it looks completely different, so i need to know how to keep it still
> > > > looking like its a print preview, and two: how do you save it so it keeps the
> > > > values i entered in the fields, such as text boxes and drop down menus. thanx
.

Quantcast