Search results

I placed the design of my second form in my first form, but when I click the button, the second form still pops up as a separate window, and the secondform I have embedded onto my first form does nothing, it is just a blank space. The code (DoCmd.OpenForm "secondform") I believe is the reason...

I currently have a form (firstform) that contains a button. If I click the button it opens another form (secondform - as a sepated window) that displays data. I use VB (DoCmd.OpenForm "secondform") to open the second form. This works fine. Now I am trying to insert the secondform into the...

Formula for the conditional formatting is: condition 1: =R111="S" condition 2: =R111="B" Put this formula in cell I4 first. Then copy cell I4, and use paste special (select formats) to insert the conditional formatting from I5 to I83. Does that help?

I notice you have repeated this comment. We're not ignoring it, but I think you may have to dismiss it - I'm certain it's impossible to do in Excel.

I also work for a Worldwide business (US in origin) that will not 'officially' release Access with its MS Office applications. They don't recognise it as an approved program, and refuse to support it in any way. Therefore I had a very tough time getting Access installed throughout our Dept...

I can't work out how you differentiate between the 2 companies in your spreadsheet - as you stated in your original email. But I will confirm conditional formatting can set formatting based on words. Open the conditional formating box and change 'between' to 'formula' - then you can set the...

Excel forum can be found under: Access World Forums > Apps and Windows. However, have you tried recording a macro in Excel to import the file and append it to your data? You can do a real lot by with macros without being a programmer. I'd suggest you make a copy of your file, and experiment...

Yes, I appreciate that, maybe I didn't explain myself too clearly. If you create a query, with device_type in one of the fields, you filter on laptops by inserting the text 'laptops' in the criteria section of the query. I think I am visualising what you require correctly!

I think you have to change your approach, to something like this: In a query field, insert: Date: Format([FaultOpened],"mm-yy") Then in the criteria, insert the month and year you require, such as "11-09".

First you need to create a query and put 'laptops' in the 'Criteria' section. You can then create a report from your query. If you google 'access query tutorial' you'll find lots of helpful info.

Create a Report, this will give you a header and footer where you can add your date function and the results of a query (to add up what you need). You can then export the completed report as a text file.

I have used this command many times and in my experience it only ever overwrites the worksheet. Have you tried using the TransferSpreadsheet action as a Macro (under objects)? If this works, you can always convert the Macro into VBA and compare this with your original code.

I may be way off track too, but have you considered using 'conditional formatting'? It can automatically set the colours for you based on the contents of other cells (such as the company).

There are a number of ways of doing this by recording macros, have you tried it? One idea: 1) You could record a macro to insert a new row from whereever the mouse happens to be and then merge the cells you require. When recording the macro, you could add a new row in your table, and then...

I'm not too sure what you're looking for, you say it works fine except - what goes wrong? I have simplified your formula to: (A1+B1)/(A2-B2)*100. and I wondered if something like this may help? =IIf((A1+B1)>0,(A1+B1)/(A2-B2)*100,0) I'm not sure if you need to google the iif statement to...

There are also many others who rapidly respond to questions (such as DCrake for example) - whose help has been invaluable for me, does your post apply to other helpful members too? Just wondered if you could clarify that as your post could be seen as rather offensive. This has been my...

ahh yes, thanks guys - I followed the instructions too explicitly and put the code in the event property at step 5! Looks like I'll have to open the Access Window to display queries though, and I have lots of them. I think I have a lot of work to do before I can implement this code...

I wondered if anyone could help me out with this: I am trying to implement the code provided by ajettrumpet here: http://www.access-programmers.co.uk/forums/showthread.php?t=171396 My issue is with step 5, I have placed the different code into 'On Open' and 'On Close', but when I run the...

way too long, I'm finding this is the slowest site out of several I am using. Isn't there a compact and repair tool they can run? ;-)

arrg...90% of what I wrote was lost! Try putting the following formula in the forth column, second row. Then copy and paste it down as far as you need: =IF(A2<=B1,C2+C1,C2) I'm assuming your data is in columns ABC and rows 123.