microsoft access

  1. M

    text search box searchforrecord

    Hi, Please someone help, I've been trying to complete this for 2 days now and cannot find the correct solution. I am fairly new to Access but fairly knowledgeable as well; I have taken 24 hrs of Access training. I have an employee form and would like to have 2 text boxes at the top of the form...
  2. M

    Excel (VBA) Project Ideas - Your advise needed!

    Dear Group Members, I have recently joined this group since I have started a University course which requires VBA/SQL programming. Since I have not prior experience in programming, but have some IT knowledge, I would like to ask for your help.:) For my project, I have to come up with a...
  3. V

    Field 'F1' doesn't exist in destination table "test" in ms access import text file

    Hi Guys, I have a written a code for a button in a form to import text files with the following field names in the text file. Title LastName Firstname Address City State Please see the below code and help me in finding the issue with the code. Private Sub...
  4. A

    Need Suggestions on How to Create a Customer Rollforward

    I have a customer database with the following: tblCustomers that includes the following fields: pkAccount_Num, Customer_Name, Service_Market, Acquisition_Date (required), Cancel_Date (null if customer has not cancelled). I have been able to summarize the data using 2 separate crosstab queries...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top