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

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

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

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

I have two tables in my database that are linked. One is a Branch listing that consists of only 3 fields, BranchID (autonumber) BranchName and OpenClosed. The other table is individual account records which are associated to a Branch (in the branch table). I have added code to a button on a...

I want my Switchboard, and all subsequent forms to be maximized on open...so that the form name doesn't show. Is that possible?

I have a "status update" subform on a form that the user can go in and put periodic updates for that record. I have one field on the subform called UpdateStatus that I want it to get its value from the current value on the main form (which changes periodically) called SDPPhase so that you can...

I am sure this has been asked a thousand times, but I couldn't seem to find a thread. I have a form, which contains a subform. When in the subform, I have a button to create a new main form and I want it to prefill in the data from some fields on the subform. It looks like it should work...

I have a button on a form that opens Outlook and prefills text in an email. The default seems to be Plain Text. Is there any way that I can make it default to Rich Text?

I have a button on my form that will open up and email message in outlook. I need to be able to prefill out the body of the email with two separate paragraphs. The problem I am having is I can't get a carriage return to work between the paragraphs..it keeps showing up as one big paragraph...

I have some code that attaches a report to an email. What I need to be able to do is make the body of the email's text bold and red, but I can't figure out how to do it! Can someone help?? Here is the code: Private Sub Command3_Click() Dim rptName As String Dim bytchoice As Byte Dim strmsg As...

I have a button on a form to search for a document by a number that the user inputs. It works great as far as finding the correct document, but the problem is that if there is no match, it automatically opens up a new blank document. I have tried all different error messages, etc. and can't...

I have a field called Priority where the user will give it a numeric value to state the Priority level, i.e. Priority 1, Priority 2, etc. However, I had to make it a text field because they wanted to be able to input "NP" for Not Prioritized. The problem is that they want a report that sorts...

I have a report in my access db that I would like to just click a button and have it automatically send to a user. I am new to VB and can't figure out the code to do it. Can anyone help? :confused:

I am new to VB and need help with the following: I have a form that is used for two types of requests (either Task or Project). The user selects which type of request it is by a dropdown box. What I need help is is this: there is also another field called Number next to the Type field. I...