Database Tag Directory

Featured Database Questions

  • Sum using SQL

    What I want to do is the following: Name_Patient......... amount........ xxxx aaa................................500.................500 bbb...............................500...................500 aaa................................500..................1000 I want to make the field named xxx to...

    mohammedwagihe5 pointsBadges:
  • 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:
  • Creating an Access 2007 query with results similiar to a Crosstab query

    I am new to Access and I have an Access 2007 database that has a table that has the following fields: Employee Name, Date Worked, Yes/No for Paperwork Received and Yes/No for Paperwork Returned. Is it possible to create a query that I can run a report off of that will show one row for each...

    mjp126215 pointsBadges:
  • Creating a report in Access 2007

    I have a table in an Access 2007 database that contains the following fields: Emp. Name, Date Worked, a Yes/No field showing Paperwork received and a Yes/No field showing Paperwork Returned. I am trying to create a report that will be run for a selected month that has each day of the month as a...

    mjp126215 pointsBadges:
  • Create a form/subform in Access 2007 that displays multiple records to be updated.

    I have an Access 2007 database that has 2 tables: 1st table is the Employee table that contains Employee ID, Employee Name, and the Location code they work at. 2nd table is the Work Log table that contains the Employee ID, date they worked, and 2 yes/no fields for paperwork received and paperwork...

    mjp126215 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:
  • Microsoft Access: ACCDE and ACCDB

    what does the word ACCDE and ACCDB stand for?

    Humphrey25 pointsBadges:
  • Hotel database in Access 2007

    How do I create a Hotel database in Access 2007?

    Reginaldsackey10 pointsBadges:
  • Print 2 A5 sheets on one A4 sheet in Access 2007

    I want to print 2 A5 sheets(the same content,printing two copies) on one A4 sheet in the Access 2007.if you have any solutions, please contact with me.mail: 7924168235@163.commany thanks in advance

    lengpaton5 pointsBadges:
  • Handling Record Update Collisions

    I have a split database. A form on the front end allows users to input their updates and then press a "Save" button to send their updates to the back end database. If two users simultaneously try to update the same record, one will connect, lock the record, and the change is committed. The other...

    MarvinM8050 pointsBadges:
  • Forms in Access 2007

    I am using a form to upload data from the form into a database. I have a submit button on my form that upon clicking, needs to input all the users data into the correct slots in the database but I have no clue on how to do this, or where to get started. How should I go about solving this problem?

    Jenkinac40 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:
  • Access 2007 invalid procedure call or argument (runapp)

    Hi. We have a proprietary Access Database/program that a former employee created for us. We have no knowledge of how to fix it, most of the time it still works just fine.  A user in our office gets the error in the subject when he tries to run it. It worked fine up until a few days ago and I have...

    Longshot95 pointsBadges:
  • VB6 App with hardcoded SQL to access a Access 2007 DB

    Hi Team, I have a query that I run successfully in native SQL within Access 2007 but if I use this code within VB6 it seems as though it is not using the "From" & "To" dates. It does return values but it amounts to the complete database totals. The extra code added to the production code was...

    Witsend5 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:
  • Access 2007 database errors when using Access 2010

    I have a database built with Access 2007. Some of our customers are upgraded to Access 2010 and cannot open the database anymore. Error is "The expression On Timer you entered as the event property setting produced the following error: Object or class does not support the set of events". Anyone...

    Browntr15 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:

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