Search results

Hi I have a Make-Table query, that pulls info from a number of subqueries and tables. When I run the query normally, it takes about 1 second to create and populate the table. But when I tun the same query via VBA like: CurrentDb.Execute "MyMakeTableQuery" then it takes about 10 seconds. The...

Is it possible in Access 2010 to change the theme for a single form? I do not want the theme for all my other forms to change, but only for 1 specific one.

I installed Access 2010 Service Pack 2 today, and now it seems like Access is corrupt. Even when I create a new database, create a form, add a button and try to set a picture to the button, I get The database cannot be opened because the VBA project contained in it cannot be read. The database...

Not really, although it should work in the examples I gave. But when you have literal characters at the end of the first 3 samples, you will run into trouble determining the length to pass to IsNumeric. If D123456DS1234 should also be returned, as well as D1D1, then it will become tricky...

How do you search for any number of numeric characters using wildcards? The # symbol only searches for 1, and * obviously includes letters. Example: I have: D1234 D3 D5336767 D123F My search should only retrieve the first 3 values. WHERE FieldName LIKE 'D[0-99999999]' does not seem to work.

I see. Index seems to be the correct method, but Index fails on RecordsetClones. Perhaps iterating through the recordset will have less of a DB impact, than creating a new TableDef recordset.

I would like to get the Min + Max values of the data currently in the form, but without changing the sorting currently on the form. So I was hoping for this, but it is not working. The data in the recordset are not sorted. Set R = Me.RecordsetClone R.Sort = "SendOn ASC" R.MoveFirst MinDate =...

Thanks. VBA it will be then. Was hoping for a predefined query.

Hi Is it possible to have a dynamic whereclause to a query? I.e. one that is generated by a Function? E.g. SELECT a, b, c FROM MyTable WHERE GetWhere() GetWhere will then return a string like 'a > 3 AND b < 3' I have tested this scenario and it is not working, so maybe there is some work around?

Hi. Funny one, and lots of kudos for the one who can answer me :) I have a Access 2010 form based on a query (3 tables). When closing the form, the forms takes long to close (5 seconds) and says 'Running Query' in the status bar. If I change the query a little bit, it works fine. The funny...

Put it in the On_Click event of the Search button.

Will be tricky. My graph and textbox is based on a query that is dynamic and gets changed based on user selection. So I'll have to optimise it so that Access dynamically changes a view so that the Stored Proc can read from it. What makes it more complicated is that under certain conditions...

The graph is the important object on the form and takes a couple of seconds to refresh (based on the user's filters). The textbox is just additional nice-to-have data, which also take some time to load. The reason why the display order is important is that if the main data item (graph) can be...

You will have to recreate the query's sql with code and pass in the dates as a where clause. Currentdb.QueryDefs("suspend_trend_CHART").SQL = "SELECT xx FROM xx WHERE MyDate Between #" me.StartDate & "# AND #" me.EndDate & "#"

Hi I have a graph on my form, an Update/Refresh button, and a textbox that display a calculted value. The textboxes controlsource is "=GetMyValue()" Now when I click the Update button on the form, I would like to have the graph to refresh first, and then the textbox should update its value by...

Hi I have a graph object on a form. When the form is resized, I set the chart properties in code to make the graph and the PlotArea wider to fit the form. However, at some point the Graph object and the PlotArea goes wider, but the ChartArea stays the same. See screenshots below. If I try to...

You can't really tell your clients who are governed by a shared services company what they should install. We will just have to work around it.

Thanks. I did see that one, but there are no accepted solution and non of the suggestions helped me. But I did however find another post with a solution that worked. I have also posted an answer on the post from your link. This is the post that have the solution that worked for me...

What worked for me (credit to http://stackoverflow.com/questions/5724396/excel-64-bit-and-comdlg32-dll-custom-colours): Change all your Long Data types to LongPtr. That's in both the Function declarations and the Structs and the return types.

I have the same problem. Have you found any solutions yet?