Search results

This is one of those situations where just answering your question brings up more questions. This brings us back to Bob's observation. Why are you needing to add the same information in another table? Normally you would not need the same information entered into more than one table. You...

In the Control Source of the second text box put the following: =[NameOfTextBox2] When you type a value in text box 1 and exit the control, the value entered will immediately appear in Text Box 2. If you specifically want to do this in code, here is code that you could put in the On Change...

I do not have any examples that I can direct you to. However, you should be able to use Google or other search engine and get information about automation for MS Word from Access.

If you use MS Word automation (This means actully creating an instance of MS Word and opening a document) then you could continue to work with the document using VBA code from Access. That is what I had in mind.

Using the Follow Hyperlink method to open the Word documents will not allow you to have any control over enabling or disabling the save options when opening the documents. However, if these are existing documents, it would be possible to use VBA code in the On Open of the documents and replace...

I hate when I get one of these mental blocks. Sometimes you just need a reminder. Glad to help. Good luck with your project.

Try using the "OpenArgs" parameter when you open the form. Just add "NewItem" as the value for the "OpenArgs" paramter as shownin the line: DoCmd.OpenForm "frmNewItem", acNormal, , , , acDialog, "NewItem" Then in the "OnOpen" event of the "frmNewItem" form, just check for the value of...

Try a little different approach to getting the count of the records that meet your criteria. I normally just do a "count" of the records that meet my criteria rather than try to return the recordset. Here is some code that I have used to do what you are wanting to do. This code will return...

After looking at the current structure of your database, I would suggest that you take a look at "normalization". In your case it would appear that you have Customers and those customers have "Units". Each of those units have initial data and then test data that is to be compared. Try...

If your database if normalized then there is no reason that a query as I described in my post would return only one child record. I also would like to see your data and the structure of your database.

Add the following to a new column in the QBE: YrMo: Year([OrderDate]) & Format(Month([OrderDate]),"mm") This will great a new column called "YrMo" with the format of "YYYYMM".

Try creating a query that will produce a list from tyour Household table where the Household menber type is equal to "Child" or "Other" (if you want the "other" records included) and include the HouseholdID field in your query. Then use this query in your existing query that is returning the...

Re: A2007 way to "put lots of reports on a menu" since 2007 has Ribbons, not Menus Creating custom ribbons can seem a little overwhelming when you first start, but once you get the hang of it, it is not all that bad.

Re: A2007 way to "put lots of reports on a menu" since 2007 has Ribbons, not Menus You can create custom "ribbon" menus and include a section for your reports. I have an application that I support for a client that has a Report section in a custom ribbon menu and that section then has multiple...

This makes it sound like the Page Header section is already displayed. Sorry, but I thought from you post that this section was not visible. You can extend the height of the Page Header section by clicking down on the top edge of the "Detail" section and drag it down. You can then move any...

Right click on the top of the report and select Page Header from the options.

The Report Header will only print on the first page of the report. Try putting everything that you want printed at the top of each page in the Page header section.

Check the "Join Properties" for the joins you have between your tables. The default "join type" is "Only include rows where the joined fields from both tables are equal". It may be that you do not have all of the fields in the tbl_Job table populated with data for one or more of the fields...

Try using the Select Case method. You can specify multiple criteria and thus cover the months of each quarter with three case options in the Select Case statement like this: Dim MonthName As String MonthName = Format(Month(Date), "MMM") Select Case MonthName Case "Jan", "Feb", "Mar"...

What you have will work if you add the "Key" field to the "SubTopic Qry" (which is the record source for the "cboSubTopic" combo box). You currently have the "cboSubTopic" combo box defined as Column Count = 2, Column Widths = 0"; 2" which would be fine when you actually have 2 columns in the...