Search results

Frank, That's the beasty ! It's easy when you know how. Thanks.

I have spent most of the day on this and despite searching through the Forum I have not found an answer :( stLinkCriteria1 and stLinkCriteria2 work on their own, but when I try to join them to use both the date and text I get a type mismatch.... stDocName = "Operations_By_Unit" testdate =...

Excellent ! Rural Guy you ARE the man ;)

Thanks RG. The new message box tells me that there are no records, but why are there none ? 1. If I open the form directly, there are 9 records and the form opens correctly at today's date. :D 2. If I open the form via the switchboard there are no records at all :confused: Oscar

I have recently added a standard access switchboard to my database. Now one of the forms flatly refuses to open from the switchboard giving "No Current Record" error. The form opens fine when opened directly. There must be a conflict between the S/B and the Open Form code but I can't see...

This works now "StartTime = '" & Me.StartTime & "' ," & _ "StopTime = '" & Me.StopTime & "'" & _ Thanks to Workmad3 post here http://www.access-programmers.co.uk/forums/showthread.php?t=110806 Oscar

Fellas, This is driving me nuts & despite searching I can't get it. I have very similar code in other forms which updates numbers and text variables to the underlying table but I can't get this one which updates the time (short time) to work. I am pretty sure that it is a formatting issue but...

I have copied some nice code from this site (sorry can't remember who posted it). It moves through records in a continous form, producing a message box that informs you when you are at the begining or end of the records. It works fine going back through the records to the beginning but when...

Sorted - almost. I added a new date to the table in US format 05/10/2006 and it matched with 10/05/2006. Just need to work out how to make that work for my purpose. All, particularly RuralGuy, thanks for your assistance.

You must be getting almost as annoyed at this as me. I'm afraid it still doesn't work. I have added 2 more dates (yesterday and tomorrow) to the table. When run, I get your Msgbox "Unable to locate...." and the form opens at yesterday's date. I note your location. Is this something to do...

Test DB Enclosed Still no joy, I'm afraid. I have tried Int() & CDate(). The date was set using the Date() function. I have removed all of the dates from the table except today's so the form now opens at todays date (obviously) but the If Not RS.NoMatch is still = True. Test DB enclosed. I...

Sorry still no joy. If the OpenArgs is a string and Field1 is a Date, do I need to convert them both to the same before comparing them ?

RuralGuy, Thanks for your help. I have managed to transfer the current date to the Form_Open procedure below but it is still not finding the record. Private Sub Command0_Click() DoCmd.OpenForm "Form2", acNormal, , , acReadOnly, , Date End Sub Private Sub Form_Open(Cancel As Integer)...

Openform at specific record (again) - Example added Sorry about this. I know there is loads on here about this but I just can't get it to work. I have a basic table of dates. One form based on the dates via a query When the form opens, I want it to show today's date but allowing access to...

Sara, That's almost exactly what I am trying to do. Did you have any joy ? Oscar

Thanks for your help. I have used Filter successfully on the test Db. Now to try and incorporate that into the more complicated one :eek:

Modest, Thanks very much for the prompt reply. You obviously know your stuff but it is at odds with this.....http://www.fontstuff.com/access/acctut15.htm. I will use filters as you suggest but can you explain what "fontstuff" are on about. Are they using a different version / code ? I am...

Hi, I am sure this is a simple error but I just can't get it. I want to open a form with information based on today's date. I then want to have the ability to click buttons to advance or retard the date and then show the appropriate data for the new selected date. I thought the best way would...

Thanks but I was hoping to use just a single calendar enabling me to select a range of dates on it but I haven't been able to locate anything which fits the bill yet :( . I will work on selecting a start date first and then selecting the end date second to give me the range of dates for now. Oscar

I am trying to build a form that accepts either a single date for start and stop dates whilst allowing a range of dates to be selected for operations that cover several days. I am using the Access 2003 calendar which is fine for selecting a single date but how do I select several dates (4-7 Mar...