Help
in [Access]
|
How to use operators Like and Not Like together? Hi, How can the Miscrosoft Access 2003 SQL statement be changed so that the operator Not Like will work? When I view the query the data I want excluded is still included... SELECT ROOT_AE_P_PRO_E.PROPOSAL, ROOT_AE_S_BLD_C.BLDG, ROOT_AE_S_BLD_C.BLDGDSC, ROOT_AE_P_PRO_E.REQUESTOR, ROOT_AE_P_PHS_E.SHOP, ROOT_A... 25 Jun 2008 09:50
Query Criteria to Identify Expired Credit Cards Hi Chuck & Mike P, I have tried both of your solutions in relation to converting the initial data into a suitable form for sorting/applying criteria to and both work. But now I'm having trouble with the criteria part... I keep getting the error: "Data type mismatch in criteria expression". Chuck, I put th... 26 Jun 2008 01:16
Changing Form's view in VBA I have a form that does not display correctly. frm1 opens frm2 via a command button. My three problems with frm2: 1. Displays in form view when called from the button. (should be datasheet view) 2. "Shortcut Menu" is set to "Yes", however I cannot right click in the form to go to design view. These prop... 27 Jun 2008 00:53
Update oracle via Access forms? Hi, Is it possible to update oracle via Access forms? I am thinking maybe I could make a link table connnected with oracle database. And the form could be based on the link table. Does this sound feasible? Any better ways? Thank you. ... 24 Jun 2008 20:34
Query Oracle Dual via Access Link Table? Hi everyone, I am working on a project using Access as the frontend of a Oracle database. I'd like to use the Dual table in Oracle so I made a link table in Access for the Dual. However, it doesn't work when I run the following queries: SELECT sysdate FROM dual; (dual is the link table in Access) or SE... 24 Jun 2008 15:25
Export to Text File with newline delimiter Hi All, I need to export a query to a text file but i need each field delimited by a new line. Cant seem to find a way to do it. any ideas.. thanks jim ... 8 Jul 2008 11:02
Using Access to analyze and report SurveyMonkey results? I recently used SurveyMonkey to host an online survey and one of the options they offer is to download the data for a relational database. When you download the file, (you can download a sample here: http://www.surveymonkey.com/_exportExamples/Examples.zip) , you end up with a folder with three html files: Question... 25 Jun 2008 12:56
SQL In Statement with Variables? Is it possible to create a SQL In statement using variables? For example, here is what can be done: SELECT Test.ID, Test.Desc FROM Test WHERE (((Test.ID) In (3,6,9,12))); But, I would like to do something like this: SELECT Test.ID, Test.Desc FROM Test WHERE (((Test.ID) In ([@TestTypes]))); ( I have... 24 Jun 2008 12:18
arbeiten als krankenschwester im ausland job luebeck Event-Manager Event-Managerin arbeiten im ausland stellenangebote arbeiten als krankenschwester im ausland job luebeck Event-Manager Event-Managerin arbeiten im ausland stellenangebote + + + ARBEITSANGEBOTE IM AUSLAND http://WWW.STELLENANGEBOT-AUSLAND.DE http://WWW.STELLENANGEBOT-AUSLAND.DE + + + AUSLANDSJOBS ONLINE FINDEN http://WWW.AUSLANDSJOBS-24.DE http://WWW... 24 Jun 2008 08:11
Link to CRM tables from external application My client has a mission-critical application that was written in Microsoft Access sitting on a SQL Server database. It is basically a Quotation management system. The client wishes to install CRM and I'm investigating how to migrate the Customer data from their Quotation system to CRM. I'm pretty confident I can... 25 Jun 2008 18:06 |