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!

  • Congratulations John Tel 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: *

  • Users: naturalsn
  • Content: Threads
  • Order by date
  1. naturalsn

    Option Group

    Good Morning I was hoping someone could please assist. This seems very simple but I get a runtime error 2427 "You entrered an epression that has no value" error the whole time. I have and Option Group call "ApplicationSucc" Yes / No Option group which is bound to a field in my table called...
  2. naturalsn

    Subreport Visible

    Good Monring I hope someone could possibly assist. I have a report that I am generating with 1 subreports embedded in it. When the subreport has no data , the subreport does not show when I run the main report. Now i know i need data to display the report. But at some stages the report...
  3. naturalsn

    VBYes VBNo

    Good Morning I was hoping someone could possible assist. I currently have some code. That with a current record on the form. The user can append to a different table. Once user click a message box come up asking Are you sure you would like to "append" the following record, if user says yes...
  4. naturalsn

    Append

    Hi I was hoping someone could possibly assist. I have Two Tables TblIntrvCandidates & TblEmpInfo. In the "TbleIntrvCandidates" we have hundred of records of candidates being interviewed and using it for sending document etc. Once a candidates interview was not successfull or experience was...
  5. naturalsn

    Multiple Reports in Single Print Job

    Good Morning I currently have a form that has four check boxes on it, to allow users to select which report that would like to print with the current record. It is working perfectly but now need need to provide the users with an option to use the the same checkboxes to choose which reports...
  6. naturalsn

    Form Checkbox If yes Print Associated Report

    Good Morning I am hoping someone might possibly assist I have a very simple DB 1x Table 1x Form 4x Reports In my table i have four yes/no fields that will indicate the required reports to print (with the specific record) I have taken the four fields and placed them on the main form as the...
  7. naturalsn

    Can Grow Shrink Min Height

    Good Morning I was hoping someone could maybe assist. I currently have three fields on a report sitting right next to one another Doc Reference No Of Copies Description No Of copies and Description only appear ones on the report but can vary from 1 line of detail to 5 lines of...
  8. naturalsn

    If Value in Listbox = this open this Form if = That op that form

    Good Morning I have a form where data is being filtered in an unbound listbox. When the data is filtered I will then double click on the record and will open it in an additional form for viewing etc. I now however in my listbox have a new field called status. The status can be, Active...
  9. naturalsn

    Relay

    Good Day I was wondering if anyone else has maybe experienced this. I am currently using CDO to send emails from Access and was working perfectly until yesterday i granted a user rights to send emails from the same email address as specified in my CDO Config. I now when sending from Access...
  10. naturalsn

    CDO Browse To Attachment

    Hi I just recently changed sending emails from Access - Outlook to using CDO and working perfectly no problems except my attachemnt. I used to via Outlook send emails to individual users as we are working with their record, and migth add an attachment or might not. I did add a Browse function...
  11. naturalsn

    Add via command

    Good Day I was hoping someone might be capable of assisting. I currently have a dropdown call "Addskills" on a Form wich has 2 Coloms from a Table in My DB. One ID & Another The Description of The ID. I am hoping to allow the user when selecting from the AddSkills Dropdown, Select An...
  12. naturalsn

    Unbound Listbox

    Hi.. I have a form bound to a table Called "Personell". I would like to display a multiselect listbox that retrieves it data from a Table called TblEmailsSent. Both have a unique PersonellID in each table. And i can not get the data in the listbox to link with the data in my main form. I...
  13. naturalsn

    Tracking Email

    Hi I was hoping someone could perhaps assist. I am currently using a form in Access to Send and Email to outlook. This work perfect. But I am hoping due to the fact that only emails sent from the DB are being sent to Clients in the DB keep a copy of what was sent. Just in a Table. Due to...
  14. naturalsn

    SQL Group By Colum Order

    Hi. I was hoping someone can assit. I have a search form. That searches various tables and show the result in multi selelct list box. The data shown in the list box is retreived via SQL. I am hoping to change the way the data is being displayed in the list box. Currently the order of my...
  15. naturalsn

    Module To Command

    Good day.. I currently have a module that imports a MS word Document. I currently Run the import by opening the module and F5 which which then provides me with a popup asking my document name. I was wondering if it is possible to place this as a command on a form. I did to copy/paste this...
  16. naturalsn

    Importing Limit

    Good Day I am currently importing records from a word document, to different tables within acces. Everthing is working fine, Execpt for one section. I have A table with 5 Fields in My word document that give user place to enter all their Education Details. IE Name of Institute Attended From...
  17. naturalsn

    Grouping As Field Grows

    Good Day I was hoping someone could perhaps give some advise. I currently have a report with 5 fields next to on another indicating Institute Name, Course Taken, Date From, Date To, Degree Obtained With a black border around each to give it a table format. This is running from a table to a...
  18. naturalsn

    Opening Stored Filed Location

    Good Day, I have been scratching around but no luck and hoped someone can adivise we i am going wrong. I have a form, with a multiselect list box wich list data from my Maps Table with the location of every mapped stored in a field called "MapLoc" On Double click event I am hoping to open...
  19. naturalsn

    Viewing Big Files

    Good Day, I was oping someone could perhpas or just give some advise. I currently have 40 Cd's with Images whose size i am currenly reducing from 150mb to between around 9mb -13mb per file. Now on Each Cd I have about 30 of these images(maps) on them. I am currently sorting them as need...
  20. naturalsn

    Merged Doc Save

    I was hoping someone can perhaps assist. I am currently using bookmarks to enter the current record on my form into a word doc called Personal Data From. The data that merges is, ID, Name and Surname. The word template lies in the same directory as my DB. Due to the fact that the doc is a...

Part and Inventory Search

Back
Top