• Database Access 2007

    Hi, I have created a database and created a query with some fields from my main table. Now I would like to add more fields but I can't any hint? When I go into my design mode those new fields do not apper?

    Ld23315 pointsBadges:
  • Application.FileSearch no longer exists (in 2007)

    My company is migrating to Office 2007 - I have VBA code that works wonderfully in "older" versions of Access, but will not work in 2007. One in particular is "Application.FileSearch" - what can I use instead? (And why was it removed??)

    Dhoosier5 pointsBadges:
  • Need Help With Multiple Conditions and Constraints for Access 2007 VBA Event

    Hi, I’m working with VBA for On Click Event procedures in Access 2007. My knowledge of Visual Basic is rudimentary and I've come against a business rule I can't even begin to figure out how to code. I work at a college and was asked to build a database for a student conference we're hosting. One...

    Dataempress115 pointsBadges:
  • Windows Sharepoint Servs 3.0 – Linking existing Access 2007 Database with new list.

    Is there any way I can link a pre-existing table/query in an Access 2007 database with a new Sharepoint list? At the moment, the only way I can find to do this is to copy the information from Access to Sharepoint, then import the copied data back to Access and link these two. I need to be able to...

    Domc1115 pointsBadges:
  • Subject: Limiting information in combobox

    I have two comboboxes, one shows a list of customers, the other shows a list of contracts. One customer can have mutliple contracts, but a contract can only have one customer. I want to limit the contracts in the second combobox to only the contracts of the customer in the first combobox. I have...

    Gavaughn10 pointsBadges:
  • MS Access 2007 Author credit

    I'm designing a database for my town office as part of my class project. I want to put my name on the project somewhere as author so I get some credit for my work. Where/how can I do this?

    Lwbadgr5 pointsBadges:
  • Sending more then 1 Access Report to Outlook

    Hi, I have 2 Access Reports which I need to send to Outlook as attachments. I usually use SendObject, but that only allows for 1 attachment. I am using Access 2007 Thanksyou Julie

    JulieSandra15 pointsBadges:
  • Combo search box – “Invalid Outside Proceedure”

    ..and before you ask, no I don't use anything linked into Access 2007 to program my database. So, I've been creating a form coming from the same table with the same information to be used as a separate edit form. And now suddenly my "search box" gets this error in my normal form. HELP!

    Abaumeister25 pointsBadges:
  • Access 2007 Report OutputTo Print

    Please help. This is driving me around the bend. I have a report that I OutputTo Rich Text format but my Percentage calculations do not survive the conversion from the report to the saved document. Please see: Has anyone encountered this before? I have many other reports and they all save correctly...

    Riaane65 pointsBadges:
  • Access 2007 – How to include option group on report

    Hello, I'm new to Access so please consider this when forming your response. This has been driving me crazy and I've looked high and low on the 'net for a solution. I look forward to your response. I have a form with an option group. I've wish to have this display on my report. Take for instance...

    Tuxalot5 pointsBadges:
  • Monthly Average in Access 2007

    Dear All, I need to calculate the monthly average on an array of data the gets added to weekly. Therefore, from Jan to March, the total is divided by 3. Come April, the total should be divided by 4, and so forth. Please, no VB code if possible - my VB sucks Thanks Riaan

    Riaane65 pointsBadges:
  • Access/Word Mail Merge Currency lost digits

    I made a Donations database which merges with a Word document that provides a receipt. The data that comes over drops zeros after the decimal. Ex: $700.00 appears as $700 ...Even worse $700.60 appears as 700.6 How do I get the decimals to show?

    OBI Girl85 pointsBadges:
  • Sum of Donations for current year

    I have a query that sums donations and groups them by year. When I print receipts, it gives me two receipts -- one for year-to-date donations for 2009, and another that includes 2008 and 2009 donations. How do I get just the one receipt to print?

    RonleeG5 pointsBadges:
  • Crystal Reports can’t connect to Access 2007

    We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see the dB's. I think it is the new file extensions with Access 2007. Anyone know how I can connect and see the dB's.

    Rcsully6515 pointsBadges:
  • Minimize results in form.

    I am trying to create an issue tracker for my company. The problem is that I have many contacts for each customer(Each contact will have their own record in the "customer" table). What I would like to be able to do is when I enter a new issue, I will select my customer from a drop down box that is...

    Jvaniman15 pointsBadges:
  • mixed 2000 db and 2007 mixed datepicker results

    I had an old access database (2000) and ported it to access 2007 all well and good then created a new date field in my form, now i get the datepicker option for the new field but none of the old date fields. any ideas how to get access 2007 to give date picker to my old date fields, i have already...

    Jarcher1230 pointsBadges:
  • VBA to print to specific printer with print button

    In Access 2007 how do I use VBA code in my print button to print to a "specific printer" for my report.

    RPJ5 pointsBadges:
  • Microsoft Access 2007: Using an IF statement

    I want compare a field in one record to the same field but in the next record. For example I have this IIF statement: IIf(([MAILADDRESS]=[MAILADDRESS]),True,False) This will compare the MAILADDRESS in the same record but I want to compare that same field but in the following record. How do i do...

    Servent15 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:
  • 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:

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