Search results for query: *

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!

The only thing is that all my dates are daily entries (even many per day). The report was the only way I knew how to group it by week. If there is a way in the Query, could you go into detail of how to get the week grouping? Thanks a bunch!

Is there anyway to download a field in a report to excel? I have average calcs by week in my report that I can't get from a query or a table download. Any thoughts would be great! Thanks!

Do you have the control source of the mainform in properties pointed to the sub-form?

Is there a way with Dlookup to check the entire record? For example, it is okay to have duplicate values of EID and duplicate values of TID separately, but it is not okay to have duplicate values of EID and TID together. I am checking the duplicate values by seeing if dlookup returns null...

I set the required property to true in my table- thanks!