Search results

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.

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

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.

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. ;)

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...

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...

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.

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

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

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...

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 =...

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...

try refreshing the form me.form.refresh

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

"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...

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...

So the code is in Swedish too, of course?

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.

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 &...

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...