• MDE to updating table in backend database

    I inherited a few databases which were created in Access 2000. I only have Access 2003 and I needed to make a new MDE file, I converted to Access 2003 then created the new MDE file. Now the problem is this, the new MDE won't write to the backend database.

    Herdine30 pointsBadges:
  • Report -Conditional Format with multiple conditions: Access 2007

    I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD then DATE()-30= (red font), and DATE()-31 BETWEEN DATE()- 60= (yellow font) and DATE()-61 BETWEEN DATE()-...

    Nichalos825 pointsBadges:
  • Convert OO Base to MSA

    Is there a way to convert an existing Open Office Base database to MS Access?

    Naomih15 pointsBadges:
  • Notifications Microsoft Access and Outlook

    I have created a form and one of the fields in the form is for the date of expiry for certifications. Is there a way that access can send a notification or some type of flagging through Outlook (or any other method for that matter) to let me know that someones certification expiry date is coming up?

    Tkalanchey5 pointsBadges:
  • mdb talk to jdbc

    is it possible to make an inner procedure in (any) jdbc db that will produce simple p2p connection with another db for example a mdb, this is highly needed that the other db will be a flat file (mdb), if you know any way to create connection through another db, with a non-java db (not a jdbc...

    Elad Karako255 pointsBadges:
  • DB Web interface

    What would be the easiest language to use/learn if I want to create a web interface for my Access DB?

    Jaco65 pointsBadges:
  • Microsoft Access – I would like to have the first character of a field print without the first character?

    I would like to have the first character of a field print without the first character? (ex: LC7 to print as C7, The size of the field may vary)

    11235 pointsBadges:
  • Dropdown Window connecting… Help!

    Ok, to get to the point, I'll talk about the WHAT, I am asking the HOW and I'll leave out the WHY. I have 3 peices of Data, + credits (positive credits), - credits (negative credits) and I want a dropdown window to the left that stores ways of 'getting' those credits or losing them, each way...

    Slight5 pointsBadges:
  • Date Picker

    Can I create a Date Picker (enabling users to look up a date from a calendar) in Access 2003 forms?

    Shazzie70 pointsBadges:
  • Problem converting Access SQL query to T-SQL 2005

    I have a SQL Server 2005 database. One of my co-workers has put a MS Access front-end on it, because of the ease of designing queries in Access. I need to convert an existing query from Access SQL to T-SQL to put it into production. So far, I have removed all the obvious differences between the 2,...

    Chunkydrew15 pointsBadges:
  • set up file not installed in other system

    Dear sir i created an application useing VB 6.0 and MS-Access.i made it exe and packaged as well as deployed using "Pavkge and Deployment Wizard" from Add-Ins menu. it is installed in my own system where i created the application.While i am installing in another system an Warning shows that "SET UP...

    Bipansahoo20 pointsBadges:
  • How Can i restrict the user to insert next record

    Hai all, I have a requirement that , i have to display the data from a table in the subform in a datasheet view mode. I should validate the fileds in such a way that i can restrict the user to insert a next record when the one of the fields in the previous record is null. And also i should pop up a...

    VBAccess5 pointsBadges:
  • Limiting characters in memo field

    In Access how do I restrict the number of characters a user can enter into a memo field?

    Olddog10 pointsBadges:
  • MS Access IIF

    There is a task type column and a cost column. I need to pull out only the costs related to the task type steel. I was thinking an IIf ( [tast type] = steel, sum, 0 ) statement would work. Not making it happen. Any ideas? I actually want to pull out all of the different types of costs seperately...

    Keg5 pointsBadges:
  • auto send e-mail

    How does one auto send e-mail from access

    Mabaxter5 pointsBadges:
  • MS Access – Email from form – VAR email receipients

    Hello, I have an access dbase and I need to email records (usually one at a time) to different receipients. The receipient name is part of the form and I have a table that lists the name and e-mail address. I am hoping to click a cmd button that will e-mail that individual the record on view. I...

    Asuasol10 pointsBadges:
  • Convert time as text to datetime

    I've got a stupid table that I have to work with (and no, I can't change it) that stores times of certain events as text (example: '10:25 pm' or '3:02 am'). This table has an actual date to work with, which is essentially just the date with no time component. Know what I'm going to ask yet? You...

    VentureFree45 pointsBadges:
  • Microsoft Access

    I have created an Iff statement where it will compare two fields and return the bigger number. The problem is that instead of compare the numbers as a whole, it compares them digit for digit. Result is that it will return a value of 150 instead of the bigger value of 1040, because the second digit...

    Jaco65 pointsBadges:
  • MS Access ActiveX Control

    I am using a MS Form where I am trying to fill in a couple of date fields from a Calendar I inserted using ActiveX controls. How do I go about doing that? Thanks, Asuasol

    Asuasol10 pointsBadges:
  • Combined Address

    I have one tblContacts that has "Home" and "Work" address included within it, I also have an option button 1="Work" and 2="Home". I need to prepare a mailling report, but only for the defaut address. Someone suggested that I create a calculated field. I tried this but all that it is doing is...

    Thuzinec10 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