Search results

Any value that is calculated should rarely be stored in a table. You would be better off writing a query that includes this calculation and then use that query as the basis for any further queries you need to run. HTH SteveA

I'm not sure what you mean by older than two weeks and not greater than today. If you mean an appointment that was dated in the last two weeks ie between 31st Dec 2001 and 11 Jan 2002 then place the following below the date field in your query: >=DateAdd("d",-14,Date()) and <=Date() If this...

Rather than having the recordsource of your main form trying to gather all the information, I would set the recordsource of the main form to your personal table. I would add a subform to the main form and set the recordsource to the finance_records table. You can then set the Link Child Fields...

I was having the same problem when programmatically exporting data to excel from Access 97. The standard export always truncated the value to a maximum of 255 characters. I had to place the result in a CVar() function to prevent the truncation from occurring. Unfortunately, this only works...

My experiences to date with SQL have been that dates always have to be massaged into the American format of MM/DD/YYYY to get the correct result. While Access will display and hold dates in the non American format, my SQL always expects American formats. This occurs even though, my regional...

The timer event in Access still runs when Access is minimised. You could use the timer to trigger your message box, however this will not move the focus from the application you are working in back to Access. I'm not sure how you would do this, but it is probably an API call. Cheers, SteveA

A few things are happening. 1. There is some code in the AfterUpdate event of the Products field in the Orders Subform. This uses the product ID to retrieve the UnitPrice for the selected product and stores it in the Unit Price Field. 2. The ExtendedPrice field is automatically calculated by...

I would change the line: If Me.password Is Not getpass Then MsgBox "Your password is incorrect. Access Denied" End If to If Me.password <> getpass Then MsgBox "Your password is incorrect. Access Denied" Me.password = "" me.password.setfocus Exit Sub End If The Is operator is...

Give this a try and see if it works: Private Sub fraSecIIIa_AfterUpdate() Select Case fraSecIIIa Case 1 Me.fraSecIIIb.Visible = True Me.lblSecIIIb.Visible = True Me.linSecIIIb.Visible = True Case 2 Me.fraSecIIIb.Visible = True...

You can also just say Text155 = 'Canceled' Cheers, SteveA [This message has been edited by SteveA (edited 12-22-2001).]

If you look at the database tables, are the records being saved correctly? Cheers, SteveA

I would probably change the design of the invoice table to not have seperate fields for each month ie: Invoice Table: InvoiceID CustomerID InvoiceAmount InvoiceGeneratedDate etc This will allow you to run your report easily, be able to generate statistics across months easier and also provide...

If Project Info can only be held once, shouldn't this be part of the Project table as it is not a one to many relationship? Is there a reason as to why this data is being stored in a seperate table? Cheers, SteveA

When you place a subform on a main form you have to set two values on the subform field. These are Link Child Fields and Link Master Fields. If you set Link Child Fields to PatientID and Link Master Fields to which ever field in the Patient table has their unique number (probably Patient ID)...

In your code you are setting a stLinkCriteria1 and a stLinkCriteria2. However, when you open the new form you pass stLinkCriteria which doesn't have any value. If you want to filter by Course Code and Participant Number you need to set stLinkCriteria after setting stLinkCriteria1 and...

At the same time where you make the Subform Visible ie (Me.NameOfYourSubform.Visible = True), place the following code: Me.NameOfYourSubform.Requery HTH SteveA

The length parameter for the MID function is optional. If you leave it blank, MID will return everything from parameter 2 onwards ie MID("Hello World",4) will return "lo World" Cheers, SteveA

If you are planning to or have implemented access security you can control this via the security settings for each user. If you need more info, please let me know. HTH SteveA

In the OnCurrent event of your form place code like: Me.AllowEdits = Me.blnActiveRecord Change Me.blnActiveRecord to point to the flag you are using to indicate the active record. HTH SteveA

Dobie Each control on a form has a property call ControlTip Text. Set this to whatever text you want displayed and it will pop up over the control when your mouse moves over it. HTH, SteveA