what defferent between "reprt" and "query"   in MS-ACCESS   ?
550879
Queries:\nQueries are a fundamental means of accessing and displaying data from tables. Queries can access a single table or multiple tables. Examples of queries for our bank database might include: \n\nWhich Customers live in Georgia ? \nWhich Accounts have less than a $500 balance ? \n\n\nReports:\nReports are similar to queries in that they retrieve data from one or more tables and display the records. Unlike queries, however, reports add formatting to the output including fonts, colors, backgrounds and other features. Reports are often printed out on paper rather than just viewed on the screen. In this section, we cover how to create simple reports using the Report wizard.
701036
i beleive that this is a problem in MS word please go to tools and then options then select the edit tab there the first check box (typing repalces  selection) to be ticked.\n\ngood luck
294787
A database will work very well for what you need. MS Access is the only one I have personal experience with. I'm sure there are better apps out there. Create a query based on the cert expiration date and run it as needed.
904060
you are missing the semi-colon at the end of line 65.\n\nFWIIW you might like using the sprintf() command for inserting into the $query statement.\n\n$query =sprintf("Update name set INBOX = '%s', SUBJECT ='%s'  where SITENAME = '%s' ", \n$_POST['MESSAGE'],\n$_POST['SUBJECT'],\n$_GET['account']);
650047
What does "hit all of the control form fields and report the information back to SQL" mean? \n\nDo you mean, you want a button that will run a given stored procedure on the server, using parameters?\n\nDo you mean, you want to obtain the value of the form fields and use them to build a SQL statement that you then execute on the server?\n\nAlso, are you using SQL server, MySQL, SAP, whatever as a SQL database?\n\nUPDATE:\n\nYou still haven't told me what kind of DB server you are using, so I'll assume is SQL Server.\n\nYou don't need to create a VBA Script to do what you want. You can simply link the relevant SQL tables in your Access project file, then work with them as though they were tables in the Access DB itself.\n\nIn other words, you can build a form based on a linked table, just like you would build a form for a regular Access table; it will insert data for you into the linked table, the same way it would for a regular table.\n\nSee link below for more information.
868155
MS-Access is generally regarded as a backend tool (a tool for storage of data). You have to use some front end tool like VB with Access. In such a case you  have to write snippets that manipulate the data and return a result from the backend. Inturn this front end can be converted into an executable file.\n\nVB is just an example of front-end tool that can be used . You can also use ASP, PHP, CFML, Flash files as the front end.
527678
Both will work perfectly...\n\nIn case one, you make sure that INSERT INTO's are done right away, in case two, you let let the SQL server to decide when to do the actual insertion.\n\nIn case one, INSERTing the second record is not held before the first one finishes; that's the only difference.\n\nCASE 1:\nINSERT INTO: Handle the query and check what to do.\nCOMMIT: Insert (the actual disk action).\nINSERT INTO: Handle the query and check what to do.\nCOMMIT: Insert (the actual disk ...)\n... goes on like this.\n\nCASE 2:\nINSERT INTO: Handle the query and check what to do.\n#2: Handle the next query and check what to do\n#3: Handle ...\n...\nCOMMIT: Actually INSERT (do the disk operation).
747603
Depending on where you are (the main form or the subform) and what you need to access, there are several different ways of doing this.  Check out the forum archives at:\n\nhttp://www.access-programmers.co.uk/forums/archive/index.php/t-77746.html\n\nto see how to do this.  I grabbed the text and saved it on my hard drive so I could get to it later; this cheat sheet really helps!\n\nPS: This is a MS-Access question, not a VB 6 question.  MS-Access uses "VBA" (vb for applications), VB6 has a compiler and it's own form editor.
696438
I'm missing something from your question.\n\nYou can always test your query in query analyzer.\n\nYour query looks fine but my confusion is in your where clause - if xxx is coming from the textbox then it sounds like you might generate the following query:\n\nselect * from table where bob like '%@bob'.\n\nWhen you probably want the following:\nselect * from table where COLUMNNAME like '%bob'\n\nnote:  I removed the @ symbol from your sql statement.\n\nAlthough you're better off creating a stored procedure that accepts a parameter using the field value as the parameter.\n\nIf you have any questions feel free to send me an email.
470488
MS Access comes with some sample databases.  Other than that, you just have to look for some.
633256
I think your problem is more basic than this.\n\nYou define a variable named dt and are stuffing a date into it.  This is all well and good.\n\nBut in the next line, you're doing an SQL select.  In this line, dt is the name of a field in table [current$].  The two lines aren't related even though they have the same name.  \n\nIf you want the query to pull back data where the value in field dt is equal to the date 10/5/03, then you have to add a where clause to the SQL query:\n\n"Select dt as CloseDate from [current$] where dt=" & strDate\n\nNot sure which database you are using to select from, so the syntax may be slightly off, but you get the picture.  The thing here is that the SQL query is all text...even the date part.  The only exception to this is if you are running a stored procedure and some of the inputs are declared to be datetime data types.
25643
I've included some helpful links listing SQL commands.  Note that some may depend on what specific database you're using (Access, MySQL, PostgreSQL), so you should check the reference for that product.
1015496
Access has the "forms" but I forget how to use it.
377667
heres some code from a old ASP.NET application I found (the database connection string should be 1 line)\n\nDim Public DBS as String = "PROVIDER=Microsoft.Jet.OLEDB.\n4.0; DATA Source=c:&#92;DataBase.mdb"\n\n\n\nDim myconnection as oleDbConnection = new oleDbconnection(DBS)\nmyConnection.open()\nDim myCommand as oleDbCommand = New OleDbCommand("Select * from Threads", myConnection)\nDim myDataReader as oleDbDataReader = myCommand.ExecuteReader()
948329
It sounds like you are using a linked table that does not have a primary key. Without a primary key, I think Access looses track of which row is which, and gets this error. Even if you don't want to use a primary key, you could add a primary key column to the backend table (for example, with an auto-increment value) just for Access to use. Then you can leave that column out of your queries in Access.
331868
Can you post a copy of both bills so I can put them in Access and run a compare query on them?
300205
As the Definition says it is a SUBROUTINE (or a procedure) that is executed when the VB Form is Loaded........\n\n\nIn practice all the database connections and the Global Variables are defined in this Sub becuase this is where the processor do bulk of the processing of your application i.e. at the start.\n\nIt is used like\nPrivate Sub Form_Load ()\ndim DBConnection\ndim name AS String\n.\n.\n.\n.\n'Other executions\nEnd Sub