msaccess

  1. P

    MS Access remove date but keep time

    Hello, I have a date/time field that either contains the date and time "1/1/1900 5:30:00 PM" or just the time "6:30:00 PM". I would like to remove the date if it's there and only keep the time when I run my query. Can someone help? Thanks, Adam
  2. K

    Calculating results by combining two tables in MSaccess

    I want to draw a result based on data available in two different tables in the same database. Basically, I want to calculate the % share from both of these tables My Table 1 looks like this and has data somewhat like this. | Code | Category | |------|----------| | ABC | 123 | | BCD | 145 | | DEF...
  3. K

    Counting text in multiple columns together

    Hi, I want to count a specific text in a column and also want to do this for multiple columns (6 columns in a single table). Need help. I am only able to do it one column at a time. Sample Table: <tbody> Month Text Week Ending Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 Dec'18...
  4. A

    Find Week start and End Date from any sepecific date of week required in Excel and MS Access.

    Hi Everyone, I want week start date (Thursday) and week end date (Wednesday) from current selected month, I have tried to find First date of week by this formula "=MIN(C3-WEEKDAY(C3,14)+1,EOMONTH(C3,0))" and Week End Date by Formula "=MIN(C3+(7-WEEKDAY(C3,14)+0), EOMONTH(C3, 0))". Formula...
  5. wind20mph

    MSAccess vba to read a text file any advise?

    Hi pleasant day to everyone. I am new to this forum and I need some advise in MS Access - Excel VBA. Starting with MSAccess, how do I read a text file line by line and put it in a VBA variable? thanks in advance. Data content of a text file hostname = 192.168.33.11 port = 3306 username =...
  6. C

    Ms Excel versus Ms Access

    Hello, I work for a the doctors' HR department in a hospital. This fall, we will have to review our systems and make a lot of changes. I was wondering if we should consider changing our database made in an Ecxel spreadsheet to Ms Access. Ultimately, we would like to be able to keep data on...
  7. R

    Suggest more efficient code for this loop on very large Excel data - Trying to cut down from 20 min

    Thanks for the previous comments. It helped me shape the design. The Excel Report generated from MS Access VBA is completed and working fine. The only problem is that the code shown here for the loop takes about 20 minutes. Any suggestion on more efficient way to accomplish the same thing would...
  8. A

    Create dynamic Connections from MS access for Pivot Table in excel

    This is the first time I am using VBA and MS access. I developing a dynamic chart in excel for my client.This chart is link with pivot table and pivot is linked with MS access. There are couple of issue which I am facing it. when I am trying in different system and getting a pop-up message...
  9. P

    MSACCESS 2010 SumProduct (Expression or VBA)

    I am new to MrExcel, but have gotten ALL my issues resolved simply by searching threads, however this one !@# *This has been migrated from EXCEL to MSO ACCESS 2010 I have a database that uses the days of the week for its field names. Each row has similar data. Row 1 has the same data as Row 2...
  10. R

    calling ExecuteExcel4Macro from Access 2010 VBA module - can't seem to get reference right

    These are my code fragements after many attempetd failures to call the ExecuteExcelMacro from an Access 2010 VBA module. Access referencing Excel (in code window, References, Excel checked) is a preferred way to create reports from MS Access 2010. Just can't seem to get the object reference...
  11. M

    Access front end MySQL backend conxtion troubles

    Hi all, hope someone can help me! I cannot get a connection to this MySql database for the life of me I have tried everything. this is where im at at the moment http://itc.virginia.edu/desktop/web/mysql/msaccess.html. ip, port and credentials are all good but I keep getting the 'Connection...
  12. D

    MSAccess limitations when linking to ODBC database

    My Office PC has Access 2002 installed (with Office Standard 2003). I'm connecting to a remote Mainframe containing hundreds of DBase2 tables, the structure of which I have no control. Whenever I link to the table I'm interested in, Access pulls through around 256 fields of which I need about...
  13. H

    Search before you add

    Can anyone give me some ideas as to how to force a user to search for an existing client, open a form showing that client's record if found, show an empty form for the addition of a new client if not found. I've tried putting a dummy record as the first record in my client table but my dear...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top