• How to create an auto-update table via user input using Access or Excel?

    Currently, I have somebody-I-don't-Know-Who created an access table that auto updates its records, I believe, done by user forms. How is this done? Can I do the same in excel? I would like users to input the required information from the link uploaded at a site and I would receive those output in...

    mtanutama10 pointsBadges:
  • How to export query output from qmf to access and/or excel?

    I would like to be able to use the date eventually in excel? Is there a way to export direct to excel? If not, through access is another option. How do I accomplish these?

    mtanutama10 pointsBadges:
  • Please suggest me perfect solution to know how to fix corrupt access files?

    I am a database administrator and maintain the database in well mannered way. But suddenly i got corruption in my access database 2013 and lost crucial files. I want to know to fix corrupt access files and how to restore ms access database on system with old originality?

    hunt69morgan5 pointsBadges:
  • Will streaming media work in a motorhome?

    I am new to Streaming.  A couple of questions.  How are my computers, VCR, and TV connected to the provider.  We are planning to buy a motorhome and need to know if this is a good solution to use on the road? Rex Ralston netrex@aol.com

    Rnetrex20045 pointsBadges:
  • Hotel database in Access 2007

    How do I create a Hotel database in Access 2007?

    Reginaldsackey10 pointsBadges:
  • save all listbox items to access DB

    Trying to save all items from a listbox, ListBox1, to an access db named CalcDB when a button is clicked, "Save To DB"

    Enumerate5 pointsBadges:
  • Controlling VPN access

    Here's my scenario. I fall under guidelines of HIPAA. I have mobile users using laptops and tablets loaded with Cisco VPN CLient connecting to my Cisco 2811 ISR which functions as my router/firewall/VPN. I am using Micorosoft AD in my domain. To authenticate users to the domain. Is there an easy...

    Gforsythe75 pointsBadges:
  • Created Public Folders for Excel spreadsheets

    I have created a public folder to store Excel spreadsheets that I need users to be able to access and change. I understand the permissions. My question is can more than 1 user be in the same spread sheet at one time and make individual changes. Will all changes be saved?

    Chenzo5 pointsBadges:
  • Run VBA code as admin

    I am currently working on an ms access application for a large insurance company which generates reports for the user after the user inputs/select some data.... Unfortunately the application has already been built - and till now we used to run the application/reports by logging in as admin.....

    Gangac5 pointsBadges:
  • Fingerprint recognition in Java

    I want a programing source code for fingerprint recognition time and attendance payroll system in Java language. I also want the source code for capturing a fingerprint image and storing in MS Access in Java language for the same project.

    Anikketthakre5 pointsBadges:
  • Count distinct rows on multiple columns

    I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00...

    Mjackson0 pointsBadges:
  • SQL Group by Query with aggregate function as well as detail information

    Given a simple table with historical info about Hotelroom occupancies such as name of the guest, date in, type of room, number of nights, ... I want to make a query resulting in 1 output record that shows the highest number of nights someone has ever stayed in the hotel, as well as the...

    idontknowthis20 pointsBadges:
  • access query criteria using LIKE operator and msgbox if no results

    I am using Access 2010. My query criteria looks like this: Like [ENTER THE FIRST LETTER OF THE SUBJECT] & "*"......so the user clicks the button and a box pops up with the above question. If the user types in a letter and there are no subjects that start with that letter it just opens a blank...

    draia10 pointsBadges:
  • Report design Access 2010 / 2007

    I do not know how to design a report that will display the data the way I need. It is hard to describe here, but I will try with a simple example. Each record is based on a date. On each date there are entries to 0-200 accounts for various $$ amounts. IE: on 1/1/12. acct 120100 for $5, acct 120202...

    gc4evr5 pointsBadges:
  • Problems exporting Access table to XML file

    I am having a problem with exporting a table from Access as an XML file. I export the table and the XML file has the following at the beginning of the XML file: [!--l version="1.0" encoding="UTF-8"--]- [dataroot xmlns:od=""urn:schemas-microsoft-com:officedata""...

    Epk19635 pointsBadges:
  • Access and sql server wide tables

    Does anyone know how to access sql server wide tables using Access

    Johnatsteeltorchdotcom5 pointsBadges:
  • Converting a Report in Access to PDF

    Hi Does anyone know the VB code used to convert a report in access to ADOBE PDF format and E-Mail it automatically? i can do so manually but it would far easier if i could just click on one button while in the form. Thank you

    Dyllon0 pointsBadges:
  • Open / Convert MS-Access x64 file into MS-Access x32

    Hi, Is it possible to Open or Convert MS-Access x64 file into MS-Access x32? Thank Regard's Owais

    MOwais91115 pointsBadges:
  • OLE field in UNION query

    I need to join 2 tables, each with a field with an OLE object data type, in a UNION query in MS Access, but I get the message that an OLE field cannot be used in the Select clause of a union query. Does anyone know a work-around?

    Mlwonio90 pointsBadges:
  • What is the best why to get started in DBA

    I have some experiance in SQL and Access and all the other MS software too. I deal alot with spreadsheets, and database in my job. I work alot with the AS400 and do alot of queries throught MS Access. What is the fasted and tghe most inexpensive way to get to the piont of being self sufficient as...

    CompEng1,185 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