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 derfloh 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. AlienRay

    CreatedBy

    Go to your Start menu, and select "Run". Type "regedit" in the Open box to open the Windows Registry Editor. Select HKEY_Current_User, and hit Ctrl+F to start a Find. Search for any entries with your name as the Data. (F3 cycles to the next entry). When you find a record...
  2. AlienRay

    expression too complex

    I don't know if this will help, but I have databases that get the "too complex" error if records are missing certain data. If, for example, it needs to evaluate the distance between StartTime and EndTime, but EndTime is null for one record, the query will fail. Try setting criteria on...
  3. AlienRay

    CreatedBy

    What about a Windows registry key? Is there anywhere in your Current User profile that your full name is stored? If so, you can write a module that will call the contents of the registry key.
  4. AlienRay

    Running query based on a specific time range. HELP!

    Is it possible that your records contain a single date and time stamp? (i.e., 10/14/03 17:30:00) If so, this time is not between 17:00 and 18:00, because short times would refer to Jan. 1 of 1900. If this is the case, then you need to add your Date and Time fields together, then check to see if...
  5. AlienRay

    Adding from the same textbox

    I assume you mean each record has a single value in this textbox, and that you want to sum the field entries for the entire table. In that case, a DSum function would probably be the easiest choice.
  6. AlienRay

    Slowwwww form

    Just curious; does the form HAVE to be bound to the query? Could the form be unbound, with the query results displayed in a table?
  7. AlienRay

    propulating a text box with an automatic date and user

    Set the form's AfterUpdate event to: Me![FieldName] = Now() & Environ("UserName")
  8. AlienRay

    Check Box Unusual Behaviour

    Are you checking to see if the value of the box is 0 or -1?
  9. AlienRay

    Start With A New Record

    Set the form's On Open event to: DoCmd.GoToRecord,,acNewRec
  10. AlienRay

    Best Place for Code to Repeat Input Values...

    I personally would attach it to a Command Button that would also contain the code for generating your New Record. I do see one potential problem with what you're doing. Your user fills out the form, then hits New Record, and all of the fields remain exactly the same. How does your user know...
  11. AlienRay

    Search Forms...Is VB really necessary?

    I do multiple criteria searches without any VBA all the time, just by setting up the proper query. Suppose you have a form with two fields: CityLookup and CompanyLookup. You want to be able to look up all customers in a particular city, all customers in a particular company, or only those...
  12. AlienRay

    Displaying Query Results on Form Locks the Records

    It may not be the list box that's causing the problems. Are you certain that your query produces an updatable recordset?
  13. AlienRay

    locking a field

    Incidentally, when the entry form is complex enough, I find it helpful to use two separate forms: one for new entries only, and another for viewing existing entries.
  14. AlienRay

    Question about combo boxes

    Use the DoCmds. You'll live longer...
  15. AlienRay

    Export data in Access form to Excel ?

    Sure, just make a report containing text fields which refer back to the form (i.e., "=Forms!MyForm!Field1"). Then, on the On Click event for the button, use this code: DoCmd.OutputTo "ReportName", stDocName That should do it.
  16. AlienRay

    Question about combo boxes

    What I always do is set up your combo box with the index field (usually called "ID") as the first column, and call it "LookupBox". Then all you need to do is set an On Exit event for Lookup Box: DoCmd.GoToControl Me.ID.Name DoCmd.FindRecord Me.LookupBox That should be all...
  17. AlienRay

    Date Sorting

    The formatting of the dates should be irrelevant. The only question is: WHERE do you want to sort it? In a query? On a report? On a form?
  18. AlienRay

    Having trouble populating a field from a combo box

    Alternatively, in the On Exit event of combo1: Me.text1 = Me.combo1.Column(1)
  19. AlienRay

    Having problems with DLookup

    It's possible the DLookup is waiting for a Refresh event. You could try putting an On Exit Refresh event on the SSN field. If it were me, however, I would scrap the whole DLookup formula. Instead, I'd make the SSN field a combo box with two columns: SSN and Name. The Name column would have a...
  20. AlienRay

    Force entry on field depending on value of combo box

    Sure, just set an On Exit event for the Comments field that reads something like: If Me.OrderStatus = "Completed" and Me.Comments is null Then MsgBox "Yo chump! You didn't fill out the Comments field!" DoCmd.GoToControl Me.Completed.Name End If

Part and Inventory Search

Back
Top