Search results

Sorry for the awkward title, wasn't sure what to call this... I am trying to create a query that will return all the projects that a contact is associated with. However a contact can be linked to a project in several different ways: Contact ID ----- Owner ID Contact ID ----- Architect ID...

This is more of an SQL question than a query issue. I want to determine the max value of an autonumber field, b/c this is an easy way to access the last created record in a table. I can't use DoCmd.GoToRecord , , Last, because I have a sort active on my recordset, and that navigates to the last...

I have a small business database that is split into a front end and back end. For some reason, when the back end was accessed from different front ends, users experienced massive slowdowns. So, instead, I opted to create only one read-only front end that all users access through a shortcut on...

Hi all, I am trying to basically set the value of an option box through simple VBA, and I just can't get it to work, I receive Run-time error '438': Object doesn't support property or method. Here's the code: Public Sub ProjectViewCmd(ID As Long, Stat As String) Dim i As Integer Dim...

I'm attempting to use code written by the Microsoft Access Team that maps fields from a custom Contacts table to the fields used by Microsoft Outlook, to facilitate use of the AddFromOutlook command that comes with Access 2007. I have all of the code in a module, and then I call the sub...

I'm attempting to use code written by the Microsoft Access Team that maps fields from a custom Contacts table to the fields used by Microsoft Outlook, to facilitate use of the AddFromOutlook command that comes with Access 2007. I understand the code well enough, but I'm having an issue with...

I have a table called Inflation Rates and one called Project Info. Project Info has the field "Date Completed", and Inflation Rates has "Date Year" and "Cost Index". My first query is called "Project List Query" which has the fields "Project Info.*" as well as the calculated fields: Year...

So my main form is a marketing contacts viewing form, and in this I have a subform which has a list of all contacts in the database (its a small one). The subform is a continuous form formatted like a datasheet, so I can view essential data for multiple contacts at a time, while still allowing...

So I have a main form, and in the header I have a combo box where a user can search for contacts, but I want the box to search for records in a subform, not on the main form. On the combo box's After Update property I have this code: Private Sub cboNameSearch_AfterUpdate() On Error GoTo...

I have a form, Marketing Targets, which pulls records from a simple table that contains a field called Contact ID (key field). This form has a subform, Action Items subform, which also has the field Contact ID. The subform displays records that share the same Contact ID with the current record...

I'm attempting to use a text formula as a field name in a query. The scenario is this: I have a field named Design Phase, and also three named GMP Owner Bid, DD Owner Bid, and SD Owner Bid. Design Phase is a lookup field, with three possible values (GMP, DD, and SD). See where I'm going with...

So I am setting up a Marketing Targets form, which essentially identifies targets that need to be pursued as potential clients. I have two fields that identify the "target": Contact ID and Company ID. (yes I know, the person who started the database had never heard of naming conventions...)...

I am programming a database for a mid-level construction company, and in the program I have a Contacts table, and a Project Info table. The key field of Contacts is Contact ID, and for Project Info it is Project ID. There is multiple one-to-many relationships between multiple instances of the...

I've googled as much as I can on the topic, all to no avail. Does anyone know if there is functionality or a work-around that would allow the export of records from a "to-do list" table into Outlook calendar? The only fields I would want to export would be Item Description and Due Date. Thanks

This situation requires some explanation. I am trying to set up an importing routine for syncing contacts in an Access 2007 database with Outlook 2007, however I don't want to link the databases - I want to import from Outlook to Access. I am importing all contacts using a .CSV file, into a...