Search results

Rephrase: THAT Line method will not work for this. Cheers Realnine.

The Line method will not work for this.

As a quick workaround why not only enable the button ONLY when the DCOUNT is greater than zero. I like to do this using this trick: If DCOUNT(whatever)>0 cmdMyButton.OnClick = "[Event Procedure]" 'button does event procedure ELSE cmdMyButton.OnClick = "" 'clicking button does nothing END IF

If you have a small dataset in A97 I can look at I can look at it for you and try and resolve your issue. formatian@aol.com put "Access World Forums" in the header because I delete anything and I mean ANYTHING I can't recognise - my fiancee has given me numerous b*ll*ckings for deleting her mail.

Sounds like you db is corrupted. Try importing the entire contents into a new database and try again. Does it do this on every report or just this one? Does it only do it under certain circumstances (i.e.if you build it from a query, or query with more than one table etc..) Also try it on a...

As far as I am aware you cannot find a particular on a report and move to that page. You can move to a particular page but because reports can be varying heights this is not a suitable solution. The best I can suggest is to limit the report to display only your desired record. This would not...

If it's a saved query you are trying to run you are using the wrong syntax. Use: Docmd.SetWarnings False Docmd.OpenQuery "YourQuery" Docmd.SetWarnings True

Although discussed on many posts, I will reiterate. The maximum size for a db file is 1Gb (has this gone up to 2Gb for A2k?) A db file can have linked tables linked to other db files to create a file cosmetically greater than 1Gb to the user. A 306Mb db is big but not huge. We return to PC...

Just to throw something else into the pot, you can override the 0 base by using Option Base 1 at the head of the procedure.

When you say normal mode, what do you mean - you want to open the report in design view? If so... DoCmd.OpenReport "YourReport", acViewDesign Note: There are 3 constants when opening a report: acViewDesign = DesignView acViewPreview = PreviewMode acViewNormal = Sends To Printer

I can't find the replace function in A97 so built my own... Private Sub Command0_Click() MsgBox strPictureName 'returns picture name End Sub Private Function strPictureName() As String Dim tmpStr As String 'builds string where / exists Dim sChar As String 'holds character to add Dim...

Check out the MousePointer help in VBA used as in: Screen.MousePointer = 1 'arrow

Read up on the ApplyFilter and FilterOn methods in VBA - definitely right track..

You don't need a where clause if the relationship is perpetual you need to join the tables together as in: select DPT.DPT_NAME, ACT.ACT_NAME from DPT INNER JOIN ACT ON DPT.DPT_ID=ACT.DPT_ID ...or thereabouts

this code returns the last file created in a certain directory... Dim tmpDate As Date Dim aFile As String Dim mypath As String Dim myname As String mypath = "c:\temp\" ' Set the path. myname = Dir(mypath) ' Retrieve the first entry. Do While myname <> "" ' Start the loop. ' Ignore...

It's a Chris Tarrant(UK Who Wants To Be A Millionnaire) thing - it's only easy when you know the answer. ::COUGH::

John Doe? :) (not funny now you edited it from DOA to DAO above!) I think you mean DAO (Data Access Objects). If you use 2000 or XP I think ADO features higher in the priority list. Circumvent this by explicitly referencing your desired object type. Dim dbs As DAO.Database Dim rst As...

1. Use an append query to update the tblRoster table with the list box's value by setting the append value as Forms!YourForm!List0, changing YourForm obviously. 2. Then requery the listbox displaying tblRoster something like: Private Sub Button1_Click() Docmd.OpenQuery "YourAppendQuery"...

Ensuring you have completed all the required fields, closing the form will save the onscreen data to the table. In very simple terms, it is not like excel or word where you have to positively request a save, the data is saved as you work as you add/amend/delete records.

Either use a choose function to return the value in query: ReturnValue: Choose([Cond_cap],"FMC","PMC",NMC") or build a lookup table of associated values and join that to your query to return the appropriate string. Dependent on how likely these are to change will govern your decision as the...