Search results

Wow, mlooman that worked absolutely perfect; exactly what I needed. For anyone who views the thread in the future, the exact SQL I used was: SELECT Contacts.[Contact ID], [Project Info].[Project Name] FROM Contacts INNER JOIN [Project Info] ON Contacts.[Contact ID] IN ( [Project Info].[Owner...

First, I just want to thank you for walking me through all this, I know I'm not the most knowledgeable when it comes to queries. I did what you said, but I got essentially data output that is already present in the Project Info table. Attached are screenshots of the query I made, and the...

OK, I tried that but it didn't seem to work. I attached two screenshots, one of the query setup, and the other of the datasheet view of the query results. I also tried selecting option 1 in the Join Properties window ("Only include rows where joined fields from both tables are equal") and I got...

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

Yes it does, except every single table I have is in the backend. I switch to sort objects by type, and not a single table shows up that isn't linked. By end of day yesterday I had just given up and decided to make it a non-readonly copy, and just restrict what users had access to by modifying...

Yep, that's what I needed. Thanks guys.

You can, as long as the back end isn't read only, can't you? When you open the database in read-only mode, it has an alert bar below the action bar that says, "This database has been opened read-only. You can only change data in linked tables. To make design changes, save a copy of the...

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

Thanks guys, both of those options fixed the problem, appreciate the help.

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 created a new database, exported just the contacts table and the code and no luck. I really wish this would work, the AddFromOutlook is a such a cool feature

In line 19 you have an error, there is an arbitrary space in the word "Definitions" Set rstApplicationTableFieldDefinitions = dbs.OpenRecordset("Application_Table_Field_Definit ions", , dbAppendOnly) For all those copy and pasters out there...

so....does nobody know what my issue is? :/

Yes it is. The line you're referring to (I believe) is Sub SetProp(o As Object, strProp As String, dbType As DataTypeEnum, oValue As Variant) What I believe happens is that in the MakeContacts() sub, the line SetProp td.Fields(fm.Field), "WSSFieldID", dbText, fm.prop passes in dbText...

I did, the table is called "Contacts". Haha that was a DIFFERENT set of errors, which i finally solved and kicked myself for lol

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

Thanks, I'll give that a try when I get to work tomorrow morning.

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

Still no luck using that string, with or w/o quotes :(