Search results

On my report, I have a textbox which is populated with data from a query. Occasionally, the text is too long for the textbox and I need to wrap it onto the next line. Is there anyway to do that? I can't find a property for it at the moment...

I need to display the users' WIndows login name on a report in Access. Is there a way to do this through VBA. I have a label box setup for which I would do something like lbl_Name.Caption = variable

bump......

Hi In Excel, I believe you can format a number and automatically divide it by 1,000 without messing up rounding. For example, 10,000.06 after you apply the formatting becomes 10 as in 10k (for some reason accounting people find this easier to look at/work with). However, if you try to sum the...

Hi I have some drop downs on my form, which has some code that decides which recordsource to use. When I first select an option from the drop down, the query takes 10 seconds to load data. I then select another option, which runs a different query, which takes x seconds. If I then select the...

I have attached an example of one. All the work is done in the first part of the joins SELECT ? FROM Structure. Then all the separate sub selects are joined onto that. Interestingly, it only became slow as soon as I added the 3 extra subselects onto the end NA_ZA, NA_BD, and NA_ZI. Any ideas...

bump......

Thanks. Out of interest, if I put that in a startup form, won't it still error in 2002? The reason I ask is because the error tht came up the other day occurred before any command buttons had been pressed. It was an immediate runtime error in the VBA code. Is all the code compiled before the...

It's quite a complex SQL statement full of joins onto nested sql statements. It works on SQL server fine. The problem I am having is that Access' queries are slow. The only way to improve the speed would be to have a stored procedure on the SQL server side wouldn't it? In which case, there's no...

Hi I did get this sorted eventually. It turns out that Access can't reconcile the form references in the queries, so you have to actually refresh all the parameters by doing: Set db = CurrentDb Set qdf = db.QueryDefs(Me.Form.RecordSource) For Each prm In qdf.Parameters...

Thanks, does this autoamtically fix references to Excel and Access , etc. For example, I have the 11.0 objects library, How will Access know which library to fix it up to ? Also, what do you mean by start using autoexec? Do you mean an autoexec macro? Not sure if Access 2003 has that and it...

Hi I'm trying to program Excel from Access. I need to get a variable into the range bit here: .Range("B" & iCount + 7).AutoFill Destination:=Range("B12:Z12"), Type:=xlFillDefault I'm trying to replace B12 with "B" & iCount + 7 but can't get it to work because of the semicolon in the range bit...

I designed my DB and forms in Access 2003. A user opened it up in 2002 and it errored due to some missing references. Is there a way to add code to my startup form that can check whether the version of Access is 2003 or not before carrying on ?

Yeah, it's on my local machine. The SQL Server has about 3x more RAM and it's SQL Server anyway so, as you say, it's probably faster. I would like to use SQL SErver as the back end and Access as the front end but it seems to run into the same trouble because it is Access running queries through...

Is Access slower at summing null records than SQL server? I have a query which takes less than 1second in SQL server but takes about 5-10 in Access but can't think why there is such a lag in processing speeds.

bump......

Bear with me on this one as the query looks a mouthful although it's fairly simple. I started with the following query, which was working working very quickly and almost instantaneously bringing back results. Essentially, it is a number of nested select statements bringing back data and joining...

I have an Access DB (complete data and forms, etc.) at present. I would like to use this as a front end with SQL Server as the back end. I have used to upsizing wizard to transfer everything to SQL Server and now all the tables are linked tables. This all works but I need to send out the front...

Will indexing help speed up my queries if the queries are predominantly summing and group by queries? I know how indexing affects queries with WHERE clauses but what about the ones that don't? Also, are joins more speedy if resultsets have indexes?

Hi Thanks for looking. I know the queries look complex but the only bit that really matters in them, is in the 1st join SELECT Field FROM Structure WHERE... and then it goes on to put in a parameter from the form. This is the only place where parameters are in the query. You will see in the code...