Search results

Hi, Try pasting this code into a VBA module. The code is untested. In the VBA Editor you will need to go to Tools > References and check the box next to "Microsoft VBScript Regular Expressions 5.5". You can then use this function in your query like this: CorrectedString...

Hi, Here is the modified file, it works fine on my computer which runs Access 2007.

Hi, What is your aim, do you want to remove the HTML tags (like <div>) from the text or replace them with something else?

Hi, Welcome to the forum. There are lots of very experienced and friendly folk here, I'm sure they will be able to help. Introductions usually go in the "Introduce Yourself" section, perhaps one of the moderators could kindly move this.

Welcome. There are lots of very experienced and helpful folk here, don't worry if the question is simple, it's sometimes the simplest questions that are hardest to answer!

I'm guessing they may have changed one or two things. Hopefully the folk here can ease the transition! Welcome

Welcome, you will find the folk here are very friendly and helpful.

Hi, I agree with the sentiments above. I decided to register here and attempt to give something back, as the answers on this forum have helped me numerous times in the past. This is a very friendly and helpful community, I will try my best to welcome new users too.

Hi, Yes, of course you can. The checkbox will allow you to display current or non-current staff. If you include the ysnCurrentEmployee field in the T_Keepers table you can just check that this is true, and you can then display current employees only (without the need for the combobox on the...

Hi, I have checked your example database and the refer reason combobox is disabled when "refer to tl" is selected in the status combobox. However I have realised this will only work for the current record. So that the enabled property is set correctly when you change record you will need to...

I have Access 2007 so can help. As Beetle suggests you can create a running total using the DSum function. By summing the prices and discounts separately you can do this in a single query. Create a new query with the following SQL: SELECT Table1.[No], Table1.Price, Table1.Discount...

Hi, Yes, you can use the function Now() to return the date/time. I have used the format function here to return the date/time in the format yyyymmdd hhnnss. Note that hhnnss is the time in hours, minutes and seconds. Dim pStr As String pStr = "S:\ChestPain\Elective...

Hi, I would use ADODB to connect to your database from Excel. I have written some example code here for you, but it is untested. You can use the "Workbook_BeforeSave" event to run the code each time the user saves the file. You will need to modify the code to copy the relevant records. If you...

Hi, I hadn't appreciated you were looking for a specific value. Here is the code you need for the afterupdate event if you need the status combobox value to be "refer to tl". Private Sub StatusComboboxName_AfterUpdate() Me!ReferComboboxName.Enabled = Me!StatusComboboxName.Value Like...

Firstly make sure that the directory you are copying the file to exists. In your previous post this was x:\directories\value1\ Assuming this directory exists you should then be able to copy the file into that directory with any valid filename you like. This means you are able to include value1...

Hi Janith, For future reference it is best to create a new thread when asking a new question, that way you will get the best advice. Firstly you will need to set the enabled property of the refer combobox to false, so that it is disabled when the form is opened. I have assumed here that the...

Hi, To do this you will need to change the RowSource for the combobox on your subform, and add some code for the combobox on the main form. Row source for subform combobox: SELECT tblCaseStage.CaseStageID, tblCaseStage.CaseStage, tblCaseStage.CaseType FROM tblCaseStage WHERE...

Hi Wally, Firstly I would be inclined to use a single check box that would indicate "yes" if it was ticked, and "no" if it was not. You will need a yes/no field in the table T_keepers to store if the employee is current or not, in the example below called ysnCurrentEmployee. You will also...

Hi, The Date() function will return the current system date, so assuming the settings on the computer are correct this will return today's date. To view the records for yesterday you should use the dateadd function, e.g. DateToday: Date() DateYesterday: DateAdd("d", -1, Date()) It is worth...

Can you try saving the database in a format that is compatible with Access 2007 and re-upload. I can't help without being able to open the file!