Search results

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, 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'...

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...

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...

Hi, Not sure if this is the best way to do this - happy to hear other suggestions - but was wondering if its possible to create a list of reports in a listbox that the user could select and press a button to launch a macro specific to the selection which would output the query to an xls Was...

Hi, Tried searching this forum and the web for an answer to this but not sure what exactly to search for to find an answer What I am hoping to do is to put some text in a text box that would help the user inputting the data in a similar fashion that a search site would have a text box that...

Hi, Trying to build an access database (to be completed by early jan) with a module that looks up patient information from a database - unfortunately my visual basic knowledge is non-existent and although I have a working script (borrowed from another db) if an unknown patient number is...

Hi, Still rather new to visual basic and I had the following working for a bit but it has stopped now and I dont understand what has changed (nothing from what i have done besides aesthetics of the form) or what has gone wrong. Private Sub findpatientname_AfterUpdate() ' Find the record...

Hi, Sorry still rather new to access and hitting brick walls searching for answers - created a form that has some calculated fields (from a combo box choice) and some unbound fields - how do i select some of these fields and append them to a table? Many thanks

Hi, Created a simple input form that stores the data in to the table on clicking the submit button and runs a macro 'on exit' - this macro just tidies the inputted data and fires off an email with the form data. This works fine. Trouble is the form also has a 'close form' button and whenever...

Hi, I have tried various suggestions on here as to refreshing a subform but they havent worked - i guess that is because my form is different and doesnt have any filters etc I have a multi tabbed form and the particular tab in question has a button that imports new data to a table that is...

Hi, Still rather new to access - was wondering if it is possible to update some fields on a form while data is being entered - specifically to pull client name and surname from an odbc linked table when an account number is put in - to save entering the name by hand and any errors that could...

.. I need to restrict 'usage' of the second table so that when a match is found the particular line in the second table doesnt get used again (as you can tell i am still rather new to access) Is there some easy way to do this? Or am i going about this the wrong way with a join? Thanks :D

Hi, I have been asked to build a database to capture client information - the difference being that the data would need to 'update' every day (or period) itself, where as I am used to only building databases that I control - eg transferring data, manipulating with a query etc. As an example...

Hi, Not sure if this would be best tackled as a query but struggling with how else I could go about doign it. What I want to do is add a £100 charge to orders that are delivered - but I want to build this in to the price of the item ordered rather than showing it as a delivery charge on a new...

How can I create an 'anonimised' field for a client's name (eg Joe Bloggs) to something like just the initials (say J B or JB)? Need something like this excel formula but for access: http://chandoo.org/wp/2008/09/02/get-initials-from-name-excel-formula/ Many thanks :)