Search:

Type: Posts; User: 22strider; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    447

    Re: Exceptions table

    Hello Jon,

    Because all the fields in Table2 are also present in Table1 there should be no NULL (unless I did not understand your approach).

    My goal is to return records from Table1 that are not...
  2. Replies
    3
    Views
    447

    Exceptions table

    Hello,

    How can I return records from table-1 that do not match with records in table-2?

    I have a master table (say Table-1) that contains all the data. Another table (Table-2) contains records...
  3. Replies
    1
    Views
    957

    MS Word Bar Codes

    Hello,

    Could you please point to why my MS Word 2016 cannot view (and save) bar codes. Upon opening (or saving) a document that already has a bar code my MS Word converts the bar codes to text.
    ...
  4. Replies
    0
    Views
    502

    MS Word Bar Codes

    Hello,

    Anytime a save a file that has bar codes in MS Word. The file converts bar codes in to human readable text.

    Any idea why is it doing this and how to stop this behavior?

    Regards,...
  5. Replies
    5
    Views
    937

    Re: MS Access auto/scheduled report export.

    Thank you very much for your help. I will follow your guidelines and report back. I might need further help in creating batch file and task scheduler. I will get back in couple of days with more...
  6. Replies
    5
    Views
    937

    Re: MS Access auto/scheduled report export.

    Hello Dbc23,

    What you mentioned is correct; I need to share excel export report.

    Rather than sending email I was hoping to save excel export on shared drive. I can put Access db on that shared...
  7. Re: Sharing MS Access applications over internet

    Hello,

    Thanks for your message.

    The goal is to create a report and share with team that is located remotely. The users may not have MS Access and also would probably looking for easy 'press a...
  8. Replies
    5
    Views
    937

    MS Access auto/scheduled report export.

    Hello All,

    Is it possible to run MS Access report export (to MS Excel) by a user that does not have MS Access?

    I need to share report that uses data over ODBC to multiple remotely located...
  9. Re: Move cursor to the next record after adding value using bar-code reader

    After little search online I learnt that it can be performed by programming bar code scanner. It was easy to program; just matter of scanning 6-7 parameter bar code for adding tab to the end of value...
  10. Move cursor to the next record after adding value using bar-code reader

    Hello All,

    Is there way to configure MS Access so that the cursor moves to the next record (below) after I enter value (using bar code reader) in a record?

    We are entering a number of values in...
  11. Replies
    5
    Views
    136

    Re: From column to single cell

    Thanks Tom;

    Your code worked very well.

    Regards,
    Rajesh
  12. Replies
    5
    Views
    136

    From column to single cell

    Hello Friends,

    Could you please help with VBA code for doing following:

    1) Read list of values in a single column
    2) Enter all those values delimited by semi colon in to another single cell.
    ...
  13. Replies
    3
    Views
    412

    MS Access for MAC

    Hello Friends,

    Is MS Access compatible with MAC?

    I recently bought new MacBook. I am finding that MS Access may not be compatible with MAC. If this is true then which other Relational DB can be...
  14. Chart-plotting %age but data label displaying absolute number

    Hello Friends,

    Is there a way of displaying absolute numbers (for example 50/100) as data labels on the chart plotting %age.

    I have a line chart plotting %age of some data. I would like to...
  15. Replies
    7
    Views
    438

    Re: Format date for group by function

    thank you very much. I am sure both methods you suggested would work. I tried Method1 and it worked; going with Method1.

    Thanks again,
    Rajesh
  16. Replies
    7
    Views
    438

    Re: Format date for group by function

    Hello Joe4,

    Following is my calculation:

    DatePart("M", [Effectivity Date])&"/"&DatePart("yyyy", [Effectivity Date]) AS [Calculated Date]

    Upon sorting results based upon above given script...
  17. Replies
    7
    Views
    438

    Re: Format date for group by function

    Hello Joe4,

    Thanks for your replay.
    I did try that. The problem was with sorting. The date field was getting sorted alphabetically rather than in date chronological order.

    Regards,
    Rajesh
  18. Replies
    7
    Views
    438

    Format date for group by function

    Wanted to add that I am using MS Access 2013

    Hello Friends,


    For my report I have to group records by Month/Year. The data has date in the format of date+month+year+time; I was able to...
  19. Replies
    7
    Views
    438

    Format date for group by function

    Hello Friends,


    For my report I have to group records by Month/Year. The data has date in the format of date+month+year+time; I was able to reformat to Month-Year format. But the problem is that...
  20. Replies
    1
    Views
    651

    Link Table; Column heading in 3rd row

    Hello Friends,

    Can I link to a table (CSV format) and have Access ignore first 3 rows?

    The Table that I am linking to have junk data in first 3 rows; the 4th row has the column headings.
    ...
  21. Replies
    4
    Views
    201

    Re: Modifying Data Format

    Thank you very much; worked like a charm
  22. Replies
    4
    Views
    201

    Re: Modifying Data Format

    Hello Rick,

    Thanks for the code; it works. My header row is row number 1. I tried running the code by replacing 3 with 1 but it gave me error. The other feedback is that the out put has additional...
  23. Replies
    4
    Views
    201

    Modifying Data Format

    Hello Friends,

    I am preparing data to be imported from Excel (2010) in to our MRP. The system requires data to be presented in certain format. Could you please help me with a code that would...
  24. Replies
    3
    Views
    375

    Re: finding last edited cell

    Hi, I was hoping to have a macro, running which would highlight last unsaved/edited cell.
    Regards,
    Rajesh
  25. Replies
    3
    Views
    375

    finding last edited cell

    Hello Friends,

    Is it possible to find the unsaved data in a spreadhseet/workbook? Or the last cell was edited?

    After working on multiple workbooks when I try closing them excel confirms if the...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4