Search results

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

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

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.

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

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

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

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

Thanks, I must be messing up the permissions issue

Thanks Mr Pillai

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

: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...

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

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

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

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 :(

Yes both are of the format General Date, display both date and time, I earlier tried long date format but the problem remained the same.

Hi I am using the code minutes: (DateDiff("n",[starttime],[endtime]) returns a number 59356850 instead of the correct answer which would be 11 min both starttime and endtime are General dates need help, what am i doing wrong :banghead:

I am using Access 2007 and have designed a report printing the prescription of the patient, the length of the prescription varies and hence need the printout length to vary accordingly, I use a paper roll for the printout, I am unable to control the length of the printout, it is either too long...

Hi I've a database that I am trying to replicate, the problem is that the macros continue to work in the master, however they do not work in the replicas. Is this a recognised problem or am i missing something. Your help will be of great value.:rolleyes:

Northwind I have tried it but when I try to util the code into my app it does'nt work, the problem lies in the line "Application.FileDialog(msoFileDialogFilePicker" could you help me overcome it.