• How to transition an old local CRM system to a more modern networked CRM Solution

    Hi. We have an old CRM system that is currently local to only a single location and we are looking to transition it to a more modern system with network capability and would appreciate any advice about the best way to go about it. Basically, we currently have a fairly simple Microsoft Access (2007)...

    ericw19755 pointsBadges:
  • Apply 2 mathmetical operators on Access fields

    Hi all, could you help me to create new field on Access table calculating the sum of two other fields and divide it by 2? I am struggling with its syntax. Thanks a lot.

    Knowledgeislight5 pointsBadges:
  • Date dd-mm-yyyy reversed to mm-dd-yyyy

    Hi guys, Could you tell me why when I insert date into a database table, it's reversed from (dd-mm-yyyy) to (mm-dd-yyyy)? I have well defined my date format on form design already, but when it's inserted into the table it automatically reversed. How can I solve it?

    srithea360 pointsBadges:
  • Random generate in Access SQL

    If one random generate program on web, can it be hacked by a hacker and get the result?

    eessm13975 pointsBadges:
  • Measure occurrences in MS Access SQL

    I was wondering whether it is possible (and if it is, the way) to perform the following task in Microsoft Access: there are two tables; first one consists of three columns 1) ID 2) tweet text and 3) date. Second table is a single vector of words, like a lexicon. For every row of the first table, I...

    dempar5 pointsBadges:
  • Value too Long in Microsoft Access

    this is a hypethetical question.. Using MS Access you enter the last name of a student, and you recieve an error message stating that the value is too long for the field. What are your next steps?

    Jeffhill5 pointsBadges:
  • How to insert row number using SQL

    When importing data from Excel into MS Access, how do you insert a row number using SQL?

    JimStAubin201515 pointsBadges:
  • Conversion of Microsoft Excel formula to Access

    How do I convert the below given formula of MS Excel to MS Access for the following data: ID Level Session Gender Regular/Plus Shift Programme Section 13 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-4 14 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-3 15 INTERMEDIATE...

    MUHAMMADYOUSAF10 pointsBadges:
  • Cascading combo boxes in Microsoft Access database

    I am a Continuing Education Teacher and I have been asked for help in building a function in a Microsoft Access database. I must say I have not yet found a solution. So, here what is needed: “I have constructed a contacts and networking database that I use to gather information on my professional...

    lawantyson5 pointsBadges:
  • Microsoft Access: Reports in Custom Groups vanish

    I have a couple different groups under Customs Groups in Access, and more than once now, when I open a Group there is nothing in it?

    Jaljets5 pointsBadges:
  • Paste records in OLE Unbound Excel Object in Access Form

    Ok so I have built a database that is used to house and manipulate records that I get from a monthly report that is posted online. Basically I work for the Army and we have over 50 units. Each unit has anywhere from 10 to 1000 soldiers in it. I initially had tried to build a database with a table...

    Brianaaskew40 pointsBadges:
  • Can you accept or decline task in Microsoft Access?

    Can task be forwarded to a person among group of persons in Access?

    ahonutere5 pointsBadges:
  • Sorting of students strength on one form in Microsoft Access

    I have a table named Students with the following fields and data ID Level Session Gender Regular/Plus Shift Program Section: 13 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-4 14 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-3 15 INTERMEDIATE 2013-2015 MALE REGULAR MORNING...

    MUHAMMADYOUSAF10 pointsBadges:
  • Updating forms in Access

    I have updated a form with membership information, adding several new fields. How do I get Access to update previous entries to include the new fields?

    lmack15 pointsBadges:
  • Microsoft Access import foreign key

    My question is basically this about MS Access: How do you import data into an existing table if at least one of the fields actually contains a foreign key related to another table? Let me give an example: Tables/fields involved: 1. "tblEmployee" with fields "EmployeeID", "EmployeeName", "StateID"...

    HardlyNotMe5 pointsBadges:
  • Building a query in Microsoft Access

    Hello: I need a code to create an auto generated multi record report depending on date like if I have a 4 portions loan that it's payment will take 4 years. The report will create a 4 records each in a year of how much to pay, starting from the first year. I want the query to calculate as that: I...

    theseeker7210 pointsBadges:
  • Microsoft Access joining tables

    I made a new table by doing group-by max from table-A, through Query design. Now I need to include a new column from table-A that matches the content in the Max column (which I already done max group-by). I try to do some ways but its picking the whole data in Table-A (but I need only matching...

    vinulopez015 pointsBadges:
  • VB6 and Access database combo box

    I have 2 combo boxes. In first combo box, I have district name from database table. If I select any one district, combo2 will display all schools in the concerned district from the access database table.

    shekarsuma5 pointsBadges:
  • Auto populating Excel fields from an Access query

    How do you auto populate an Excel report leveraging data computed in Access - is there a link function?

    Brigita5 pointsBadges:
  • Query for add, delete, update and insert using VB6 and Microsoft Access

    How can I query for add, delete, update and insert in Visual Basic 6.0 and MS Access?

    nagu7645 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.

Thanks! We'll email you when relevant content is added and updated.

Following