Search results

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, FYI I found the following to work. Dim rs As DAO.Recordset Set rs = CurrentDb.openrecordset("tblReviews") With rs For a = 1 To txtAmountOfReviews .AddNew !Learn_ID = txtLearn_ID !Review_PlannedDate = CDate(txtReviewStartDate) + (a * 7 * txtIntervalWks) !Reviewer =...

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 Mavis, Try putting the following as the control source of your text box:- =Format(Dcount("Your Field Name Here","Your Table or Query Name Here"),"000") Hope this helps Taff

Sorry Ken, Thanks for the reply :) . Taff.

Thanks for the reply SJ, I did mean Rowsource, you can tell its Monday. Works great. Taff.

Hi steallan, Try replacing Not Like to <> HTH Taff.

Hi all, I have a form with a combo box on it and what I would like to do is when I click a command button, change the record source of the combo box from the query I currently have to a different one? Is this possible, Thanks for your time. 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...

Hi Kupe, Haven't had that problem before. Try setting the Auto Centre property of the form to yes. Taff.

Have a look at the Modal and Pop Up properties of your form. HTH. Taff.

Try holding down the Shift key whilst you open it. Taff

Thanks Again Wayne, Taff.

Thanks for the reply Wayne, Hoping I'm close now. However I get a Run-time error '3075' Syntax Error (Missing Operator) in query expression 'Dentist 1 And #10/02/2005 09:00:00# Between StartTime and ExpFinishTime'. Have attached a sample of the problem. Any Ideas? Taff.

Hi Just1, I don't get asked to be able to sort either when using the wizard. However, In the design view of your form, Right click your Lookup field and go to properties. Click the Data tab on the properties dialog, click in the field row source and then click the button to the far right...

Hi wazz, What did you make changes to, tables, queries, forms etc.? 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...

Hi Ken, Followed what you said and got it working in the end. Thanks for ya help. Taff. :)

Hi Ken, Bit unsure how to do that, any pointers. Thanks Taff.

Strange question me thinks. I have a form which is set to continous forms and requeries every 15 seconds. When the form requeries it checks the records and if certain criteria includes those records. What I am trying to do is when the form requeries, beep if anymore records appear. Possible...