Recent content by varunmathur

  1. V

    Date Part Year and Month

    Thanks Namliam yes you are right I tried to get the month name it did'nt work so I also tried DatePartM: (DatePart("m",[VisitDate])) & "/ " & DatePart("yyyy",[VisitDate]) it works fine
  2. V

    Date Part Year and Month

    The problem is that when you sort in ascending order: April comes before Jan or Feb or mar
  3. V

    Displaying the lowest cost only

    I have a similar problem, how does one display the lowest values or price when multiple dealers quote the same lowest price. In this case the query displays either of the two as the lowest value and is unreliable. Help will be appreciated.
  4. V

    Adding picture to startup form

    Thanks, I tried compact and repair several times but it did'nt help. It seems linking the picture is the best option, however I was looking some other option. Paul I liked your blog, its really cool. Varun
  5. V

    Adding picture to startup form

    I have added a .jpg picture to my startup form, the image on disk is 659k however when inserted into the form increases the database size by 90MB I am unable figure out whats going wrong, help required
  6. V

    Linked tables

    Thanks This may be the problem. I shall be more careful to ensure that the BE is shut down after all FE's are.
  7. V

    Linked tables

    I have a small database running on LAN with one computer holding the backend linked to 12 computers on which the frontend runs, I was using windows xp in the computer holding the backend, it ran well but would automatically delink one of the computers and run only 11 frontend users. To overcome...
  8. V

    Question Problem using MS Access with Windows server 2003

    Thanks, I must be messing up the permissions issue
  9. V

    Page Setup as per length of Bill

    Thanks Mr Pillai
  10. V

    Page Setup as per length of Bill

    Hi I need to print bills of variable length depending on the number of purchases, I need to use a paper roll which will print a continuous bill to be torn off when it stops printing without wasting paper in the event of a single item purchase nor split the bill into two if the number of...
  11. V

    Question Problem using MS Access with Windows server 2003

    :banghead:Hi, I was using a database with a backend in one computer and 10 frontends at various user desktops, it was slow but running well, so I decided to procure a new computer and install Windows Server 2003 to hasten the transfer of data. After linking all the users into one domain and then...
  12. V

    DateDiff problem

    Thanks a lot I reformatted the table to set the date format :- dd/mmmm/yyyy hh:nn the datediff started working correctly Thanks again Mr Bob
  13. V

    DateDiff problem

    Thanks sir, I think the format may be the error, I shall try amending the format
  14. V

    DateDiff problem

    The dates in the fields are:- StartDate EndDate 07-11-2012 06:55:05 07-11-2012 07:02:35 07-11-2012 12:50:03 07-11-2012 12:58:55
  15. V

    DateDiff problem

    Yes, both fields are of the general date format, and display both date and time, I tried to work with long time format but the problem persisted :(
See more
Back
Top Bottom