1 Resources for

s.field1

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Asking twice on MSAccess 2003: Hi to all!I've an issue that I really have no idea why is happening...When I FIRST run the query shown below, it's asking me twice the field "[PLC]". When this happens, I only need to insert the value I'm looking for on the second pop-up window.SELECT *FROM Table1 SWHERE (((S.Field1)...; Tags: PLC, rayasta@..., S.Field1, S.Field2; Discussion threads 2007-02-01

Additional Resources

SQL Question: When the Pivot data contains a Key Column (and character data at that!): I recently wrote about pivoting (or is it unpivoting?) some data. A new wrinkle has been added.Let's say that the data now looks like this:INSERT INTO X ( FIELD1 ) VALUES ( 'row1,1,2'); INSERT INTO X ( FIELD1 ) VALUES ( 'row2,2,3'); INSERT INTO X ( FIELD1 ) VALUES...; Tags: Field1, INSERT, SQL, VALUES; Blog posts 2006-07-06
Access Query: Hi all, hoping you can help me with a probably simple task.In running a query i would like to be able to submit any amount of a parameter to bring back all information related to one or many ObjectID's.Any ideas how i can perform this task?Sample code looks likeSELECT Field1,...; Tags: jim@..., Microsoft Access; Discussion threads 2007-03-16
Join a query with one of the Tables used to generate the query: Hi to everybody,I would like to know if it's possible to do this in MSAccess SQL:Select * FROM (table1 LEFT JOIN table2 ON table1.field1 = table2.field1) LEFT JOIN table2 ON table1.field2 = table2.field1Note that table2 is being used twic; Tags: join, sql, programming, access, software, microsoft, windows, Table2, LEFT JOIN, rayasta@..., Table1, Table1.field1; Discussion threads 2006-12-13
extract text from comma seperated values in a text box: hi guys, girlsi have users entering words in a text box seperated by commas. i need to use those words as values in a search. there might be only one word, but then there might be twenty or only three. i need my code to extract the words there and...; Tags: carterlangley@..., comma; Discussion threads 2007-05-02

