• Access Database Splitting

    I just split a database because there are multiple people using it and we started having problems with people not able to get into the database while someone else was in it. I moved all the tables to the back-end and created links to the tables in the front-end. After doing this we tested out. The...

    Randrae15 pointsBadges:
  • Increasing text in Access 2007 without losing info

    I have formatted an Access Form with four inserts for text as each were limited to 50 characters at the time, this works but is tedious as some of my input is over 50 characters and breaks up my text to the next insert what I am looking for is to encrease my text characters as much as possible for...

    PeterQ10 pointsBadges:
  • “Automation Error Invalid Advise Tags” What is an advise tag?

    I have a visual basic module within Access that seems to compile fine; when I select the Debug function in the visual basic editor, I receive no errors or messages.  However, within my Access form, when I try to click the button associated with this module, I receive the error message, "Automation...

    Siggy5 pointsBadges:
  • Access 2003 report printing

    We've been using Access 2003 for a while and are now changing over to 2007. At the same time, I am creating a new report to replace a report we've used in a database successfully for several years. I open the new report, and it looks perfect on screen, then I print it using the printer icon. The...

    tlsanders11,340 pointsBadges:
  • Access 2007 button addition

    Hello I have what I assume to be an easy question that hopefully someone can help me out on. I have a form that I need to add a button to that will pop up a box that you can write a description in. It needs to be different for each record that comes up in the original form. Does anyone know how to...

    Jdusaf5 pointsBadges:
  • help with access database

    Searched high and low and while there are many internet posts addressing this topic, none seem to be geared low enough for this ubernubee. I have 2 tables, one lists various addresses and associated file numbers, the file numbers are unique and the primary key in the table. The other table lists...

    Joebaich5 pointsBadges:
  • In Access 2007 for query exports to Excel 2007 – How do you turn off Automatic backups

    How can Access 2007 be set so that when it exports queries to Excel 2007, backups are NOT created in Excel each time the Excel file is saved?  How can Access 2007 be set so as not to cause EXCEL 2007 to backup exported query files?

    2010475 pointsBadges:
  • Password in Delete Button in MS Access 2007

    How to set a password in command button "Delete" in microsoft office access 2007 ?, that the only thing we need for our defense, please help me .. thank you !! :)

    Tipsdawn10 pointsBadges:
  • Data transfer from Access 2007 to Excel 2007 stops at 65,xxx rows

    How do we transfer/export data with over 575,000 rows in Microsoft Access 2007 to Microsoft Excel 2007? Is there a way to change the export data # of rows restriction of 65,xxx rows to 1 million rows in Microsoft Access 2007?

    MLM10 pointsBadges:
  • MS Access Report modifications

    I am using MS Access 2007. I am trying to modify a report and I want to delete the label in the page header section but not the detail field. I cannot find a way to detach the label from the detail field

    Heymon20 pointsBadges:
  • Hyperlinks in forms sent from Access 2007 to Sharepoint 2007

    Hi, I send files from Access 2007 to Sharepoint 2007 daily. The first column of data in the Access file is a hyperlink, and appears as one(htt:.....). When I send the file to our Sharepoint sight I would like it to appear as an image of our logo in that field, instead of the url. The link is the...

    Carystand15 pointsBadges:
  • Converting from Access 2003 to Access 2007

    hi, everyone i have 3 desktop with Access: one have Access 2003 two of them have Acess 2007 so i divide my Access database in two parts on of them have tables an other a form queries, etc. My problem is, is possible link tables for these three desktop's. because of that diference i convert for two...

    BUG68235 pointsBadges:
  • Need project plan for Access 2007 database migration to SQL Server

    project plan with steps outlined

    Anflores5 pointsBadges:
  • Multiple user login in one Access 2007 database

    I found a lot of answers how to make a multiuser login but when count of users is known. I want to put all my users and passwords in one table and search for them. For example (I am admin with full access. I want to add a new user and give him different access. So I'll put a new record in my...

    Johnnyt05 pointsBadges:
  • Progressive Incident ID number in Access 2007

    I have a db that records each security infraction at a library. The desired ID number for it is year/month/day/number of event that particular day (example, 2010/12/01-1 for the first event, 2010/12/01-2 for the second, etc.) My question: I have this -- 0000/00/00-0;_;;_ -- as the format for people...

    Markcwrite5 pointsBadges:
  • Access 2007 Report / Query ?

    I have a soccer player database that has fields for parents names and fields for parental support (coaching, concessions, committee) I want to check my parental support fields for(checks) then print that parents name on my report. So in the end I have a listing of parents and what they will help...

    Rladkins821985 pointsBadges:
  • ACCESS 2007 setting up repetitive entry form

    I'm doing a database for our transportation company. How can I set up multiple expenses for multiple vehicles? How can I set up a form for data to be entered by choosing a vehicle, a month during the year, and multiple expenses on a single form?

    Net201015 pointsBadges:
  • Putting object description in Access 2007 navigation panel

    how do i get the object desc. to show in the navigation panel?

    Rdd111115 pointsBadges:
  • Creating Automatic Notifications in Access 2007

    I am building a volunteer database. I have a table tracking hours that each volunteer has put in, and would like to be notified when they reach certain milestones, (eg, 25 hours, 50 hours, 100 hours), so that we know who to thank appropriately. I believe that I will need a query totaling the hours...

    MeowGina10 pointsBadges:
  • Green Boxes in Access 2007 form after deleting O’s & 1′s from database

    I have a database tracking the information turned in on a hard copy form. If a patient triggers specific questions the data must be input: so if someone triggers the depression, I in their suicide rating, treatment plan, etc... I have the access form use check boxes but the data base use -1's. I...

    ARickert20 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