Anyone familiar with using an NT file structure as a data source in Access? I am trying to store information in an Access table and query it. For example, a particular server has a particular folder with 45 files. I need to see the folder name and each file with the file name, size, last...
Is it possible to use the DLookup function in a report with more than one criteria? For example, DLookup("[Amount]", "tblSales", "[Year]= 2002 AND [SaleCD]=1"
I keep getting error messages. Thanks!
Does anyone know of a way to do summations on data in a crosstab query that contains null values? For example, Here is the dataset of the crosstab query:
item 2002 2003 2004
1 56 56 56
2 48 49
3 674 828 916
4 12 5
5 51
When I refer to this query in a report and attempt to do a sum...
I need to create a message box in VB that uses options other than YesNoCancel. For instance, when a user clicks a button, a message box appears that prompts for one of two options, say "Add Item" or "Delete Item". Is there an easy way to change the text on the vbYesNo...
Anyone know of or have some code to automatically launch an ODBC login upon startup of an Access database? I have a couple of Oracle tables linked and the login process prompts only when these tables are accessed. I need to add this to the startup of the database. Thanks!
When using the Append Query tool in Brio 6.5, how can you utilize 2 different queries containing different tables to Union? My problem is that I can't figure out how to "build" the second query. Any changes I make in the second query show up in the first, like adding and deleting...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.