Search results for query: *

Thanks Ken.

Hi Ken, Thanks for the reply, worked great. However, why would I need to format it as (yyyy/mm/dd) as apposed to (dd/mm/yyyy). Taff.

Hi all, Have a problem trying to open a form with certain dates. I have the following information:- tblReviews Learn_ID -Text Provi_ID - Text Lprog_ID - Text PlannedDate - Date/Time (Short Date Format) ReviewType - Text FrmReviewList txtLearn_ID txtProvi_ID txtLProg_ID txtPlanned txtType...

Hi PHV, In my error trapping added If err.number = 3022 then resume next and it seemed to work. Thanks for your help, appreciated. Taff.

Hi again, In a follow up to the above, when I run the code, if any of the records violate the Primary Key it does not add any. i.e. If I try to add 10 records and the first one Violates the primary key the rest are not added. Does anyone have any suggestions? Thanks again in advance for any...

Hi earthandfire, Tried the above and got an Data Type Mismatch on the following line: !Review_PlannedDate = txtReviewStartDate + (a * 7 * txtIntervalWeeks) Changed it to !Review_PlannedDate = cdate(txtReviewStartDate) + (a * 7 * txtIntervalWeeks) and now it works great. Many thanks for...

Hi all, Am a bit stuck with this one. I have a table "tblReviews" with the following fields:- Learn_ID Review_PlannedDate Review_ActualDate Reviewer I have an unbound form with the following txt boxes:- txtLearn_ID txtReviewStartDate (Format dd/mm/yyyy) txtIntervalWks txtAmountOfReviews...

It will be used to tell me what the maximum length of the appointment can be. Taff.

Thanks both for replying. The statement in my query is: SELECT tblAppointments.AppDate, tblAppointments.AppTime, DateDiff("n",[Forms]![FrmAppointments]![AppTime],[AppTime]) AS TimeDifference FROM tblAppointments WHERE (((tblAppointments.AppDate)=[Forms]![FrmAppointments]![AppDate]) AND...

Hi all, Bit stuck with this one. I have a table called appointments with the following fields AppDate, AppTime, AppComments and these are also on my form called frmAppointments. What I am trying to do is check how much time there is between the appointment that is currently open on my form...

Thanks lupins46 for your suggestion. Not sure how to do that but I will have a look into it. Regards, Taff.

Hi All, Not sure if this is possible but here goes. I have a form with a time in the format "hh:nn". What I would like to do is create a query that takes the value from my form and adds a row for each 15 minute increment until it reaches a certain time i.e. 16:30. So if the time on my form is...

Thanks jaydeebe, I will have a play about and let you know how I get on. Much Appreciated. Taff.

Hi all, I have a form with the following fields:- StartTime = Format dd/mm/yyyy hh:nn:ss ExpFinishTime = Format dd/mm/yyyy hh:nn:ss Dentist = Number StartTime is bound to my table, ExpFinishTime is calculated in the forms underlying query. Before the record updates I am trying to check if...

Thanks for the help guys. Greatly appreciated it, works a treat. Taff.

Maybe?

Hi there, I have defined TDate as Date/Time - Format Short Date and TTime as Date/Time - Format Short Time. I use a form to determine the parameters and date parameters are in the Format of dd/mm/yyyy and time is in the Format of hh:nn. Taff.

I have a database which records vehicles passing through a weighbridge and records the date and time of weighing. What I am trying to do is create a query which shows all vehicles that have been weighed between two dates and times. What I have so far is select blah from blah WHERE...

Thanks PHV, Worked great. Taff82.

Hi scriverb, Nope still no luck. Taff