Help

Report Prints Too Small
Has anyone encountered a situation where your Access report will be printing just fine and then one day you run the report as usual and instead you get a small image of the report scaled down to about 1/2 the size of the paper? ... 26 Jan 2006 18:03

Using and If Statement in conjunction w/ Multi-Select List Box to Filter a Report
Is there a way to add an If Statement to the following code so if data in a field equals "x" it will launch one report and if it equals "y" it would open another report. Anyone know how to modify this? Private Sub cmdPreview_Click() On Error GoTo Err_Handler 'Purpose: Open the report filtered to the items... 25 Jan 2006 11:40

Access 2000
I have a one table of logged data, Time and Value (two fields) TIME VALUE 01/01/05 11:00:08 1.33763 01/01/05 11:00:16 1.33238 01/01/05 11:00:24 1.32988 01/01/05 11:00:32 1.33125 I want to filter out all records above a certain value X and then only the first record when the value goe... 2 Feb 2006 20:17

Commit : database changes in Ms access.
Hi all, For a ms access database is there any facility like 'commit' like activity to save or not to save records.. to modify/delete changing records. Any vbs code can we do in forms..? -kish ... 17 Jan 2006 04:44

Calculating Strait Line Depreciation
I am attempting to calculate the book value of assets in a query. I calculate total depreciation of the asset using the built in Strait Line Depreciation function and then use the following statement to calculate BookValue: BookValue: [PurchasePrice]-[AccumulatedDepreciation] which works fine. The problem that I... 16 Jan 2006 21:01

Why does fso.MoveFolder fail with "Permission denied"?
Why am I getting: "Error Number 70: Permission denied" when trying to move a folder with the Microsoft Scripting Runtime? Is there some security setting I don't know about? Platform: Windows XP SP2 / Access 2003 Private Sub MoveFolder(strDestination As String) 'required references: 'Microsoft Offi... 10 Jan 2006 18:11

Access links, hyperlinks and headaches!
Hello! I'm having trouble with links and hyperlinks in MS Access 2003 - any help would be great! Question 1! The "insert hyperlink" icon opens a browser window, allows the user to browse to the desired file and paste the hyperlink on the form (which obviously remains for on all the records). I am trying to... 9 Jan 2006 16:28

ucase function
I need to define a field so that when a lowercase letter is put in the field it turns to an uppercase letter. What would the expression for the field be? My field name is site_id. ... 9 Jan 2006 16:28

run-time error 3073
hi I have got the following query which I try to run: UPDATE Qry_temp INNER JOIN Tbl_TEMP ON Qry_temp.Maaned = Tbl_TEMP.Maaned SET " _ & "Tbl_TEMP.Reklamationer = [Qry_temp]![Antal] Tbl_temp is a table and qry_temp a query. when I run the query the run-time error 3073 shows - "You need an upd... 8 Jan 2006 15:50

Could Not Lock File Error 3050
Network users with read-only access are getting this error message when another user is in the database. Any suggestions on how to fix this problem?? Thanks! ... 6 Jan 2006 03:32