A SALES Form that can update both PRODUCT & SALE Tables
Well, allow me to ask this question!
Am creating a Product-Sales Database, and I would like the corresponding
Sales made in the Sale Table to be automatically deducted or to be reflected
Product Table. The product table contains all my stock and has a relationship
with the Sales Table. The Sale Table does not necessarily include the Stock.
I create possibly a Sales Form that will be used as an entry point for all
the products (stock) sold and automatically register the sold products in the
Sales Table and
at the same time make the required adjustments in the Produ...Split form problem
I’ve created a contacts form with a browser control to preview a picture. In
order to refresh the browser I’m using the form_OnCurrent event. This is
working fine in a single form but fails when I navigate in the split form
datasheet. The main problem seems to be that Access runs my code in the
context of the split form datasheet and not my main form. A similar problem
is also occurring when resizing controls in split form view; Access resize
controls in the split form datasheet and not my main form.
Is there anyone else experience this behavior?
What do you mean by "synchron...Create a Web Address on a Form for Followhyperlink
I am trying to create a web address in Access. I have a form that
text boxes numbered 1-8. It is my intention to concatenate the text
in the text boxes to create an address then use the followhyperlink
method. I can create the string that I need but I get an error when
the code gets to the followhyperlink method; runtime error 490 cannot
open the specified file.
The reason why I intend to concatenate the text in the text boxes is
to allow the user flexibility. Some portions of the address are
to be static and others are going to depend on a value in a list box.
Here is an exampl...Form will not allow data entry 01-30-08
Today my database which has been working fine for 10 years quit working. I
have tabbed controls of which some are subforms. All of the subforms work
fine, but the tab-control pages will not allow any data entry and no error is
given. I checked to make sure that the page properties and field properties
are not locked. I can enter data directly into the backend of this database.
Why would this happen to only tab controls and not subforms. I suspect this
is a problem of the back end as prior front ends (that have not been used
for months) do not allow the changes also.
Any suggestions....Office saves docs in app folder
A friend has Office 2004 on Mac OS 10.3.8 and complains that it's
sometimes, randomly, saving docs into the Office folder in Application
instead of into the Documents folder.
He never said *which* of the apps in Office, though.
Is there a fix for this?
in article ei4APQAKFHA.1052@TK2MSFTNGP10.phx.gbl, Jonny at
firstname.lastname@example.org wrote on 05/03/13 11:37:
> Is there a fix for this?
When you "save" a new document, you get a dialog box showing a proposed
folder location. Your friend needs to learn to look at this and browse to
the desired folder if desired.
Al...Getting ' database full' error message trying to save in Publisher
I am getting a pop up error which states 'The disk is full trying to write
C: etc etc. Save this file on a different disk and/or drive."
My C; drive has plenty of space and when I try to save to a CD, I get an
error message as well.
This is a trial version of Office which has about 28 days left of a 60-day
trial if that makes a difference. Last night I WAS able to save the same
I am on a deadline and I really need help. Thanks so much
Never save directly to removable media. Won't work.
What is the exact error message you get when you try to save to the ...double-click to new form in Access 2003
An application (which I am not familiar with) was written in Access 2002.
There is a form with a subform where double-clicking on a row is supposed to
go to another form using the information from the selected row in the subform.
The user's Access has been upgraded to Access 2003 and double-clicking now
brings him to an empty form rather than the next form according to the fields
of the selected row.
I have Access 2002. However on my computer, double-clicking doesn't do
The Action on On Dbl Clk on the fields in the Details section of the subform
of the main form is OpenF...Long time to save or open a form
I have a problem when opening a form or save the code behind . I am using
Access XP with Windows XP on machine P4 3.4 GHz, 1.5 GB RAM the problem is
that access take too much time to save or to open a form ,any idea to solve
this problem is appreciated
thanks in advance
Is there a network that separates your computer from the actual .mdb file?
If so, my advice is to only do design changes on a local copy.
You might also try the undocumented /decompile switch. First, make a backup
copy of your database, just in case something horribly wrong happens. With
Acce...Excel 2007 Save As PDF Bug
any news or workaround concerning this bug? facing the same problem
with the german version.
...Add capability to graph in the form of y=x.
Mathematical functions are very difficult to accurately graph even with
massive amounts of coordinates. Excel will not graph variable-dependant
equations; that is it will not graph them without a lot of tinkering and
results in very unprofessional looking end product.
Please add a way to make y=x graphs that doesn't take hours to create
through mixed graphs.
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 p...how to save extracted audio as .wav
I have a video format(.cam) and audio files are stored in it.I can able
to extract and play audio using waveout funtions in wave class.
I would like to save the extracted audio in .wav format.
how to do this.do i need to add any class like waveIn
I saw the following code to record wav file.
// Uses the MCI_OPEN, MCI_RECORD, and MCI_SAVE commands to record and
// save a waveform-audio file. Returns 0L if successful; otherwise,
// it returns an MCI error code.
DWORD recordWAVEFile(DWORD dwMilliSeconds)
M...raise form events programmatically
Is it possible to raise built-in form events programmatically? I have a
feeling it isn't but thought I would check.
For instance, I want to do something like this within a private sub on the
and have it trigger the Access.Form delete event -- i.e. without actually
deleting a bound record.
Note my delete event is not handled by the form itself but by an external
class, so I can't simply call Form_Delete(Cancel).
No need to raise an event: just call the procedure
Dim intCancel As Integer
Call Form_Del...Create Email From Access W/Information From Form or Query in
I have designed Databases for many years now, but never attempted this:
I need to know how to create an email with information located in the active
form or off of a query. I would like to have the email automatically
generated with the To Address, The Subject Line and the Body of the Text. I
would like that email to open but not to send until the operator has a chance
to make modifications. (one record per email).
"email@example.com" <firstname.lastname@example.org> wrote in
message news:F3F01720-2676-4DE6-A881-0E640CAF4CB5@microsoft.com...Open a form with TABS from another form
This is my problem:
I have a form with TABS (formVisitReason) i use to create a record with many
After I create the record, I want to view the record I just created, but
impossible to make it work. The form always comes back blank, even though the
record was created and i can see it in teh database.
Here is teh logic: I open the above form from the visit table, which has a
visitID. Tha visitID is passed to the formvisitreason. This is working like a
charm. But when i want to view what I just created, impossible
visitReasonID is an autonumber from the visit table...Passing avalue from one form to another
I have a form (ItemBrowse_frm) that provides me a list of active Item
numbers. When I click the Item number I want to pass the Item number to my
other form (SingleBill_frm) and requery the form based on that part number.
I am using the following OnClick
Somehow the SingleBill_frm does not requery and the field that I am passing
the value to does not show the value passed until I highlight the field. Is
there a better way to do this or what am I doing wrong?
...Converting Access Forms to Webforms
I've scanned through the forums here and didn't notice any up-to-date links
for my answer, so I thought I'd post my question and see if I could get any
response that I could understand, lol.
I have several databases that individuals use with user interfaces (forms)
that I would love to be able to convert, and still retain their functionality
with the database, to a webpage. How can I successfully do this? The forms
themselves are a lot of work in combination with queries and reports, and I'd
rather not have to recode them all if possible.
If this is possible, ...Recieving forms
For some reason I no longer recieve my front page forms and possibly related
problem my e-mail no longer automatically downloads when I open my e-mail
the header of the e-mails come on there but I have to click on the header to
view the message.
...Help Creating Form
I have 5 tables: Manufacturers, Products, Brands, Varieties, Sizes.
I would like a combobox Manufacturer that would filter a Products combobox
that would in turn filter a Brands combobox. After selecting a Brand from
the Brand combobox, I need to enter several Varieties for each Brand and
several Sizes (Size, Unit, Pkg) for each Variety.
Please help. I am new to this. I have the relations set in the order that
the tables appear on the 1st line of this post.
On Thu, 11 Mar 2010 06:38:14 GMT, "rnjalston" <u58689@uwe> wrote:
>I have 5 tables: Manufacturers...Adding form textbox to subform textbox
Hi, I have a form named frmBusiness which has a subform named
frmInspectionsSub. Each business can have several inspections (One to Many).
I would like to add a number in frmBusiness's textbox named "InspectionCycle"
to a textbox in frmInspectionsSub named "InspectionDate" which contains a
date. I would like to display this in a textbox on frmBusiness. I need to
have the "InspectionCycle" add to the year in "InspectionDate". I also need
the InspectionDate that it adds to be the last or largest date of that record,
(not of the entire domain just of th...Saving on a shared Excel workbook
Operating System: Mac OS X 10.5 (Leopard)
My company uses a shared excel workbook to record the status of our projects on a daily basis. We recently converted from Windows/Office to Mac/Office.
We're having problems with this scenario:
Colleagues A & B have the document (workbook) open.
A saves a change. (makes a change and then hits "save")
Then B saves a change.
Under Windows/Office, when B saved, a message would pop up alerting B that other users had also made changes, and the saved document would display both A's and B'...Check Mark does not show in form check box
I have a form with two check boxes that the user may check their choice.
Upon receipt of the form the check marks do not show.
Did you bind each check box to an Outlook yes/no property, on the Value page
of the control's Properties dialog? If you don't do that, Outlook does not
know where to store the data.
FYI, there is a newsgroup specifically for Outlook forms issues "down the
hall" at microsoft.public.outlook.program_forms or, via web interface, at
-...auto-saving emails as files on the network
Does outlook have the capability to save
incoming/outgoing emails to a standard file structure on
eg. I have a directory for clients and the next level
down is client a, client b etc. If I receive a mail from
client a, when I open it, I would like it to auto save to
...close form automatically after say 2 second
I guess I cannot close msgbox after predetermined time in code. So I want to
use a form to display message and close automatically in 2 seconds. How to
Check the Access help for the OnTimer event.
"Song Su" wrote:
> I guess I cannot close msgbox after predetermined time in code. So I want to
> use a form to display message and close automatically in 2 seconds. How to
> do that?
These code works. How to supply message to the form in code?
Option Compare Database
Private Sub Form_Open(C...Newbie
I am kind of new to Outlook.
I would like to know of any fast shortcut or a Macro for Save As many messages. I work in a NGO and due to the Haiti crisis we recive like 500 emails at day. I have to save each one them and ONE BY ONE that says Donations (not all emails says donation).
I would like to know if there is any way i can select a bunch of emails and save them all at once to my disk location not having to do it one by one.
Any help or ideas,
Submitted using http://www.outlookforums.com
You can drag and drop the messages out of Outlook and into an ...Hot Spots on Photo image after saving to Web Page.
For those of you familiar with Publisher (I'm using 2000). I'm working on my
family's holiday e-card. And every once in while I've had this happen over
the years...not always though so having problems troubleshooting it.
When I insert my photo file, it looks fine. File is currently saved as JPEG
but I've tried various formats too. BUT, then when I 'save to web page' (then
I copy/paste this into my email so it comes through as a graphic (e-card)
there are hot spots on parts of my kids' faces....it's weird. Their nose,
cheeks are 'hot' (almost w...