Recent content by Tango524

Yeah- It baffles me too! My result set is embedded in my table tags. It is like this below. <%=rs.getString(&quot;Field1&quot;)%> Thank you for your support. Oh- and yes, my variables passes and everything works if my sql query only uses one table in the WHERE statement like this...

Yes- I can perform this in Access sucessfully and I can perform the sql query in jsp using one table, but I have a problem when I try to join two tables to use data from both tables. There is no error. It just shows a blank screen on the browser and is done running. Thanks!

Hi- When I try to use a standard sql query SELECT FROM WHERE in my jsp code, I can pull data, but when I try to use a join in my code, there is a problem. I've used both the ansi join and the MS join in my code. My code has looked something like this... SELECT Table1.Field1 FROM Table1 JOIN...

Sure! Thanks in advance for all your help! These statements follow the statements above. Statement s = con.createStatement(); s.executeUpdate(&quot;create table myForm (date varchar(20), name varchar(50);&quot;); s.executeUpdate(&quot;insert into myForm values('2/2/02','John Doe');&quot;)...

Hi All- I am trying to create a table and insert values into an Access database with Java. My java program will compile, but I receive this error when I try to run the program: ERROR: java.sql.SQLException:[ODBC Microsoft Access Driver] Syntax Error in field definition I am not sure if I am...

Hi guys! I am having trouble with the lines below- particularly the getString and SQL statement. It gives me error 68- whatever that means. Any clues as to what is wrong? Thanks! function onLoad() { con = DBDriver.getConnection(&quot;alias:hrbid&quot;); stmt =...

Hi guys! I am having trouble with the lines below- particularly the getString and SQL statement. It gives me error 68- whatever that means. Any clues as to what is wrong? Thanks! function onLoad() { con = DBDriver.getConnection(&quot;alias:hrbid&quot;); stmt =...

I set up permissions to users for forms, tables, etc, and I also have a password to my access database. The users that have these permissions can get into the database and update, add, or delete data in the forms and it will of course save to the tables. A person who did not have permissions...

Yes- but I just unset the password in the Archive database and everything worked out ok. Thanks for your help!

Oh- actually I got it. Thank you so much!

Thanks for the info. When I create my append query, I am appending some records in one database to another in a different directory. Both are password protected and I get an error msg, &quot;not a valid password&quot;, when I tried to run my query. My password is a five character 3 digit...

Cool! Is there a way to select thousands of records at a time and mark them inactive all at the same time? Thanks for your help!

This gives me a &quot;Data Type Mismatch in Criteria Expression&quot; error. I don't want to use Date Entered just to get one week's worth of data because I want the query to give me average productivity for ALL weeks included in my data tables. I guess I want the query to sort my dates by...

I am sorry if I confused you. I think I confused myself. I meant the control source on the subform should be pointing back to the main form. I am not sure what your filter is for the records coming down to the sub form from the main form, but you can do calculations in the control source...

This is a beginner's question, but is there a way to have two databases, archive and live, and any transactions added in the live will go directly to archive. However, when transactions are deleted in live, they will NOT be deleted in archive. Any help would be greatly appreciated. Thanks!