Reply:

Build Dynamic Query from Form
I am trying to build a dynamic Query from a Form. I keep getting an error that reads ‘Object qryFilter already exists’ I suspect it has something to do with the string of dates being passed to the Query; strDateCondition = "([Trades].[TDATE] Between [Forms]![SearchForm]![cboFrom] And [Forms]![SearchForm]![cboTo])" I am trying to add a means for a user to Query by Customer and Trader AND all records between two dates. This was working fine for Customer and Trader; when I added in the code to filter by dates I started having problems. I know the SQL will be li...

Reconcile hangs on certain items
Every time I run inventory reconcile (history not checked), the same items seem to hang (most items are a few seconds up to 1 minute tops). These items are setup as misc charges, so they are not even inventoried. One of the items takes about 20-30 minutes in total. Why would an item that does not retain quantities take so long to reconcile? It's consistently the same items every time. ...

Comparing first and last names in two lists
I have two data sources that each contain about 8000 names in seperate fields for first and last name. I can put them on seperate worksheets or append one to the other. I need to make them match and find out where they don't. Messed with consolidate but not sure if that will work for more than one column at a time. FYI data set one is from a school transportation database and data set two is from the main student database from the same school district. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages dir...

please help with this query
Ost Ocity Dstate Dcity Carrier Price Rank Diff A B C D X 1200 1 100 A B C D Y 1300 2 100 A B C D Z 1350 3 100 A B C D W 1789 4 100 A1 B1 C1 D1 X1 785 1 A1 B1 C1 D1 Y1 789 2 The rank for every carrier is based on the price . If rank1 carrier is not a pariticular carrier(say if it is not X1 or Y1 or Z1), then i want to calculate the difference be...

Contact looses Post Office Box field when synchronized to Outlook
When I sync contacts from CRM 4.0 to Outlook, the Post Office Box field from the contact gets empty. Anyone has the same issue? ...

List Running Horizontally-Pivot Table Possible?
I just had a customer ask this one and I'm not so sure about it. 1) The customer has setup a list of information that is running horizontally instead of the typical list running vertically. 2) I just taught him how to do pivot tables and he wants to generate a pivot table with his "horizontal" list. 3) I know he can copy and paste special and use the Transpose feature to change the list from horizontally oriented to vertically oriented. 4) the question is: can he leave the table in its original orientation and still generate Pivot tables? I can't seem to make it work ...

Update Query
Access 2003 XP SP2 I am having a problem with an update query. Table is in a one-to-one relationship, referentail integrity and cascading data are checked. (The fileds I want to update are not in both tables) Table name= payForward Has 15 fields ie: ID, Name, MemID, Oct , Nov, Dec, etc Oct-Sep fields are yes/no type I want to "select" a field (Oct-Sep) via a query parameter and repalce "yes" with "no". Here is my query: UPDATE payForward SET [Enter month]=No The messages I get is 'operation must use an updateable query' Wh...

Rule to automatically mark header to download based on contact list?
Is there a way to do this, or an add-in? TIA. Rich On Tue, 26 Apr 2005 04:44:35 -1000, rmc <rmc@nospam.com> wrote: > Is there a way to do this, or an add-in? What version of Outlook are you using? -- -Ben- Ben M. Schorr, MVP Hi Ben: 2003 SP1 Rich "Ben M. Schorr - MVP" <bens@bogusaddress.mvp> wrote in message news:op.spuxh8sf6r4cx1@bms-tablet2.scgab.com... > On Tue, 26 Apr 2005 04:44:35 -1000, rmc <rmc@nospam.com> wrote: > > > Is there a way to do this, or an add-in? > > What version of Outlook are you using? > > > -- >...

List folders to file
Hi Does anyone have a macro that would list all the folders (with path) and subfolders to an excel sheet but not the files? Thanks Shona Shona- There's a function called CELL() that should return your filename (or any of a number of parameters) but I can't get it to work properly on my machine, so I can't make it work for you. The syntax is =CELL("filename") which ought to return the path and filename of the current file, and which you could then trim down to show just the path. Can anyone provide some guidance here? Dave, If it isn't working for you, it pro...

Disable people picker in a sharepoint list
Dear all, I would like to disable the users/groups picker field in a SharePoint list (NewForm.aspx). I managed to disable the field itself (text box) but it's still possible to click on the "Browse" button and search for people that then get eneterd in the field. Is there a way to disable the browsing? Thank you in advance, Hrvoje I think you will delete that column. 1. Settings>List settings>Click you wnat column name on Colums category. 2. Click "delete" button. And then you can make other column. "Hrvoje" wrote: > ...

Combo
Hi, I am able to create a list of items with a drop down menu. I can select specific item but how do I select all item to get a query output. Your help would be much appreciated. Thanks You can't select multiple items from an Access combo box. To do that would require a listbox with it's MULTI-SELECT property set to SIMPLE or EXTENDED. See more info about list boxes here: http://www.fontstuff.com/access/acctut11.htm -- Bob Larson Access World Forums Super Moderator Utter Access VIP Tutorials at http://www.btabdevelopment.com __________________________________ If my post ...

