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

    .ade file doesn't allow popup forms

    I have following script behind a button on a form: DoCmd.OpenForm "fMobile_PUK_Finder" The form "fMobile_PUK_Finder" has property popup: Yes. When the access file is an .adp file, command runs OK. When I convert the .adp to .ade, the popup form doesn't open. Actually it opens but remains...
  2. Natha2

    SSRS newbie needs some tips

    Hi, We are a telecom company, and have to create once a month an invoice for all of our customers. An invoice consists of a first page and one or more page with call details. Currently, we create snapshot files (.snp) for every customer from Access reports via vba script. Those snapshot files...
  3. Natha2

    Changes in Web Site Administration Tool raises error

    Hi, I am a new user of Visual Web Developer 2005 Express Edition. In Web Site Administration Tool, every try to change something on Security tab or Application tab, raises following error message: Attempted to perform an unauthorized operation. at...
  4. Natha2

    Requery and Bookmark do not relocate me to current record

    TheAceMan1, "Me.Recordset" doesn't support the method "FindFirst". It returns run-time error '438'. Anyway, FindFirst will maybe find the right record in Me.Recordset, but it will not position the form to that record. In order to do that you must use Bookmark. The only problem remaining is...
  5. Natha2

    Requery and Bookmark do not relocate me to current record

    TheAceMan1, "Me.RecordsetClone" is not supported by DAO.
  6. Natha2

    Requery and Bookmark do not relocate me to current record

    PHV, No success with your code either...
  7. Natha2

    Requery and Bookmark do not relocate me to current record

    Hi TheAceMan1, I tried your solution and got same result as I described. It appears that when bookmarking, it takes a time to the form to load the data completely. Very strange. So what I am doing is looping around until form is completely loaded. (it takes less than half a second) After...
  8. Natha2

    Requery and Bookmark do not relocate me to current record

    I am having a form in adp (access project with SQL Server as backend). In order to refresh the form to view data eventualy changed by other users, I have on the form a button with following "on click" event: Dim varBkm As Variant varBkm = Me.Bookmark Me.Requery Me.Bookmark = varBkm Data...
  9. Natha2

    Get Requery to return me to current record

    I tried the suggestion of danvlas, without success: I am having a form in adp (access project with SQL Server as backend). In order to refresh the form to view data eventualy changed by other users, I have on the form a button with following "on click" event: Dim varBkm As Variant varBkm...
  10. Natha2

    Use Result Set Column Names in same SELECT?

    Hi, Following statement returns an error: SELECT AMOUNT_A + AMOUNT_B + AMOUNT_C [+ ...n] AS AMOUNT_TOT, AMOUNT_TOT*1.21 How can I overcome this problem? I need to do this for far more complex calculations, so it is quite critical not to do it as follows: SELECT AMOUNT_A + AMOUNT_B + AMOUNT_C...
  11. Natha2

    Combo Box limited to 10,000 records?

    I should have around 11,000 in combo (according to query), but it displays exactly 10,000. No more. I have experienced no loss of performance. We work on Office XP SP3.
  12. Natha2

    Combo Box limited to 10,000 records?

    Is it possible that a combo box can contain no more than 10,000 viewable records (even that the RowSource query returns more than 10,000)? This is OK if "LimitToList" is set to "False". But if "LimitToList" is set to "True", we have a problem. Anyone some feedback? Thanx...
  13. Natha2

    Button Find and Find Next in form/subform

    Hi, We are a telco and have an Access project that manages the customers and their telephone number(s). I have a main form with a subform in it. The records in main form (customers) come from one table and are unique. The records in subform (telephone numbers) come from another table. A...
  14. Natha2

    EXCEPTION_ACCESS_VIOLATION

    Trying to export from SQL table to txt file with dynamic property for txt file name, and using some global variables for defining criteria in source query. There is also some ActiveX VB script to pass global variable to dynamic property. When running, package fails on Transform Data Task...
  15. Natha2

    Run-time error '13'

    Hi, My form contains an unbound textbox named "txtFind". User is supposed to enter a customer id number and type 'enter'. Event behind "txtFind" is: Private Sub txtFind_AfterUpdate() Dim rs As ADODB.Recordset Dim x x = DLookup("Customer_nr", "CUSTOMERS", "Customer_nr = " & txtFind) If...
  16. Natha2

    Cancel Report on No Data in subreport. How?

    Hi, Can anyone tell me how to cancel a report containing 2 subreports when BOTH subreports have no data? (Both subreports are linked to the main report's data, but exist independently one from each other.) Thx, Natha
  17. Natha2

    Multiple Selection in Continuous Form

    How would Multiple Selection (record or column) be possible on a Continuous Form (using Shift+click or Ctrl+click)? I cannot use datasheet view since that Continuous Form contains a SubForm. Or can I?

Part and Inventory Search

Back
Top