Search results

I am developing an app for a small medical office that requires a way of tracking periodic health testing for their patients. They are ultimately requesting a report that informs them of upcoming required tests for their patients. Most periodic tests for a given patient will be manually...

Could someone point me in the right direction on how to statically store current pricing for a product in an invoice database, whereby future price changes would not change pricing on past/previously created invoices...?

Shortcut menus on a report are not available in runtime mode... I want the user to have ability to email a report... Ive created a new "reports" toolbar with a "Send To: Mail recipient" command on it and inserted this code into the Open Event of the main switchboard...

Explain this solution... The combo box field has a conditional format that changes the color of the background and text when it has the focus...I removed the conditional format and everything works fine...so far. Can anyone explain this Cheers

:confused: I have a frmServiceOrder form that has a "datasheet type" sfrmSOItem subform with a combo box that allows a user to select service order items... Problem: When I select a service order item in the dropdown, it doesnt place the item in the record...I have to select it a 2nd time...

I've read several previous threads regarding this...but could not find an answer: Is it possible to store a PDF file in a table? I know that I can store a hyperlink with the path to a PDF file located elsewhere, but I would rather store the file in the database itself. If it can be done, how...

This site helped me eliminate the security warnings. http://www.mac-net.com/741485.page

If the reports recordsource is a form-based parameter query, make sure the form is open...

Pat Hartman, The menu I have is the default menu you get when you disable at startup...and I can still print everything as normal...I use no macros. I have discovered that this "/runtime" feature has increased the performance speed of my forms/reports 8-10 times...the entire office loves it...

Pat, Regarding the "Start/Run" box you mention...Is that same as the "Target" path on the "Shortcut" tab of the properties dialog box? I currently have a database that utilizes access-level security that references a WIF that has to be opened using a shortcut on the user's desktop...and just...

I'm starting a design on a homebuilding database and I have 80 job cost items associated with each job record... I'm trying to determine if I these costs should be fields in a tblJobs table or records in a tblCost table linked thru a JobID...

Does Access2002 limit the number of fields you can insert into a table?

Thank you.

I am trying to reference a database filename so it will show in a textbox on a form within the same database...I can find no previous threads on this... Thanks for any help.

Is there any harm in using this command on a database that is in a shared environment, AND NOT opened exclusively? Thanks for any factual info.

I am not familiar with a subquery...could you explain in more detail and also how I would go about summing the OrderDetail items? Thank you for your help.

I have an OrderDetails table that has many records (OrderDetailID's) with like OrderID's (I use autonumbers for all primary keys)... I have a query that has a calculated field to return material cost extensions (Quantity*Cost*TaxRate) for each OrderDetailID record... How to sum OrderDetailID...

Rich, Thank you.

Yes Neileg...your suggestion is exactly what I would like to accomplish!...Could you help me with the code to insert in the OnOpen event? Thank you for your help.

My form properties are currently at these default settings...What I need the form to do is open in Add Mode, but also allow edits to existing records concurrently. Thanks.