Search results

Sorry, forgot link to MSXML: http://msdn.microsoft.com/en-us/library/aa468547.aspx

It's pretty easy to create an xml document - barebones you can just do it yourself as plain text. It comes down to the details - possibly your data can be saved as xml, or you can transform it to xml. XML is a bit confusing at first though, but once you know the basics you can stumble about...

Welcome back. Access 2007 is a great program. So is 2010 but I'm not ready to rely on it - waiting for SP 2 on that one. They have introduced a lot of new features - great time to be re-learning.

In Access, text must go inside quotes (double quotes or single quotes), dates inside hashes, and otherwise I guess you are fine. Though in VBA string literal text must also go inside double quotes - so that can be confusing at first. StrSQL = "INSERT INTO tblInvoice " & _ "(Book_Ref...

No problem. The basic bracketing structure with multiple joins is like this: Select w,x,y,z FROM (((Table1 Inner Join Table2 ON a = b) Inner Join Table3 ON a = c) Inner Join Table4 ON a = d) Most databases don't need this but Access is "picky" (at least in my experience, thus far). I...

If you group by these fields you will probably get more than one row because the grouping levels are fairly narrow. loc, cus_name, sls_amt, terr, search_name, price To get a fewer rows, by customer, you will probably have to sum sls_amt, and possibly not use the other categories such as...

UPDATE Table1 INNER JOIN Table2 ON Table1.KeyField = Table2.KeyField SET Table1.Field1 = 'a', Table1.Field2 = 'b', Table1.Field3 = 'c', Table1.Field4 = 'd', Table1.Field5 = 'e' ;

Try: SELECT name.longname, a.SystemID, a.PDModifiedby, a.PD FROM (([Copy of Table] AS a LEFT JOIN [current log] AS log ON a.systemid=log.systemid) LEFT JOIN (SELECT A2.customerID, LongName FROM [Copy Of Table] AS A2, GeneralInfo AS info WHERE A2.CustomerID=Info.CustomerID) AS name ON...

Using Access' built in filter by form feature is better than fiddling with textboxes etc. If you must re-invent the wheel, I guess the following could work: 1) Use VBA to write a proper filter string 2) Set the form's filter 3) Apply the filter This depends on the user knowing how to create a...

I wouldn't worry overmuch about whatever you see under "object dependencies" - that tool is pretty much useless (if someone knows otherwise, let's hear it). And when it comes to searching external sql server databases who knows if it even works. Why not analyze the database on the SQL server...

You can get to the trust center through Access options. Not sure if you are using Access 2007 or 2010 - in Access 2007 it's under the office button, and Access 2010 under the file tab. Not database-specific. As long as you add the location to your trust center databases in that location will...