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: *

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

    automatically bypass the default message boxes for append query on frm

    I have a bunch of append queries running from a command button on a form. I would like to automatically bypass all of the pop-up messages that ask if I would like to update a table and then append records. At this point I am clicking the yes option over 50 times. I am wondering if there is a...
  2. DBritter

    link access to outlook to create a shared calendar report

    I am trying to link an access project database to outlook to create a shared calendar report for the company to see. I have no clue how to get this set up. Any help would be appreciated.
  3. DBritter

    Report to print EPS images

    I have a report that I would like to print EPS(Adobe Illustator) images on. In the help files it says that I need a special filter to access these images. It also says that I need a special filter for jpegs as well. Could someone please point me in the direction of this filter.
  4. DBritter

    putting a null valuein the subforms?

    This is the error that I get when I open a form in data entry mode: "You tried to add a new record but didn't enter a value in the field that contains the primary key." The primary key that i have on the form is an autonumber which in not enabled. there are two subforms on this form...
  5. DBritter

    getting an error,3058, when form is being populated

    Index or primary key can't contain a Null value. (Error 3058) This is the message that I get when one of the forms that I have opens. The code that is associated with the command button that opens the form is as follows: Forms!frmLookup.Visible = False DoCmd.Close , "frmLookup&quot...
  6. DBritter

    having date apear on a report

    I have a letter that I would like the current date to appear on the top. I inserted [=Date()] in the default value for the field it was working fine and now it asks for the date parameter as the report is brought up. My question is that I would like the date to appear at the top of the letter...
  7. DBritter

    make subform data entry

    I have a subform that I want to be in data entry with only blank records showing. This is a form for a new order by an existing customer(all of the order information is in the subform. the main form only holds the ID field relating the order to the customer). I have both the main form and the...
  8. DBritter

    set focus from subform to control on form

    I am having trouble setting the focus from a subform back to the main form. I need some type of code that I can reference. I have no clue how to reference back to the form. I have tried using the gotocontrol function but it returns the current value in the control that I want to reference with a...
  9. DBritter

    moving between forms and subforms and back !!!!!Help!!!!

    The problem comes when trying to set the focus back to the main form from a subform. I have used the .GoToControl action after the lost focus event to have the person go directly into the subform. exiting the subform I tried to do the same thing,but I keep getting an error saying the field is...
  10. DBritter

    trouble with drop down based on other drop down

    The problem is that a message box appears asking for criteria of [lngShipping]. This box appears as the subform is opened and when the [lngShipping] is changed. I have a list box[lngShipping] that is based on another list box[lngShippingOption]. On update of the of the first list...
  11. DBritter

    information from form will not print

    I have a form with a command button that prints a report based on the information in that form. It is actually set up to run the report off of a query that is based on an ID number on the form. When I go to a past record and back to the current record, it will print. I put a requery function...
  12. DBritter

    Not to print reports when there are no records in source query

    I have a series of mailmerge reports that run off of queries. I have a form set up to run all of the letters and their underlying queries when a button is clicked. The problem occurs when the query comes up with no results and the letter prints anyways with "#error" in the place of...
  13. DBritter

    Report not to print if source query is empty

    I have a series of mailmerge reports that run off of queries. I have a form set up to run all of the letters and their underlying queries when a button is clicked. The problem occurs when the query comes up with no results and the letter prints anyways with "#error" in the place of...
  14. DBritter

    sendkeys to fast problem

    I am having trouble with one of my modules. It is sending the key too quickly and document does not open. Here is the section that has the problems: OpenWord = Shell("C:\Program Files\Microsoft Office\Office\WINWORD.EXE", 1) SendKeys "%(fo)" SendKeys &quot...
  15. DBritter

    send keys syntax needed

    I need to have 3 keys pressed at the same time. I need the alt+ctrl+k keys pressed down at the same time. I see examples of two keys but not 3 in the help files. What is the syntax for 3 keys. Thanks, Dave
  16. DBritter

    cleaning up my code

    I been trying to use as much code as possible on the back end of my forms. I was wondering if you had any suggestion to cleaning up the appearance of the way my database functions. Basically I don't want all of these query windows opening and minimizing as I am currently doing in this...
  17. DBritter

    Removing value of a field based on contents of other field

    I am creating a form where one list box's range of choices(strShippingOptions) is based on another list box(strShippingCompanies). The problem is that on the form level when I change the option in strShippingCompanies, strShippingOptions is effected but in the table the origal chioce remains...
  18. DBritter

    convert text field to number field in query but leav as text inthe tbl

    I am in the process of creating a lead database for my company. The problem is that the zip field is text due to international zips having letters. I would like to create a set of queries to route the US leads to our US reps. The reps have a specific geographic area basedd on a zip range. It is...
  19. DBritter

    Duplicating a Record

    I need to create a procedure in a form that duplicates a record and appends it to the table. I was trying to use the wizard for command buttons to do this but it just created a new record without duplicating the information in the record.<br><br><br>The reason for this is to create a form that...
  20. DBritter

    Clearing fields in a form based on an option box.

    I need to know how I can clear a group of fields in a form based on a selection from an option box. If I select option 1 then the first five fields are cleared, If I select option 2 then the next five fields are cleared, etc.

Part and Inventory Search

Back
Top