Search results for query: *

Hello all, I am a little unfamiliar with MS access reports,which is why I am struggling with what seems to be an extremely simple problem. I have a report header which must display a logo at the start of every report. My program prints out multiple reports at a time. The problme is the report...

Hi, just passed my SCJA exam yesterday and I found out today that there is no logo for this exam. That is unfair. Did anyone else get the logo?

Hi all, I have two tables residing on two different servers. I am trying to update table 1 with values from table 2 using a merge statement and I get this error. I am not sure what it means. Any help?

Hi all, Right now, I have this code in my VBA module. One of the columns in my tables is the name of the database. Public Function CurrDB() As String On Error Resume Next Dim dbs As Database Set dbs = CurrentDb CurrDB = dbs.Name End Function But instead of the name of the database, I need the...

Hi all, I have this statement. I am trying to update a column in a table using values for a column in another table. UPDATE a SET DIAG = (SELECT b.ID FROM b ,a WHERE b.ID = a.ID AND b.TYPE = 'c') WHERE a.ID = (SELECT a.ID FROM b,a WHERE...

Hi all, I have a form which contains a report that is based on a query. When I run the query itself, it works with no problem at all. But when I try to run the same query from the form, I get a message saying the expression is too complex to be evaluated........ I think the problem is with...

Hi all, I have been trying to set a default value in a text field in an access form, but something seems to be goin wrong and I am not sure what. Basically, I have a text field in a form whose value is passed as a parameter to a query, which generates results that are displayed in a report. I...

Hi all, I am not vey familiar with access, hence this question. I have a form which has a text box. Users are meant to input a value (character string) into this textbox. Based on what they input, this string needs to be passed to a query which will then generate a report. I am using the...

Hi all, I have some tables in an access database that I need to export into text files. When I export these tables, I also need the name of the database(not the table)to somehow be included, either as a seperate column or as a suffix to one of the columns or simply as a header etc... right...

Hi all, I have some external tables created in my schema in oracle. The data is loaded into these external tables from text files. I have many files to load data from. It looks like each time I use a select statement to load data into the external tables, the current data is overwritten..i.e...

Hi all, I am trying to declare a surrogate key for a table and I get an error saying invalid datatype. Here is what I am doing. I have created a sequence to generate numbers lets say SEQ. I am declaring the key as ID SEQ.nextval in the CREATE TABLE statement and it is giving me an error...

Hi all, I need to update a table such that the existing values in the column are still there and the new values are concatenated. I tried using the concat function but it is not accepting the column name as a value column_name = concat(column_name,'1') This gives an error saying column_name...

I have dates stored in this format Jan 1 2003 12:00:00:000AM Hi all I need to convert this into mm/dd/yyyy format so that I can compare with dates from another table. When I try using the following function TO_DATE(SUBSTR(DT,1,10),'MON DY YYYY') I get the following error...

I have dates stored in this format Jan 1 2003 12:00:00:000AM I need to convert this into mm/dd/yyyy format so that I can compare with dates from another table. When I try using the following function TO_DATE(SUBSTR(DT,1,10),'MON DY YYYY') I get the following error...

Hi all I have a column in ms access which is supposed to represent date/time. It is in this way feb 19 2003 12:00 am. mar 23 2001 12:00 am. It is stored a text field. I am trying to get the latest dates from this column , but by using the max(date) function I get the latest as march 23...

Hi all, I am trying to join a table (using equijoin) on two columns that are of two different data types..one is a text and the other is a little-endian data type. Can anyone tell me if there is any way I can do this join? I can re-create the table and change the text column to little endian...

Hi I have to test some delete statements on a table in test. Instead of having to restore the test server each time I run the delete statements, I am trying to back up the table before the DML statements and restore after the queries are run. I know there is a backup command in sql server i...

Hi all, I am going to take the 1z0-007 test next friday. I know the pass percentage for this test is 71%. My question is how many questions are there in this test? I have searched on Oracle website and did not find any info. Thanks for your replies.

Hi i have to delete records from a table. The criterion for deletion are specified in the parent table. here is a part of the stored proc that i have,but it does not work.I am wondering if there is another way of making this work. delete from (select g.* from shshrssurvey as...

hi all, I have to delete records from some tables in sql server. Can I use a UNION command to combine two delete statements? Both these delete commands query the same table. thanks for your help.