Search results for query: *

Hi All, I would like to figure out how to identify a future date using an identified date and adding only work days in Excel. So for instance, today is 7/15 what date would it be 20 work days from now (M-F)? Thank you for your help. Sandy

Hi All, I have an Excel spreadsheet with the following conditional formatting set in a macro. When this macro runs it highlights fields that are null. How can I only highlight those fields that are populated? Here is what we have: Columns("H:H").Select Selection.FormatConditions.Delete...

Hi All, I understand how to highlight every other row in an Excel spreadsheet using conditional formatting and the mod() function. Is there a way to highlight every other data grouping such as by State? My spreadsheet fields are as follows: A: AgencyName B: AgencyAddress C: AgencyCity D...

Hi All, I am looking for a program comparable to GeoAccess. I need the ability to develop maps using data I currently have housed in Access. Any suggestions?

Hi All, I have a search form named SV Search Menu, which includes the following fields: Agency Number Name State Rep cboFederalBuilding All of the fields are required for data entry except the cboFederalBuilding field. What I am trying to do is run a query using the search form criteria...

Hi All, I have a form that I use to run roll up reports by Colleague, Team or Auditor. The team and auditor report is the same but the colleague report is different. I would like to use the same form and report button to run either report. Here is the code I am using for my report run...

Hi All, I am trying to append some data from one database to another using an append query. The database I would like to append to has a password and I keep getting a "Not a valid password" error when I run the query. This is what my file name looks like in the append file name box...

Hi All, I am trying to put together a scatter gram in Excel to show how many colleagues are falling within a particular percentile. My range is from 85% - 100%. I have tried to use a roll up of my data and the full data set and I get the same result either way, one dot for each percentile...

Hi All, Is there a way to count how many times a letter appears in a field? I will have a string of characters such as PPPPLLLLPPPPPBBPPPP and would like to have one query that will tell me how many Ps, Ls, Bs and so on are in that field for each record. Thank you for your help! Sandy

I am trying to locate some reasonably priced Access 2000 courseware. The audience only needs to understand what a database is and how to work with tables, queries and reports. I have found so much online and would like to know if anyone has any suggestions. Thank you! Sandy

Hi All, I have a Word table with a 100+ rows. When I put the table together for the first time it took a long time to save. However, now when I try to make updates to the table it just locks up. Is there anything I can do to keep this from happening? Thank you! Sandy

I have an Excel Spreadsheet with the following: ScheduledTime(D):18900 ActualTime(G):17160 ScheduleAdherence(H):=IF(ISERROR(G6/D6)*100,"N/A",(G6/D6)*100) MeetsGoal(I): I want to say if ScheduleAdherence is "N/A" or div/0! then "N/A", else if ScheduleAdherene is >=...

Hi All, I have a form where I do not want the user to be able to close it if the LetterAlert check box has been checked but no details have been added to the LetterAlertDetails memo field. So I have placed the following code before all of the other code on my close button: If Me.LetterAlert =...

Hi All, I have a user that developed a database where one of his forms has the ability to filter checks using a macro. He has placed this macro on the double click event of the check number label. After upgrading to Access 2000 from Access 97 his filter does not refresh or clear itself so he...

Hi Everyone, I have a spreadsheet that houses survey results pulled from our Web Page but the date field for each record is showing as 2.00211E+13. However when you click into the cell the true value is shown in the formula bar as 20021116121646. But I cannot see this true value unless I...

I hope I can explain this properly... I have a calculation in a query that produces the total calls per hour for our employees. If an employee did not have any calls Access tells me that the Total Calls Per Hour value equals #Error instead of "0". I'm not sure if I can program...

Hi All You Experts! I need some guidance on how to format time duration. I have a file that I have imported from our phone system directly into Excel. The duration of each call should be tracked in hours, minutes and seconds. For instance, 00:00:00 should say that this Employee was not on...

I have always created separate front-ends for each user. The front-ends are housed on our server not the user's hard drive. Do I really need to create separate ones? Or can they all share the same front-end at the same time? Thank you, Sandy

I have a spreadsheet that houses both phone and correspondence statistics within the same cell seperated by a /. For instance 2/5. I would like to split these into two seperate columns of information. I tried to use the LEFT and RIGHT functions but the number of characters are not always the...

Is there a limit to how many front-ends can be attached to a single back-end database? Thank you! Sandy