Microsoft Access

• Microsoft Access Questions

• • M`I,5.Persecutio n ` ha rassment at w ork

    -=-=-=-=-=-=-=-=-=-=-=-=-= harassment. at work -=-=-=-=-=-=-=-=-=-=-=-=-=Once I stopped watching tel...

    By evmemefie_bigfoot_com

  • data missing

    Can you advice my how to recover data from a tape. I made a backup withwinnt server now I have apdat...

    By uzaburahotheodoriclicpamo105

  • SQL command help

    I have two tables like so:Employee:Employee_ID Name01 Hansen, Ola02 Svendson, Tove03 Svendson, Steph...

    By john

  • External table isnt in the expected format.

    I have a access database with linked tables, when i try to link the tables to dbf files i receive th...

    By lacp

  • FAQ! for Date: 20030912 - New Users Look Here! [La...

    An HTML version of this document is available at:http://www.mvps.org/access/netiquette.htmFeeling le...

    By faqposter_cdma_invalid

• • sql command

    explain sql command...

    By stansoft, 1 Comments

  • SQL command help

    AnybodyI have two tables like so:Employee:Employee_ID Name-------------01 Hansen, Ola02 Sve...

    By john, 2 Comments

  • SQL compile error

    I have a text box on a form to display the last odometerentered for a specific truck based on the tr...

    By walter, 9 Comments

  • Data missing from Report

    When i enter data onto a form then click the button on the form to openup a report do dispaly the in...

    By simon, 2 Comments

  • data manipulation in excel from access

    Hello folks,I currently have a backend db table with data that I need to manipulate in excel because...

    By jovantovich, 3 Comments

• Microsoft Access: is the Category's subject.It's has 450 questions,this is No.23 pages.
• SQL Command help for Unique records.
• What is the syntax for an sql command to get the following.I want to pull in a handful of fields from a table but one of thefields needs to be unique.For example, if I have a customer table and I want to get each uniquecustomer number but I also want to get the customer's name, address,email ad...
• mscurto_gmail_com, Mon, 15 Feb 2010 02:29:00 GMT, 463 bytes, 10 Answer
• SQL Command in VBA
• I'm attempting to write a SQL statement in VBA to select specific recordsfrom a table but I'm not having much luck. What I need to do is select allrecords from Table 2 where Field 1 is equal to Field 1 in Table 1. I'vedefined a variable ("cl_ID") that I can set equal to Field 1 in Ta...
• johnw, Sat, 28 Mar 2009 01:27:00 GMT, 682 bytes, 4 Answer
• SQL command LIKE and ADO
• Hi,I ran into this odd problem when trying to make a query in Excel VBA with ADO. When using SQL clause:"SELECT * FROM Table" : everything works fine and records are found.But when using:"SELECT * FROM Table WHERE Name LIKE 'test*'" no records are found. The odd thing is when I copy t...
• jnyman, Tues, 19 Jan 2010 08:40:00 GMT, 533 bytes, 8 Answer
• sql command to compact access db is ?
• I have an access database on a remote web server and a program that will letme issue raw sql commands to it...Is there an sql command to 'compact' the data base?thanks for any help....
• tmb, Sat, 28 Mar 2009 02:09:00 GMT, 213 bytes, 4 Answer
• SQL Commands
• I do have the following problem:I would like to combine several commands in SQL with one command button onmy Form.a) Run an append query to append data to a tableb) Run another append query to append data to the SAME table as in a)c) Print a report which is based on that tabled) Run a delete que...
• amateur, Fri, 12 Mar 2010 12:39:00 GMT, 1,641 bytes, 3 Answer
• SQL Comparing Date Question
• hi again~I am having problem comparing dates using SQL.I have a table with a field called 'order_date'. The field is a 'date/time' data type and contains the date and time like '15/4/2004 0:09:48'. What I am trying to do is to display all the records that contains...
• yupapa, Thurs, 11 Feb 2010 12:04:00 GMT, 460 bytes, 1 Answer
• SQL comparison between two takes HELP Please
• Hail to all, I am in need of your assistance. I am needing to run a query to search for the 'DOC NBR' on an update table which changes daily and find the matching 'DOC NBR' on the primary table and then display 4 fields of the Update table if the 'STATUS' field o...
• mythos, Sat, 28 Mar 2009 03:29:00 GMT, 1,744 bytes, 3 Answer
• SQL compile error
• I have a text box on a form to display the last odometerentered for a specific truck based on the truck #selected. I created a set of queries to select theappropriate record. I pasted the SQL from the last queryinto the AfterUpdate event of the Truck # control to setthe Control Source of the tex...
• walter, Fri, 12 Feb 2010 04:33:00 GMT, 876 bytes, 9 Answer
• SQL compile error
• >--Original Message-->I have a text box on a form to display the last odometer>entered for a specific truck based on the truck #>selected. I created a set of queries to select the>appropriate record. I pasted the SQL from the lastquery>into the AfterUpdate event of the Truck #...
• walter, Sat, 06 Mar 2010 08:11:00 GMT, 1,407 bytes
• Sql Code Help for Access (urgent help needed)
• I want to add the code below to a query so that only accounts show upon a report that have a balance greater than the sumprincpmts field.This query will need to sum the Transactions before comparing to thesumprincpmts field. Below is the code that I have come up with but Iam getting a syntax err...
• sallen_gcamail_com, Fri, 27 Mar 2009 23:30:00 GMT, 600 bytes, 2 Answer
• SQL Code in Access
• Hi there,I have a question for someone who knows Access and SQL. Is it possible towrite SQL code and make it work in Access? I have the ability to write SQLbut I do not seem to be able to make it work in Access. Any Suggestions?apps...
• hbb, Thurs, 04 Mar 2010 12:52:00 GMT, 252 bytes, 5 Answer
• SQL code problem
• Hi Ken,when I try to insert the code you wrote below, with thefirst statement the compiler gives me the following errormessage:"Too few parameters. Expected 2"And when I insert the second statement you wrote it givesme the following error message:"Too few parameters. Expected 1"Why is happen thi...
• guest, Fri, 27 Mar 2009 23:44:00 GMT, 1,946 bytes, 2 Answer
• SQL Code that is submitted to server changes when run on different clients
• I have an application that works fine when I run it on my own client,but when it is run on a different client the SQL code that is generatedis different... Let me explain...I have an access ADP that in one of the reports, it uses a User-definedfunction(UDF) as its recordsource. By watching it ru...
• dale, Fri, 27 Mar 2009 23:49:00 GMT, 1,121 bytes
• SQL Code to Set Desired Relationship
• Hello all! First thank you to everyone in this community that has been helping me over the past few days. It's greatly appreciated and I've learned a lot. At the moment I'm trying to write some SQL code to set up the proper relationship between a created table and an existing table. The exist...
• rewalk, Sun, 13 Dec 2009 21:33:00 GMT, 5,833 bytes, 7 Answer
• Sql code wont pick up form
• Hi guysCan anyone tell me what is wrong with the following code:What I am trying to do is run a pass through query base don the criteria within the form. As im running the code the query is runnning the criteria as zero and updating the form.Rather than vice versa. i cannot see where I am going...
• siddy1978, Tues, 09 Mar 2010 03:44:00 GMT, 1,279 bytes, 2 Answer
• SQL Command
• How do you total up figures within a column,Using SQL command?I need the syntax...
• wantula, Sat, 28 Mar 2009 00:45:00 GMT, 87 bytes, 2 Answer
• sql command
• explain sql command...
• stansoft, Fri, 12 Feb 2010 08:37:00 GMT, 27 bytes, 1 Answer
• SQL command help
• I have two tables like so:Employee:Employee_ID Name01 Hansen, Ola02 Svendson, Tove03 Svendson, Stephen04 Pettersen, KariOrders:Prod_ID Product Employee_ID234 Printer 01657 Table 03865 Chair 03I want to create an SQL statement that will return the following resultName ProductListHansen, Ola Print...
• john, Wed, 10 Feb 2010 13:05:00 GMT, 541 bytes
• SQL command help
• AnybodyI have two tables like so:Employee:Employee_ID Name-01 Hansen, Ola02 Svendson, Tove03 Svendson, Stephen04 Pettersen, KariOrders:Prod_ID Product Employee_ID-234 Printer 01657 Table 03865 Chair 03I want to create an SQL stateme...
• john, Fri, 12 Feb 2010 07:00:00 GMT, 661 bytes, 2 Answer
• SQL Case Statement for a report
• Is it possible within Access 2003 to use a Case statement in the query sql that returns info for a report. I mostly work with a Sybase database system which allows such commands. Can't find any references as to whether this is legal in Access. If so, could you possibly include a sample of its u...
• atrottier, Fri, 12 Feb 2010 20:43:00 GMT, 378 bytes, 6 Answer
• 1234567891011»»»