Combining Lists within excel.
I'm hoping someone can help here. I'll try to explain the problem I have. I have 2 worksheets both containing a product list. I have entries on one worksheet which I need on the other, so basically my question is... might there be a way of combining these two lists so one updates the other with the missing entries. Help on this would be great, as they are very large lists which I dont much fancy the thought of looking through them manually. Are you familiar with the VLOOKUP function? I use it all the time for this type of problem. vlookup(Product cell in first sheet, Array...

sent and received fields
I've just switched from Outlook Express to Outlook 2000. In one of my folders, I have sent and received emails that I want to sort together based on the sent or received date, but all my sent emails sort together because the received field has no value. And the same for the received emails. Is there a way to combine these fields or tell Outlook to sort based on both of them? Do I need to write a VBA macro to accomplish this? Thanks, Michael ...

Option for fields to show up in datasheet view
Hello, Since most people are more familiar with excel then access, my users prefer to see it in datasheet view. However, since it could be too long, anyone can help me how to make an option to show up only field that we can chose in the form. I remember there is a sample of database that has that one, but I do not know where is it now. Please help. Thanks in advance, Frank -- Frank Situmorang Simplest solution might be to set the Visible property of the controls on the form, based on the fields the user wants to see. -- Allen Browne - Microsoft MVP. Perth, West...

filter records in a form
I've created a form with its subform to enter tasks of employees. however I need filter records only for active employees The form has as a source, the table CARD_EMP (employee card). It has a field ST_EMP for the employee status (Active , Pasive) In the Event Form_Current I wrote DoCmd.ApplyFilter ST_EMP='A' but it doesn't work Thanks for advance Carlos -- Message posted via http://www.accessmonster.com Hi mamumi Your advice was the solution Thanks a lot Carlos -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscodin...

how to set up a query
I am using sql server 2005 express and have 3 tables Table1 Dept_Id (primary key) Dept_Name Table2 Employee_Id (primary key) Dept_Id (foreign key with table1) Employee_Name Table3 WorkSchedule_Id (primary key) Employee_Id (foreing key with table 2) Date_To_Work (date type) I want to list all the Departments (Dept_Name) that do not have anyone scheduled to work on a particular date (ie '1/20/2010' ) Any help would be appriciated. Thanks in advance, RABMissouri2010 Try this: SELECT dept_name FROM Table1 AS D WHERE NOT EXISTS(SELECT * ...

auto fill in data when changing fields
i new to crm 4 and i would like to; once i selected the account i need it to grab the main phone and put it in the phone field, and could you tell me where i need to do this, thanks -- j.hardy you can modify the mappings of the corresponding relationship "moon" wrote: > i new to crm 4 and i would like to; once i selected the account i need it to > grab the main phone and put it in the phone field, and could you tell me > where i need to do this, thanks > -- > j.hardy ...

Excel comparative query
I'm respectfully requesting assistance with the correct formula to use for the following query: I'd searching all of column A on spreadsheet 1 to see if a value in column A of spreadsheet 2 is there, and placing a result X (or another) next to (adjacent cell) the confirmed value on spreadsheet 2. Please help if you can. Chris Hi Chris see your answer in puclic.excel -- Regards Frank Kabel Frankfurt, Germany Chris wrote: > I'm respectfully requesting assistance with the correct formula > to use for the following query: > > I'd searching all of column A on ...

Currency Format Lost in Union Query
Thanks to John Spencer, I resolved one problem in my union query (Thank you, John). But I have another problem. Some of my fields in my union query are currencies and others percents. I see both formats are lost. I am sure it is a union query problem, because when I ran an individual query, none of the formats were lost. Is there any way I can keep currency and percent formats without writing, FORMATCURRENCY, etc for each field? Thank you. What data types are these fields? The field in a UNION query will normally take on the data type of the field in the first SELECT. So, if ...

drop down lists #7
I haave a drop down list which is in a table. When I change the selection (on the list) I want another cell in my "price column" to change value with it. Is this possible? Hi You could create a list with values relating to the items in your dropdown list. Set up on Sheet2 in cells A1:B100 a list with Item in A and price in B Supposing your Column with the dropdown is Sheet 1 column A, and your Price column is column C. In C1 =Vlookup(A1,Sheet2!$A$1:$B$100,2,0) -- Regards Roger Govier "Vivek" <Vivek@discussions.microsoft.com> wrote in message news:B16A028...

How do I get a list of data on one sheet into the form on the fir.
I have a timecard form on the first tab of a workbook & the various employee crew combinations on each of the subsequent tabs (each crew on a seperate tab). How do I format the for to get the employee name info from the individual crew tab required? Let me clarify my question - I am trying to use the first tab (the form) as a constant form & just change the employees names in that specific field based on the crew I want to generate the timesheet for. The crew lists are on the sugsequent tabs. I would like to be able to select the crew & print the form with only those emp...

Getting all Sproc through one query
Hi all, can anyone help in getting below information from all stored procedure from one DB we have 100 procedure in one DB of sql server 2005.instead if of manully getting info for each procedure i want all below details in one shot or one query Procedure Name : Input Parameter : Output Parameter : Called By : Calls : Dependent tables : Thanks in advance ...

How to carry over date value from one record to the next.
I have searched this site and the internet in search of an answer to this problem but none of the solutions I've found have seemed to help. I have a form that is used for data entry. The first two text boxes are called Supervisor and W/E Date. These two values will remain the same for several dozen entries. I have tried just using CTRL + ' to repeat the data but that is getting quite time consuming as well. How do I automatically carry over the value to the next record once I input the first data in? Any help on this would be much appreciated. -- Message posted via AccessMo...

Payee line and memo line need to be reversed for certain transacti
I currently am using Money 2004. Here is my question- I import my transactions each month. The only problem is that evry transaction that is a debit card purchase currently as to be manually fixed, because in the payee box I see the bamk's info ex:" DDA PUR 4545454". tHEN IN THE MEMO LINE WILL BE THE actual name of the business that the transaction was made at. I am hoping there is a way to automate the process of switching these two fields. So basically, i want to progem Money to look at the Payee line and if it starts with "DDA" switch it witth the payee line. ...

Having marketing lists in outlook as Distribution list
We have already CRM specialized Distribution lists for contact, lead, accounts, we should also find here all the marketing lists owned by the user and with members accepting email contact. Thanks CS ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microso...