Search results

My simple approach is to have a yes/no flag field for each record to indicate whether to include the field in the calculation, on the fifth run you could then click the field to indicate not to include. Would this be appropriate. There are other solutions, but I believe that this buy four get...

try: Function NextThursday(d As Variant) As Variant NextThursday = d - WeekDay(d) + 5 + IIf(WeekDay(d) < DayCode, 0, 7) End Function This function can be used in a query, form or report as: NextThursday([YourField])

You can't reference a calculated field, you have to recalculate the value. You need something along the lines of: PerCentIs: (Me![MyControl]/Sum(Me![MyControl])*100 However, having not tested this you may get erroneous results if the records load incrementally. An alternative solution is to...

I have the idea but could you give an example. I think what you need is a conditional sum based on the number of dies sold. Please exemplify with an example fo each case.

if you want to do this in VBA use the Line Method: The following example uses the Line method to draw a red rectangle five pixels inside the edge of a report named EmployeeReport. The RGB function is used to make the line red. To try this example in Microsoft Access, create a new report. Paste...

Take a look at the OutPutTo method of the Docmd object as a starting point. Getting the SaveAs dialog up will require the Common Dialog box to be used which is not good for distribution. Another alternative is to use an API call to show the Folder and File selection dialogs. If you need an...

Sorry for not getting back sooner, I've been taken off my normal job of enforcing licensing laws to assisting in conversion of our poor database information to an equally inadequate unix system database. When will people learn that a customised built package with good support is better than a...

Interpretation is half the job

Thanks wayne, unfortunately I've tried that already, no avail. I am writing a script to extract the info but FoxPro inserts 'dirt' into the file to encrypt it - sporadic returns and non-printing characters apparently at random intervals. By changing all non-alphanumeric characters and sentence...

Further information suggests this may be a Foxpro table, does anyone have any experience with such things? Do I need to have Foxpro installed to read the tables? I have a Foxpro driver on my PC but it isn't recognising the file.

A friend has asked if I can extract some information from a non-copyright public datasource CD for use in a mailshot. I have loaded the program, it unzips with files with .dat and accompanying .idx extensions. I understand that characteristics of each of these types of file. I am not sure...

I think you'll need to delete the current record, you can't undo what's been done because it's been committed. If it's a validation issue, we can handle that but if it's a choice issue, then you need to delete the record and set the relationship to cascade deletes to ensure all children are...

Cheers Tim, Unfotunately none of the data is entered by the users, it is imported as text files from a internet site resource therefore a front end would not be sufficient successful. You are spot on with your comments re making sense of chaos. I'm not even sure they know what they want to do...

If the checkbox is on your report use an expression in the footer of the group suchas: =Sum(Abs([YourChkBx]))

The short answer is you can't because the data has been committed to the table. Why do you want to cancel the save? You may be able to cancel the subform taking the focus by using the BeforeUpdate event of the main form to check the record is valid before committing.

http://www.geocities.com/Athens/Atrium/3005/asciitutor.html

You could also use : Application.FollowHyperlink "MyFilePath" This should start up the default picture browser. Note that it may not always be editable because you can choose IE as the default viewer.

sorry, no ideas then, ANYONE ELSE????

external table what?

try this as VBA behind in controls before update event Private Sub Text0_BeforeUpdate(Cancel As Integer) If Me.Text0 > DateAdd("yyyy", -16, Now()) Then MsgBox "Age is below 16 please,try again", vbExclamation, "Incorrect Age" Cancel = True Me.Text0.Undo End If End Sub Thsi will work if you...