• Using Dlookup to populate form fields

    I have a simple database with one table(Issue log). What I want is a form that allows for creating a new "issue" within the table or updating the status of an existing issue. I want the form (Issue log) that will update an issues' status to auto-populate based on which issue number you enter....

    Dave4015 pointsBadges:
  • How to import Microsoft Access to SQL Server 2005

    hi, while i am importing database MS-Access to sql server 2005 its could not importing its Showing like this: The operation could not be completed. Additional information: -> Not a valid password.(Microsoft JET Database Engine) What to do? can you give the solution. Thanks, Deepa

    Deepatss5 pointsBadges:
  • Amending a Product Price without altering existing orders in Microsoft Access

    Platform; Windows XP Microsoft Office - Access 2000 Adapting the example database that was supplied with Access - Northwind Sample Database. I adapted the above sample database back in 2003 to my own database but have now hit a snag and i am unable to rememberor or find the solution. Currently, If...

    Skipy10 pointsBadges:
  • Converting SQL data to Microsoft Access through coding in VB.NET

    I have tables in SQL and i want to port them to MS access through coding in VB.NET

    Kiti15 pointsBadges:
  • E-mail Notification

    Can Access 2007 notifiy me by e-mail when someone has added or made a change to my data file?

    Mightymrs5 pointsBadges:
  • Beginner – How to move a table

    I have one database, called Mask List. It contains two lists, Mask List and VIP Visits, which are unrelated and unlinked. I'd like to move VIP Visits out as a separate table I can call up and use without having to go into the Mask List database. I have created a link directly to VIP Visits on my...

    JustTrying5 pointsBadges:
  • Export report into seperate Word docs

    Hi, I have created a Crystal report that runs from an Access Database. The report shows details of different projects. There are around 300 projects in total, and when I am exporting these at the moment, all the details are being produced in one report. However, I want to be able to export the...

    Hunty835 pointsBadges:
  • How to use Access object library in my Windows application

    dear friends , how to use docmd.opencurrentdatabse command to open an access application database please advise

    Ashabalu5 pointsBadges:
  • Hotel database (Rooms availability) using Access 2007

    Hi there... I'm working on hotel database (Access 2007) I have a table named Rooms There are 3 fields in it Room ID, Room type, availavility how can I make Access shows the vacant rooms which are not related to any guest?

    Black0ice5 pointsBadges:
  • Microsoft Access QueryDef problem with numeric column anme

    I have a form that creates a query on the fly. It works great, but has a problem with columns that have numeric names. The table is not mine so I can not change the columns. When I run the query the column name appears in the column. I tried to find anything wrong in the query and could not. IF I...

    Davisdo5 pointsBadges:
  • Sort Access Query From Variable

    I wanted to see if there was a way to sort an Access query based off a variable. I have a textbox on a form and I want to be able to type in a field name and then open one query and it's sorted by the field name I type in the text box. Any help would be greatly appreciated.

    RoadDust390 pointsBadges:
  • Adding new entries to a table via a combo box in a form

    I have a Database for tracking conference attendance. Because of this I want to be able to both retrieve attendees and also adding new attendees. I have a form that allows me to retrieve attendees already input into a table via a combo box, but I can't add new attendees via that same combo box. I...

    Danielgroot5 pointsBadges:
  • Export Attachmets

    How do you export all attachments for all records from Access 2007 database?

    Angellja5 pointsBadges:
  • Trying To Make A pop up on MS access to come up every time a client needs to pay me..

    So I have a table full of details of my clients.. including when they have to pay me (the date) and how much they have to pay me.. Im not an expert at MS access. i know how to make forms and all that but not this.. can somebody tell me how to get a pop up to come up every three months saying the...

    Helpwithmsaccess5 pointsBadges:
  • MS Access & EDI

    Is there a way to use MS Access to interface with a database that uses EDI? If so, what do I need to do to do this & where can I get more info on this?

    Axcel5 pointsBadges:
  • Combo box date/alpa field

    Can it be done and how... I create a combo box and I want the field to have some alpha some numeric. the drop down will say "N/A". But if they want to put a date in that field, should be able to. My testing show it has to be either or. Also when I type in the year in that field, I will be typing...

    Slcart115 pointsBadges:
  • Advice on buying new PC

    I have a Pentium 4 & need to upgrade. I teach Microsoft, use graphics in my manuals, & use CorelDraw a lot. I also design huge Excel spreadsheets with lots of formulas and design databases in Access - what would be a good PC processor, ram, etc? I have been quoted on a system with a Quadcor...

    Shazzie70 pointsBadges:
  • Access 2003 checkbox to perform calculations

    I have modified the ledger template database from MS to incorporate 4 columns containing yes/no checkboxes. The checkboxes refer to 4 phases of contruction for the line entry. Some line entries may have nore than one box checked. My problem is that when I need to run a report on an individual...

    Tm13005 pointsBadges:
  • Create table by comparising 2 tables

    I am new at Access but have some help with creating a db. I would like to know if it is possible to compare table 1: prior data and table 2: current data, and then create a table 3, with all the changes/deletions from the 1st table to the 2nd. All the data is workflow tasks that are dates. I need a...

    Gooies5 pointsBadges:
  • About UPDATE query

    hi friends , i am using VB 2008 . database access 2003 in my project , i include an update query,its below con.Open() Dim cmd As New OleDbCommand("update device set manu='" + mtxt.Text + "',desc='" + dtxt.Text + "',model='" + mdtxt.Text + "',pdate='" + prodate.Text + "',price='" + ptxt.Text +...

    Ashar5 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