• ** 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/

Search results

  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
  15. R

    expression help

    is there any more details required , please tell me?
  16. R

    expression help

    thank you, but all rows are now showing as over due , even of completed date is empty.
  17. R

    expression help

    thank you, but #NAME? error is coming
  18. R

    Coronavirus - are we all doomed?

    wish you a very happy birthday , Jon.🎂
  19. R

    expression help

    hello all, =IIf(Int([Due Date])<Int(Date())&IsEmpty(Int([Completed Date]),"Overdue") I need to modify this to get the below result(I am not getting how to use of not null) 1. if due date is lesser than today's date or if completion date is empty then it should show overdue. 2. or if...
Top Bottom