Search results for query: *

Thanks guys for your help. Works a treat. PHV - I think you meant "100" and not "1" in your equation. Appreciated.

Hi is there a VBA way of calculating a percentage reduction? eg. work out what a 20% reduction of 10 is? The answer is 8 of course but is there a way I can code the calculation? I know I can do it using: 10 x .2 = 2 therefore 10 - 2 = 8 but is there another way? Ta.

Thanks mate. Worked a treat!

Hi is it possible to display the "Startup" dialog (found in the Tools menu) from code? Cheers.

Thanks for the replies Remou. I've got a "Compile Code" function available to me in my app and using that brings up the DB window. Happy days!

I have a database that I have secured it so well that I now cant get back into it! I've removed the "Startup" option from the toolbar as well as the Access toolbar. I cant right-click on the menubars and holding down the shift-key etc wont work. I tried importing all the objects into a...

The Forms recordsource is a filtered query. As I mentioned when I used to Print it'd print the results from this query. Now it prints all the records from the screen underneath. Any other ideas?

Thanks for your reply but to begin with it's a pop-up Form and it can contain more than just the one record. I dont really want to go down the road of having to put hidden text boxes on the form displaying ID's. This used to work in a previous copy and I'm not sure why it's now broken.....?

When I run the above command it seems to print out all of the records contained in the Form behind the pop-up one that is open AND that has the Focus (first thing I checked). I also tried using Docmd.PrintOut.acSelection to no avail. Anyone know why this is happening?

Thanks Duane for your reply but I tried that already and it didnt work. The answer in the end was to create a footer for the common parameter between the sub and main reports. In this case it was SalesID. So I went to "Sorting and Grouping" selected the para set it to "Yes" on "Group Footer?"...

...the plot thickens. The invisible text box on the Subreport Report Footer displays a different total to what you get if you reference it in code. That is I wrote some code in the On_Format event and then put a break in and checked the Debug window for the value of that textbox and it wasn't...

I have a report that details customers and the items they have bought. The "Detail" section of the main report houses a subreport which displays all the items for that particular customers order. The customer may have more than one order but only one invoice is displayed at a time. In this...

...or a way to trap the error?

...isnt there a timeout property somewhere which I can reset because, as I mentioned earlier, this only seems to happen on those reports which take a long while to compile (lots of data)? I've already set the ODBC Timeout property in the query to zero.

In my connection string I'm specifying the "UID" and "PWD" already; isnt this enough? Also (for my sins) I'm using DAO to attach in this DB (legacy thing which I inherited) and dont really want to change it.

Thanks for your replies guys. Prairie is there a way of remembering the password in code? I've already hardcoded the password into the connection string - is this what you mean or is it something different?

I'm linking to a SQL back-end using SQL authentication from my Access FE. Everything works fine apart from those reports which contain a lot of data when a SQL Server Login prompt appears halfway through processing. If I then enter the password it continues and works OK but I dont want this...

Give that man a star! Cheers PHV.

Thanks for your reply Crowley. I tried this but it didnt work. Any other ideas and why does it work when I set a breakpoint? Does the code window become the active form/window?

I have an image on my Form that I use as a button. When I click on the image it opens another Form which I make a selection on and then minimize onto the taskbar. When I want to re-enable the minimized Form by clicking on the image again, the Form fails to open. It stays minimized. However...