Search results

Howzit Try this. If the criteria is a string you need to encase it in an apostophe Total = DCount("SubcallID", "Stats Customer Subcalls", "ContactID='" & CID & "' And "CallDate>= (Date() - 30)")

Howzit Go into the design view of the table and check there. Why do you want to remove this anyway. Indexing is a good way of improving performance when running queries and the like?

Howzit If the column is indexed then access will sort based on the index. Try taking out the index for this column if it has one.

Howzit See this from Allen Browne

Howzit If you add the missing field to the form, take note of the name of the control when you add it as it will be that name that you use in the me.controlname = Now() part. You can make it invisible if you do not want to see it. It is the absense of this control you are getting the eroor...

Howzit Is the form bound to the table Master? DO you have controls on your form bound to the table fields TS_2CashApps etc? That is can you see the fields on your form where you want to update the values? Or is it an unbound form?

Howzit But is it the "Name" of the control on your form. See the Properties Sheet - Other Section? That is what the me.TS_2CashApps will refer to

Howzit FYI - The link works fine for me.

Howzit In the event procedure of your button place something like me.yourcontrol = Now() me.yourothercontrol = Now() me.yourtickcontrol = true

Howzit Yes it should. In testing be sure to take regular backups - especially if you are unsure of anything.

Howzit Try this lsSQL = "" lsSQL = lsSQL & " INSERT INTO Tbl_ContactDetails ( CompanyRef, Forename, Surname, CreatedBy, CreatedWhen, MainContact ) " lsSQL = lsSQL & " VALUES ( " & ICompanyRef & ", '" & lsForenames & "', '" & lsSurname & "', '" & SUser & ", Date(), 0)"

Howzit If the dates are actual numbes, you can you apply a custom format to it - "dddd/dd/mmm/yyyy"

Howzit Try this... SELECT tblBook.BookID, tblBook.BookName, tblBorrowedBy.BorrowedBy, tblBorrowedBy.BorrowedDate FROM tblBook INNER JOIN (tblBorrowedBy INNER JOIN (SELECT tblBorrowedBy.BookID, Max(tblBorrowedBy.BorrowedDate) AS MaxOfBorrowedDate FROM tblBorrowedBy GROUP BY...

Howzit An alternative is to use MS QUERY from within excel to get the data. You can set parameters and link to an excel cell. See Data >> Import External Data >> New Database Query The data can be automatically refreshed on open and or on change of parameter value. This requires no VBA.

Howzit Say no more

Howzit Glad you got it working but is there any reason why you don't just import the csv straight into access?

Howzit In the after update event of your combo box put something like Select Case me.yourcombobox Case 'Credit Card" Me.pur_CardName.Visible = True Me.pur_CardNumber.Visible = True Case else Me.pur_CardName.Visible = false Me.pur_CardNumber.Visible = false End Select

Howzit I'm not sure if this syntax will work any faster. SELECT Count(Contacts.ContactID) As Contaxts FROM (Contacts INNER JOIN Calls ON Contacts.ContactID = Calls.ContactID) LEFT JOIN (SELECT Distinct Calls.[ContactID] FROM Calls WHERE Calls.[DateCreated] <Date()-30) AS T2 ON...

Howzit Ignore my last post it is rubbish. I have done some googling on this and it looks like the Begins with syntax - that you have does not work on numeric fields. The suggestion on most sites was to have a new column, turning the value into a text string using something like...

Howzit It lists the call they made as you put this criteria in the select stmt in a few posts back, so I just modified your last solution. I did raise this subsequently. What you can do is check that you have the correct indexes in place. The code below will count the number of new contacts...