Search results for query: *

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

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

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

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

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

Hi all, I have a table with several date fields. Next I have a query where I format the date fields so they can be exported in the correct format. I do this as follows:- Date1: Format ([DATEBRTH],"ddmmyyyy") Date2: Format ([DATESTRT],"ddmmyyyy") When I export the file it is saved as a Fixed...

Hi all, Not sure how to word this but here goes. I have a query with three tables as follows:- SELECT [Learner Dataset].LEARN_ID, [Learner Dataset].PROVI_ID, [Learner Dataset].LSURNAME, [Learner Dataset].LFORENAM, [Learner Dataset].NAT_INSU, [Learning Programme Dataset].TYPE_LPG, [Learning...

Hi all, I have a a form with a listbox on. When I click a command button it opens a form depending on what I have selected in my listbox. When the listbox is requeried it automatically selects the top record from my listbox. It is possible to requery the listbox but keep the record I...

Hi all, I have a table with about 20 fields in and what I am trying to do is create a query which will show me all records with one or more fields missing. Can someone point me in the right direction. Many Thanks Taff

Hi All, I have searched this Forum and unfortunately not to much luck. I'm not sure if this is possible but here goes. I have a form with a command button on and when the command button is clicked I would like to Print 1 copy of a report to 3 different printers. %-) This has to be done...

Hi All, Not sure at all if this is possible, but here goes. I have a field which is made up of letters. The field is 8 letters long and I was wondering if it is possible in a query to count the last four letters of the field in the table and see how many of them there are. For example: -...

Hi all, My company is currently using Windows NT Server 4.0 and have lost the case with the CD Key on. Does anyone know if the key is stored anywhere and if so can they please let me know. Thanks in advance Anthony

Hi all, Not sure how to word this, but please bare with me. I have a form with several unbound text boxes which make up a Calender. When the form Loads Values are passed to these text boxes which make up the dates of the month. What i would like to happen is if one of the Values of my...

Hi all, I have a form with a Calendar Control 9.0 on it. Is it possible to make the dates Red or some colour if it matches a date in my table? Not sure if this is clear enough. Regards Taff

Hi All, I have a form with a command button on and an unbound text box. When i click my command button it sends a numeric value to the text box. The problem i am having is when i close and reopen the form, the value has gone. Is it possible to store this value so it stays there even if the...