Search results

I am currently working on a form for my users to look at budget data. I have several listboxes for them to filter queries by. What I was wondering is, if it is possible to have data in one list box be filtered by the preceeding listbox? For example: Three list boxes: Report_Period, Budget...

I assume what you mean is to actually make a join between the two primary keys? The primary keys in this instance are record ID's, and based on data input, the keys won't match. Are you suggesting a full outer join then?

I am trying to create a form in Access 2007 based on two linked SQL 2005 tables. the form works fine, but when I attempt to update a field, I get the infamous message "this recordset is not updatable". Both tables have a unique ID, and show up in Access this way. My SQL code: SELECT...

Wow, I sifted through the code you sent, along with some other stuff I found online... here is my code currently: Private Sub Command5_Click() If Me.Dirty Then Me.Dirty = False End If If Me.chkAddedtoOutlook = True Then MsgBox "This appointment has already been created", vbCritical Exit...

Thanks, dbDAMO, I tried similar code I found online, the problem with most of them is they want to automatically create and send the appointment, I am looking to partially create and have a user add other information or check scheduling conflicts depending on who the attendees are. Code...

I have been tasked with making an addition to my Access 2007 database, we want to create a button on a screen that will open up the Appointment screen from Outlook (not directly create the appointment), and populate the Subject line and invited attendees from fields within Access (user will need...