• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Recent content by Ravi Kumar

  1. R

    Solved Database creation suggestion

    Thank you ...let me try with help of blog as it will give me experience ..if still no possible ..i'll contact you for the tool.
  2. R

    Solved Database creation suggestion

    Dear all , I need to create a Access database for the attached excel file , and i need to here your suggestions as i am not finding an efficient way of designing the table relationships :(column names will be renamed by removing space and special characters) currently i am only thought of...
  3. R

    Solved Auto increment number based on machine number coloumn

    Dear all , In my table want to auto increment the spool number based on my machine number column : i don't know how to explain this problem in depth , hence i am attaching my sample database , please help me.
  4. R

    percentage value round off

    I am very sorry for the late reply , i was hospitalized due to covid-19 , i used the format() and now it coming as percentage itself , thank you so much for your help.
  5. R

    percentage value round off

    Thank you so much for your reply , From the macro function "Emaildatabaseobject" and there i am using the above expression in subject field
  6. R

    percentage value round off

    Hello all , In my access database , i am using replace function to automatically fill the body are of my outlook while sending as below : =Replace(Replace(Replace("Please note that there is a high qty of rework found in above order where inspected qty is:|1 Rework qty is: |2 And % is:|3...
  7. R

    History column for date field

    Hello all , In my data entry from i want to have a history column which shows the previous version of change : i have done this for long text field by making the field as append only but now i want to have the same for the column having"Date type" where the table design is not sowing this...
  8. R

    App.config path not correct

    can anyone help me in this regard
  9. R

    App.config path not correct

    I am very new to visual studio and i am building a data entry app in it using visual studio connected to Microsoft access database (VB.NET language). But i am getting error during initial debug to check on the path like below: And I have entered the app.config data correctly like below...
  10. R

    SQL Not working

    Yep it was named before I could take on this database for editing & I left it as it is(sorry) : And after your suggestion I finally made it worked with this below SQL: WHERE (((Year([Calibrated on mm/dd/yy]))=Year(Now())) AND ((Month([Calibrated on mm/dd/yy]))=Month(Now())))
  11. R

    SQL Not working

    Dear all, I have a query with the below SQL , which needs to show me the calibrated equipment for this month only. SELECT [Instruments list].[EQUIPMENT number], [Instruments list].[Calibrated on mm/dd/yy] as [Calibrated on] , [Instruments list].[Next Calibration mm/dd/yy] as [Calibration...
  12. R

    Solved Query to find count of new instruments

    Thank you for your quick help,it worked
  13. R

    Solved Query to find count of new instruments

    Dear all, In my table instruments list I have two columns 1. Instrument received on(date type) 2. Equipment name The first column has the data from almost 6 years. But now I want a query showing the count of equipment's we received only from this year(that too in month wise). How to accomplish...
  14. R

    expression help

    sure 5 mins
Top Bottom