Search results

Hi, I have a form-based search. The code is as follows: Private Sub Command7_Click() If Len(cbosearchfield) = 0 Or IsNull(cbosearchfield) = True Then MsgBox "You must select a field to search." ElseIf Len(txtsearchstring) = 0 Or IsNull(txtsearchstring) = True Then...

Hi, I have a report, which contains a memo field. When the report is ran, the columns show characters such as <br>, <linebreaks>, etc. Is there any way to get rid of them and only show the content? Thanks

Hi, Is there any way to physically protect the backend? One way of doing it would be to create backups every day, but this still won't prevent ppl from accessing the folder and deleting the backend. Any thought on this guys? thank you

Hi Ling, thank you and it worked. The other thing is....how shall I put a save button on the form that basically says "saved" when the change has been confirmed? right now it says "saved" even when the change has been undone. thanks again

Great it works out well. Thank you Bob. One more thing........how do I cancel out of the filter once I am done viewing the filtered results? Do I have to close and re-open the form each time? Thanks

Hi, I am testing out a sample database, but I'm getting no where with it. Basically it's a form-based search on a main form. When you click on the search button, Access brings up a search form. On the search form you can search for a string in a chosen field. Hit Search and on the main form...

Hi, Users would like to careful when it comes to updating through forms. Is there any way to have Access pop-up a prompt window to indicate that the record currently shown on the form has been modified? And if user wants to exit out of the form, another pop-up window should appear asking...

Hi, Could some one please help me on this? I have a form-based search which will bring up a report showing records based on parameters. 3 textboxes in total on the search form. The 1st one is a text field and the query behind it is....like iif(text1 = "", "*", text1). So this will return...

Hello, I have a subform built on a main form. In the subform, there are two columns, A and B. They are store texts. For ease of data entry, I would like to be able to have Access check the first two characters of a string in column A, and if it is....for example, 02, then in column B I want...

Hi, I have this form set up for users to do report. It's a pop up form with a couple of fields and two buttons. One is for opening the report and the other closing the report. Sometimes users may not remember what fields they chose after the report has been opened. Is there any way to...

Hi, When two forms are open, would it be possible to reflect the changes made on the other? I have noticed that users do not want to close the current right after updates are put in. They just want to see if the change has been recorded on another form. So an example would be......a user is...

Is there a way to insert a pdf or internet address into Access form? Users would like to click on something on the form to bring up this webpage. Any thoughts or comment much appreciated.

Hi, I have a question regarding adding OLE objects into Access. When adding a word document, do I necessarily have to click on the "Link" checkbox right beside "Browse"? what's the significance of it? Does anybody know? thanks

Hi I have a main form set up and on the form there are multiple fields. Users would like to search in one of the fields on the main form without having to go to the report. The search is using the contain() function to look for a string found in the field. Is it possible to have a small...

Yeah I think it's most likely what I need. Will look into it. thank you!

Hi guys, I have a one to many relationship set up. The PK is not set on the Autonumber on the primary table. Users can now add a new record into the primary table through the main form. There is also a subform that shows records hitched onto the record in the primary table. I have ran...

Hi, Would it be possible in Access to multi-select items from a drop-down and do reports on those items? I have a very simple one to many relationship. Users would like to see multiple items on the report. For example, users want to choose up to five items from the dropdown. So on the drop...

Hi, I have a main form set up. On the main form, I have 4 subforms and some other textbox fields. One of the fields of interest is the actual PK field where users find a PK by going "control f" and see what information is related to the PK. I'm beginning to notice that you have to first...

Hi, I have a combo box filter set up. It works perfectly when it comes to data entry. However, when users browse through records, the 2nd combo box only shows contents once. It only shows the text for the 1st issue, then stops showing texts. Hopefully my attached sample database explains...

Hi, Is there any way to make the record selector at the bottom of each form bigger? It's just kind of painful to see which record you are currently at sometimes. Is this possible at all? Which parameter would I be looking at to change? thanks for any comment on this