• How supply password in VBA during CompactOnClose for back-end password-protected db?

    Access 2000: Goal: to open and close a password-protected public access db (which compacts on close) and hide the "Password Required" prompt on open and on close. Purpose: Provide public access to Main.mde and protect Main.mde from remote connections, i.e, import & link. I have password protected...

    Dlc9ball20 pointsBadges:
  • Access to MySQL – How hard is this going to be?

    I've just taken on a client who has been building his databases in MS Access for 14 years. He wants to put a significant amount of this data into an online MySQL application. I know it can be done, and I've agreed to help him do it. Does anyone have a feel for what it will take to get his data...

    Ken Harthun1,195 pointsBadges:
  • MS Access Query

    I have a table that has item information by store. I am looking to get back the top 25 items in each store. I can't figure out how to run this. If I use the "Top 25" tag I only get the top 25 through all stores, not by store. Anyone have any suggestions?

    Hollouise5 pointsBadges:
  • Is there a way to Call a Lotus Notes agent from Access code and pass Variables?

    I'm on a Windows XP Pro System using M.S. Access 2003 and Lotus Notes 6.5. I provide adhoc and ancillary reports to our user community. We now have to send a hotspot to the users to inform them where their Excel files can be found. I created an agent that will send an email to a specific user, and...

    VinceP45 pointsBadges:
  • Access Module – calculating work minutes

    I have this code that someone else created and I modified to calculate elapsed time between submit time & complete time but exclude hours that aren't between 6AM & 6PM. The problem I am having is if something is submitted at 6:18PM and not completed until 6:30AM the next day it isn't providing the...

    Noetloj5 pointsBadges:
  • MS Access – Count of parent table items in a report

    I have an MS Access database with a parent table and a child table. Table A (the parent, an Order table) has a PartID field, an OrderDate field, and an CustomerID field. Table B (the child, Parts) has a PartID primary key field and a PartDescription field. A relationship joins the 2 tables on the...

    LegacyDave5 pointsBadges:
  • Access 2007 refrence look up

    Ok this question might sound kind of elementary but i just seem to be missing something. I have a drop down box, within that combo box i want to display choices which consist of 3 cap letters then a "-" Then what the letters stand for. when i choose a selection from the combo box i want it to...

    IT-Guy1509210 pointsBadges:
  • Access help

    I have a 10 digit predetermined ID number. What I want to do is when a new number (the number referred to above) is added to the database, information based on this number will appear. The producer is based on the first three digits, the owner is based on the first three and the last two, and so...

    Dabbsa5 pointsBadges:
  • access supoort beyond 2007

    will Microsoft package and support Access beyond office 2007

    Richaslam10 pointsBadges:
  • Where is my data

    Hi Friends, I am able to enter the data through web form and able to get a query web page with the data being entered, but can't find the data in the relevant table in Microsoft Access Database. Where is the data hiding and why it is hiding? I am trying to develop a dynamic web site using...

    Ananthlyuba5 pointsBadges:
  • Cold Fusion and Data base application

    I am in the process of developing and internet web site, and do not know cold fusion. I have a database in access that I want customers to be able to search. There will be three levels of search and I am using dreamweaver 8 for designing my web page Instead of coding every link into my html, I want...

    Stevehm0 pointsBadges:
  • Open MSAccess database

    Hi there, Does anyone know how I can open an Access database with script without giving the path of the MSAccess.exe file. I would need the equivalent of Execute, @Command that does not require a path. @Command( [Execute] ; "msaccess.exe"; "C:\\MyApps\Test.mdb" ) currently I am using Shell that...

    Constantin0 pointsBadges:
  • Synchronizing Two Subforms in MS Access

    In my main form I have two tabs – Alumni Class and Placement – both of which tie to the AlumniClass and Placement tables respectively. My Alumni Class subform stores the year and term a person graduated. My Placement subform tracks if the person was offered a job (company name & position) for...

    FERREJE0 pointsBadges:
  • Changing an existing Export Specification in MS Access

    I have added 2 fields to a table that is being exported to a text file. The export is done via TransferText and uses an Export Specification. I would like to know how to change the existing Export specification to add the two fields. I have tried various things in the File->Export wizard but...

    SDBAPI0 pointsBadges:
  • - DB2 – RPG

    My question has two parts: 1- Is there any way to create DB2 at a PC similar to what is exist at IBM I-Series AS/400? 2- Is there any RPG Compiler that I can install and run it and PC?

    Qawasmeh0 pointsBadges:
  • REPORT WAIT TIMES

    We have a commercial accounting software package programmed in Access. Recently began having to wait for some reports to process to the screen for over 3 minutes. We have only had this software for under a year and have eliminated the problem being the network by moving the data files from the...

    Jmoeller0 pointsBadges:
  • Front-End Reporting Tools for Secure Web Service Application with MS-SQL server

    Hi... We are a Cdn Govt agency involved in Satellite Operations with a commercial partner based across the country. We will need to build/buy a small web service application for reporting purposes that will require minimal IT experise to build or maintain. The back end RDBMS engine is built with MS...

    Mmosystem0 pointsBadges:
  • Improve MS Access performance on a Win 2k LAN

    We have recently replaced our old DataEase database with a package that was built using MS Access, and the system has slowed away down to an unbearable speed. However we are stuck with it now, and I would like to know if there is anything that we can do to improve the performance of the database....

    Harg77690 pointsBadges:
  • Access 2003 Options Group

    Most of my work is with VB and I always use option buttons within a frame. I'm trying to do the same thing in Access 2003 and I get an error message: You entered an expression that has no value. For simplicity this is what I'm doing: If Me.Option3.Value = 1 Then Msg = "A" ElseIf Me.Option5.Value =...

    TonyTempio0 pointsBadges:
  • Microsoft Access: Append Query problem

    I have a table with a surrogate key created by Autonumber. I have data (in a linked spreadsheet) which I wish to append to that table. I would like to have the new data appended with automatically generated keys, but I cannot find how to do it (without writing a specific macro). If I try to append...

    EricThomas0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following