Threads Replies Last Post 225 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Coding the "yield" function in Access Hi there. I would like to calculate the yield of some bonds in my Access database. I thought I could use the "Automation" of Microsoft to calculate these yields through Excel, but it is a very long process, and my Access database does no more work correctly with so many calculations through Excel. So I need to build my own Yield function in Access. Many people probably already did ... 1 30.09.2006 19:14:04 ErrMsg: The MS Jet DBEngine stopped the process because you and an Hello I am intercepting the Delete action with KeyPreview and running a process on the selected records. How can I release an object (table) having Set the object to a variable and enumerated the selected records to memory, I have Set the variable to Nothing at the end of my code but I still receive the above message once when I hand back to the BeforeDelConfirm event. TIA Simon PS. ... 5 30.09.2006 18:07:01 Set Focus removes text from text box? In my form When I use SetFocus on a text box in the "Keyup" event I find that I can only enter one single letter into the text box. If I try to enter the next letter of a word or name, the first letter disapears! Probably because my text box "updates" with the form. I need to have each character entered into the text box remain after each update until they are deleted or backspaced ou... 4 30.09.2006 17:38:01 Comparing datasheets I have a main form with two subforms (both in datasheet view). Both have the same columns. I need to compare the data from the two datasheets to catch any differences between them. The problem is that these subforms can have hundreds of rows and there are 14 columns in each subform. To give a bit more detail. The left subform has data that will be imported, the right subform has data th... 3 30.09.2006 15:58:30 Extracting Folders... I have and extensive collection of CD/DVDs of my digital photo archives and would like to automate extracting the contents to place it into a searchable database. The only data other than the sequencial file names are folder names. So instead of naming each of the thousands of photos they are placed in folders with the date they were taken. Then what we end up doing is renaming the folde... 2 30.09.2006 15:08:35 Compare recordsets I have a form with two datasheets (two subforms in datasheet view). I need to compare the data between them, they both are based on different queries but the columns in both are the same. I need to indicate to the user if both lists are the same. How can I do this? Ray... 6 30.09.2006 14:39:58 Date Calculation Programming Challenge I am working with a Microsoft Access Database helping a non profit organization try to figure out how many nights in a month people are staying in there shelter. I have two fields a Check In Date and Check Out Date Field. Therefore to figure out the nights a person stayed, I minus the Check Out by the Check In Date. The problem is if they check in the prior month, let’s say Febru... 3 30.09.2006 13:46:10 Reading Database Property Values I want to be able to verify the value of a custom property for my database. I have an application that I want to be able to set either as a single or multi-client version, and to verify which version type it is. I am using Access2003 and the help shows how to add and delete, but not view the value. Thank you... 3 30.09.2006 07:02:01 The MS Jet DBEngine stopped the process becasue... Using KeyPreview I am intercepting the user when he/she keys Delete (KeyCode 46) and running some code to enumerate the records in the dynaset in which the records are being deleted. I have to enumerate the records before Access removes & buffers them during the BeforeDelConfirm event. Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) 'intercept delete key and enumer... 6 30.09.2006 06:09:26 populate previous fields Hi all, When I enter 65 in totalday's field for month 3 I'd like 65 distributed 30,30 and 5 for month 3,2 and 1. formula is so: (65=30+30+5) Fields: name month totalday workday Records: jack 1 5 jack 2 30 jack 3 65 30 would you please help me? ... 6 30.09.2006 03:50:38 Filter a report I have a report that I want to only display the records where PerslNme is not blank. I would also like to know how to display only the records that are blank. There are other fields in the report so knowing how to filter for the blank/null value on that field would also be used and useful to know. The report name is NMEList. Thank you.... 2 30.09.2006 03:43:23 Set msgbody = report variable Hi, I need to send a report that is in my Access database as the body of an email. The following code works to send an attachment but for some reason when I dim a var for report object nad trying to set the message body to the report var I am not having any luck. :-( I cannot use docmd.sendobject because it causes Outlook to prompt for the user to enter their exchange server login a... 4 29.09.2006 21:05:02 Calling a function to fill (update) field value in query/table. Hi everyone I wrote a simple function that picks the value based on the selection criteria (See below) When I try to use it by putting it with field values as arguments e.g. GetLevel([SerialNumber]), Access gives me a compile error. Any help would be very appreciated. Thanks EM Public Function GetLevel(lngSerialNumber as Long) As String If lngSerialNumber = 1113 Or lngSerial... 9 29.09.2006 20:11:02 Excel add in functions not working when being opened through acces Hey all. So I have a procedure I run in access, that in part of it, opens excel, and runs a macro from excel. However this uses the function 'networkdays' which is an excel add in. When I run the code from excel directly it works fine...but when access opens it, it does not recognize any add-in functions. Is there any way around this?... 8 29.09.2006 19:46:02 Reference User Profile I'm trying to reference the current Window's user's desktop with some code; I am using the following: C:\Documents and Settings\%userprofile%\Desktop When I run the code I get a "Path not Found" message. Just to test, I took out "%userprofile%" and inserted the actual user name and the code ran fine, so I'm almost positive that that's the problem. Is that not the correct way to ref... 3 29.09.2006 19:43:02 Len Validation Rule How to make validation rule for textbox; min. 8 and max. 10 characters? I try with Len function but not work... Len([Text0])<8 And Len([Text0])>10 Thanks!... 8 29.09.2006 19:41:13 Use VBA to create a graphic from a picture in a table I have a table with a field defined as "OLE Object" which is populated by ..JPEG images that were pasted into the database, rather than a link to an external file. My question is if there is a way I can write code to take that image in the OLE field, and create a .JPEG file, name it and create a directory file. ... 9 29.09.2006 19:34:20 Check for dependencies, before deleting field from table I want to delete a field from a table (i don't thing that it was ever used). Is there a routine that I can run that checks if any objects (e.g., query, form, report) depend on this field? Don't want to delete the field and then find out later of dependencies.... 1 29.09.2006 19:21:03 Union Query Report Code ?? I have a small business that I run, and I have used Service Time Management wizard to build my database, with some personal changes due to the personal preference and requirements. I am right now stumped at creating a report from a query that sends out notices, ie 1st, 2nd,... for payments. The problem is that I know that there is a way to have a "template" report for all the notices, ... 1 29.09.2006 18:31:01 Function/Subroutine Pointer Parameter I would like to pass a pointer to a function/subroutine written in VBA (I know you can pass one to a builtin DLL routine) and run it with data specified within the calling routine. Let me flesh it out a bit more for you with the following code: Public Sub DoIt(TableName As String, Optional CodeStub As Integer = 1) '== Skeleton code for processing all records in a table Dim db As Data... 2 29.09.2006 18:28:19 Append query is slow! Would VB be faster? Takes over 5 minutes to run. Would coverting the query to VB to quicker? There are a total of 300,000 records being processed. ... 6 29.09.2006 17:35:35 Implementing Viescas' SendOutlookMsg Module I have found this module to be tremendously useful, and it works just fine as long as I use the objMail.Display option. If I change to objMail.Send, the email has no body. The To: and the Subject: are there, just no email. Using objMail.Display and then objMail.Send works, but not objMail.Send by itself. I would really like to use the ..send alone as it would allow me to implement some ot... 1 29.09.2006 16:32:28 Remote Database Closing. New problem for me here. I sometimes have a need to have exclusive access to both front and back end content. 1. Is there a way that I can shoot a message (as in a timer) that will say something to the effect "The database will need to come down in 1 minute for routine maintenance." 2. If anyone walks away front there PC while logged in....can I setup a way to be able to close ... 2 29.09.2006 16:08:01 Global variants Hi, I need a little help. I have two procedures in my code: Private Sub Form_Open(Cancel As Integer) ..... Dim Arr() As Variant ..... End Sub Private Sub Form_Close() ..... End Sub In the first procedure I create and populate an array. How can I use this array in the Form_Close procedure? Is there a way to define global variants? ... 3 29.09.2006 15:52:02 How do I set global variables in an Access Database Project(ADP)? I'm using Access with SQL Server 2000 to develop a database, and want to set global Transact SQL variables, but I don't know how. How do a set a variable that can be seen by any query, etc., in the database ? -- -- Paul Anderson... 2 29.09.2006 15:50:01 225 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>