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, 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...

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...

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 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...

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...

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...

Ok my database tracks escalations through my team, I have a main table that stores the unique ID's from the other tables I use in my Combo boxes, this part works really well, no problems. My issue is with a tableI have claled "TBL_EscJournal", this table has the following fields: JournalID...

Right slightly complicated (in my eyes) and I have not found anything in previous threads to help but here goes: I have a main form (FRM_SUMMARYREVIEW) that has an unbound subform field on it (subfrmmaster). When FRM_SUMMARYREVIEW is first opened subfrmmaster has its sourceobject set to a form...

I've had a search in the threaqds for an answer but cannot find anything specific, plus this one has stumped me. What I need to do is check if a certain field has a value if another field has a specific value ??!!? Ok so if Combo Box 1 is set to 1, then Combo box 2 must have a value selected...

I wonder if anyone could help me here: I have my main form that has a row of buttons at the top, some of these buttons have multiple functions so I have some hidden text boxes underneath that appear on the mouse move command, giving the impression of a drop down list for that button. Just...

I have put together various charts form my DB, using Pivot charts but would like to be able to export these out to Powerpoint, easily. I am trying to use a macro and the "SendKeys" option to take a snapshot of the screen(form) and then have it pasted into Powerpoint. Does anybody know the...

A quick design question here, Is there any code that you can add so that you have your main form open to maximise and your subform adjusts accordingly ? My database is used by a number of users, some use 1024x768 and some use 1280x1024. I want the main form to maximise when loaded but I would...

Ok i have searched through the forums but can't find anything that is specific to my problem. On my database I have a main screen, that has several option buttons on it, and asubform for the main data entry. On the main screen I have a text box that is bound to a query that counts a total of...

Ok i have searched through the forums but can't find anything that is specific to my problem. On my database I have a main screen, that has several option buttons on it, and asubform for the main data entry. On the main screen I have a text box that is bound to a query that counts a total of...

Ok this is a bit long winded and I will try to explain, I have a main form, with a title at the top, then a row of buttons underneath and underneath the buttons I have a sub form. Some of the buttons can have a dual function (or multiple function) so rather than open up another form I have...

Ok, not sure if this is a fix with the report chart or the query, I run a query that captures the last 15 days worth of entries, however currently it counts weekends, which are blank, as such I do not get a full 15 working days worth of data. This is fine when exporting the data to Excel as the...