Search results

Hi DBL, Thanks for that. Works a treat. All good things come from Scotland, including my wife. Thanks, Dereck

Hi All. I have a form with a Combo Box that the user can use to select a record. What I would like is, if the user types in a search that is not in the Combo Box list, I want a message box to popup that informs the user that the record does not exist. Can anyone point me in the right...

Hi Pat and All, I have fould out what was incorrect with my split database. For some reason the tables were linked to 2 different directories. I deleted all the links in the FE and exported all the linked tables from both the BE files (different directories) back into the FE. Then I...

Hi, Looking at the Tables window, why is it that some of the tables are split, ie, they have a blue (right) arrow next to them and others do not. I know that the arrow indcates that the table is linked but when the split was done should not all the tables in the database ne in the split...

Hi Pat, thanks for your reply, again. The problem I am having is this. I developed the database on my PC. I then split it so that the : FE was in f:\database\admissions\referral.mdb and BE was in F:\database\backend\referral_be.mdb. Now that I am ready for the database to go from...

Hi All. Is it possible to remove all the links form the FE database to the BE database. Because of lots of problems I am having after my database split I want to gp back to the beginning and have a standard database without linked tables. I need help with this one as it is giving myself and...

Hi Pat, Thanks for your reply. Just what I needed. Why is it the simple things are so invisible. Many Thanks Regards, keep safe and well. Dereck

Hi All, When a database is split, i.e FE and BE the spliter creates 2 files. In my case the database (before splitting) is called "referrals". After I run the Spliter I get 2 files, one called "referrals_be" I take it that this is the back-end containing the table data and table structure...

Thanks for the Reply Pat. Another question if I may. I have a combo box on the form. how do I clear the contents of the combo box using a command button. Thanks again Kind Regards, Keep safe and well. Dereck

Hi all, I have a Form with a subform attached. I will call them "mainForm" and SubForm1". In SubForm1 I have another SubForm which I will call "SubForm2" ****** Running SubForm1 on it's own. ******* On SubForm1 I have a Combo box which looks up details from a table. When the user selects a...

Hi John, Thanks for that, I knew it would be simple. Regards Dereck

Hi all, Can someone explain. I know how to use the "IsNull" function, but how do I implement the reverse. How do I write code to test if a variable contains data, i.e IsNotNull Anyone. Kind Regards Dereck

Hi Jerry , Thanks for time on this. I have tried your idea, but is gives an "error 2185 you can't reference a property or method for a control unless the control has the focus. Here in the UK it's time for bed. I will start again in the morning. I thank you once again for your time...

Hi, I can post the query and here goes: SELECT Referrals.[Referral Reference], Left([Referrals]![First Name],1) AS FirstIntitial, Left([Referrals]![Last Name],1) AS LastIntitial, Referrals.[Date of Birth], Referrals.Sex, Referrals.[Ethnic Origin], Referrals.[Referral Date]...

Hi, Surjer, Yes it does. At the start of the process, the user clicks on a Command Button which opens a popup Form where the user inputs the start and end dates. They click on a go Button which in turn Opens the Form based on the "NDTMS_ReturnQueryTEMP" query, At the bottom of the Form are...

Hi Rich, thanks for your reply. I have a Form which has a query behind it. The query produces records based on a start date and end date. The Form works with no problems. The 2 unbound fields on the Form show date produced by the query behind the Form, which is the start and end dates. The...

Hi All, I have some code that runs a query from a form Command Button. One the form are 2 unbound fields that get data from a another query. How can I use the data in the 2 unbound fields in my code. The 2 unbound fields are [date1] and [date2]. CODE: DoCmd.OutputTo acOutputQuery...

Hi All, If I use the following as a control source: =Trim([First name]) & " " & Trim([Last name]) & " D.O.B." & [Date of Birth] Can I make the D.O.B. bold. Kind Regards, keep safe and well. Dereck

Hi All, I have a Form which gets its records from a query. The query works and shows the correct records on the form, No problem here. I have a Command Button on the form which when clicked on runs an Event. DoCmd.TransferSpreadsheet acExport, , "NDTMS_ReturnQueryTEMP"...

Hi All, I have read all the post regarding Combo Box and have not found the anwser to my problem. Simply, I have a number of Combo Boxs on a Form. After the user has selected the items from the Combo Boxs the record they have requested appears. How do I produce a Command Button to CLEAR the...