Threads Replies Last Post 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17   Eval Function Dear all, I have a problem with eval function with the code like this : ?Eval("IIF(3>2,10000,0)+4,5") 4,5 means 4.5 The user choose regional settings which "," (comma) as the desimal separator. Thanks for helping. Vensia ... 8 10.12.2005 22:09:34 Case Function Hi I am a newbie and am trying to get my head around Case Funtion naming and syntax. On a form, - Form1 - I have an Option Control OC1. The user can select option 1, 2 or 3. I then want to use the results in say a report In the report On Open, I would have: SELECT CASE Forms!Form1.OC1 Case1 Commands Case 2 Commands Case 3 Commands End Select Is this correct... 6 10.12.2005 19:48:17 Code signing I am running into this for the first time and have a few issues:- 1) I have a development PC with both 2002 & 2003 office BUT Digital Certificates only appear in 2003 2) Once I have signed the code in 2003 I can no longer edit in 2002 3) Once the code was signed a line of code no longer ran on a client pc under 2002 If Me.Subform1.Form.Module.Find("Recchange", lngSLine, lngS... 1 10.12.2005 08:46:39 Connection to database Hi, I have a access database that I inherent from a coworker who left the company. I have been try to use this database but the problem is that this access is connected to back end sql server, I will like to have a local machine back end instance of a sql server. Is there a easy way to break the connection to the sql server, because I will prefer to make a copy of the sql server back end... 2 10.12.2005 08:30:56 How to call function in *.dll file Dear all, I have a dll file in folder c:\windows\system. The dll file name is ValidateCust.dll How to call the function in the dll file using VBA code? Thanks. Regards, Vensia ... 6 10.12.2005 02:46:07 Consolidating data I was wondering if there was a way to pull in the information that I have stored in a comments table(tlbcomments) and combine all of the comments into one string? Each comment is linked by a field called wonum. I'm just barley above the novice level on access and wondered if I could use a function to combine these items so it could be pulled in queries and on reports. Thanks Br... 11 09.12.2005 14:14:56 Control Word userform from Access Hi everyone I need help sending a text string to a texbox in a Word userform. I can call the Word macro to open the userform but I can't paste or send the result of a string into the textbox even though the cursor is flashing in the box. How do you access the objects in the userform assuming the userform name is Userform1 and the textbox is Textbox1? Can it be done? Thanks in advanc... 2 09.12.2005 12:25:50 Credit Card Verification I have an access app that I would like to add an onlostfocus event to a creditcard number field to make sure it is a valid number before committing the data. We batch process so online verification is not necessary. Has anyone done this for access, I see a lot for the ASP world and javascript. -Dan I found a class function in ASP and vbscript but do not know how to add it to access. h... 4 09.12.2005 01:28:37 Fill Fields automatically on a form I have 2 tables I would like to fill two fields on form based on two tables The tables are shown below with the pertinent fields. tbljournalentrytemp (Producercode,ProducerName,Expensecategory) tblProducer (REC,ProducerName,Expensecategory) REC = Producercode The user enters a producer code on the form which is bound to tbljournalentrytemp. I woul... 1 08.12.2005 04:19:53 appending varchar parameter to ado command I have a problem with appending a varchar parameter to a prepared ado command. It returns an error(number 3708). Which states that the parameter object is not properly defined and the information is incomplete or inconsistent. I have tried with every varchar type there is in Access VBA. There is no problem with appending any numeric(integer, single, double, etc...) parameters. The parameters ... 5 07.12.2005 14:14:11 Open an external Database and run a function Hi i want to be able to open another database (2) in code from my current database (1) and when the other database opens (2) i want it to run a function in that other database (2), then close that other database (2) leaving me to continue using my current Database (1). Can anyone help how i would code this in a module. Thanks in advance... 8 07.12.2005 02:48:23 MSDE and Replication Thanks in advance for your help. Does MSDE support replication to and from an access database? thanks again ... 1 07.12.2005 00:32:23 Form instance without hard coding Howdy, Does anybody know a clever way to create an instance of an access form without hard-coding the form name? This works: Select Case FormName Case "frmPracticeEditAdd" Set frm = New Form_frmPracticeEditAdd End Select But, how can I make this work (air code that really, really doesn't work): frm = New "Form_" & FormName I hope you get the idea... 19 06.12.2005 18:48:26 getting data from inserted record Hi, I use adobc.command to update my database. What i would like, is to get data from the inserted record created with the command. I do it with a insert ...values() statement. The intention is to find out what the values are of the fields that are automatically filled in by a sequence. I know how to do this in SQL Server, but not in Access. It's totally in Access, the database does not have... 2 04.12.2005 06:27:22 DotNet As Late Bound Automation Server I have a vb.net application in which I have used global variables. I converted it to become a late bound automation server (it is a dll now), where I simply want to call it from an Access application and run it. To my surprise, when the Access app calls the application with CreateObject, it works fine the first time. Then I set the reference to nothing. Then I run it again, and all the... 2 02.12.2005 19:56:31 Sub/Function name of last sub/function ran I have a general error handling function that gets called from most of the subs/functions within my application and autosend an email from within the error handler. I would like to know from which sub/function the error handler was called so I can have this info without having to change the error handler to accept another input value of the name and updating all the existing subs/functi... 10 02.12.2005 09:54:07 how to change a query property with VBA I would like to change the "Destination DB" of a make table query with code. I'm sure it's simple, but I develop mainly in Excel. Thanks in advance for your help. Ken Valenti ... 2 02.12.2005 03:32:52 ahtCommonFileOpenSave function to open in thumbnail view Hi I use the ahtCommonFileOpenSave function (from http://www.mvps.org/access/api/api0001.htm) to open the windows file browser. I am using this to select photos to download from a digital camera to then link to the Access 2002 database. The code works very well however I was wondering if it is possible to open the windows file browser in "Thumbnail" view by default as this would make ... 1 02.12.2005 01:31:03 Call DotNet Application From Access - Cannot Release Dotnet Application Help! I cannot get my DotNet application to shut down as an automation server from Access. I have the following simple code in Access that I am using to call a VB.NET application: Dim w As Object Set w = CreateObject("MyProgram.MyProgramClass") w.MyProgramDoSomething Set w = Nothing I have tried many things in DotNet. The final lines of the applic... 1 01.12.2005 18:31:27 Coalescing date ranges Hi all, First, sorry for cross-posting, but as I have flexibility on how I do this, I thought I'd post it to the two most-relevant groups. I can do this either server-side, using a stored procedure, or I can do it client-side using VBA. The recordset is only a few thousand records, and we all have at least 3M down/800k up DSL if not 10/100 LAN connections, so client-side isn't really ... 4 29.11.2005 18:59:45 Question re FILE Hello all. I am accessing a text file containing a int number representing the current tax percentage. in case the file exits but 1. is empty 2. it doesn't contain a required plain number (between 0 and 100) I would like raise an error err. raise (1234) " File not correct" - If file is empty I get an error here: Line Input #1, Line my question: how do I ask for ' file is emp... 3 28.11.2005 14:16:57 Run Time Error 3134 I am trying to run some sql and I get the following error: Syntax error in INSERT Into Statement... can anyone advise me and what is wrong with the code below: Function DoSQL() Dim SQL As String SQL = "INSERT INTO tbl_change_inactive.fk_memebership_number.change_inactive" & _ "SELECT tblPersonnelDetails.PK_MembershipNo.tblPersonnelDetails.inactive" & _ ... 5 25.11.2005 08:40:04 code stops at previous breakpoint - code is highlighted I've seen this a problem on various mdb databases (very infrequently) : the code stops with the code line hightlighted but this isn't a breakpoint. Occurs even after the mdb is closed and reopened. Looks to me like access is "remembering" an old breakpoint. Could this have to do with editing and continuing? Am I crazy or has anybody else seen this? Any suggestions to solve? Only... 4 24.11.2005 19:03:34 Digital Signature Problem I am upgrading an Access 97 mdb to a new version that will be used by people with Access 2002 and 2003 and am attempting to assign my own digital signature so that the 2003 users won't have to see the prompt if they have their security set above Low. I applied the certificate using 2002, created an MDE and when I open the file using 2003 I get a message that the certificate is invalid or... 3 24.11.2005 01:43:48 Help? Concatenating fields which include null values I have a SQL statement that concatenates several fields into one for search purposes. I've run into an issue with null fields. The final field has nothing. Short of cycling through the records and replacing null values with a space, does anyone have a suggestion to get around this? My statement as is: strSQL = "SELECT *, ([Name] + ' ' + [Add1] + ' ' + [Add2] + ' ' + " & _ "[... 18 23.11.2005 02:05:33 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17