Search results for query: *

OK so Outlook 2003 used on Home computer linking to our Fios account. Windows XP When I updated the contacts list the wrong information was then populated in the address book. Additionally I know the NK2 file (which helps to populate the drop down list of previously used emails) is out os...

Sorry Access 2007 Windows XP

Ok so I have a grouping by date. Dates are grouping by Qrtr report shows Q4 2009 the code which shows this is as follows in the properties sheet in the control source:="Q" & Format$([Opened Date],"q yyyy") OK so here is my question: How do I modify the qtr report to show up for Government...

What,,,,, Are you syaing Microsoft still has no feature with a gun placed directly into the face of a user??? Oh man, I thought that was supposed to be released with DOT NET Framework!!

Alright, I need to ensure that the analyst enters data into a specific cell and when they exit or save the workbook a prompt or other bold signal occurs either in the cell or a pop up that the cell requires data entry, based on the fact that related row cell has data. If the primary row cell is...

The only problem with your solution is that the subsequent sheets read the data and decompose it into different cells. so your solution would then provide on sheet 2 E2 "ENT" and sheet 2 F2 "ATA" and if the analyst fills in down to line 23 and that ends the lines of Data, then I do not want...

So I have excel 2007, on windows xp. I have three sheets. Sheet 1 contains raw data, sheet 1 disassembles data and sheet 3 reconfigures or rewrites data based on logic to populate for a .prn file to be upladed into a mainframe system. I need to ensure that cell E2 has data populated based on...

OK this is a two part question. First, if I can creat a button to run a Macro fine or VBA fine; which would you recommend if the Macros security issues are different between Orgs using a templated Excel spreadsheet. Second, what I need the macro/script to Execute. I have a data template (DATA...

OK , I thought this was simple fix. Please help. I have an ACCESS 2007 Template which I modified simply and it works with one user. I placed the Tracker.mdb onto a share drive \\tulip\fmbm No one except one person at a time is able to input data until one person enters informaiton then saves...

OK this is a two part question. First, if I can creat a button to run a Macro fine or VBA fine; which would you recommend if the Macros security issues are different between Orgs using a templated Excel spreadsheet. Second, what I need the macro/script to Execute. I have a data template (DATA...

Ok I am using Excel 2007 and here are the examples of what I need. in the column I have data example: 03 - Maintenance & Production Facilities 02 - Training Facilities I want to read the text of the first two identifiers 03, 02 and store it into a new column seperate rows. I plan to delete the...

Ok so now I really have done it.... Here is the latest development I forgot to tell you that I entered the new field into a TabControl area. then I attempted to fix the situation by deleting the following table fields: Resolution_Comments Resolution_Comment and so I copied an existing field...

After inspecting the Db folder, it would appear that the Form is based off of the Table. I say this because I can see only one Query in the system called "Open Issues" which apparently is associated to a Macro of "Browse All Issues Macro" I inspected teh only Query and I do not see the field...

OK, I am working on Access 2007, I am familiar with the Access 200 concepts but haven't worked it since. I added a new field to an Issues Tracker MS Template table. I copied the "comments" field and added a new field called "Resolution_Comments" I added it to the "Issues" Form Now when ever I...

Ok so I have an access 2007 table which I was updating with a new field. This is a Memo field and all appears fine. After saving the table and form update suddenly when I go to reopen the Db or the Form it asks to fill in a parameter. It does not require an entry if I select OK then it will...

Hey Mint, Actually it wasn't described well in the help section it took me more time to figure out they were talking about "Format" from the menu bar than from the formula bar. FYI, the reason many come HERE is for more guidance than just "GO check out HELP" The only guidance you provided me...

I'm trying to make a cell in an excel document change color within the context of an IF statement... [=IF(A20="LSS Training", blue background, no background)] Is something like this possible?

here is the file I am discussing

redesign of the work book at this point is not the option I was seeking. I tried yrou suggestion last year and the users were too confused. I found a system that they liked, worked well in and the formulas worked to provide SOLID results. My current problem is the updating with new names and...

Yes, that I do understand, I use that features quite easily and I find it very powerful. But the problem is that others who would not have direct support (i.e. Girls and Women out of state and people who want this excel workbook to track scout cookie activities are unable to use such advanced...