Search results for query: *

Hi all, Appreciate if anyone could give me a heads up on how (if?) this sort of thing is best handled using Sharepoint. We have a set of standard organisational document templates that are used for our ISO processes as well as other organisational communications/processes. We would like to...

Hi, New to SP so please bear with me as I am struggling to understand the best way of doing something. We are looking to use SP to host a number of document templates i.e. one repository to go to for to access our organisational forms i.e. standard letter templates, QA forms etc. We would...

Hi, We have Exhange 2003 configured with an SMTP connector to our SMTP relay at the network edge. Does any mechanism exist to allow me to limit the maximum bandwidth that this SMTP connector will use? I appreciate I can limit message size and scedule oversize items but what I actually want to...

Hi, Can anyone explain why I get the error 'cannot shrink log file **** because all virtual log files are in use'. A Full and then log dump has been taken and if I run DBCC SQLPerf (logspace) only 1.2% of the log file is used? I have a server that was set to Full Recovery but no log backups...

Hi, I have a table and one of the fields is a boolean datatype and i need to ensure that only one record has this set to -1 Access to this field is via a form and I would like to trap the before update event on the tick box bound to the field, iterate through the records to check the flag...

Hi, I have a requirement to have a control on a form that meets the following criteria: 1. Is bound to a table field 2. Has its value automatically calculated based on the value in a related table (Could use dlookup) 3. Can have a manual value overwrite the calculated value Example: Net...

Hi, Have a calculated column for VAT that I am opening in a Datasheet. Is it possible to format this to currency i.e. round to two decimal places, show £ and .00 at the end even if integer? Regards, Simon

Hi all, Blatantly ripped off Getz, Litwin & Gilberts code to create a dynamic report base on a crosstab as follows: Private Sub Report_Open(Cancel As Integer) Dim intColCount As Integer Dim intControlCount As Integer Dim i As Integer Dim strName As String On Error Resume...

Hi all, Have done some research on the forum and consulted the Getz, Litwin and Gilbert bible but I can't seem to nail this one. I have a crosstab generated thus TRANSFORM Sum(OuterQry.NetPayment) AS SumOfNetPayment SELECT OuterQry.strPackageName AS [Package Name] FROM OuterQry GROUP BY...

Hi all, Hope someone can help me as I am lost here! Have a base query as follows: SELECT Packages.pkPackageRef, applications.intValuationNumber, IIf(IsNull([Applications.dtePaymentExpected]),[Applications.dtePaymentDueDate],[Applications.dtePaymentExpected]) AS [Date]...

Need some help here as I am not sure the best way to accomplish this. I have a query that generates data as follows: [PackageNo] [Date] [Amount] 12345 2/3/2007 100.00 12346 12/3/2007 500.00 I would like to report this in the format [2/3/2007] [12/3/2007] 12345...

Hi all, I would like to prepopulate a record based on another record in the table and need to define a variable that is the TOP value + 1 of the existing values for the field in the table. When a user then adds a new record the field is therefore prepopulated with an incrementing number. This...

Hi all, Don't know if I am on the right trail here but I have attempted to create some code that validates the contents of a text box @ BeforeUpdate against now() and if > msgbox advises the user that this is a future date. It takes the response via vbYesNo and if No cancels the update via...

Hi, Does anyone know if it's possible to disable autocomplete on a form? I have a form in datasheet view and the first two fields expect integer values - if I enter 1 and 2 then the third field is autopopulated with 3. The problem is the third field is a data field and jet throws a datatype...

Hi all, Anybody advise on the best method of enabling command buttons when a control on a form is dirty. Have created a couple of buttons for undo & save but would like this buttons to be enabled only once data in a control on the form has changed. Not sure what the best event to trap this...

Hi all, I have a form that I wish to display in form view and datasheet view. Unfortunately the form size defined for the form view doesn't work for both views. Is it possible to resize the form at run time in VBA so that one form can be used for both purposes or do I have to create two forms...

Hi all, I have a form with a combo box that uses a select query as a row source. I have created a button to allow a user to maintain the data in the table the combo box uses so that a record can be added on the fly. The problem is however that it appears the combo is populated on form load and...

Hi, I have some code using the Dmax function in the current event of a form. I need to stop this code from running based on a user response on form load If Me.NewRecord And Me.OpenArgs <> "" Then Select Case msgbox("No Packages found. Create new?", vbYesNo) Case Is = vbYes...

Hi, Is there any way of getting a template document to open as a new document when invoked from a Word hyperlink? At present all my links to .dot files actuually open the template and not a new document? Regards, Simon

Hi, I've had a good play with DoCmd.Openform but can't work out if it possible to achieve my goal. I have a main form bound to a table on the one side and a datasheet form bound to a query selecting records from both the table bound to the main form and a related table. The datasheet view form...