Changing field properties on tabular form (MS Access): Hi,How to change field properties on the tabular form depending on values of certain fields?F.ex. if the Field1 on record1 has value 0 then I want to show the Field2 value on the same record in red. If I use the following VBA code for the onCurrent event on that...; Tags: Microsoft Access, Microsoft Corp., oguintch@...; Discussion threads 2007-10-15
Access report w/conditions: I am working on an access report that displays records depending on the conditions of multiple fields from a query. If ([date1] [date2]) and [fieldA] is false. The fields in the report are the same for each of the 3 sections. It should look something like this:Report Header (once...; Tags: Microsoft Access, birdbyte@..., Records Field1 Field2 Field3, Second Group, fieldA; Discussion threads 2007-08-13
Access-AutoNumField on ImportSpec: How do I add an AutoNumber Index Field on the Import Specification in MS-AccessChris, you can't add an autonumber field to an import spec.You need to add the field after the importrun imporrt then to add an autonumber to your table run the following SQL, modifying as required.alter table table1...; Tags: Field1; Q&A 2005-06-27
Performing a search of my DB in Access using data access pages: Hi all -I am trying to run a search of my DB through a query using a couple of fields as a front end wild card search. Ex. DB Field1: NAMEwild card entry1: FUNDB Field1: AGEwild card entry1: 23SEARCHI am creating a WHERE statement of [NAME %FUN% AND AGE...; Tags: Microsoft Access, aczocher@..., data access, wild card, card; Discussion threads 2007-03-26
how to optimize a update query: i am using sql server , and try to update a table a single field with a update query " update table alpha set field1='23' where field2='asd'"now i have to run this kind of query 70 times/sec .Now in some cases query takes 7 ms to complete , but some...; Tags: Databases, amitbharadwaj@...; Q&A 2005-07-01
summary query?: Right now i have a query on top on another query for a certan count. I'm wondering if there is a way to turn it into a single query.the data is say 1,2,3 time day count.For report/query I need to pull 1,2,3 into say 1-5 and add them together...; Tags: natasha.epperson@...; Discussion threads 2005-03-22
Reset ID Autonumber counter field on Table in Access: Hi, I import data from a text file into an existing table. The text file has no column headings, so I delete all records from my existing table and populate it with data from the text file each tim. I need the ID autonumber field. However, the...; Tags: chris.chetty@..., DAO, ID, ID Autonumber, Microsoft Access, software, SQL, text-file; Discussion threads 2005-06-24
Parameter Passing to Crystal Report: I am using Crystal report 10. I developed report with subreport. I used sql queries joined with union all having different selection criteria. I need to pass from & To Date as parameter to main report & same parameter to sub report also. But I am not using simple condition...; Tags: riteshkhare@...; Discussion threads 2007-04-09
Passing an parameter to a Query in access: I have a query in MS-Access which when run prompts for a parameter and then copies data from TableA to A Temp Table.As I need the Query to run more than once how do I pass a parameter once or how do I do this using code?ThanksBrianPassing ParametersThere are a...; Tags: bop_zw@..., database, msaccess, Passing Parameters, Query, software, Use ADO; Discussion threads 2005-07-11
How to use Access' conditional formatting feature with muliple controls: Recently, I learned that Access' conditional formatting feature handles multiple controls. For instance, you can use conditional formatting to highlight an entire row in a continuous form. To do so, simply select all the controls in the form's Detail section, choose Conditional Formatting from the Format menu, and then choose...; Tags: Microsoft Access, Form, Susan Harkins; Blog posts 2007-08-15
Excel - autoformatting number to formula: I have a file that is acting kinda funny. Maybe I am just an idiot. :)In a Microsoft Excel 2000 WS, I have a column that includes 16 digit numbers such as: 4366163039281060 exampple. Excel is automatically converting to 4.36616E+15 example. This is only after I convert to.csv file and...; Tags: Microsoft Office, Microsoft Excel, csv, cell; Q&A 2006-03-06
Sort nontabular data in Word with Table Sort: spellingThanks for the tip but next time check your spelling in your example, it'll lend more validity to your tip. Carole from TUCSON AZUsefulTipI've used Word for years but did not know a non-table list could be sorted. Thanks for this very useful tip. It indeed does work. PAEShouldn't...; Tags: cmcmullen@..., hardware, Microsoft Word, Sort, Table Sort, tip for the tip; Discussion threads 2005-08-10
SQL Joins,Subqueries. One Table.: First, I am NOT an sql expert or anywhere close to that. I'm attempting to put the work portions on the Database backend as there is less cpu throttling done there than on a cgi frontend, here's what I need to accomplish:Have a table with something like this for columns:uid,...; Tags: SQL, maillists@...; Discussion threads 2007-03-05
Forms and PHP Help! (Time restricted!!): Hey everyone, I've recently gotten into mac, and I use dreamweaver now, before I used MS FrontPage on Windows. In MSFP making a form is very simple, and has a "mailto" feature thats easy to get. However, here on dreamweaver MX, I need a script for this to work, so...; Tags: Scripting languages, ncsorcerer.kol@..., PHP; Discussion threads 2007-05-22
How do I... Identify and delete duplicates from SQL Server tables?: Duplicate records in a database are bad. You can't tolerate them. At the very least, they'll produce misleading analysis. At the worst, they'll totally wreck everything. Your application will probably run, but everything it generates will be suspect. You have to find them and delete them or your client might...; Tags: Microsoft SQL Server, Server, Column, Record, Table, Databases, Storage, Enterprise Software, Software, Data Management, Hardware, Susan Harkins; Blog posts 2008-06-03

<< Previous
page 1 of 1
Next >>

Troubleshooting A Failed Hard Drive Power Checklist: The hard drive is one of the most important components in a computer because this is where most of us store all our data. As a result, hard drive prob ...; Buy Now

Microsoft Outlook Basics: This ready-to-deliver presentation will help you introduce your team to Microsoft Outlook -- even if you don't consider yourself a public speaker. It ...; Buy Now