Search results

Hi, I want to cancel opening of a report if it has no data. I've tried the suggestions on the forum viz. use macro with msgbox & cancel event / use VBA code with cancel = true No matter what I do ( on error resume next , error trapping, set warnings) I still get the message : "OpenReport...

Hi , I have a form in Access 2000 based on a table with embedded OLE Objects. When I insert an EXCEL OLE oject on my form , and double clik , it opens within teh container & shows me the worksheet with both horizontal and vertical scrollbars. however , if i insert a word object , there are...

Hi I have the following code in the BeforeUpdate event of my form : Private Sub Form_BeforeUpdate(Cancel As Integer) MsgBox "Before Saving" 'Preview Button on form not clicked If GlobalLoginInd <> 1 Then MsgBox "Save aborted" DoCmd.SetWarnings False Cancel = True End If End Sub...

I've looked up all posts on this topic . and tried almost everything. but still no luck Here's a thread which also describes teh very same problem i'm having. The primary key violation error just can't be trapped...

is it possible to have a combo box display values from a query AND list values ? e.g. I have a query [Status] which has values '123', '234', '1234' can i have the rowsource of my combox as : select * from [Status]; 'All' Thanks for anny help in advance, Gina

Hi, I have a multiuser Access database. The login form has a dropdown displaying the names of all users. and any1 can login as any1 from different machines. I've created a table USER_LOG, which records the Network login name and computer name when a person logs in. ( thanks to all the big...

Hi , Does anyone know the significance of the contents of the lock file that Access creates? I have a shared Access database. Looking at the .ldb , I assume it is the "computer name network login name" If any1 else accesses teh database his/her "comp name login name" would get added to the...

Hi , I have a linked ORACLE table in Access 2000 with a date "mydate" of type "Date/time" I have built a simple query which selects mydate. the query output shows as mydate as e.g. "6/23/1997" 1. If I export this query to Excel using "output to" in a macro the same date is displayed as...

I'm perplexed!! My joins are acting really strange. I have a linked table A . Using a maketable query and using some criteria , i have created a table B from table A . Both table A & B are exactly same in structure. If I use A instead of B in my query I lose data and i just can't understand...

Hi , If i have an input date, is it possible to derive the first day of teh year from it ? e.g INPUT START_DATE 1/3/2002 1/1/2002 2/6/1999 1/1/1999 4/16/2001 1/1/2001 I tried date value , but it gives me only for the current year...

Hi , I have a MS access db with linked ORACLE tables. I used the ORACLE passwd when i linked the tables. Instead of relinking all tables , can i link automatically with ORACLE via code/ autoexec macro , when i open the database ? Would appreciate any help. Thanks, Gina.

Hi, I have a table with fields ID, Summary. The summary field is an Embedded Excel spreadsheet. Is there a way to access specific ranges in the Excel sheet, and read /write to it ? eg. I want to change the cell A1 in the embedded spreadsheet from "Value" to "Last Reviewed" Appreciate any...

Hi, I can't see the light anymore ! I have 2 tables : DEAL Table Deal_ID User_ID eg. Deal 1 User 1 USER Table User_ID Name eg User 1 David A deal can have more than 1 users under it . I want to be able to show a concatenated list of all...

Hi , Can't figure out this one :( The amount "Interest Accrued/Num of days " will give the daily amount of interest between start date and end date . eg. in the attached excel sheet , For facility 1, 101128.87/92 =1099.23 is my amount for each day between 7/1/2002 and 9/30/2002. What I...