Search results

Thanks to you both. I thought that was the case. I am betting they don't support VBE, but are scared of people writing bespoke Access systems which they get reliant upon. When the individual who designed it leaves, then modification or enhancing an undocumented system becomes impossible without...

Hi All I have a very simple database (just three tables), which I have designed using Access, together with a simple input form with a few buttons and drop downs. Is it possible to convert the who thing to Excel (in particular, the form), and continue its development using Excel VB? The...

Thank you. I've just this minute sussed it out! I actually receive a file from an external source as a CSV. I simply open it in Excel and save it with a file name which conforms to the file name specified in the macro. What I have just noticed is that the underlying name of the worksheet...

I have a number of macro's, each of which initiate a saved import. The saved import looks for a specific file in a specific location. This works fine the first time I run it, but each week a new file has to be saved, named exactly as the saved import is configured, but when I run the macro, I...

Thanks for the response. A single macro runs a sequence of queries, each of which deletes records from many underlying tables. When the user clicks on a button, I want a Y/N box to appear, in case they clicked on the button but didnt mean to. If they say Yes, the macro carries on and executes...

Hi All I have inserted a function via a module at the beginning of a Macro using the RunCode action: Function Msgbox_Yes_No() Dim Response As Integer Response = MsgBox(prompt:="Select 'Yes' or 'No'.", Buttons:=vbYesNo) If Response <> vbYes Then End If End Function However, it doesnt stop...

Hi All I have developed a system where three separate lots of data are imported and compared in a query. There is a unique code contained within each import, which is the key field that relates all three sources. However I want to see data returned where for example this unique code and...

The user has to import information during the working week, and on the Monday, clear down the database ready for the import of data for that week, and so on each week. He will need to clear it down, but I want a warning to come up in case he clicks on it unintentionally and deletes everything...

Hi All I'm a relative newbie to the world of VB, and I've written the following code, to delete the contents of multiple tables. The trouble is, if the user says No to the Y/N message, it still deletes the contents. What is missing so that it abandons the process if N is chosen, and another...

Hi All I have created a simple switchboard form, which I have made a Pop Up = Y, Modal = N. I've added a few buttons, got rid of the scroll bars but still allowed it to have a min/max and close down button. One of the buttons generates a report, but the form itself has to be minimized or...

Hi All When I try to insert this into a field in a query whilst in build, Payee Name: Split([DE_ppayee],"*")(1) I get a message telling me "The expression you entered has an invalid .(dot) or ! operator or invalid parentheses. Can anyone help? Tks

My deep and unconditional respect to you all for your help! :D

Sorry vba, I'm being a numpty plonker. What I really meant was that if there are any fields which dont contain a * at all, then it shouldnt copy anything across :confused:. There are a lot of fields where just the name is displayed, I am only looking to copy anything with a reference after...

Thank you! Works a treat... And if I only want it to show the characters after the *, and to ignore any characters preceeding it?

Thanks Plog, appreciate your help. I am struggling with the syntax. Would you be kind enough to give me the equivalent code to find everything after the * in the text below? It would be better if I could actually cut that reference from the original field and place it in a new one in the...

Hi All I am using the following formula to strip out certain characters from a field using MS Excel, containing similar to the following data: Miss M A Budgett W/T *094169/2 In the next field to the right, I want everying after the * to appear: =TRIM(REPLACE(D15,1,FIND("*",D15)," "))...

"Different" comes up if all three quantities are not equal, so that will give someone the heads up to investigate. In any case, all three fields with the quantities are shown on the screen, so it should draw the eye. I will also write a separate query to return only differences, or <> 0, for...

Thanks VB, the first bit of code works perfectly - It displays as a zero, or the actual difference if there is one. I tested it by changing one of the three amounts :)

Hi All I have three sources of data which all equate to a reconciliation of the same data e.g. the same record of a stock holding is held on three separate systems, which must all be the same. I am trying to build a an equation in a query field, which compares each quantity: Qty Diff...

Sussed it! Works a treat: ([Pulse Value]-[SWFAL Mkt Value])/Abs([Pulse Value]) :D