Recent content by Mcgrco

Thanks for all your help. I solved the porblem by formating the etxt string. The codes looked like this Between #" & Format(CVDate(dtStartdate), "dd mmm yyyy") & "# And #" & Format(CVDate(dtMatdate), "dd mmm yyyy") & "#))

thanks but it just doesnt seem to workl for me. here is my code. This is so frustrating Public Function CreateQueryForHolidays(dtStartdate As Date, dtMatdate As Date, strCurrency As String, strCountry As String) Dim quniSql As String Dim db As Database Dim qdf As QueryDef Set db = CurrentDb...

Hi , I trying to create a sql query in code that queries a holiday table between two dates. the trouble is that the code seems to format the date in the us style meaning that for the 1st to the 6th of Jan I get everything up to the June. Can anyone help . the query results are below and . Any...

Loading all and hiding caused me no end of trouble because all the forms are bound when you load them which is why Pat was kind enough to set me straight. Im not sure how you do this without code but try opening the form in code mode and paste the entire contents of the code I supplied you with...

Hi, I used a tree view control to trigger the event. On load try this routine Private Sub Form_Load() Dim x x = SetSubForm("frm_SUB_General_Instruction") End Sub Function SetSubForm(SubFormName As String) On Error GoTo errez: Me.Slideshow.Visible = False If...

Pat , Many thanks for the much easier and more managble solution. It was my first approach at the type of database screen . A lesson well learnt

Thanks for your help, I manged to get it working, albeit via a workaround.

Pat, Just for future reference, how can i add a control and change the controlsource to look at differnt subforms. Thanks in advance

Thanks Pat. I did try to create the table before the recordsource was assigned to the problem subform. This worked fine except that it was only triggered when the main form loaded . I couldnt find an event that i could unload the record source and re trigger the the table creation. Thanks for...

Pat, thanks for your comments. Unfortunatly the subforms are all differnt. ie some are datasheet, others Single Form with controls. For what its worth, I manged to get the problem sorted and as ever learned something new about access. The reason whey the process would not run when the datasheet...

Hi, I have a one main form in my database and several subforms, exactly the same size, that appear/dissapear depending on what user has selected from a tree view menu. The form works by hiding all the other subforms and only showing the subform of interest. The code i use is Function...

Hi, Im new to the listview control and need dome help with the checkbox option. i added the checkbox option to the control but i dont know how to capture its state when clicked. the listview is based on a table but the checkbox resides on the form . i want to cahtch the state of the checkbox...

Thanks for your reply Pat, I do have problems with DAO databases due to the reference not been set. I tryed to add the reference in code before it was converted but I cant work out how to do it. The database only have small amounts of simple code, but there are 100s needing converting, hence...

Does anyone know if its possible to convert a 97 database to access 2002. I have 100s of small databases and what i would like to do is place them all in a folder, loop through each one and convert it to a 2002, with a new name. Thanks in advance

Hi, Does any one know how i can get a database to add refernces in code on start up. I have a database with various pieces of office atomation and when a new user imports the objects The referncxes need to be reset. thanks