Search results for query: *

Hi. What exactly causes the horizontal scroll bar to appear when using Scrolling="Auto" with frames? I have a top banner image frame about 950 pixels wide and will have a lower vertical scrolling frame and don't want or need the horizontal scroll bar, but have no choice to use "auto" and if...

Hello. How does one get rid of annoying "Press F1 to resume" at boot when there are no error messages displayed and system runs well? The previous messages are typical IDE messages, keyboard and mouse enable with last message of "USB Legacy Enabled" followed by the "Press F1 to resume"...

Hi. After running Ghost to 'Clone' or to 'Backup and 'Restore' a system C; drive of Windows XP Pro. I get this message when trying to boot the cloned or restored drive. "windows could not start...did not properly generate ARC names for HAL and System Paths". I have swapable drives on the same...

Hi. I came up with this simple and short solution to give users the option to either "Print Now", "Preview" or "Cancel" a report after clicking on a print button. In this case the button is labled "Print Order" MsgAnswer = MsgBox("Yes=Print Now. No=Preview. Cancel=Cancel."...

Hi. I have searched and have also experimented with no success. I have a DB where the mouse right click works to pop up a copy, paste menu which is good. I have another DB where the mouse right click does nothing. I have checked and unchecked between closing and re-opening the Startup 'Allow...

Hi. I have a continuous form that is okay. I can add records to it, BUT as soon as I add a joined table to the form's qry, I cannot add any records on the continous form? The new record navigator is disabled and there is a blank rec as the last of the continuous forms but it does not accept any...

Hi I have been lookin for how to initialize values on a new continuous form? I have a continuous form which list all recs where the rec source is base on a query for all recs of a "many' side of a one to many relation ship, but if a user adds a new form of that continuous form,,, it...

Hi. I have 2 tables. Items and Trans. Items be on Trans many times with a foreign key. I have a contunuous forms of Items which contains and EDIT button to open up a form of trans associated with the item of the edit button. I open of the trans form passin the foreign key. It lists all the...

Hi. I see how to make group headers visible = false to supress details lines to make only total lines appear in a report for a 'Totals Summary' Report. But what is a good method to combine a 'Details and Summary' report with a 'Summary Only' report at the end of the 'Details and Summary'...

Hi. I'm trying to find a simple answer with no luck so far. I'm using Access 2000. I have come across no db errors, but in my production directory I have db1.mdb, db2.mdb and db3.mdb all with last modified dates in the past. I realize these are part of the compact process which looks like it...

Hi. What is the error number and in what event do I trap for the error that I have read is displayed if you set your database to compact on close and there is another user on the database? A side question,,,, when this happens, I assume it will attempt compact on the next close until no other...

Hi. I read some posts but can't get a unique count on duplicates of my report. For examplee. CustomerNumber Order 10 A B C 20 A 30 B I want total Customer count to be 3. CustomerNumber has 'Hide Duplicates' On. I tried...

Hi. I cannot enter data on a popup form if the main form is being edited (pencil is displayed at left). In other words, the popup form opens and displays but I cannot enter any data in the fields with no messages etc. as long as the main form is being edited. U have to update the main form...

Hi. What is the code to exit the access application after a user clicks on the 'exit' of a switchboard? I see in the code of the switchboard form it only executes Closecurrentdatabase and leave the access applicatin open maximized and user has to perform addtional step and close this down...

Hi. I followed the instructions in faq181-1021 but my 'database' window keeps appearing even though I have 'Display Data Base Window' unchecked! Here is what I've done... Tools Startup I'm using switchboard form. Uncheck 'display database window'. uncheck 'allow full menus' uncheck 'allow...

I'm having a difficult time writing an SQL statement. Hope I can explain it. (Or after reading this, should I just set a 'status' flag and avoid a complicated query? 8-) ) In my db we lease phone numbers. There is a phone number table and an order table. The phone number table has a one-many...

Hi. Is it possible to sendobject a string for an email body in html format for OutLook? I can send email very easily to Outlook in plaintext but my DHL and FedEx tracking links get truncated. If the only solution is to write an html report and send that as an attachment, how do you do that to...

Hi. I can send mail using the SendObject Method, but I cannot send mail in an html format. Can someone tell me what I'm missing? Thanks. Here is my code. Dim strToWhom As String Dim strMsgBody As String Dim strMsgSubject As String strToWhom = "vern@mydomain.com&quot...

Hi. I am tring to prevent a text box and label from appearing on a 1 page report, but cannot locate the right .visible property for either? Can anyone help? I can find Application, Column, Controls, Formproperties etc... but not the standard properties like .visible. Here is what I have so...

How does one NOT return #VALUE when the FIND Function does not find its value? For example... In the following I only want to put a cell value in column B only if there is a phone number in column A, but I also get the #VALUE when the FIND functin fails. I don't want the #VALUE! HERE IS A...