General

if first digit of a WO is A or to Z...then substract first 5 d
thanks Bruce, the code works fine.. Thanks again. -- Lorenzo Díaz Cad Technician "BruceM" wrote: I can't see how this would work. If the first character is D you extract the leftmost five characters, which include the D. However, if ScanWO is always six characters you could use the Right f... 1 Jul 2008 13:22

Requery in Access 2000
I need to update a combo box and have the following code working perfectly in Access 2007 Private Sub Manufacturer_AfterUpdate() DoCmd.Requery "Manufacturer" End Sub In Access 2000 it comes up with error message Run time error 2488 You can't use the Apply Filter action on this window I need this to run on ... 3 Jul 2008 06:21

getting top result for only some records in a query
I have a query with the following fields and sample data Id-----Exam-----Score 01-----M-----70 01-----S-----65 01-----H-----90 01-----H-----95 01-----M-----72 01-----M-----97 02-----M-----65 02-----H-----79 02-----H-----81 02-----S-----81 02-----S-----72 I would like the query to only show the top resu... 2 Jul 2008 11:54

OpenReport using macro
I would like to open a report based on 3 items on a form When a button is pressed, I would like a macro to look at the current id, date (short date), and assess # and access that page only on the report and print it right away. I can't figure out the where condition using 3 criteria. The id is text, the date is d... 1 Jul 2008 18:31

if first digit of a WO is A or to Z...then substract first 5 digit
this code works perfect if the first digit is "D" but how I make it works with any letter, example from A to Z? If Left([ScanWO], 1) = "D" Then WOnumber = Left([ScanWO], 5) Else WOnumber = Left([ScanWO], 6) End If Thanks -- Lorenzo Díaz Cad Technician ... 2 Jul 2008 02:41

Repeat fields from last record
Access 2003 I have a form with many fields most of which are based on a table. My client would like these fields to be defaulted from the last entered record. Should I use Defaultvalue property for each field? If yes, how to get last record without disturbing current (new) record ? TIA -- AP ... 2 Jul 2008 08:48

User-defined type not defined
Hi, Th ebelow code is working fine in a database,i tried to copy and paste it in my database but it gives me error "User-defined type not defined" Dim mess_body As String Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Set appOutLook = CreateObject("Ou... 1 Jul 2008 13:22

Change Query on a Form OnOpen
I'm trying to recycle a form, rather than copy it and just change the data source. What I have done on an OnClick Event is the following (which isn't working!): Private Sub SeeSelected_Click(Cancel As Integer) Dim stForm As String Dim stQuery As String stForm = "ProspectSearch" stQuery = "WHERE ProspectTable... 2 Jul 2008 13:57

Adding an attachment in Access 2007 with code
Hi, I'm trying to add a record to my table that has an attachment via DAO. I can't figure out my last step here. Here is my code: Private Sub SaveTheRecordClick() Dim dbs As Database Dim rst As DAO.Recordset Dim rstComplex As DAO.Recordset2 Set rst = dbs.OpenRecordset("Current Issues", dbOpenDynaset)... 2 Jul 2008 02:41

Image to appear on certain subform records
I have a form with a subform. I would like a small image to appear on records of the subform that meet a certain criteria. Is this possible? ...Let me rephrase, I'm sure it is, but what would be the best way to do it? ... 1 Jul 2008 11:18