Search results for query: *

I'm using the Count function in the header of a continuous records sub-form to return the number of records. This works when there are records in the sub-form, however, if I go to a record in the main form and there aren't any records yet in the sub-form the field is displaying a blank rather...

I know there must be multiple threads on this: how do you use the system date in a VBA fuction? The following results in, "Invalid use of null." Dim DateToday As Date DateToday = Date RemDayNum = DLookup("RemDays", "tlkpRemDays", "DateCal=" & DateToday) Thank you, Jaaret

I am attempting to create a function that will return the first workday of the week (Monday). The function I created is as follows: Public Function Monday(DateDue As Date) As Date Dim WDay As Integer WDay = Weekday(DateDue) Select Case WDay Case WDay = 1...

I've run into this bug before and would like to resolve it once and for all. I have a simple, concatinated field: Field Name: txtStratInit Control Source: ="► " & [StratInit] It works correctly until I compact or close/reopen the dataabase, then it returns #Name? If I rename the field (i.e...

I have a subform linked to a main form by AuthorID. I am attempting to unlink the form when I populate a search field. The first part of this If statement works but the Else part fails. I've tried LinkMasterFields = Null. If IsNull(Me.txtQuoteSearch) Then...

I have a query based on a single table. If I open it up with no criteria I can (of course) update the data. However, if I add criteria based on form parameters I can no longer edit the data after the query runs. I'm not finding a reference to this on the Microsoft site. Is it not possible to...

I'm hoping someone can point me to the correct thread. I've tried the following code that I found on this site but it it errors out on the first line at "wdApp As Word.Application" Dim wdApp As Word.Application, wdDoc As Word.Document On Error Resume Next Set wdApp = GetObject(...

Can someone direct me to a thread on how to restrict users from viewing a form's design in Access 2007?

I have tried the technique listed in VBA Help for hiding the ribbon when Access starts but it isn't working - the ribbon still loads. Can someone please point me to a thread that addresses how to best hide the ribbon?

I have been using Access since version 2.0. I'm currently on Access 2007 on Windows 7 (Release Candidate: Build 7100). When I modify an Access report design and preview it, it takes over 2 minutes to either save the report or go back to Design view. Is this an Access 2007 problem or could it be...

I have inherited an Excel pivot-style table with about 550 rows of courses and almost 300 columns of job titles. The point where they intersect lists whether the course is required, recommended, elective, or n/a. Is there a way to automate getting this data in a standard Access table without...

Okay, when I'm using Access tables as data sources for subforms, I don't recall having to have the field actually populated into the form to use it as the slave link, it just needs to be in the underlying data source. I just discovered if I'm using SharePoint lists I appear to need to have the...

I am new to Access 2007 SharePoint integration. I've twice tried the Move to SharePoint command to migrate the Access data to SharePoint. Some tables transfer over to lists, however all my linking tables do not transfer over. The two fields are converted to two columns in the SharePoint list but...

How do I change the Conditional Formatting color palette in Access 2007. Is it possible, or do I have to resort to VBA to have custom Conditional Formatting color choices?

I have a new form that I created in Access 2007. There are two subforms: one listing dates and the other listing notes from the date that is selected. (The date's key id is pulled to the main form as the Master link to the notes subform.) If I click on a date that does not yet have any notes...

I'm using Access to analyze a MS Project 2007 project plan. I'm writing queries that I can adapt into functions to parse the project Work Breaksdown Structure (WBS) codes. To link a Level 4 task with its parent Level 3 task I have to parse the third number in the WBS code. So far I have been...

I have a subform that displays meeting participants. The subform is designed to display the names in three columns. I increased the footer size so that the column breaks occur after every five names. When I drop this subform into a main form it does not have any column breaks. I tried setting...

What factors cause the AutoNumber Key to become corrupt? On three occurances now the AutoNumber field has reset to a number lower than the maximum in the table. If the maximum AutoNumber key is 8013, a new record will try to assign 8005 as the key which, of course, causes an error. In one...

This is a follow up to thread703-1466592. My original question: I have a text box named txtRevCreditAmt on a main form that is pulling sub-report totals into the detail of each order: =rsubOrderCredit.Report!txtTotalCreditAmt Is there a way to create a sum of this value at the end of the main...

I'm writing an append query that appends the key id's of all clients who work for a particular company . I need to append the reciept ID for each appended record. I'm attempting to pull the receipt ID off of a loaded form: ReceiptID: [Forms]![frmExpReps]![txtReceiptID] The receipt ID for the...