Search results for query: *

FYI. I formated the report into an image. This fixed the problem. Hope this helps someone.

Ok, I need help. I have a report that was created by cutting from a Word document and pasting into a blank report. The report displays fine on my computer but is blank on computers. Any suggestions or solutions are welcome. Steve

FYI all. http://support.microsoft.com/support/kb/articles/Q186/3/04.ASP . Look at this link and see if it will help. It is my experience that 10 percent of the users create 90 percent of the problems. Finding out who they are and educating them has normally alerted me to problems they have that...

In Access, while viewing the database window, click File/Get External Data/Link. Change file type to MS Excel, Point to the Excel Workbook, Specify the desired worksheet and answer the questions in the Wizard. You can then create forms and queries based on the link. Hope this helps.

The replica route is the correct one to take for your need. I do this on 20 something machines. I would do Three things. 1- Split the database. This puts your data tables in a backend mdb. 2- Create the replica set you spoke of. 3- Create a mde for your front end. The mde does a couple of...

I will try. 1- Make your database window visible (press F11 if window not visible). 2- Select the Modules, select "New". 3- add '****************** CONTROLS Global ctl As Control 4- Save as "DefinitionModule 5- On whatever form you want to insert the...

You labor under a mis-conception. User's are never happy. Only temporarily satisfied.

Ok, I understand your problem but I still need some info. Are you saying you do not want the data updated in the original backend. Assuming you do not then do this; 1- Look under Tools/Add-Ins/Linked Table Manager. Click the Select All and Click the "Always prompt for a new location check...

That is why you split a database and why you create a MDE. You want the frontend to update the backend. Why would you want anything else. I am confused by your question. Give us more details.

You have got the jest of it. The backend is for data. Your forms, queries, reports, modules are in the FrontEnd (MDE). You will make changes in your Design Master .mdb and create a new mde to implement your changes. It preserves your design of any code in your forms as well as converting your...

Uncle Bill has done this for you. Use the ActiveX Calander provided in MSAccess I use a Definitions module to put all of my Global declaration. In that module add. '****************** CONTROLS Global ctl As Control In a textbox on a form. (Click Event) Private Sub...

Microsoft has a LDV Viewer utility that is a free download (translate to unsupported) that I use if I just want to see who is connected. The previous suggestion of check for the presence of the .ldb file is good as well. I would check to see if you can delete the .ldb file before you decide...

Your .ldb file will be in the same folder as you .mdb file.

I would like to read from (not change data in) some QuickBooks. Does anyone know of an ODBC driver for QuickBooks.

Rename original database "Name1". Create an new blank database named original name "Name", import everything from the renamed Name1. Save and you are now the new admin.

I need information on how to detect that an indirect synchronization is underway on a set of attached tables. I have a .mde front end that I would like to display a hidden lable when the replica set tables on the back end are in sync. Turning the lable on and off is not the issue. It is what do...

I have tried the one out of sybex and found it to really put a crimp in my overall db performance. If you have a strong enough computer the performance issue may not be as noticible as it was with mine. The program worked as stated but was soooooo, slooooooow.

This is a little dirty but it works quite well. Create a hidden (not visible) text box on Form1. On Form1 combobox create an after update event that writes the results into Hidden Textbox1. also in this same after update event (if you want this much automation) place a DoCmd that opens Form2...

If your lookup uses the DCount or IIF statements, you might want to follow up in the online help concerning the cautions on using these. They are very slow. Make sure the queries that populate your combos refer to indexed fields. Running queries on un-indexed fields will also slow down the...

Are you sure the form with the tabs is what is causing the problem? Is it possible to rename the page and sub in another blank page to see if the tab'ed page is the real issue. I am curious, I have a form with 40 tabs and numerous performance issues I am working through.