Search results

  1. L

    Scroll Bar Question.

    If you are talking about your form having the extra length, you have to calculate the height of your form.detail to match the size of smaller controls. Either that or I cannot imagine what is the problem, you could create a jpg file from a print screen and send it to us.
  2. L

    Count function problem

    Count(IIf([TABLE]!TICKED=True and ([Service]![Funding] '"Whatever" ,1))
  3. L

    Re: Slow in opening database

    could it be the connection? are your tables manually linked or coded? try mimicking the tables, put in your database. if it run fast, then its not the form but not the connection.
  4. L

    Sending Email

    If the question is 'How to create a msgbox", the Access Clip can help you. If the question is "Can you give me the code?" You have to send me your database. ;)
  5. L

    Filtered field for new record

    You can create a public variable IFFiltered, YEs or No; FilterRecordID as integer WHen you open the main form, set the IFFIltered = NO; FilterREcordID = 0 if you filter it, set to YES, open the form; so if you open the subform, FilterREcordID = me.recordid first before opening and the...
  6. L

    How to solve this.

    From one of my memo table form. okholder = original memo data Dim sql7 As String AnyHolder = Replace(okholder, "'", "?") If InStr(okholder, "'") > 0 Then sql7 = "SELECT * FROM AllCHAPST WHERE AllCHAPST.Inspection like " sql7 = sql7 & "'" & [AnyHolder] & "'" Else sql7 = "SELECT * FROM...
  7. L

    Help on sorting

    1st query is Product Name (I need this to be Secondary sort) 2nd query is Date (This to be primary sort). If you are not kidding: drag the product name first, then the date. ascending both. The primary sort field should go first at the query grid.
  8. L

    Is there some way that I could find a mdb file

    If all things dont work out, sue him. All codes he did on company time are properties of the company. :D
  9. L

    How to show the longest days?

    Paste on SQL Select Table1.Workingdays, Table1.FTE FROM Table1 where Table1.Workingdays = ( SELECT Max(Table1.Workingdays) AS MaxOfWorkingdays FROM Table1)
  10. L

    Selecting Records Based on 3 Criteria

    ID Subject Mark -------------------------------- 1 English 56 1 Maths 62 1 Chemistry 96 2 English 49 2 Maths 65 3 English 87 3 Maths 78 3 Physics 45 Now i want to write a query that will select those IDs whose English and Maths mark both are 50 and above. i would be very grateful if someone...
  11. L

    Using select Statments to filter a subform

    Private Sub NewItemFrame_Click() Dim NewItemFrameValue As Integer NewItemFrameValue = Me.NewItemFrame.Value '(The chosen option dim mytext as string Select Case NewItemFrameValue Case 1 ' if the value of my option group is 1 -- make sure you number your options. mytext =...
  12. L

    Using select Statments to filter a subform

    Get the values form the list box and calendar, put them in a variable. First create your query with a sample data then copy the sql, put it into a string variable then on a command button, make the sql as the recordset on click me.recordsource = sqlstring make sure your sql syntax...
  13. L

    Setting subform to new record

    try refreshing the form me.form.refresh
  14. L

    Zero's won't add

    use the nz. if your sum is bill1 +bill2 + etc use: =nz([bill1],0)+nz([bill2],0) + etc
  15. L

    Sending Email

    "If I were making changes to a form and I wanted to send an email by clicking the command button and I want a box to pop up saying send with changes or send without changes so that it would either record the changes that I have made or not. How would I go about doing this? " Use the msgbox...
  16. L

    Datasheet view (Sort disabled)

    Is it an ole object? From Access Clip: You can't sort an OLE Object under any circumstances. Although you can't sort a Memo or Hyperlink field in a Page, you can sort these fields in a table, query, form, or report. In a report, you must type the name of the Memo or Hyperlink field into the...
  17. L

    Delete record on subform?

    So the code is in Swedish too, of course?
  18. L

    Incrementing autonmber with string

    Did you create a new field for XYZ or is ABC and XYZ both in the same field? If you created a new one, then its looking at the original field, maybe? Can you send the the code, and table format? Thanks.
  19. L

    updating next record

    Private Sub TarA_AfterUpdate() Dim TaraValue As String, ThisRecordId As Integer, NextRecordID As Integer TaraValue = Me.TarA ThisRecordId = Me.RECID Me.Form.Refresh Recordset.MoveNext NextRecordID = Me.RECID Me.Form.Refresh Recordset.MovePrevious 'MsgBox "this, Next" & ThisRecordId &...
  20. L

    updating next record

    so if this is how your table looks like RECID ---------------- TarA----------------------CTarA 1-------------------------A 2-------------------------B -------------------------A 3-------------------------C-------------------------B the, A, B, C being the values Private Sub...
Back
Top Bottom