Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PJname
  • Content: Threads
  • Order by date
  1. PJname

    Rename database from another database

    I have a morning job that I have scheduled to kick off at 0300 am each morning where I work. What I would like to do as one of the first steps in the Autoexec macro is to rename another database to prevent users accessing while this update is running and once the update has completed, rename...
  2. PJname

    Error..... Not Enough Space on Temporary Disk.....

    Help...... I am trying to update tables within an MS Access database and I continue to receive this message this morning...... NOT ENOUGH SPACE ON TEMPORARY DISK I have this running on my c:\drive and it shows that I have 15.8 GB free space. I tried to run from a network directory, but...
  3. PJname

    VB code to Backup MS Access databases

    I would like to set up a backup function in a MS Access database where it will go and perform backups of other MS Access databases located in various directories . Can someone send me the VB code to do this? Thanks in Advance.....
  4. PJname

    VB coding to Compress Microsoft Access Databases

    Can someone direct me to where I can find VB coding to be included in a Microsoft Access Database to run a compress on other MS Access databases which are located in different directories and naming conventions? What I would like the VB coding to do - is to include this action in my Autoexec...
  5. PJname

    Microsoft Access has encountered a problem message

    I have a MS Access database that I have set up to automatically run using the Scheduled Tasks application at certain time early in the mornings using the Autoexec Macro in the Access database. Sometimes when I login to my machine the next morning, it shows the following Microsoft Access box...
  6. PJname

    TAB Control in Microsoft Access forms

    Is there a way that you can change the font size, color, text, etc.. when using the TAB control in a form? If so, can you send instructions? Thanks in advance.
  7. PJname

    MS Queries - duplicate field names

    Question: Is there a way to check for duplicate fields in a Microsoft Make table query? Trying to perform a Make table and receive the following error: Cannot define field more than once I know that I can start over, but would like to prevent this due to complex criteria defined.
  8. PJname

    Microsoft Excel 2002 = networkdays function

    Problem: Recent issue - Function: =NETWORKDAYS(A1,A2,A3:A53) This function was working correctly in my worksheet until recently. Now it is showing: #NAME? error in the field where the data should display. I have the Tools - Add-ins - Analysis Toolpak box checked. field settings: a1...
  9. PJname

    Microsoft Access - Form

    Can someone provide me the Visual Basic coding for a Microsoft Access form for a field where if it is = TRUE , a pop-up message box will appear? I have a "Delete" field on my form and if a check is placed in this box, I want a message to pop-up similar to the following: "***If this activity is...
  10. PJname

    Memo fields containing html identifiers

    Question: Is there a way to remove the html identifiers that show up in a memo type field when using Microsoft Access? <html> This is an example </html> Would like the field to only show: This is an example
  11. PJname

    MS Access Query problem - OLE object field

    i have linked to a table and when i run the query - in one of the fields it shows OLE Object When I make a table the data in this fields shows: Long Binary Interger How do I by-pass this and have the html data display? This is the response from the Application tech support: You would...
  12. PJname

    Pop-Up Calendar for Access Forms problem

    I have added a pop-up calendar for users to use when entering date fields on a form. Most of the users are able to use this function with no problems. I have one user when he tries to enter a new record into the database when he clicks on the drop down box for the calendar, he states that the...
  13. PJname

    Pop-Up Calendar for Access Forms

    Help! I found some coding where I can include a pop-up calendar on my Access Forms for date fields. I have several forms that I would like to use this code to update one date or multiple dates depending on the form but I am having a problem where on some of the forms, the coding works...
  14. PJname

    Microsoft Access Tables / Microsoft Excel Pivot Tables

    I am using MS Access data tables to run in MS Excel to update graphs using the Pivot table option. I haven't used the Pivot table option very much and I am struggling to understand how it works. I am able to include the MS Access tables containing the data using Pivot table, but I have...
  15. PJname

    Microsoft Access Conversion

    I don't think this can be done, but can you convert a MS 2002 into a MS 1997 version? and, if so, how? I have tried creating a new database in MS 97 and trying to import from the MS 2002 but I get an unrecognized format error. I have tried the Tools -- convert -- MS 1997, but still receive...
  16. PJname

    Extracting data from various positions in a field

    Help! I have a field in a Microsoft Access table where I am trying to pull portions of the data out. Unfortunately, it is not in the same position in this field. No such luck..... [sad] or :-( Anway the following are some examples of what I am trying to pull: example 1: DATA IN...
  17. PJname

    Corrupt Microsoft Access Database

    Need information: User was in the database and something happened when he was exiting from the Microsoft database. When I tried to load I get the following error: The Microsoft Jet database engine could not find the object "MSysDb". Make sure the object exists and that you spell its name and...
  18. PJname

    Microsoft Access Query vs. Report

    Can someone explain to me why when I run a query it brings the results back in approx. 10 seconds, but when I use this same query from a report, it takes at least 15 minutes or longer before the print preview displays. I would think that if the query runs quick, the report should also run the...
  19. PJname

    Visual Basic coding to Auto submit MS Access Macro

    I have a MS Access database where I have a macro using the "SendObject" Action where it sends several SnapShot report's to various individuals listed in the "TO" section. Unfortunately, I have to click on a button to send. I don't want to include this in the AutoExec file on open since this...
  20. PJname

    Error Message(s) in Microsoft Access

    [rednose] Can someone tell me where I can find a document that has a listing of all the Error(s)messages and possible solution(s) to these error(s) for Microsoft Access? I had a user who was trying to run a compact and repair on a MS Access database and he received the following error box...

Part and Inventory Search

Back
Top