Summary: Hi, I have the following UNION query in MS Access: SELECT DISTINCT "DOM " & mDOMExceptions.ExceptionID as ExceptionID, mDOMExceptions.[Status], mDOMEx...
Summary: In my db i have a colummn fname where first names are stored. If the name contains a middle name, i wont see whats after the space. Example: fname ...
Summary: Hi everyone, After building a database for our growing company, we have a problem with our data and its synchronization. Our company has a rather s...
Summary: Hi, I am new here so hello to all. I have got a problem with my database and would like to transfer the data from my Access database onto DB2. I am ...
Summary: Hi, I'm designin sort of asset manager software and i'm already stuck with some SQL-querys... :) Tables don't have all the fields yet, because it's ju...
Summary: Dear all, I have a problem with sql function: I want to change Amount column to Words, senirio is like this: i have a 2 column, 1 has name and 2 has a...
Summary: I have a perplexing problem with a Access/Word merge. The Word main document is connected to an Access query. Once the connection was established, t...
Summary: Am retrieving a list of appointments (diary) and have a start time, duration and location, together with other fields. Where the location is the same ...
Summary: Thanks for the generous advices. I'd still like to see how far I could get with this though. It'll be good learning experience for me as well. I ran i...
Summary: I am trying to connect to a SQL database and it returns the following error when I want to connect SQL Server through the System DSN in Control Panel ...
Summary: I am executing a query from the VBA using the docmd.openquery command. The same query is also the record source for the form I want to use. When I cal...
Summary: I am trying to connect to a SQL database on windows 2000 advance server and it returns the following error when I want to connect SQL Server through t...
Summary: PROBLEM 1: ---------- i have 2 function that use paramaray as argument FUNCTION func1(Paramarray arg()) //some code here func2 arg //more code here en...
Summary: I have a problem with margins of reports in Access 2003.I have make an application in Access 2003 with a lot of reports.For all reports in OnOpen even...
Summary: I have a strange problem .I have a Access 2003 application with some reports.I print reports using vba code .When i print the reports on Laser printer...
Summary: Anthony, does this help you in some way by chance? Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Dim strList As String Set...
Summary: Mr Paramjit. You get the problem only when you are using a pirated version of Busywin. Please buy a original version of busywin , its not very expensi...
Summary: If the goal is to have all the data in one table, and your Customer Name is all one field (not recommended, but okay for now), make that the Primary K...
Summary: I have a couple of databases used to track data. (Eventually, they will be combined, but things move slow sometimes). It's a straight form/table conn...
Summary: In the database window you shyould see Tables, Queries, Forms etc. Click Queries -> "Create new query in Design View", add both of your tables (the ke...
Summary: Hi everybody, I would appreciate some hint to resolve a problem concerning some SQL code that runs without problem in a query design, however using th...
Summary: company web site: www.serenitylane.org [job is not posted at site] email resume, cover letter with salary requirements and any professional references...
Summary: Hello, I am new with Veritas NetBackup and we don't have support contract. This responsibility was dumped on me. My only question is this: We have 24...