Search results for query: *

Hello- I have an acreage field that has decimals and some with null values. How can i create a search between a value and value without it displaying incorrectly? For example i do a search between .5 acres and 1 acres I dont want 10 acres showing up as well as it does now. So I have this now...

Hello- I want to have a drop down that shows the cities in a listing database and the # of listings for that city in parenthesis next to it. So it would show "New York (5,000)" etc... I have a table called Listings to pull from with a column named city. So how can I do that?

Hello- I had posted something like this prior. However the iteration for each field to be highlighted wont work as in the code it only highlights the first field that was required. How can I put each element into a variable and have the form highlight all of the fields that were required at...

Hello- What can I add to this to tell the script to highlight the input box in a different color? So it will alert them and change the color of the input box to red if not filled out? if (theForm.pr_ny_estimate.value.length < 1) { alert("Please enter at least 1 characters in the...

Hello- I have an owners table where they have a list of 3 different companies in 3 columns (cnumber, cnumber2, cnumber3). I want my query to search on all 3 columns to find the match for the company they logged in under. How can I do this? So example would be: Select * from owners where...

I have 6 fields for company ownership. They are decimal fields since an owner can have a fractional ownership of a company. However all 6 fields need to add up to 100 if they dont i need to alert them with my validate script. I have included some alert script i am using already so you can see...

Hello- I keep getting an error on the and statement below any ideas? I'm checking one field to see if its been checked yes, if so than the second field auto_count needs filled in. function DoCustomValidation() { var frm = document.forms["myform"]; if(frm.own_auto.value == "Y") &&...

Hello- How could I use a query such as the following but check to see if the record exists before running it? Such as Cal_User_ID = tblPersonnelID is Null or? Update Cal_User SET Cal_User.Cal_User_UserName = tblPersonnel.Username and Cal_User.Cal_User_Password = tblPersonnel.Password FROM...

Hello- I have a tab delimited text file users will download and by pushing the import list button will get a Browse function which allows them to find the location of that text file. However, I'm not sure how to take the text file and then import it into my database. I have column headers on...

Hello- I am using dbPix for a batch download process. I want to include the filename itself in the tbatchload table when I import. However I cant seem to get it to work. I can get the Auto ID and OLE Object(Image) but cant seem to input the filename. Is there simple way to do this? My Table is...

I have the following Replace Function Replace(TotalSqft, '.00', '') How do I add another check within the replace function? I want to check and replace anything with .00 and .50. Can I use wildcards? Thanks for the help