Search results

Hi All, So I'm trying to apply conditional formatting to my spreadsheet, that already has some data in there, basically on each row I want to change the fill colour, for the row if say one of the cells in the row has the word "Assigned" in it. This is easy enough using conditional formatting...

Hi Brian, Many thanks for that, it worked, I just had to calculate the last cell to work back from and it totals up for me nicely. Thanks for the quick response :) Mattp

Hi, I have a spreadsheet where I capture proposal information, including customer name, status, who prepared the proposal, date prepared and the value. I also then have a number of columns where I can log any amendments to the proposal cost, where by I log the date and the new cost. How...

Hi, I have the following code, working off an archive button (I didn't write it, I was advised). Basically it looks through all rows on my "Open Quotes" sheet and looks for the status in column D. If the Status is closed it cuts it out and pastes it into another worksheet "Closed Quotes" and...

Lagbolt, No that is the problem I am getting, as I have various lengths of text in the journal notes I either go for a smallosh text box and cannot see half the text, unless I use a zoombox or I go for a larger text box, that on some occasions will have a lot of blank space in it. It's not a...

Hi, I have a continuous subfrom on my main page, that keep Log entries. Is there anyway I can resize the text box, for each instance in the continuous form, dependant on the size of the text in the record ? At the moment you either have it to big or too small, so I did set it to smaller size...

Might be a real easy one this one, When designing a form, what is the difference between a Form Header/footer and a Page Header/Footer and when would you expect to use either option ? Thanks MattP

Ok I hope this makes sense, I'll try to explain clearly I have a database that is used by several teams, I have a simple loggin code, that I got form this site, where by the user details, team and level (user, manager, etc..) are captured and can be called at any time. SO on the forms every...

Neileg, I've used Cascading combos already on another combo however on this particular issue I may have a table entry that is visible to 4 out of 5 teams and another that is only available to one out of the 5 teams. I could not find anything in the forum relevant to this particular way I want...

I'll have a look at that, however my main performance issue seems to be around my large journal table, these are all unique entries as they are memo fields of update notes. If I take this table out completely thent he whole DB runs very well, however I need the journal notes to show when I open...

Ok so another query from me today. On my database I have a number of different teams, on some of the combo boxes not all the entries are relevant to all the teams but they may also share some of the same entries in the combo. Can I have the combo filter it's drop down list dependant on the...

Hi, I'm not sure what you mean, is this the option to select Indexed (yes/No) for the fields in the tables ? Regards MattP

Hi all, My current database (built with a lot of help and sample code form this site..thankyou to all for their advice) tracks the escalations we receive into the business but as we have used it more and more I have started experiencing a massive performance issue. I basically have a main...

Ruralguy, Not sure what you mean, I have a combo box on the form now, which shows the first column only, whoch has the QTR values in there ie. FY06 Q1, FY06 Q2 etc When I select a value from the drop down I want to get teh corresponding 2 columns to populate, or update two textboxes as below...

Ok I think this is going to be a really easy answer for someone but I'm going round in circles :confused: I have a table, called "TBL_QUARTER" It has 3 columns, as follows: Quarter Startdate Enddate I have a form that is bound to the table, which has a combo box which is using Quarter as...

RuralGuy, yes I know I can use the upsizing wizard to convert to a SQL backend, however I was advised that creating the Access part using ADP would be "Cleaner". MattP

I have attached a basic logon function, that I originally got from these forums. I am trying to use this type of logon example for my new DB, that I am creating in ADP with a SQL backend. I am experiencing problems trying to get the recordset function to work correctly, in particular in the...

RuralGuy, I started from scratch and got the code working in the ned, thanks for your response anyway. MattP

All, I am having a similar problem, I have my code set up exactly as you have advised in this thread but I still get a Run-time Error 13, Type mismatch error? I have the DAO referenced as well. Any idea's ? Many thanks MattP

Smart, So how can you differentiate if you want to view or Print a report, can you place customer commands or do you just put the report under a submenu to print ? Thanks MattP