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

    command button in report

    Thanks again. As I mentioned I am pretty new to access and especially visual basics. But I can't place it in the open event, as when I do I get a compile error again. So I have tried it as general code the following way: Function PreviewAndZoomReport(ShowSearchResultsRpt As String, ZoomCoeff As...
  2. Frederic74

    command button in report

    Thanks for that. Much appreciated. However as you said it did give me a compile error. Is there not a chance just to have a simple code to zoom it to 90%? I tried the following as well: Private Sub Report_Open(Cancel As Integer) DoCmd.RunCommand acCmdZoom90 End Sub Doesn't work easier.
  3. Frederic74

    command button in report

    In normal view my reports data is too small to be properly analysed. However if I maximise it, it is too big and I can't see the controls to move to the next page of the report etc. I am sure there must be some code, which says something like maximise to 90%, unfortunately I am fairly new to...
  4. Frederic74

    command button in report

    I want to put a command button in the page footer of my report. However once I have placed it, it doesn't allow me to add a macro. Actually the only thing I can change within the properties is the format, but not the event. Anybody know why that could be and what I can do to solve it? Any help...
  5. Frederic74

    Make controls flash once they are enabled

    Sorry, as I said I am pretty new to Access. I am not sure what you mean by browse in this context. Would you be so kind to specify. Thanks ver much in advance.
  6. Frederic74

    Make controls flash once they are enabled

    I am pretty new to access so forgive me..... I would like to make each control of a form flash once enabled. I have tried working around some advice I was given. Timer Event: Private Sub Form_Timer() Me.YourLabelName.Visible = Not Me.YourLabelName.Visible End Sub That only enables one control to...
  7. Frederic74

    Saving the current record of a form before updating into another table

    I am pretty new to access, so forgive me. I would like to safe one record from a form and safe this record before it's being changed to another table. I have created an append query to append from my form's recordsource to another table. I have selected the record in my query using criteria...
  8. Frederic74

    How can I create a user-friendly search

    I am sorry, but as I said I am pretty new to Access. I Tried to do pretty much what the following Microsoft example tried to do: Microsoft Access Database Solutions - Searching Records using a Microsoft Access List Box In an earlier article, we discussed Using a Microsoft Access Listbox to pass...
  9. Frederic74

    How can I create a user-friendly search

    Hi, I am pretty new to Access, so forgive me if this is a simple problem.: Here is what I want to do: I have a equipment database with: EquipmentTbl – pkeyEquipmentID; pkeyCategoriesID; strCategories; pkeySubcategories; strSubcategories; strItemDescription; strSerialNo; strModelNo...

Part and Inventory Search

Back
Top