Search results for query: *

Thanks Lightning, I redid the form from scratch (ExpirationDate wasn't a member) and now it works like a charm! I really appreciate your help. And thanks to willir for your input, too. sweetp

Thanks for the reminder on the Date name. I knew that. Don't know what I was thinking. Anyway, I've changed it to EntryDate. But when I substituted YourFieldToUpdate with my field name which is ExpirationDate, it gave me an error "Compile Error - Method or Data Not Found". So what am I...

Dear Lightning, I am also having the same problem as JustforLoving. I tried your suggestion, but my expression: =DateAdd("y",+[Days_Due_To_Expire],[Date]) works in ControlSource, but not when I moved it to DefaultValue. If I change [Days_Due_To_Expire] to a number (I just type a number in...

I have: =DateAdd("y",+[Days_Due_To_Expire],[Date]) in my Control Source of a form and it adds the two controls together fine and shows it on the form. But to get it to insert into the database, I need to move the expression to Default Value and bind the Control Source to the database field...

Hmmm...posting my connection file. Do you mean the parts in my Dreaweaver code that refer to the connection such as: <%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %> <%@ include file="../Connections/conConfRoomSchedule.jsp" %> which is...

lebisol, Are you saying that the only way I can run 2 different DB's without conflicts is to use the userid & password portion? I'll look at it, but I don't understand why that would be required. Right now we don't log in at all (they just click the link in our Intranet, and can start using...

lebisol, Thanks for your reply. I'm still trying to piece together the possibilities. FYI, I'm using NT and Access 2000. I do have a driver timeout for the ODBC bridge-driver set to 5000 (according to a tech note telling me to do so). General permissions for the DB's are set to...

I'm using Dreamweaver, so it writes my code for me. Any suggestions?

OK, so how do I fix it? What do I need to do and where do I need to do it? I'm still pretty new at this. Thanks!

I'm not sure what you mean by "committing". Database A only contains queries (office staff bios), so the database never changes. But after someone goes into it and looks at a bio of a staff member, then closes it, and then someone (anybody) opens Database B (conference room scheduling with...

I have 2 database connections on my server (using jsp and iPlanet with Dreamweaver). Everything is fine if users only use one of the programs (it never locks up), but if I make both available, after someone uses one, then the next time a person goes into the other jsp program, it hangs. I have...

I have 2 database connections on my server (using jsp and iPlanet). Everything is fine if users only use one of the programs (it never locks up), but if I make both available, after someone uses one, then the next time a person goes into the other jsp program, it hangs. I have the...

I can't get Dynamic List/Menu to work. I'm using JSP and MX. I am using Dreamweaver's Server Behavior which generates the code below (for a dynamic list of Personnel) but it always fails and I get a "Data Not Found" error on my server. Anybody know what's wrong? This is just Dreamweaver...

scriverb, Thanks for your help. I appreciate any and all I get! And I'm sure it won't be long until I'm looking for more help on something else. Thanks again.

I get "wrong number of arguments used" error message. The cDate code above worked, though. Any reason that I shouldn't use that? thanks!

Hey it does work! I originally put the code in the Acces query instead of including it in my Dreamweaver recordset. It works! This is great! THANK YOU SO MUCH, Golom!!!!!!!!! :-)

It still goes in the order of the numbers instead of putting am before pm. Example: 04:15 p.m. 05:50 p.m. 09:00 a.m. 12:00 p.m. FYI, I'm using jsp/dreamweaver for the search and results pages to connect to the Access database. Thanks for any more help!

Well, I can't figure out how to apply it (I'm pretty new at this), so here's my code in my Query (before I tried to do anything). SELECT Conference_Room_Schedule.ConfRoomSchedID, Conference_Room_Schedule.ConfRoomID, Conference_Room_Schedule.SchedDate...

I'll try this and see what happens. Thanks again!

The info is originally entered with an applet where you click and drag to choose the time and it enters in into a textfield (input=text), but how can it be a textfield if I can format it in Access to show time? Anyway, is there a way to format the way I want, given this situation? Thanks so...