Recent content by avagodro

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