Search results

I am getting an arguments are of the wrong type, are out of an acceptab;e range or are in conflict with one another. I though it was because of the string but obviously not. What causes this error.

Where should I be putting ' s to make this right. It's fine for a number but not a string rstEst.Find "partname=" & MyPartName

Thanks Rich I have 5 references VBA MS 11.o Object Libraru OLE Automation Active X Calendar Whic rtefernce would contain the date function.

Sorry Pat what do you mean by my references ?

>= (now() - 7) seems to work thanks Ken

I'm using Access 2003 and adp and I get the erroe. Date is not a recognised function name.

I need data for the last 7 days to be returned in a query - how do I do this using the query grid ? I have tried date() - 7 in the criteria column of the date field but it doesn't allow this

DELETE * FROM SQLACCESS.tblctest WHERE (est_id IN (SELECT SQLACCESS.tblctest.* FROM SQLACCESS.tblctest INNER JOIN SQLACCESS.tblDrawings ON SQLACCESS.tblctest.cid =...

I have a datetime field with Deafult value set on the textbox as Date(). When the user changes this it is cleared and the user must enter all the date details. What the users want is to be able to change partof the default date such as the day or month. This works fine on an mdb but I cant get...

How do you install it for ALL Users then ?

Does anyone know if you have to have Administrator rights on a machine to run an Access ADP project installed using the package wizard. It works fine if I am logged on as Admin but when a user logs on and trys to open the app a Microsoft (send Dont send) error appears.

Thanks works fine with the extra brackets

This query is returning records that have leaving dates - it works ok if it is just LEAVEDATE IS NULL but it doesn;t work when I add the other criteria. SELECT REF, INITIALS + ' ' + SURNAME AS Employee, DEPTCODE, LEAVEDATE FROM dbo.vwAllEmps WHERE (LEAVEDATE IS NULL) AND...

I am opening a recordset in code but as there are alot of records it is slow. Can I limit the number of records retrieved in a recordset ?

This works except the option to import relationships is greyed out and I only get the tables. Queries or views are not copied. I am using Access 2003 Projects and SQL server

I need a clean copy of my database that includes everything except the data. I want to keep the keys and relationships etc. How do I do this? I am using Access 2003 Projects and SQL Server. I tried Importing the tables with the option Definition only but the option to include relationships is...

Had another look at datatypes and []'s etc and I have it solved now thanks.

I am having a problem with a counter that uses DMAX + 1 to get the number. It works fine until it reaches 10 and then it stays at 10 from there on ? Heres the code. MyLineNo = DMax("line", "tblnquote_d", "id=" & MyId) + 1

Spot on. What would I do without ye.

I want to run a different report depending on 2 conditiond being true - how do I do this. I can get it working with one condition but how do I AND the conditions. Here is what I tried and I am getting a type mismatch error. strCondition = "[confirm] = 1" And "[id]= " & Me!fsubQuoteList![id] &...