Search results

Thanks Bob - that works great

Hi, I am importing some 20 odd files each month in to an access database to process - one of the fields in these files has recently changed (I dont have control over these files unfortunately). The field is a number in the format 000 000 0000 - this used to be supplied without the spaces. The...

Hi, Thanks both for the suggestion - have added it in to the database

Hi, Have searched forever to try and find the answer to this but havent found it. Have a mail merge document which picks up various fields from an access database but want to put in a blank placeholder such that text can be typed in - in my case the diagnosis of a patient as this is not stored...

Hi, Wondering if it is possible to select a record in a subform and refresh the record shown on the main form? I would use a listbox and then just use me.listbox but i need the subform as a datasheet amongst other reasons for highlighting cells The subform in question shows outstanding...

Hi, Have built a (clinical) database that links 2 main tables (a patient register table and a hospital dates/info table) - the staff using it require some means to search on multiple fields and these fields would be present in either of the two tables Came across the 'filter by form'...

Changed it to the following - seems to have been due to the way the forms were referrenced - all working now: Public Function newpriorapp() ' Update Form Pages to show newly added prior approval Dim rs As Object Dim strCriteria As String Forms![form-main-menu].Requery...

its alphanumeric - first two chars are letters then 4numbers - could use NHSNum from the same table which would be purely numeric

Must be doing something wrong as this still isnt working: Public Function newpriorapp() Dim rs As Object [Form_form-main-menu].Requery Set mdbthis = CurrentDb Set mrsPatients = mdbthis.OpenRecordset("temptable-priorapp-data", dbOpenDynaset) Set rs =...

Calling it from a macro that is run when the user chooses to append the details of the new funding request to the db The macro (in order): closes the form and saves, appends the data from the temp table to the main table and then the function is run with runcode Not doing a save of the...

commented out the requeries (also moved them higher for later) but it still fails to jump to the newly added record - any other suggestions?

Hi, Can anyone advise what is wrong with this? Public Function newpriorapp() Dim rs As Object Set mdbthis = CurrentDb Set mrsPatients = mdbthis.OpenRecordset("temptable-priorapp-data", dbOpenDynaset) Set rs = [Form_form-main-menu].Recordset.Clone...

Hi, Is it possible to somehow get the name of the last control clicked? Have two search combos in my footer (either can be used) that change the record shown in the form afterupdate - the end users however want a 'search button' to press after making a selection in the combo and I was...

Hi, I am a bit stuck on the best way to do this - have a multi-paged form with 3 main tables (main patient register, prior approval data, comments and dates). The particular form in question is as image below: The relationship between the tables is one to many- so patient register has one...

Sorry seems I was actually missing a line of code to transfer the date from the calendar back in to the combobox/field - should have checked it better though it seems to work on other forms without it http://support.microsoft.com/kb/190194 http://www.fontstuff.com/access/acctut09.htm...

Still rather new to access so I am probably not explaining what I mean properly - what I meant to say is that after the calendar shows up from clicking on the combo - selecting a date does not display that date in the combobox/form nor return that date to the field Code is as follows...

Hi Bob - yea the combos are bound to the fields in the query - no equals signs in the control source

Hi, I've built a form based on a query that joins two tables on an ID field - the form then uses a 'search combobox' (searching on two fields) to find and display the record the user has chosen. All the text boxes are fine and accept input but the combo boxes i've built linked to the...

Just in case anyone else reads this post - I couldnt find selecteditem so instead did the following: Dim strReport As Object Set strReport = Me.<listbox> Then outputted with outputto and acOutputQuery

Many thanks :D