Search results for query: *

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

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

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

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

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

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?