Search results for query: *

I have a database that I created that once the person using it is done with a report they immediately email it. Currently I have it set to email using Novell Groupwise, but we are slowly switching over to Exchange, and using Outlook Web. Is there a way to have MS Access make a call to Outlook...

I have a form (frmCriteria) that has a subform (frmCriteria_subform). The only item on frmCritera is a ComboBox where you select the "Property" that the data in the subform is related to. All of this is working fine. What I would like to do is once you enter data in the subform and move on to a...

I have a query that I have that generates a report from one particular form that is opened. I have several different forms that have the main form and a subform within the form. The subform on each is what is different. I would like to have it so that it can generate the report from any of...

I have a backend and frontend database. The backend database I am using as a "centralized" database for some aspects, such as employees, which I want in all of my databases. When I create a link to the table in my frontend, and attempt to create a relationship, I have noticed that the Enforce...

It likely is at the bottom of their lists. Heck, it took a year and a half for them to get around to looking at my computer. And it was rebooting all of a sudden right in the middle of running critical processes. That is why I was hoping to find a "work around" to not having a printer installed.

I can't but it is on the last to have our IT dept look at. I was just hoping that there could be some type of work around, since no one ever prints the report. They just preview it, then email it.

I have a database with numerous people use. I have the reports set up for Print Preview, since they need to preview the report, then if all looks good they send the report to a Mail Recipient. I encountered a problem with print preview with a user that doesn't have a printer installed. When he...

Never Mind. Issue solved.

I have a form with a query attached that I cannot get the result to pull correctly. The code below is on a Combo Box: SELECT Hotels.[ORS Prop Code], Hotels.[Property Name], Hotels.[General Manager], Hotels.City, Hotels.State, Hotels.[GM's Email Address], Hotels.[Phone #], Hotels.[Fax #]...

I actually got a clarification from Dimitri on it and I'm posting it here for others that may encounter the same issue. You have to pass an array to the RecCC property instead of a string. First, you need to declare the array of the appropriate size: Dim astrRecCC(1, 1) 'two recipients Dim...

I spent several hours before I even started working with it to understand what did what. I am just not reading something right in the code.

I am using the basGWDemo code that Dimitri Furman produced. It is a great module, but I have encountered a snare, and haven't been able to find anything in the code, and can't find any posts. In the code, it is only accepting a single addresss for To, CC, and BCC. I want to be able to send a...

I've done a modification to my table structures: tblResponses -AssociateRef -QstnID -KeyID -ResponseDate tblResponsesList -KeyID (AutoNumber) -QstnID -Choices I am working on redoing the SQL utilizing KeyID as the join rather than Choices.

I have a reference in a form that is starting to drive me crazy. Usually I can resolve this, but maybe its from having a long week and not thinking clearly. Anyway, in the query I have the following tables: tblResponses -AssociateRef -QstnID -Chosen Value -ResponseDate tblResponsesList...

I have a combo box in a subform that was displaying data from previous selections. I was able to correct that with Me.ComboName=" " However, I am drawing a blank on having it conditional. If there is saved information in the table, it would display it, otherwise it would run the...

You actually have it right on. The table structure is: tblAssociates --AssociateID --Associate_Last_Name --Associate_First_Name --etc... tblResponse --AssociateRef (1-many with tblAssociates.AssociateID) --QstnID --Rspns --ResponseDate tblQuestions --QstnID (1-many with tblResponses.QstnID)...

I have a listbox that has the following SQL in a query: SELECT tblResponsesList.Rspns, tblResponsesList.QstnID FROM tblResponsesList WHERE (((tblResponsesList.QstnID)=[Form]![QstnID])); I want to have it if I return back to the record at some point, the listbox will show all the options and...

I found the problem. I had mistakenly had a control source on the listbox, which wasn't needed since the code is doing the saving.

It is something to do with the moving to the next question on the main form after the saving code is run. If I remove Forms![frmQuestionaire]![frmQuestions].Form![Command38].SetFocus SendKeys "~" I don't get the extra record.

My mistake. That actually wasn't on the original code. I was doing some testing and forgot to remove that. Even without it, it still adds the blank record. The blank record is ALWAYS at the end.