Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. avagodro

    Access and Outlook Web Question

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

    Form/Subform question

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

    Query Filter Question

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

    Relationship problem

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

    No Printer

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

    No Printer

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

    No Printer

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

    Query/Control Question

    Never Mind. Issue solved.
  9. avagodro

    Query/Control Question

    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 #]...
  10. avagodro

    Groupwise Code Question

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

    Groupwise Code Question

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

    Groupwise Code Question

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

    SQL Question

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

    SQL Question

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

    Conditional Code on Combo

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

    Redisplaying selected in listbox

    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)...
  17. avagodro

    Redisplaying selected in listbox

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

    Listbox Code adding blank record

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

    Listbox Code adding blank record

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

    Listbox Code adding blank 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.

Part and Inventory Search

Back
Top