Search results

I have created a search form in my database. The form consists of a textbox and a button. I want the users to be able to enter a word in the textbox and click the button to search all the records in the database that have that word in a particular field. The problem that I am having is with...

I tried using that command, however, then that takes away the ability for them to open the link.

Although this is GREAT functionality, what I am looking for is for when you have an OLE object on a form to store a link to a file. Before, the user would just right-click on the mouse and it would bring up the Insert Object Dialog box...but it doesn't anymore. Now you have to select Insert...

I have a database that I completely redeveloped from scratch. On one form I have 4 OLE Objects so that people can attach links to files. In the old database, you just had to right-click and the insert object box came up...but that isn't working in the new one. I can't remember if it was...

Here is the SQL for the rowsource: SELECT Resource.ResourceID, Resource.ResourceName, Resource.ResourceStatus FROM Resource WHERE (((Resource.ResourceStatus)="A")) ORDER BY Resource.ResourceName; And here is the column info: Bound Column: 1 2 Columns (don't need to show the ResourceStatus...

The AutoExpand Property is currently set to Yes...but it isn't working. Also, I misspoke in my original message. If you type the name EXACTLY as it is in the dropdown, and hit enter, it does nothing. I can ONLY select from the list by clicking the arrow and srolling down until the value is...

I am redesigning an old database. There is a form that has an unbound combo box field that gets its values from a query. Basically, someone will choose a value from the combobox and a subform will display all records for that value. Here is my dilemma... In the old database, if I typed an N...

Thank you! I am assuming that splitting the database is what i would want to do. And just make sure that it is compacted regularly? Also, do you need to compact the front end, also?

I have a database that has had a lot of corruption errors lately (like 1 or 2 a week) and I've been told that splitting the database can help with this (even if it doesn't resolve it). Ultimately I am going to convert the backend to SQL, but don't have the access rights yet to do that. So in...

THANK YOU!! Although I don't really understand why the "Or" didn't work, since logically it should...that fixed it! Thanks again!!!

I have a dropdown box called Status on my form. I want to be able to limit what people can move an item to a specific status. In this case, I only want a PM or Developer to be able to move to the "Development" status. There are only 2 IDs to check for and if their ID comes up, it will let it...

I have a button on a form that creates an email and inserts fields from my database. I have a field that is set to Long Date format type, but when it populates the email, it shows as a Short Date format type. Is there anyway to retain the Long Date format?

I am trying to output my report to excel but keep getting an error. Here is my code: DoCmd.SendObject acSendReport, issrpt, acFormatXLS, "email@email.com", , , "Defect Report for " & brdtp & "-" & BRDNum, "Attached please find the issues/defect report.", True I have used the output format...

No, it is a text field. This can't be hopeless, right?? :o)

It is the name of the table. The name of the form is frmBranchAccount. I was trying both, but when I typed the reply below I got them mixed up. I tried forms!frmBranchAccount!Branch_Account and got an empty report when there are several open Loan Officer accounts that should have shown up in...

I put the following: forms!tblCredcoAcct![Branch Name] I didn't use Like because it should be exact as it is a pick list...not a free form text box and the value should be the same across tables. I even tried using the variable name for that field thinking that the value would still be store...

I can't believe it was just that i was missing quotes..how stupid of me! Anyway, it brought up the query results, but it didn't filter by the branch name on the original form. I get a blank report when i know for a fact that there are accounts for that branch that are active. i don't want to...

I created the query as you suggested and now I keep getting this error...now what am i doing wrong! The action or method requires a Query Name argument. I replaced the SQL code with this statement: DoCmd.OpenQuery OpenLOsforClosedBranch, acViewPreview, acReadOnly SORRY..I'm practically...

That is what i was originally trying to do, however, I don't know how to automatically put in the filter (i.e. by branch) I don't want someone to have to retype it.

I'm probably making this harder than it needs to be...i just want it to display a list with the results.