Hi All,
I have been racking my brain for sometime in trying to resolve this and now I am just wiped out.
MS-Access 2003
I have a main form that contains several selection options (combo boxes). This main form is opened with an argument from another form and this main form is bound to a table.
The main form has a subform that is bound to query that contains a set of records based off the opening...
gblack301
Last Activity: Nov 12 '09, 02:04 PM
Joined: Mar 17 '07
Location: bowie,md
-
Thanks, I will try to incorporate that into my where clause. I am just a little stuck on the part. Do you know of references that can get me on the right track? thanks
Greg -
Hi Dr B,
thanks for responding but I'm getting the following error when selecting two options. Any help would be appreciated it. Thanks
Database Results Error
Description: Syntax error (missing operator) in query expression '(Firms.FirmCer tificationNumbe r = Supervisors.Fir mCertificationN umber) AND (Firms.Chapter = Chapters.ID)AND (Firms.FirmStat us = 'CERTIFIED') AND (Firms.Air = True Firms.Hydronics = True)'.
Number:...Leave a comment:
-
Multiple selection form
Hi,
I have a search form where the user can check a box or enter some data such as a name to quey the database. I was wondering what is the best way to enable the ability for a user data in more than one field or check muliple boxes to query the database. What I want to do is create a multiple search criteria data string. Below is the code that working with a the moment. Any input would be appreciate. Thanks
Greg
... -
Hi guys,
Thanks for all of your input and suggestions. It just one those things. I have actually adding the http:// in front of it and the results was the same but thanks again.
Greg...Leave a comment:
-
Sorry about that. Please see below.
...Code:<tr> <td width="60" style="padding:2; border-style:solid; border-width:1; " bgcolor=#DFFCA9 height="24"> <font class="style6"> <a target="_blank" href="Detail.asp?ID=3315">Complete Commissioning, Inc.</a></font></td> <td height="24"Leave a comment:
-
Hi Jared,
Thanks for the response, I have placed the 'target =_blank' into the my response.write statement and get the same results. The field is diplayed as www.website.com in my asp form but the hyperlink is targeting to www.organizatio n.com/search/www.website.com . For some reason the link is be added to the root of the search directory page. The acutally field in the database is called website which stores the URL. I'm not sure is this...Leave a comment:
-
URLs in Microsoft Access Databse
Hi,
I have a Access database which stores organizations' webistes. When my asp form displays the website column it adds the search directory website instead displaying the website itself. I'm not sure if this makes sense but here is a example:
When click ,I want the page to go www.website.com. Right now is going to something like www.organization.com/search/www.website.com.
Here's me code:
...Code:<%
Last edited by jhardman; Sep 19 '08, 05:42 AM. Reason: put code in code tags. please note button marked # -
I really appreciate all of the help. I opened the database and used the F11 option(s) and it worked. Once again, thank you very much!
Kindest Regards,
GregLeave a comment:
-
Hey JS,
Thanks for quick response, I actually tried holding down the shift-key before and opening the database but it didn't work.
Is there any other method to disable this custom toolbar? Thanks again for any input.
Kindest Regards,
Greg...Leave a comment:
-
Disable a Custom Menu/Toolbar
Hi,
I have inherited a database that I am working with in Access 2003 but the client is utlizing/working with same database in Access 2007. My predecessor built this database using a custom menu/toolbar preventing any access to the form design toolbar. Is there any clear-cut method to bypass this menu and open the database with the standard menu and toolbars?
In addition, I have not found any admin module/version for this database... -
Thanks, I appreciate the help.
Greg...Leave a comment:
-
One more questions, I've installed the new update and getting the same results. Is there anything else that I may need to look out for? Also, below are the some of the parameters from my combo box.
The three text boxes that are being populated are: txtFirstName, txtLastName and txtAddress. Thanks in advance for any help.
Greg
...Code:name: cboStudentID control source: StudentID
Leave a comment:
-
First thanks for the response; yes, I have included all of the fields in the combo box setup and I am using ACC2003. Sorry about that, I should have included that in the original post. I will install the new update and see what happens. Thanks again.
Greg...Leave a comment:
-
Another combo box question
Hello all,
I have reviewed some of the other posts regarding combo boxes and populating the form from the combo box but I am still experiencing an issue with one that I created for a project.
The issue:
I have setup a table called students, studentID is the key, when I select the studentID in the combo box only three of the text boxes are being populated. My code is below; any suggestions would be appreciated.
... -
Mary,
Thanks, I appreciate the info.
Greg...Leave a comment:
-
User activity report - Access 2003 (Newbie)
Hello Everyone,
I have been researching and researching for a method to generate a report for security/auditing purposes to track any changes (i.e. creations, deletions or modifications) to the database on a user level. I have setup the database security by using the user-level wizard. If anyone could point me in the right direction on how to accomplish this task, I would appreciate it greatly. Please let me know if I need to provide additional...
No activity results to display
Leave a comment: