Database Tag Directory

Featured Database Questions

  • Creating correct relationship for report

    I am creating a report that states a taskcard # plus the panels and zones that need to be inspected under that number. All are originated by an MPD #. I have 3 tables - a taskcard/MPD #; access panels/MPD #; zones/MPD#. My intention is that the MPD# gathers the taskcard # associated with it, plus...

    hhoman5 pointsBadges:
  • Help with relationships in Microsoft Access 2010

    I am office manager in a service company that installs internet. A customer orders internet from the store, the store places the order and equipment is sent out for that job. There is a cantenna serial number, and IMEI and a router serial number that is unique to each order. There is also an order...

    AmWireLa35 pointsBadges:
  • Creating tabbed forms with data from different tables in Microsoft Access

    Hi! I'm a beginner on Access. I'm designing a database for school management system. I have a tables; Student Information, Math, Physics, Chemistry, Biology..... I want to create a form with student information then have 7 tabs for subjects information.

    Pegsoonline5 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:
  • Can I use a Linksys print server as a bridge or access point?

    Can I use a Linksys print server as a bridge or access point?  I want to use it to connect a VoIP phone.

    4jbshere5 pointsBadges:
  • How to read HTML in Lotus Notes inbox messages in VBA

    Can anyone show me how to get html from Notes inbox messages in VBA? I am using Access VBA to send notes email messages.  The message is a form I'm asking the recipient to fill out and return.  The message contains html with <select> and <input> elements.  The replies come back and...

    JoeLilly5 pointsBadges:
  • my data in A1 cell is ABCDE. I want to display it as 56789 in B1 cell

    example: my data in A1 cell is ABCDE. I want to display it as 56789 in B1 cell. (because my codes are A=5, B=6, C=7, D=8 and E=9) In a similar way I want a formulae that automatically converts my alphabet codes in row A into number format in row B. Another similar example: my data in A2 cell is...

    umgy22335 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...

    MarvinM8015 pointsBadges:
  • Acess servers

    list of access servers used by different isp??

    hareem5 pointsBadges:
  • Link Query to Report on Access 2010

    In an existing database, I have copied an existing query and an existing report so my new report will be in the same format as existing reports. I changed the criteria on the query so that it is pulling only the information I need. Now I need to link the two so the report will pull just that...

    LindaJenkins5 pointsBadges:
  • AS/400 via Access, update query

    Hi all, My DB is on AS/400 and I use Microsoft Access to run queries. However, whenever I try to run an update query, I receive the following error message: "[IBM][ISeries Access ODBC Driver][DB2 UDB]SQL7008 - table in library not valid for operation. (#-7008)" Any idea what is missing? Thanks in...

    Antser5 pointsBadges:
  • Setting up access rights in a SQL Server 2005 database

    Hello, I'm using MS SQL Server 2005. I'm connecting to the server via ADO. I have a question about access rights. Let me explain this with an example. Let's say I have a database named DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3. I want to create a SQL Server user that will have all rights on...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to use lookup query to return only entries matching the related field of active record

    I'm creating a lookup field and would like to list only those items relevant to the record actively using the lookup. So my DB has two tables one using the lookup which as a child ID field that I'd like to match with the parent ID field of another table.

    YesMayhem5 pointsBadges:
  • Using Access query data in Excel

    I have a need to use some employee data that is contained in an Access database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any success. I can move the entire file, but I really need to move only the data that meets some selection...

    Ronmcnaughton5 pointsBadges:
  • Query by character length in Access 2007

    I want to see all the records with 3 or less characters in a specific field. My field contains both text and numbers. How can I do this?

    Skb195510 pointsBadges:
  • Copy/paste a record with VBA in Microsoft Access

    How can I copy number of records from a form and paste them in another form with VBA, not with the right click, in MS Access? Thanks!

    Toli70 pointsBadges:
  • Access 2007 Database – Security Warning

    This database has come back to haunt me.... We recently changed out a computer and added a shortcut to the Access database. Actually it was the shortcut copied from the previous computer. When they double click the short cut, it takes them into the database menu as before. However, now it displays...

    LeChat80 pointsBadges:
  • Cisco Access Point: Wireless client is disconnected

    We have 21 Access Point in field in our company location. all are working and having the Good configuration along with channels and security authentication. But now a days we are facing problem with 3 access points where wireless client in one VLAN is not associating  and there is no problem in...

    Ekansh400 pointsBadges:
  • Configuring Cisco Wireless Router

    Greetings, I have a Cisco 871 wireless router and am having problems configuring it to act as a Wireless Access Point for my small internal network using Microsoft Small Business Server 2003. I am trying to set up one client access via wireless. Using Cisco’s SDM Express, when trying to change...

    RP@ADF15 pointsBadges:
  • Find and replace text in text file using MS Access VBA

    Hi I need to modify some tags of an XML file that I receive. How can I search the file for specific text and replace it? Here is the code I have right now. It runs without errors but does not replace the text.Function ReplaceTextInFile() Dim sSearchText As String Dim sReplaceText As String Dim...

    Vgnadeau15 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