Search results for query: *

http://www.tek-tips.com/faqs.cfm?fid=3324 I need to update this to add SQL 2005 books. Any one have any suggestions for good ones? Please try to give me the same information as in the FAQ: title; author; publisher; person who suggested the reference; short description "NOTHING is more...

Today I was IMing a co-worker about an issue, he told me he'd get back to me after lunch. I meant to reply: I'm off to lunch myself. I actually typed: I'm off to lynch myself. Questions about posting. See faq183-874

Aytime I try to set up a DTS package with a temp table it will not parse and thus fails. If I change it to a table variable it will work. Unfortunately I now have a situation where I need to be able to insert the data from another sp into a temp table to use in this sp that I want to run a DTS...

In case you haven't noticed, there is a new feature allowing you to archive threads that you find useful. This is particulaly nice for those of us who have answered something complex that we know we will want to refer to later to answer a similar question. It's also handy if you got an answer...

I've already fixed the problem, but I still don't understand why it occurred and I was wondering if some of you who are more expert in creating forma than I am could shed some light. It bothers me when I don't understand something and this one is truly strange. I have a form which is a subform...

I have a continuous form for vendor part data. When users are adding parts I would like the system to check the model number to see if it exists for that vendor and then tell tham it is a duplicate record. At this point I want the message box to give them the option to edit the record or go to...

DoCmd.OpenForm "frmProposalTools", , , , acFormReadOnly Has anyone ever run into an instance where the form was still editable after opening it with this command? If so, can you tell me why? Questions about posting. See faq183-874

I have a field that I want the entire field highlighted whenever the user clicks on it. It does this when you tab to it but not when you click with the mouse. I can't seem to find the command to specify that the whole field is highlighted. Questions about posting. See faq183-874

I have an an Access 2000 ADP file which has a report based on a stored procedure. Nothing odd or unusual. It has worked perfectly for 6 months. The main user of the database, recently got a replacement laptop. Now the report says that the sp does not exist, even though it clearly does. If I...

Ok, now this one is really wierd. Three users all use the same netwrok printer. One can print reports using it and two cannot, in fact they can't even preview the report when this printer is the deafult or get to the print dialog box to change the printer. However, if they make a differnt...

Recently Access has been hanging on closing for me and the users of the program. Not every time but often enough to be annoying. The program was originally developed in Access 97 then converted to 2000, but the decision was made not use an ADP or ADO. (decisons I opposed but lost on.) Instead...

In the SQL Server forum we started to discuss on one thread the need to redesign a particular production database. I thought I would bring up the topic in here and see what thoughts everyone has on maintaining poorly designed databases. Most people who have worked with databases awhile have run...

I have a linked SQL server table. I can add records to the table but not edit them. Also it will not let me delete records. If I try to edit I always get the message about this record being edited by another user. I thought at first it was something funny on my form, but I can't edit records...

Ok this one just makes no sense whatsoever. I have an application written orginally in Access 97 and converted to access 200. Currently it runs on machines which run Access 200 and access 2003. ONe of our employees has a new computer and they installed Access 2002 on it. The rest of the...

I have a subform of a subform which has the tab order correctly set. However, it does not in all cases work correctly. If you select an item from the pull down list and hit tab, it will correctly go to the field it is supposed to go to next (also a combo box with values based on what is selected...

Just in case anyone is looking for training on performance tuning, I ran across this link today. http://www.sqljunkies.com/Event/CE052D05-745B-4C74-B3C2-341BB38A40E5.scuk Questions about posting. See faq183-874

I recently installed Access 2003 and now I need to create a run-time application just like I did in Access 2000. The deployment wizard is not listed as an add-in to install, is it called something else in Access 2003? I can't find any refernce to it in the help files or Mircosoft Knowledge base...

I copied a databse from another server (Windows Server 2000 operating system)onto a new server with Windows Server 2003 installed. This database had a fulltext search catalog located on e: drive. E drive does not exist onthe other server. When I try to populate the catalog it saiy that...

I have a table which joins two other tables in a many to many relationship. I want to create a form which displays the data from one of these tables but allows you to update the table which has the link. SO what I have is a table which holds data on proposals, a table which holds data on clients...

This link is one grammar resource I recently found. Please add more so that when people are looking for ways to improve their English, they have a list of places to go. http://ccc.commnet.edu/grammar/index.htm