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

  • Users: Aerin
  • Order by date
  1. Aerin

    Dynamic parameter

    Hello All! Maybe someone had the same problem and could help me to resolve the mistery? I created the dynamic parameter in the report, the list of values populated from Command data source. Not linked to the main data source. (like list of cities, countries). Plus i have a static parameter...
  2. Aerin

    Continuous Forms & Recordsets

    Check the default view property of the form. Probably you forgot to change it from the single form to Continuous form? Why do you think that VBA method is normal?
  3. Aerin

    open new form in the same window

    Change the settings for the MS Access database Menu Tools ->Optios->View tab. The box Windows in Task bar or I do for my databases to change this option on customer's computer in any start up function If Application.GetOption("ShowWindowsInTaskbar") <> 0 Then Application.SetOption...
  4. Aerin

    DLOOKUP HELL??

    Where you have this Dlookup? in the main form ? in the suform? =DLookUp("[PO No]","POtoLOTtbl","[Lot No] =" & [Forms]![MainForm]![SampleChemistry].Form![Lot No]) or if your Lot No is txt field =DLookUp("[PO No]","POtoLOTtbl","[Lot No] =""" & [Forms]![MainForm]![SampleChemistry].Form![Lot No]...
  5. Aerin

    Insert Picture Access 2003

    Hi All, I am starting to use MS Access 2003, the orginal application was created in XP version. When I insert the picture it is no longer insert it like a pictre, it inserts it like a package and I can't see the preview. :( What's wrong for 2003 and good for XP? On Error Resume Next Dim cdlg...
  6. Aerin

    The search key was not found in any record!

    Strange, but nothing. I tested the code on one record all the time and when I changed another record, it was working and working with all records accept one record. I deleted it and now everything works. I am just afraid that something was really blocking the record and could happens again. So...
  7. Aerin

    Bound or Unbound form. What do you think?

    Hurray I am not along :) The reason for this thread was that it is not the first time in my practice, when I see unbound forms solution from programmers with many years of experience. It was strange and I thought probably something exists that I cannot see :) "Difficult to manage BeforeUpdate...
  8. Aerin

    Bound or Unbound form. What do you think?

    ineuw (MIS) Aug 9, 2004 wrote: Unbound forms give greater flexibility for the programmer and the user. In both cases, it's easier to evaluate the data before saving it. I can branch off to numerous public functions to evaluate and calculate prior to saving, without blocking other users' access...
  9. Aerin

    auto populate field

    interesting :) Lets think First we probably need to find out the today's day number dim i as integer dim NextDate as Date i=Weekday(Date()) ' then compare to know did we missed thursday or tuesday, right? if (i < 3) then NextDate = DateAdd("d", (3-i), Date()) end if if (i >= 5) then...
  10. Aerin

    Autoselection in ListBOX

    Probably... dim l as Long If CordLB.ListCount > 0 Then CordLB.SetFocus l = CordLB.ListCount CordLB.ListIndex = l-1 End If
  11. Aerin

    How do I make the form visible again?

    Hi Steven, Do you have any code for making the form not visible? or closed? nothing from the code that you posted is making the form not visible
  12. Aerin

    The search key was not found in any record!

    The AceMan1, :)))))))))))))) I know, I wasn't going to change it. I didn't understand your question properly. I have the table with patients and their id number is autonumber. Then I have Claims table and there SURE the id field is numeric :) This Claims table has a key with two fields...
  13. Aerin

    Reset text box to empty state

    Hi ineuw, Could you tell me why the unbound forms are more preferable for you? It is not first time when I see the solution like you use and can't understand why it is better to use unbound forms if your server and client applications created in MS Access? Regards, Aerin
  14. Aerin

    The search key was not found in any record!

    Yes, it is autonumber and the message was the same " The search key was not found in any record
  15. Aerin

    The search key was not found in any record!

    Help! I am completely stock on it :( I enter the data and save the record and it works fine but when I go back to the form and try to change the field (key field) - I receive this type of message :((( I was try to create an update query and change this field there...Same message, even if the...
  16. Aerin

    Reset text box to empty state

    To correct the message above, before clearing the control you need to check its type. If it is text box or combo box then clear, if not just move to the next control. '---------------------------- Private Sub CommandButton_Click() On Error Resume next Dim objControl as Control For Each...
  17. Aerin

    Default values from table to subform

    Try Me.sfrRates.Form.RecordsetClone
  18. Aerin

    Adding successive records

    Hi Amadea, If I understand you properly, you want to use one form to view the data from the table and to add new information? Is your form based on InstrName table? if you have the form showing all instructors' details and combo box where you select the instructor to view his data, I suggest...
  19. Aerin

    Help on duplicating a record in table

    You could create the append query, using query designer and run it when the user will click on the button Repeat. To turn off MS Access warnings use the command: docmd.SetWarning False 'run the query docmd.OpenQuery "Query Name" 'don't forget to turn warnings back docmd.SetWarnings True
  20. Aerin

    Default values from table to subform

    write the public function(s) for defining the largest date in tables (DMax or create the recordset order by date DESC and take the very first one. DMax works slow, recordset could be not good solution for big tables and network databases)and put it to the default value property of the target...

Part and Inventory Search

Back
Top