• Changing Access form properties within your program.

    I have a form where I want to lock a control according to the selection made in a combo box. How do I go about doing this? Thanks.

    AOMCprog5 pointsBadges:
  • Hide print page that is blank in Access 2003

    I have a report that from a query displays multiple fields. In some cases a second page hold additional data. How do I suppress the second page when the main data section is blank?

    Richpax5 pointsBadges:
  • Access VBA Code stops at Midnight

    Why do all my Access VBA scipts stop at Midnight?

    Robert19735 pointsBadges:
  • How to delete a database – MS Access 2007

    I am using MS Access 2007 and I thought that I had managed to delete a database, but every time I open MS Access 2007 the database is still showing in the Recent Database list. Is there a way that I remove all traces of that database and stop it from showing in that list?

    NLC30 pointsBadges:
  • Export AS/400 to MS Access

    My auditor wants me to export files from my AS/400 to MS Access and I don't have a clue how to do that or if it can be done. I hope someone does.

    Dowagiac5 pointsBadges:
  • convert string to double in Access 2003

    Hi - I'm trying to convert a string into a double using this expression in Access Expression builder: Field1: CDbl(string) It's not working. does anyone know why? thanks...

    Contactesa5 pointsBadges:
  • ACCESS ERROR CHARACTERS FOUND AT THE END OF SQL STATEMENT

    I tried example 6 from the book SQL for Microsoft Access and got the error message" CHARACTERS FOUND AT THE END OF SQL STATEMENT. I tried deleing the first semicolon and got a message: missing semicolon at end of SQL statement. Can anyone tell me what I am doing wrong? Thanks, INSERT INTO Toys...

    Fredking5 pointsBadges:
  • connectivity between c++ and ms access

    hi, i have problem releted with ms acess and c++ programming languge sir cant get any information about connection between ms acess and c++ programming languge give me steps to connect ms acess and c++

    Hmaria5 pointsBadges:
  • How to Set Active Period in a Table

    There is a table of multiYears record. Transaction date should be between Active Period. If any time I want to change/edit previous year record, first, i have to set that year as Active period. I have to select active period through a Form by dropdown Combo box option. When I select any year, this...

    Abdul30dec80 pointsBadges:
  • How to Set Active Period in a table

    I have defined financial periods in table. In this table i have defined 3 fields, 1-StartDate, 2EndDate, 3-ActiveDeactive. Field type of "ActiveDeactive" is set to Yes/No. One record should be ON and remaining all OFF I want to set any financial period as active period at any time

    Abdul30dec80 pointsBadges:
  • Access restrictions based on MAC

    I have developed a dbase system using MS Access and .net which is a multi-user system, database being intsalled in primary server. I would like to restrict access / usage by applying MAC address. Plz advise on steps and codes. Thank you.

    Ravindranpk10 pointsBadges:
  • MICROSOFT INTERCHANGABILITY

    Does Word, Excel and Acess work together interchangeably?

    Swanson5 pointsBadges:
  • Calculate Business Hours

    I found a VBA code that fits the program I'm trying to create but I'm having a difficult time locating the 12-1 lunch break so I can make it straight time. Listed below is the code. Function CalculateDownTime(StartTime As Date, EndTime As Date) As Double Dim Result As Double, EndDay As Date Result...

    Bostic8620 pointsBadges:
  • Adding Leading Zeros to a string

    I have a field with a mixture of 9 and 8 character strings... I need to make them all 9 characters in length..so how do I add a leading zero to those records with only 8 characters while leaving those records with 9 characters alone?

    Yahudee5 pointsBadges:
  • How to get mutiple client lines to appear on a single line

    I have a table in Access with mutiple rows of client information that I would like to see on a single line. Ex: Henry Ford in Q1 had 17 orders in Q2 he had 22 in Q3 had 11 orders in Q4 he had 35. Right now there are separate lines for Q1, Q2, Q3, Q4. A single line with Q1, Q2, Q3, Q4 headers is...

    Lsaucier5 pointsBadges:
  • List all file members from a multi member AS400 File

    I need to be able to retrieve a list of the members of a multi member file  so that I can process the members that meet certain criteria.  I need to be able to do this from a PC application. If there is anyone with any ideas I would be grateful.   Thanks

    AndrewPage5 pointsBadges:
  • How to eliminate double-entry in Access

    I'm using Access as a scheduler to schedule clients for my business. Each client has a unique and customized schedule. How can I eliminate extra work for myself everytime I schedule/cancel a client. Is there an easier way to do this? Also, clients sign up online and then I enter into Access. Is...

    Sonsie5 pointsBadges:
  • Access Calculations

    Recently made database table in acces. Then made a form from the fields in this table. Data entered into from appears in database table. Added calculations to form, calculated results appear in access form but not in related fields in access database table.

    Greenenergy5 pointsBadges:
  • Create a querry to select certain records from a Acess Table

    I am creating an Access database that contains a lists of tasks. MY QUESTION IS is there a way to create a query to pull a subset of those tasks to be included in a job? As new jobs are created, I need a way to include a new subset of tasks in a report without have to input all of the tasks...

    Stevek4910 pointsBadges:
  • find min/max date in access which also return their value for each record

    I have a table with more date per record (ID1 thru ID10) and the each date have a score, I want to select from each record of their min date and max date with their score (the score is not the min/max score), the data set is: ID    Date              Score 1     12/03/2003    ...

    Find5 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