• Rusty and Need Help

    I've been out of the IT Business for several years and have come out of retirement to work with a local community college on Training Grants. We collect specific pieces of data on each student that works for the company that we have the state grant for. It is becoming a nightmare to track everyone....

    Bluize20 pointsBadges:
  • How can I add Multiple Subdata Sheets to a single Table in Access 2007?

    I'm attempting to add subdata sheets that come from several different tables in my database to my master table. I have found, however, that no matter how I manipulate the different relationships I can only get one subdata sheet to work at a time. Is there anyway to link multiple tables as subdata...

    Zwoods10 pointsBadges:
  • MS Access conversion to CSV files

    I am using MS Access 07. Whenever I use the control to export the table as a .csv file, it changes all the fields properties, returning to the "text 255 cha" values. I need specifically to keep the same properties. I used to be able to do it and is not working now.

    Hsisan5 pointsBadges:
  • Sending MS Access reports in the body of an email.

    How to send a report in MS Access to the body of an email in MS Outlook.

    Rarto10 pointsBadges:
  • open a file in access by clicking button

    I have several directory paths in a list box and I want to highlight one and double click on it and have it open the file

    Rmaylath25 pointsBadges:
  • Building A File Searching/ Tagging System

    Hello...I want to make something in VB (Version 9) that reads multiple data from specified file (Access 2007) and displays content in list box. If file doesn't exist, alert user. More description: My name is Steven, I'm a college student and now I'm running my practical session to complete my...

    Stevio10 pointsBadges:
  • Database Window Stuck Behind Title Bar

    When I open a specific database in Access, the Database Window is helplessly stuck behind the title bar. I've tried everything to get it out including closing and reopening, moving menus, everything. Here is a screen shot to show you what I mean: http://i35.tinypic.com/2mq7zux.jpg If anybody could...

    Makeshiftmonkey5 pointsBadges:
  • Refusal to recognize SQL Server 2005 Express on a client PC

    I have installed SQL Server 2005 Express with about 10 client PCs. I also have Microsoft Access 2003 on the front-end linking to it using System DSNs. On one of the PCs, it refuses to recognize the SQL Server when I try to create a DSN. It does, however, see a different SQL Server that was...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Autonumbering gone wrong Microsoft Access

    I am using an append query to add data to a table. The query works except I have an autonumbering field and am not including it in my query because I want to continue the autonumbering in the table I am adding data to. The only problem is, is that the autonumbering is beginning from a much higher...

    Kball5 pointsBadges:
  • SQL Server 2005 within MS Access VBA

    I have am MS Access (VBA) program where I need to create a table on a SQL Server database then append data to the table. I have the code that generates the update query but I need the ADO code that creates the connection to the SQL Server 2005 database then I need the code that will execute the...

    Rjwilcox45 pointsBadges:
  • 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:

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