Recent content by matg

I'm having the same problem - appreciate any help. Thanks

Hi RG I tried many variations of the function and still could not make it work. I will try again tomorrow morning when I am back in the office in case I have overlooked something. Thanks

Hi RuralGuy I had already looked at that thread and I couldn't make it work. It seems to relate to different fields in the same record - I'm looking to include one field from different records. Are you able to show me an example of how this would affect the code in that thread? Many thanks

Hi, I'm fairly new to Access and VBA. I've designed a database for work to record student responses from customer service-style questionnaires. Most of these are Yes/No responses and easy to analyse using the =Count(Iif function in Access Reports. One of the responses however is a comment...

I've noticed this on the website you recommended - I'm not sure how this works or where I would put it though? Function SQLDate(varDate As Variant) As String If IsDate(varDate) Then If DateValue(varDate) = varDate Then SQLDate = Format$(varDate, "\#mm\/dd\/yyyy\#")...

We also tried the following line: PRVRVW.DefaultValue = Format("#" & Me.ACTRVW & "#", "dd/MM/yyyy") This didn't work either. Can you suggest how this might be resolved? Thanks

Hi darbid It's a rather large database, but the part I'm having problem with is as follows: I have a form that records progress reviews for learners and have used the following code on the 'add new record' button: MLEARN_ID.DefaultValue = Me.MLEARN_ID NORVW.DefaultValue = Me.NORVW + 1...

Hi Darbid Perhaps I'm doing something wrong. I used the Format you suggested in several places but this still doesn't work. Perhaps you could advise where in my code I would place this. Many thanks

This doesn't seem to work either - the ACTRVW date is 07/01/2009 but the next PRVRVW date is still coming up as 01/07/2009. Appreciate your efforts. Thanks

Hi Cameron The code you pasted is exactly the code that I am using on my button. Could the error be with the PRVRVW txtbox? Perhaps it's lifting the ACTRVW value in dd/mm/yyyy format but copying it in mm/dd/yyyy format? Thanks

Hi Cameron Sorry, what couldn't you make work? I have tried the code you suggested but that didn't seem to work. Many thanks

Hi all I'm fairly new to Access and VBA so am learning as I'm going along. I have a form that records progress reviews for learners and have used the following code on the 'add new record' button: MLEARN_ID.DefaultValue = Me.MLEARN_ID NORVW.DefaultValue = Me.NORVW + 1 PRVRVW.DefaultValue =...

Hi RuralGuy Again, apologies but how would I do this? My knowledge of Access if very limited indeed. Thanks

At the moment, in the drafts that I've put together, I'm using the scroll button on the mouse to move between records. I do find this frustrating however and will be looking for a code to remove this function. I will be the only user of this database so I can add buttons to navigate between...

Sorry - I'm not getting this. Will I have to insert a button to refresh every field on the form? Could I change the DLookup to something else or use the Me.Refresh as an event procedure behind the combo or unbound textbox? Apologies.