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
- 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
- sql select comand in VB
- In minr project i use that query it is workinf fine. "select * from attend where eid=" & CLng(eid.Text)but i can not wirte a query for two fields. i try tyo write that"select * from attend where eid= and field2=" & CLng(eid.Text) and clng(1)but i get a error data missmatch....
- Tags: Programming languages, Microsoft Visual Basic, SQL, sajjad81@..., eid.Text, CLng
- Discussion threads 2007-04-09
- 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
- 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
- sql select comand in VB
- In minr project i use that query it is workinf fine. "select * from attend where eid=" & CLng(eid.Text)but i can not wirte a query for two fields. i try tyo write that"select * from attend where eid= and field2=" & CLng(eid.Text) and clng(1)but i get a error data missmatch....
- Tags: Programming languages, sajjad81@..., eid.Text, CLng, Microsoft Visual Basic, SQL
- Discussion threads 2007-04-09
- 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
- 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
- Select (claculated field) Where (calculated field) >= t1.field2
- Hi,I am having difficulty with an SQL query in Access.I have 3 tables 2 with quantity value's and one with minimum qty value.I want to calculate the sum of records from t1 and t2 grouped by their "item nr"SELECT t1.val1-t2.val1 AS val3Then I want to only display the val3 records...
- Tags: Network technology, Databases, shilyn@...
- Discussion threads 2007-08-06
- 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
- Creating XML from MySQL is as easy as PI
- It's easy to integrate MySQL data into an XML file, but importing XML into MySQL is a bit trickier. Learn how to export and import XML with the popular database MySQL.MySQL is a popular choice among databases, especially for Webcentric data. Now there’s another reason to love this database—it makes...
- Tags: Databases, Storage, OPEN SOURCE, Shelley Doll, XML, MySQL, database
- Technical articles 2002-06-17
- Let Access choose your data type format
- Sometimes it is hard to tell which data type format to select for an Access field. For example, if your field's data type is Number, should you select General, Percent, or Integer? Also, which field size should you use? Rather than guess, let Access decide for you by creating your...
- Tags: Microsoft Office, Mary Ann Richardson, Microsoft Access, data type
- Blog posts 2007-08-07
- create select query with diff. mdb files
- i created two ms access database to hold my data.how can i create a select query that will include the table from the other database?can someone please help me..............?any strategies/techniques/ideas will sure be of help.thanks.You need two Queries. One with Select command for one table, other with select command for...
- Tags: Storage, Databases, database
- Q&A 2006-01-06
- 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
- Get a handle on errors in SQL Server stored procedures
- Error handling in SQL Server stored procedures is not difficult, but it may be different from what you're used to. Pick up the basics and a general strategy in this article.The idea of "error handling" in a SQL Server stored procedure is something of a misnomer—in most cases, your only...
- Tags: Databases, Lamont Adams, Print @@ERROR, Microsoft SQL Server, server
- Technical articles 2002-07-19
- << Previous
- page 1 of 1
- Next >>
