Search results

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.

Rainman89 - Many thanks I will try this. RuralGuy - There's between 30-40 fields, all codes. I work for a government-funded training provider. As you can imagine there is a lot of data that we have to forward, all in code format. I would like to have the description for each code on the...

Rainman89 - Apologies for sounding like a complete amateur (the truth is I am) but how would I do that? RuralGuy - Can I use more than one query as a form RecordSource? Maybe I haven't understood - apologies if this is the case. Thanks both

Hi RuralGuy This is one example of many fields for which I will only need to record the code but view the description on the form. If I use the query as the form RecordSource I don't think I will be able to do this with all of the other fields - although I may be wrong? Thanks

Please forgive my ignorance on this subject - I am relatively new to MS Access and appreciate any advice. I am developing a database to record student data. One of the fields in the table is named LTSCHOOL and data entry is via a combo linked to a table called 'LN20 - School last attended'...