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 Chriss Miller 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. James79

    Report text upside down??

    Hi, Trying to create a 4 fold Birthday card. This means that when it is printed, on the top half of the a4 sheet, all the text has to be upside down! Does anyone know if this is possible??
  2. James79

    Bookmark a new record with code???

    Don't worry everyone, I found the solution on a website. Here is the answer. with rst .addnew 'Add all the stuff that you want to the recordset .update .bookmark = .lastmodified end with
  3. James79

    Bookmark a new record with code???

    Say I have a couple of recordsets open that I am using in a module with no form. I want to add a new record to one of them, and then make that record the bookmarked record, or the current record. Usually I just use me.bookmark, but because there is no form it does not work. How do I set the...
  4. James79

    Bookmarks in Recordsets??

    Say I have a couple of recordsets open that I am using in a module with no form. I want to add a new record to one of them, and then make that record the bookmarked record, or the current record. Usually I just use me.bookmark, but because there is no form it does not work. How do I set the...
  5. James79

    Login forms......How !!!

    The reason that the definition of database is not recognised is because you have to add the microsoft DAO 3.51 Library to the references of the project. In the code window go to tools, references. Make sure the priority of this library is greater than the microsoft ActiveX data objects library 2.1
  6. James79

    Determine Which form opened another one.

    I want to be able to determine which form has opened another one. For example, if you have a calendar form with a simple calendar control in it, and this is opened from 5 different locations. When the calendar is closed it is meant to insert the date into the form that opened it. How can I tell...
  7. James79

    Pull down menu within a pulldown menu

    I don't think you can do that with a combo box. You can probably make your own custom menu that pops up when the form opens, and can pop the values that you want into the desired control.
  8. James79

    unbound text box

    Hi Hommer, In the form, in the general declarations section of the code window delcare a variable dim password as string Then in a new section paste this: Private Sub Text1_KeyPress(KeyAscii As Integer) password = password + Chr(KeyAscii) End Sub Replace text1 with the name of your verify...
  9. James79

    How do I change the color of a button or tab?

    Or you could create images in Paint Shop Pro and import them into access. Use the onclick event to mimic buttons. As for changing the colour of the tab controls, I have never seen it done.
  10. James79

    Opening Specific Records in a Form (Form to Form)

    Open the datasheet in the design view. right click on WorkOrderNo, select properties, event, double click, code builder. Paste this in. Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmWorkOrderEntry" stLinkCriteria = "[WorkOrderNo]=" & Me![WorkOrderNo]...
  11. James79

    Hiding Design View

    Click Tools, startup, and then uncheck almost all of the options there. Then go and remove all of the menu bars by right clicking on them and hitting customise. Set them to not display. Backup the frontend before you do this however, because sometimes you can lock yourself out of getting into...
  12. James79

    Edit Forms in MDE

    Is there any way to edit forms after the DB has been converted to an MDE? Is there some kind of tool I can use?
  13. James79

    Open a form with a blank record

    In the "On Load" Event of the form you would place this line. DoCmd.GoToRecord , , acNewRec For common functions like this, use the wizards for the command buttons like new record, delete record, go to record etc, and then cut and paste the code to the event that you want. That is...
  14. James79

    create single record recordset from form

    Thanks Heaps Toeshot that dbOpenDynaSet was the trick. Works like a charm. Looks like that rs.findfirst really only works with the dbOpenDynaSet. Once again Thank you very much. James
  15. James79

    create single record recordset from form

    How do I create a recordset with the criteria being the primary key on an open form? eg form is open with numeric field chargeID rstTemp.openrecordset("select * from tblChargeProduct where ((tblChargeProduct.ChargeID)=[Forms]![frmCharge]![ChargeID]) This looks like it should work to me. Can...

Part and Inventory Search

Back
Top