1
  • Date functions

    What is wrong with this function:=DateAdd('d','20',[REFERRAL]) I am adding 20 days to the Input date "Referral date" label . The message I get back when I save is that it cannot find REFERRAL? This function is in the Default Value for the date I want to change (Audit Date)

    HELPTECH10 pointsBadges:
  • Upgrade from Access 97 to Access 2010

    Hi All, I have a client requirement to upgrade our existing application which is developed on Access 97 and running on Win Xp to Access 2010 Win 7. The Access 97 database has file like .MDB, .MDE and .MDW. Can someone, please suggest a way to upgrade form Access 97 to Access 2010. This application...

    mercuryspark10 pointsBadges:
  • How to set up a simple form

    Hello! I'm very new to Access and have a question. I have a database set up and a form designed. I carrier items from an auction house, package them and ship them. I need a way to input client data and record of its progress (quoted, picked up, processed, shipped, etc). Once it has shipped, I'd...

    jlanefwbbc10 pointsBadges:
  • Using IIF statement in query to return answer

    How do I write a IFF statement to return data? I am trying to write a IIF statement to let a student know if they are approved or not approved to play a sport. Here's the statement: Status: IIF([Waiver]="Yes"]) and IIF([Academic]="Yes"), "Approved", "Not Approved" When I do this and hit run, it...

    loggerhead79150 pointsBadges:
  • Getting data from two sources into one table

    I have a form that will add data to say mainTable. In the form, I want to get some data like last name, first name and client_number from a linked master table (using a combo box) and have that data added into mainTable . I would also like to enter data (last name, first name and client_number)...

    handlewhat5 pointsBadges:
  • Update query doesn’t update table

    This is a really basic question, but I can't seem to make it work. I have a simple table with 3 fields. StartTime EndTime ElapsedTime Each field is defined as a date/time datatype. StartTime and EndTime are manually entered. I'm trying to use the DateDiff() function in an update query to populate...

    bonesie15 pointsBadges:
  • Incrementing a key field without autonumber

    I want to use a primary key field in format AAA9999999. Can I get the numeric part of the field to automatically increment to the next number in the range?

    HNDstudent5 pointsBadges:
  • Sort data in a column, not alphabetical

    I have an Access database that sorts the data in a column alphabetical and I want it to match my Excel spreadsheet which is by area. Where do I go in the database and change it so it follows my spreadsheet?

    DAHurd25 pointsBadges:
  • Access 2010 Field Design View, how to set up for multiple names

    I am using Access 2010 and I am setting up a training database to show trainers names against various training modules. Now some of these training modules have many trainers against these modules, how do I set this up? I have made a table with the modules and now I need to put trainers names to the...

    apmitch5 pointsBadges:
  • Formatting Cells individually in a Table – Microsoft Access

    I am currently in the process of using a Table to track employee annual leave, I need to be able to highlight all the weekends (saturday and sundays) in a different color to make easier to read. How do I do this?

    azuby2420 pointsBadges:
  • Access

    How do I change the selected columns to be required pieces of information?

    gooman5 pointsBadges:
  • How to add a text box within a option group on a form?

    I need help trying to add a text box to my option group on Access 2010. Within my option group I have it listed: Materials Labor Heat Rate Other: (text box) Or at least thats how I want it, but as I input the information to the "other" text box, it shows up on ALL the forms. I guess my question is,...

    Amroberts120 pointsBadges:
  • Question about toggle/option buttons on Access Forms

    Can anyone help me out?! I have added toggle/option buttons to my forms on this Database I'm managing and I have multiple forms and every time I click on the "option" button, it clicks it on EVERY form, my question is HOW DO I GET IT TO JUST SHOW UP ON THE ONE FORM I NEED IT TOO? For instance, I...

    Amroberts120 pointsBadges:
  • Creating a new report with a macro in Access 2010

    I currently have a macro that pulls in a very large text file, delimits it and then opens up the table. Now I want my macro to basically press the Report button to create a report. The OpenReport macro will open up a report that is already defined but doesn't seem to "create" a report from scratch...

    Dmphipps5 pointsBadges:
  • copying tables to excel

    How do I copy a table with more than 65000 records into an excel workbook?

    DatamanWarwick5 pointsBadges:
1

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