Recent content by ShortTexan

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.