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

    How to re-use recordSetClone without closing/opening form

    Been so long since I asked a question, took me 5 minutes to find the 'new thread' place! This works to tick CheckboxField on all records of a form: Private Sub cmdTickAllBoxes_Click() Dim rs As DAO.Recordset Set rs = Me.RecordsetClone With rs Do While Not rs.EOF rs.Edit...
  2. missinglinq

    Having to click twice to move focus

    Was writing a little routine for someone who needed, with a datasheet or continuous form, to have FieldTwo's back color change when FieldOne has focus. I added a boolean field, FFlag, and set it with the following code: Private Sub FieldOne_GotFocus() Me.FFlag = -1 End Sub Private Sub...
  3. missinglinq

    Sorting a Combobox RowSource derived from a Value List

    Does anyone know how to sort the items in a combobox when its RowSource is a Value List? AddItem is only available for free-standing (non-CommandBar) comboboxes in Acc2003 and beyond. I working on a hack to cover this function for earlier versions, and have it working. I'm just looking for a way...
  4. missinglinq

    Dynamically assigning SQL statement to RowSource

    This works fine when placed in the RowSource Property of a combobox, but what modifications to I need to assign it dynamically to the same combobox? SELECT [Doctors2].[MDName], [Doctors2].[MDAddress] FROM Doctors2 WHERE ((([Doctors2].[MDName]) Like ("*" & [Forms]!Doctors2![MDName] & "*") Or...
  5. missinglinq

    SetHiddenAttribute failure

    Any idea why this code would fail? I've tried it both ways (application is optional, according to Access Help) trying to hide several forms. Form names are always spelled correctly, and no error message is generated. Application.SetHiddenAttribute acTable, "MyTable", True SetHiddenAttribute...
  6. missinglinq

    "Calculating..." message

    Anyone have any idea why this realtime clock hack would cause the "Calculating..." message to appear in the taskbar for one PC and not another? I've used it for years without seeing this message, but someone else (an admitted neophyte) using it swears the message didn't appear until he put this...
  7. missinglinq

    How to alter SQL to exclude System Tables

    I'm using the statement below to retrieve the names of the tables in a db into a combobox, but need help to figure out how to exclude the system tables such as MSysObjects, MSysACEs, MSysQueries and so forth. SELECT [MSysObjects].[Name] FROM MSysObjects WHERE ((([MSysObjects].[Name]) Not Like...
  8. missinglinq

    Path to current app

    Sorry, Search is, once again, down for maintenance! I know I saw a posting here, in the last week or so, that gave the means of retrieving the path to the current database. That wasn't the main gest of the posting, but mentioned it in passing. Can't remember the context (not that it matters...
  9. missinglinq

    Running multiple reports from one command button

    Sorry, search function here is still down for maintenance! I'm finishing up a small app and the users request that rather than have a separate command button to print each report that a single button be used to print all monthlies. I seem to remember reading that a DoEvents needs to be inserted...
  10. missinglinq

    Report rounding numbers

    Never had occasion to use decimals in reports before! Why is a number, defined as a Single, rounded when it appears in a report? For instance, number appears as 169.5 in form and table, but appears in report as 170? Thanks! The Missinglinq Richmond, Virginia There's ALWAYS more than one way...
  11. missinglinq

    Access 20007 online testdrive

    This is kind of unusual, but since it's about a potentially really bad thing I thought I'd put it here. A poster on another forum took the Access 2007 online "testdrive" today and since has not been able to open up any of her Access 2003 databases. The real kicker is that M$ offered the online...
  12. missinglinq

    Two forms showing with DoCmd.Maximize?

    I'd like to use acCmdAppMinimize with two forms on the screen at once. Currently, if I have a form opening the db (with DoCmd.Maximize in the OnLoad event) and then a popup form on top of the first form, the first form vanishes when the second form appears. Alternatively, I like to have both...
  13. missinglinq

    Manually position form

    I've got a reference that I've used before that states to manually position a form you need to: 1) Have Autocenter set to NO 2) Have Resize set to No 3) In Design View position form where you want it 4) Save and exit Design View without doing anything else I've tried this and every permutation...
  14. missinglinq

    Cancel saving of new record

    Trying to help a friend with this, so I'm kind of stuck with some of the things here. He wants to goto a new record, enter a PtID then check to see if there's already a record for the data entered. It it already exits, he wants to cancel the new record and go to the existing record; if not he...
  15. missinglinq

    Cannot protect against emerging threat

    Booted up and got that message this afternoon. Clicked on "Protect Me" and wennt thru the Update Virus Definition routine. Got an error message stating "Can't update definitions...Please run Live Update." Did that without any problems, rebooted (twice, actually) and still getting same message...
  16. missinglinq

    Six viruses in one Mozilla Cache file

    I’ve managed to go 15 years and only pick up one virus in all that time. Ran NAV this am and came up with 6! Investigation showed that a house guess, without asking, went online and used IE, which I avoid like the plague! Naturally, Norton could not Repair, Quarantine or Delete the files! Tried...
  17. missinglinq

    Need to enter blank date in select query for update query

    I'm trying to select all records where a particular date hasn't been filled in yet, the object then being to do an update query on these records, and I can't figure out what criteria to use in the query grid for the blank date field. I've tried: ="" IsNUll #00/00/00# and even #//# with no joy...
  18. missinglinq

    PasteAppend won't work

    I'm trying to duplicate a record using the code below: Me.AllowAdditions = True DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.RunCommand acCmdPasteAppend Me.AllowAdditions = False I get a message that an error in the PasteAppend action has resulted in the data being...
  19. missinglinq

    ID'ing control with focus

    I need to identify the control that has focus, and place it on a label, i.e. MyLabel.Caption = XXX. What is the correct syntax for XXX ? Thanks The Missinglinq There's ALWAYS more than one way to skin a cat!
  20. missinglinq

    Curious problem with Conditional Formatting...

    I've got a single view form with text boxes. I just set the Conditional Format for all text boxes so that when the field has focus, the background/foreground colors of the field change. I have code in the Form_Dirty sub that makes visible two command buttons to save or cancel changes that have...

Part and Inventory Search

Back
Top