Search results

try shift-f2 with your pointer on the replace command. it brings you to where it is defined. it should open the object browser. when you click on the blue VBA text. It would show the DLL it uses for this particular command.

Yep, doesn't give a specific answer to my question. However in the code i saw this little piece of code CurrentProject.ImportExportSpecifications.Item(OldName) When you see .Item, usually .Add is also available. And yes, there is! I need to try something like this...

come to think of it, even the commands might require a semicolon instead of regulars comma's. I mix them up sometimes. "SELECT Replace(Field1; 'ing'; 's') AS TestOut FROM tabTesting"

One of the default references is VBA. Otherwise even "If" is a dirty word. It ofcourse shouldn't crash but give you an error message when you are using a function which doesn't exist. Perhaps your database is corrupt. try Compact & Repair. By the way, you could try this: "SELECT...

Isladogs has a lot about IMEX specs but copying it to another database is not among them. Perhaps i can use a database template in which the specifications are incorporated and copy that database to a new name.

try VBA.Replace(x, y, z) It is more specific. If that doesn't work i need more information about the attached database (or is it local db) and/or the actual statement.

Hi, I need to import 2 csv files which increase my database to almost 500MB. A primary key needs to be added to both tables and an index. After that i connect the tables to currentdb, perform a few checks als disconnect the tables and drop the database. So i've come up with this solution: I...

I found Mini Mouse Recorder and AutoHotKey. For the latter one could write a script to react on texts and/or images. For me it is important that the tools are portable. Meaning, i don't have to install them since that is not allowed on this computer. Thanks for your time!

Thanks. I searched for that question but couldn't find it so i posted this one. Thanks for the link

Hi, Do you have experience with automated testing of an Access (or Excel) application? And if yes, how do you accomplisch that? Thanks for your time!

Where are the IMEXSpecs stored if not in the MSysIMEXSpecs/Columns tables? ImportExportSpecifications seems to be read only. How are they set, using the wizard perhaps?

It can be done with a query or for clarity sake a few to keep them readable. There should be a table which defines the range you want to compare against +/- your threshold. You join the result to your product table and compare the price. Shouldn't be that difficult. Post a sample database for...

This code looks similar but this one does work without fail: Public Sub AutoPullDown_SoortOpvang(ByVal rngTarget As Range) ' ' AutoPullDownSoortOpvang Macro ' Deze macro voorziet een bepaalde cel automatisch van een pulldown menu ' With rngTarget.Validation .Delete...

I have a single cell selected and in the Worksheet_SelectionChange event i have a call to this function. Now with Error handling in the function (i had error trapping higher in code but tracking back i got me to this point.) Public Sub GegevensValidatieAantalUrenMaand(ByVal rngTarget As Range)...

Windows 8, Office 2013, 32 bits My code gives an error on the ".Add" line. Can't figure out why. The error is 1004. Which doesn't give me any information. Unfortunately. Anyone? Public Sub GegevensValidatieAantalUrenMaand(ByVal rngTarget As Range) ' ' GegevensValidatieAantalUrenMaand Macro '...

DoEvents is typically a statement that allowes other events to be triggered. The statement prevents your application from seeming unresponsive. That is why it is used sometimes. I would remove that statement from your code first if you have any in your code. removing it also speeds things up...

@Minty You are right. But then i would be using an external variable and the point was to avoid that. @MajP Yes i could use a collection, but that would feel like a lot of overkill. Like Minty said i could use a boolean. Below is a similar class. Excel Only. It uses Application.EnableEvents...

@MajP, think you are right. Can't be done without some external variable, collection or registry setting. Well, thanks for your time!

StartMeNext can be used separately. In that case i need that hourglass toggle.

When the StartMeUp procedure runs, the Hourglass is set to true. The StartMeNext procedure is called. Again the Hourglass is set to true. So far no problems At the end of StartMeNext the Hourglass is set to False. This is a problem because this is not the right place to reset the Hourglass. The...