I have two very similar search forms that show the results in a subform. I have one that works fine, but the other one will not requery. It is not necessary for the form to be linked to the subform, but I think that that has something to do with the problem. Here is the code for both...
thanks VBA jock,
I did something similar that seems to work: the main form did not need a record source, since it was input only, but I added the table that it was searching as a source, and then it recognized the requery. It seems to be working now.
Thanks for the reply!
Brian
I have a search form with a couple of different criteria that has a subform that displays the results. I have had no problems using strSQL to change the query based on the user input, but I cannot get the subform to requery or refresh from the cmdButton_click
subroutine:
Dim strSQL As String...
Hello,
I'm not sure if this is possible or not. . .
I am calling text in a <p> tag dynamically from a database, and I want to use a js function to change the text based on a flash navigation bar. The problem that I am running into is that I do not want to reload the page, just to change the...
Thanks for the quick response. I have tried escape, and it still is referencing the entire path:
var location1 = document.loc1.src
document.location.href = "update.cfm?location1=" + location1
Any ideas?
Thanks!
Hello,
I am trying to build an admin page that allows the admin to change out images on their web site. I think that my problem is simple, but I still cannot find the answer.
I am setting the variable = document.image.src, but when I pass the variable via mypage.htm?variable=value, I end up...
Hello,
I am now developing CFM pages using DWMX, but my web Host is only current to 5.0: do I need to find a new host, or will MX developed cfm pages work on 5.0?
Sorry for the basic question.
Thanks!
Brian
Hello,
I have set up and started both IIS and the Coldfusion RDS servers, and configured the IIS per Macromedia live docs. In addition, I've been able to establish ODBC connections using the CFServer Admin, but everytime I try to access a datasource in CFStudio, I select the localhost server and...
Hello,
I know this is probably pretty basic, but I can't find the answer to this:
I have installed IIS5 onto XP pro, but I can't get the localhost or 127.0.0.1 to come up on the browser. I've gone into the mmc, and checked the website folder where I get a message that I was unable to connect to...
I am trying to add a new Expense to my Expense table using an unbound form:
INSERT INTO Expenses ( ProjectID, Employee, [Expense Type], [Total Expense], [Date Purchased], [Date Submitted], [Payment Method], [Purpose of Expense] )
SELECT Projects.ProjectID, Forms![New Expense]!Combo2 AS...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.