Threads Replies Last Post 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17   Eval() Question I am trying to use a function to instantiate an instance of a class and return the value from the method specified as a parameter of the function. I have tried a couple of ways and used debug.print to get the values of the different expressions at execution and have indicated the return values in comments in the code. I am using the function as the criteria in a query in the following ... 4 30.09.2006 06:36:21 how can i disable the Design button how can i disable the Design button in the application? thanks ... 5 30.09.2006 06:06:06 Convert Hex to Decimal Does anyone know of an easy way to convert a Hex number to a Decimal? These numbers would be large, with a typical length of 13-15 characters. Thanks!... 8 29.09.2006 19:57:42 Error6 - overflow - further post This is a multi-part message in MIME format. ------=_NextPart_000_0081_01C6E2E8.7CF419A0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hello All Further to my post dated 11 Nov, to which I received a number of useful = responses from Doug Steele, John W. Vinson and Robert Morley, (many = thanks to you all), I think I now know the cause ... 2 28.09.2006 10:27:53 DoCmd.OutputTo I'm using ms access 2003 (ADP) vs SQL Server. I created a module using the method DoCmd.OutputTo to export a view to Ms Word. It works fine, but it needs improvement. I have two questions. 1. The columns width is not properly. I would like increase the column with. How can I do programmatically? 2. I would like create a Template with the logo and landscape format and then export t... 10 27.09.2006 01:13:42 Snapshot Viewer PrintDevice I have a series of .snp files, each containing the Sales Statement for a particular customer. Some customers object to receiving a snapshot report, so I am attempting to convert their files to PDF using pdfCreator. So far, I have been unable to change the Print Device for the Snapshot Viewer - the alternative would be to have a marker on the index file and create the original print as ... 2 26.09.2006 11:49:03 Info: download mdb module for creating internal documentation Hi, i've created a selfcontained module (tested with Access2003) for download which allows you to document your systems (done via two tables) here a short description: '####################################################################################### ' mdlCreateObjectListingInTables '####################################################################################### ' ' Att... 1 24.09.2006 23:38:26 Insert photos Hello How could I insert a photo on the database and show it in a form? I have created an OLE object and try to insert a photo but I don´t success showing the picture in the form, I can only open it clicking twice and see the image but not surfing form one record to another. Thanks for all ... 3 24.09.2006 20:15:42 Re - order Level I am trying to incorporate a re-order level function within a database I am designing and need some suggestion / advice.... I have a function "Onhand" which gives me my current stock total. I have added a new field in to tblproducts called reorderlevel which is where the user can enter a number at which reordering should take place. e.g. StockTotal= 10 reoderinglevel =10 item ??????? ... 3 24.09.2006 17:12:01 ByVal and ByRef Can anyone explain when to use these two terms in English? I like to think I am a pretty smart guy but I just dont get it when it comes to these two................ Thanks!Mark... 16 24.09.2006 01:00:50 Format a Control in Continuous Form Hi, I have an issue in a continuous form in MS Access 2003; I will appreciate your assistance in it. I have a control in a continuous form where I want to currency format it, in each row, different than another. In other words, I want the first row to display the amount in US Dollar format, the second in sterling pounds format and so on. Is there a way to implement ... 3 22.09.2006 19:32:29 Database Properties / Contents Once in the past five years, I have been successful in updating an AS/400 file using an Access database. Unfortunately I cannot remember which PC it was on or who the client was. I therefore need to develop a program to search all the modules and class modules in each of the databases on each computer - which would be VERY tedious. As a (more interesting) alternative, does anyone know ... 4 22.09.2006 15:13:54 'Database' not a valid data type?? Very simple data file in Access 03. Single table, one form to manipulate some data and export to text file via a Print #1 routine. Here's the issue: Dim MyDB as Database is not a valid data type. After typing the AS, my options go from DataAccessPages to DataTypeEnum. Now in another database, I have used this Dim statement repeatedly and successfully. Why would I not have this opt... 3 20.09.2006 17:31:01 Stock Value Calculation I have the following code which gives me my stock quantity .... Function Onhand(itemCode As Variant, Optional vAsOfDate As Variant) As Long 'Purpose: Return the quantity-on-hand for a product. 'Arguments: vProductID = the product to report on. ' vAsOfDate = the date at which quantity is to be calculated. ' If missing, all transactions a... 1 20.09.2006 10:13:43 how can i detemine by code the ODBCConnectStr of a specific passthrough query how can i detemine by code the ODBCConnectStr of a specific passthrough query? thanks ... 2 20.09.2006 06:54:46 String HELP!!!! Help! My string continues to return a value of Zero. I loop through a list of specialties. Say I select Cardiology. Then when I select Option10 that report should open with just the Cardiology detail. Why am I getting Zero rather than the value I selected? Here is my code: *****'Loop through List to see what Specialties were selected***** For Each varItem In Me!SpecialtyList.Item... 6 19.09.2006 20:29:24 Do Until... Help Please! Hey Guys (and Gals), Having fun with Do Until statements, can't get this one to work... What I want is if you double-click on one field then clear the contents. What it's doing is asking you the question 9 times instead of just the one you double click on. Hope that makes sense. Can someone help me? Thanks in advance, Gina Whipp Public Function ClearViolation() Dim LabelNum... 12 19.09.2006 18:55:31 Error6 - overflow Hello All I have a complex module which runs fine 95% of the time. The other 5% I get "Error6 - overflow" - then the module 'seems' to proceed OK. I tried putting a breakpoint in the module (with F9), then doing F8 to proceed one row at a time. I thought this would point me to the place where the overflow occurs. I found that the module entered a loop and seemingly could not get out - no m... 14 15.09.2006 15:16:01 Action: TransferSpreadsheet, Transfer Type: Import I have a Module which uses TransferSpreadsheet to imports an Excel file and it works fine, however I want to import multiple xls files which are all the same just with different data. What I would like to do is to use a Module that imports all xls files in a directory, this way I don't have to import one file at a time and then I can save the file to another directory for reference. The... 7 14.09.2006 23:16:43 Time out on message box? Hi. I have developed an Access application which gives quite a few "Ok" messages after the user have completed different tasks. My users are kind of "click" tired, and I wonder if it's possible to show an MsgBox only for a second before it disappears automatically? Any hints appreciated Kind regards Mr. Smith ... 4 14.09.2006 19:10:42 access97 to 2003 Hi all. I am in the process of updating an access 97 database to access 2003. Unitaddr is a linked foxpro table. I am looking for the city based on the field unit in that table(this is the numeric representation of a location). The following function worked fine in 97, but will not compile in 2003 on the rs.city line. Function fnCity(RUnit) On Error Resume Next Dim DB As Database Dim... 6 14.09.2006 13:32:00 RECALC in a subform shut's down the application without raizing any error messeg in some computers command RECALC in a subform shut's down the application without raizing any error messeg. what is missing? thanks ... 1 13.09.2006 20:11:12 helpfile in msgbox (A conclusion) In the folowing code I noticed something wierd happened. First. The myfile.hlp is it is in Greek letters prompts for help location only once. When You entered the location and you don't change it then never again prompts. Second. If the file location is in network drive for example \\myserver\myfile.hlp etc then even if you use Latin letters not Greek leters it prompts for new location. ... 1 13.09.2006 16:17:13 helpfile in msgbox I have a code where I define where exactly the help file is (by default in current directory where the database is). In the forms in the help file field there is no problem Event when I change the location of the database. On the contrary on msgboxs the help file can't be located. Once I redefine the location then it's Ok. MsgBox("Show message", vbCritical + vbYesNo + vbDefaultButton2 ... 3 12.09.2006 21:38:37 Exporting Text in BLOB field to tab-delim text? [Access newbie] I'm trying to export legacy data from an Access 2000 database to tab-delim (en route to cleaning it in Excel). I've problems as some text won't export as it was stored in BLOB fields. Why I don't know - it's only small amounts of plain text - 3-4 paragraphs at max. I'm wondering if I could add a new memo field to the table in question and then iterate the table using ... 21 12.09.2006 16:10:08 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17