Search results

You can get rid of those warnings by going to Tools/Options and the Edit/Find tab. Uncheck the ones you want turned off: Record changes Document deletions Action Queries

Could you create a table with one memo field and store your document in it? Then use that field as the control source for the text box on your report? Just an idea.

I did a job application DB that addressed a problem similar to your second question. I created a query that included all of the fields I wanted returned, and used the combo boxes on the form as criteria for the query. For instance, the criteria for the product field would be...

Use the same code that is behind the button, but put it as an After Update event for your last text box.

Open the form in design view, go to Tool and Macros. Click on Convert form's macros to Visual Basic. That will "write" the procedure for you and you can compare that code with your code.

Access is really bad at exporting reports in other formats. I have found two things that work: PDFs and Snapshot. You need to buy Adobe Acrobat to use the former. And your users need to have the Snapshot viewer installed (free from Microsoft) if you go with the latter.

You can use a variable set to the value of the combo box to designate what form to open or query to run. Your code would be dim stForm as string stForm = YourComboBox Docmd.OpenForm stform

Microsoft has a paper on the subject: Article ID Q97624. I found it pretty confusing, but did manage to get it to work. Here's what I would do. Use the wizard to set up combo1. Say you want to type in the values, then type in the diference Types. Create a query with the two fields from...

You have put in the path to a Wordpad icon. I used this path and it worked: "C:\Program Files\Windows NT\Accessories\wordpad.exe" Note the quote marks. I guess it has to be a string.

I'm not sure I understand your question fully, but it is easy to open a form or run a query using a combo box. On the After Update event, put in the code: Docmd.OpenForm "YourFormName" or Docmd.OpenQuery "YourQueryName" You also can set arguments based on the value of the combo box that will...

Have you tried a Case statement? I think they are less demanding on system resources than If/else.

Have you tried filter by form? You can create a form with all the statistic controls and set the criteria for each. Then use filter by form and the results will be returned in the form. It is a lot easier than a bunch of coding. The help file on Filter by Form explains it better than I could.

Does anyone know the VBA code that will expand a text box on a form. I know you can do it by hitting Shift+F2, but I would like to have my users do it on a double-click event. I have seen it done in a sample db I downloaded, but can't find the db. Thanks, Neal

I have a report built off a table with multiple yes/no fields. I need to list only those fields with a yes value. For example, there maybe six colors a car comes in, but only three are available. I only want to list those three on the report. Does anyone know how to do this? Thanks Neal

Can you tell Excel to do the calculations with a macro and avoid using sendkeys? I use this option all the time and have never had a problem. The syntax is: TheNameYouGaveExcelVariable.Run "ExcelMarcoName"

There are two ways I would approach this. You could create another form, and make the original form a subform of the new form. The new form would have a combo box on it that would get it's data from the incident number field in your table. After selecting the incident number, the data for that...

The document I open isn't embedded. It is just a file on our network. I use this code to open it and copy the text: Set hotapp = CreateObject("Word.application") Set hotdoc = hotapp.Documents.Open("Put the path to the document here") hotapp.Visible = False...

Microsoft has a help file on exporting Access graphs to Excel. It explains how to do it when the graph is on a report or form. Unfortunately, in both cases, you have to cut and paste the graph into Excel. I'm sure you could get it into Powerpoint from there. If you think this would work for...

It sounds like you need to look up the value of the checkbox using Dlookup. You might be able to build it into your Iif statement, or you could establish a variable for it. It would read something like this: dim IntChk as integer Intchk = Dlookup ("[CheckBox]", "TableName", "[SupplierID]" =...

I have done something similar by putting a macro in the word document that selects and copies all of the data. Then with VB in Access, I run the Word macro. To paste, I use SendKeys "^v"