Search results

Ah but... I want the user to have to use the Save button so that it displays a prompt "Do you want to save this record" it will also append today's date to the record to be saved!

I have created a form based on a query which shows multiple records - because the user wants to see an overview of all current records. The user can enter data into blank fields and update the underlying table by clicking on a Save button which also enters today's date into an inactive date...

Boblarson Great - just the sort of feedback for which I was looking. I'll press on with the tutorial foir CR. Thanks again.

I would appreciate any advice/opinions as to what advantages, if any, Crystal Reports has over Access. I am used to developing complex queries and reports etc. in MS Access but a job I have applied for uses Crystal Reports of which I have no knowledge/experience. I've got an evaluation copy of...

Hi I'm calling an Excel macro from Access and get an error 440 Method 'Run' of object '_Application' failed I've cut and pasted the offending piece of code into a separate procedure: Sub Test() ActiveWorkbook.SaveAs Filename:= _ "C:\Apps\Reward and Recognition\Quarterly reports\" _...

Found it - wrong syntax & database corrupted!

I have a Main form with two subforms Sub1 and Sub2. I want to set the RecordSource of Sub2 from the OnGotfocus event on Control1 on Sub1. My code is: Dim intCtrl as integer Dim strSQL as string intCtrl = Me.Control1 strSQL = "Select * from MyTable where Id = " & strSQL...

My daughter is setting up a small business with a friend - they will work from different locations but will need to share a database which I am going to create. They only have laptops so I need a method to synchronise any changes to the tables. So far I've considered setting up a daily routine...

I am using the following code, which I have copied from Access VBA Help on GetObject, to open a spreadsheet from Access but when the spreadsheet opens the screen freezes or an Excel.exe error is generated. The declaration section is not included in Help and initially I got an error with the...

Hyperlink opens workbook minimized Dave Thanks for the code will give it a go. (I think it's apathy not apethy - but who cares!)

I have created a hyperlink on a form to open a spreadsheet but although Excel opens maximized the workbook is minimized. I have tried including some code in the Open_Workbook event : ActiveWindow.WindowState = xlMaximized but it has no effect. Any ideas? Thanks

sort date by week Ken Thanks - yes I've used that technique before it just doesn't seem a very elegant solution! Regards

I have a table with sales by day. I want to display the data in a graph summarised by week but the period spans several years. If I format the date thus Format(MyField,"yyyy ww") then Access sorts the results thus 2003 1, 2003 10, 2003 11 but it should be 2003 1, 2003 2, 2003 4 etc. How can...

I have three line graphs, DervGraph, UlgGraph and SulgGraph, that display prices by oil company brand e.g. B.P, Asda, Esso, Total etc. One graph shows diesel prices, one shows unleaded prices and the third super unleaded however, not all charts will have the same number of brands displayed e.g...

Use * in query Wayne My form has many check boxes - Option 1, Option 2, Option 3, Option 4 etc which the user can select. What I need is the syntax for the criteria so that if Option 1 is true then all records are selected. Obviously if there were no options then the criteria could be blank...

how can I use wildcard Thanks for the feedback but regret I may not have explained properly. I just want to return all records if the value of a control is true.

I want to use the * wildcard in a query if a forms control has been checked to return all records but somehow I haven't got the syntax right. This returns all records with X as the category IIf([FORMS]![Main]![CategoryX]=True,"X") but IIf([FORMS]![Main]![CategoryX]=True,Like "*") does not...

Test for Null fails Thanks for the reply. I made an error when dimensioning the variables!

I have a table where some of the values of MyField are null. I am creating a function that depends on the value of Myfield which I pass to a variable varMyField and am testing it with If IsNull(varMyVariable) but it errors. Have tried setting the variable as a variant but no difference...

Regret this is not an easy problem to describe... I want to create a graph that shows two lines, Year 1 and Year 2 volumes summed by week from a table that has date and volume fields. I can do this but my solution is awfully messy and involves creating separate queries for Year 1 and Year...