Search results for query: *

I need a query that will look for "-" anywhere in a number and delete them. Example: 8888-88-4444444 or 8888-88-4444444 8888884-44-44-44 to 8888884444444 I would really like to do this in a query if at all possible and I did not find anything that would work when I searched on replace. ::-)...

My entire department will be upgrading to 2003 early in 2005. one thing that would cause me to expedite the process would be if the following "questionable practices" in 2000 have changed 1. Can you export Reports in anything other than RTF so that graphics can be pasted into PowerPoint? 2...

One of the glitches in Access 2000 is that when you export to Excel, it exports in 5.0/95 format. To get it into Excel 2000 format (so that it can be linked to), you need to save it using the "disk" or "save as". You can not just close it. When I wrote a macro to save it, it saves it in...

I know that Access 2000 exporting to an Excel 5.0/95 Workbook is a known problem (hope it got taken care of in 2003 [ponder]). However, it is usually not a problem, but I have this situation where I need to export 45+ queries to Excel every month to feed a bunch of graphs. AND I NEED TO SPEED...

I know that this has been discussed, but I can not find the information [sadeyes]! What is wrong with the following If [subform DATA_ACE Claims A].[BTN] Is Null Then [subform DATA_ACE Claims A].Visible = False Else [subform DATA_ACE Claims A].Visible = True End If I get "Run-time error '438...

I can create custom stationary with no problem, and get a picture in. BUT I want the picture to show like a letterhead, and none of the message to start on top of the picture. I have "sorta" accomplised this by making a large, blank picture and putting my "letterhead" picture at the top...

Is there anyway that I can do a search and replace with a query? I need to remove all NON-alpha/numeric characters. Example: 456-444*777 to 456444777 ::-) Deb Koplen deb.koplen@verizon.com koplend@swbell.net (weekends and nights) A person can stand almost anything except a succession...

I need to run a query that tells me if a field has less than 10 characters. Any ideas? ::-) Deb Koplen deb.koplen@verizon.com koplend@swbell.net (weekends and nights) A person can stand almost anything except a succession of ordinary days.

Selecting the basic top ten is not the problem. However, I need to select the top ten customers by revenue, then the largest ten orders for each of those customers. I know that I could do it with 11 queries then joined with a union query. BUT, the data can change monthly and would not like to...

The No current Record problem seems to be related to the type of JOIN, but I can not get the data I want when I use the inner join. AND, if I take out the information about the Duplicate record (see bold) I also get records. The following returns NO CURRENT RECORD SELECT [REF_Dashboard...

For a number of reasons, I need to make a copy of the file names, directories, etc of the results of a search by date. Is there anyway to do this ::-) Deb Koplen deb.koplen@verizon.com koplend@swbell.net (weekends and nights) A person can stand almost anything except a succession of...

My boss has asked me to set up a default footer for all members of his department. I plan on doing this by designing a book.xlt and sheet.xlt (for new workbooks and inserted worksheets) and having them place it in C:\Program Files\Microsoft Office\Office\Xlstart on their computer. But I have a...

In my report at OnFormat, I need to say that if subreport [RR_BLIP Report State] in [GroupFooter3] has no data, then [GroupHeader5]is not visible. Have I got too many parameters? ::-) Deb Koplen deb.koplen@verizon.com koplend@swbell.net (weekends and nights) A person can stand almost...

I have got the total from the sub form showing on the main form (Finally - Thanks everybody). Call it [MainForm_ST]. I have created a control that makes a calculation using [MainForm_ST]. Let's call it [plug]. I need to get plug to change (recalculate) any time a change is made in the...

I got most of KB Article 322900 to work, http://support.microsoft.com/default.aspx?scid=kb;en-us;322900 and it is doing EXACTLY what I want it to, except for 0ne thing. I can't get it to put the key field where I want it. Following is what I have. Private Sub cboNames_AfterUpdate()...

I have a small Access 2000 database that consists only of tables. I need to convert this to Access 97. Everytime that I go to Tools - Database Utilities - Convert Database to an earlier version, I get Invalid Field Data Type. What should I do different, or look for in the tables that could...

I need to flash a message on the screen for a short length of time (just enough to read the message) when a macro is run. So I am putting the message into Word Art, then deleting it. BUT how do I pause between the drawing and the deleting so that the Art can be read? ::-) Deb Koplen...

I think I am having a brain hiccup here! I want to summerize and perform calculations on data from a table of 15,000+/- lines in a query. Then base a form on that query. Then, in the form, add narrative based on the manipulations. Then store everything on the form in another table. AND I am...

I run two computers in my cube, both connected to the same network drive. Is there a way that I can set up Excel, Word, and PowerPoint so that I can put my macros on the shared drive and reference them from both computers? ::-) Deb Koplen deb.koplen@verizon.com koplend@swbell.net (weekends and...

I put out a "flock" of RTF reports every month, and they go to a specific directory based upon the month. I already have a form included that does lot of "stuff" based on the month. Is there a way that I can have a macro that references a field on the form in the...