Recent content by jdp103

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...