Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- MS Access
- I would like to updete fields in existing Access table. I would like to add fields in that tableHmmUpdate as in change the data, from access, open the table and type, From SQlUpdate MyTable Set MyField1 = 'Value',MyField2 = 123.8 Where MyKey = 1To change the structure of a tableFrom...
- Tags: ashishab@..., vb, access database, software, Microsoft Corp., Microsoft Access
- Discussion threads 2006-08-28
- How do i retrieve a record from a database randomly?
- Hi, I am developing a test ingine to run online testing software and i have one problem, i just cant seem to load the questions randomly from the database so that the exams dont look similar everytime they are loaded. can someone please help?IS IIS?IF SO - write a vfp...
- Tags: database, hoxt@..., networking
- Discussion threads 2004-10-12
- Access 2000 Delete Select Record
- I have a table where a field is Text format.The values in the field can be numbers and text.How would I delete only records that have a text value.Thanks for the solution, it helped me a great deal....This question was closed by the authorThat's going to be a pain.instr (http://www.techonthenet.com/access/functions/string/instr.php)might...
- Tags: DELETE, Access 2000, devmann, software, Microsoft Access
- Q&A 2006-04-27
- How can I truncate data in a MS Access Field?
- Using Google, I found the following update query posted by Tony Hopkinson in Mar 2005:update mytable set ssn = right$(ssn,4)I tried this and it works for all MS Access databases that I have except for one. In that database, I get the following error when I run the query:Compile...
- Tags: Databases, Storage, joe.a.grabman@..., database, Microsoft Access, Microsoft Corp.
- Discussion threads 2007-04-16
- Access criterias
- I have a database of information and i want to create a query to choose all information except for a particular person, how do I structure that criterion?Like thisSelect * From MyTable Where MyColumn 'Fred'
- Tags: Databases, urbnlgnd, Microsoft Access
- Discussion threads 2007-09-19
- MS Access 2000 Leading zeros
- Is there a way of adding and storing leading zeros to a number in a table field without them being entered?ie; 7001 to be stored as 007001 and35035 stored as 035035Sort ofYou'll need to make the column a char type if you want to store it, or you could just...
- Tags: jonb@..., Microsoft Corp., VARCHAR, Microsoft Access
- Discussion threads 2007-09-14
- Unable to insert a data in the table created in SQL Server.
- I am not able to insert a single data in the specific field, tell me what I have to do.Do you mean this ?Insert MyTableMyColumn Values('SomeData')
- Tags: pranav_software@..., Microsoft SQL Server, server
- Discussion threads 2007-10-31
- Reformat Column in Access
- Need to reformat column with data in it and truncate the first characters of data. Have an access database XPwith SSN column. Formated as such 111-11-2222. How can I write query, sqlview query to drop the 111-11- and keep the last four....for over 46,000...
- Tags: Microsoft Access, smallard@..., software, Technical, Wrong Forum
- Discussion threads 2005-03-18
- list all theColumn name of a table
- hi,i am using oracle 10g express to develop the applicton.i am looking the answer for retrieving all the column name of a particular table in oracle.Two waysOn the application side.Select * from mytable where 1 = 0then iterate through through the columns in the result.Meta data wiseselect c.name from syscolumns...
- Tags: valli1983@...
- Discussion threads 2007-03-22
- DateAdd function
- preparing a smallish but vital database from scratch - and that's my knowledge as well as the database! someone is likely going to tell me this is blindingly obvious but I'm wading through Access 97 Help to no avail. anyone who can help, please read on...I have a form where...
- Tags: Programming languages, Databases, Microsoft Office, midniteone, SQL
- Discussion threads 2007-03-30
- sql function
- how to use exec statement in udf function to excute a variable which given as select statementDo you meanDeclare @MyQuery VarChar(500)Select @MyQuery = "Select * From MyTable"Execute (@MyQuery)You have to put the parentheses in.
- Tags: software, SQL, thiyagarajan.srinivasan@...
- Discussion threads 2007-01-02
- how to make search Applications
- hello all i just want to know how can i make search Applications with Microsoft Visual Basic 6.0 like MUM + search button = MUM THANXNot sure I get what you meanSearch what?, a database?Select From MyTable Where MyTextField Like "MUM%"would give all entries starting with MUM
- Tags: denatra77@...
- Discussion threads 2007-03-04
- Update doesn't update
- when I try to run windows update I get all the way to the point where it checks for my version of the download manager, after initially upgrading it, it gets stuck.The automatic update doesn't seem to be working either.Any bright ideas?Try again laterI find the 'try again later' options...
- Tags: Microsoft Windows
- Discussion threads 2004-11-15
- Weird XP WI_FI probs on my laptop
- How can I check my update status for the last 90 days if the wi-fi isn't working!!More information pleaseCan you give me / everyone some more information on what your are trying to do or find out please ?What do you mean by update status ?Windows update ? Microsoft Update...
- Tags: hardware, jhlamothe@..., laptop computer, Microsoft Windows XP, windows
- Discussion threads 2007-01-28
- Security Update Keeps Reinstalling
- Cummulative Security Update for IE (KB867282) keeps acting like it is reinstalling and gets listed repeatedly in the "View Installed Updates" listing. Any idea how to fix this?run windows update and choose the custom install. In there you can check the box for hide this update. Windows update doesn't...
- Tags: CLT-IT_Tech, security, windows
- Q&A 2005-03-07
- Windows Security Update installs Over & Over
- My windows 2K automatic update keeps installing the same update over and over again. I've check the knowledege base but it gives a reason but not a solution. How do I get the SUS to reconize the install has bee made? When I look at the istall history it shows...
- Tags: Microsoft Windows, rbrowning@..., security, Windows Security Update
- Discussion threads 2006-10-26
- XP automatic updates - failure to update
- Since a recent reinstallation of XP SP2 whilst automatic updates have downloaded when I click the shield and initialisation commences I then get a report that the following have failed to be updated.Security Update for Windows XP (KB928843)Security Update for Windows XP (KB890859)Security Update for Windows XP (KB914389)Security Update for...
- Tags: Operating systems, jensham@..., Microsoft Windows XP, Microsoft Windows, security
- Discussion threads 2007-09-28
- Please help!!!Query
- I have a simple Access 2000 database that has a table.this table has gross salary field.i want to calculate income tax from this field based on criteria.because income tax as you all know varies with income please help!!!Try this, case statementSelect Income,Case When [income] < 20000 Then [Income] *...
- Tags: alexeye2006@..., income
- Discussion threads 2007-02-05
- << Previous
- page 1 of 1
- Next >>
