Recent content by Natha2

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

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

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

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

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

PHV, No success with your code either...

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

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

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

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

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.

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

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

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

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