Search results

Not too sure what you want to do but if you create a recordset useing VBA then you can rs.MoveNext rs.MoveLast etc..

There a few methods but check the help files in access for full documantaion. Basically you just put and * at the end, so bow* will find bow with any letters after it *bow* will find bow any where in the string b[n-p]w will find bow etc...

To be honest I'm not sure how it works myself, I'm not sys admin. But go to Network Places and check if the server is in there. I don't think it will be, but I think thats where access would check for the server. Someone else will have to step in and tell you how to connect them to it if their...

Is SQL Server on another domain? Do they have permissions to see that domain?

I just remebered, SQL Server works on an 'assign each user' basis not 'allow all' by default, Access project may set up it's own user account when you create the db, if the tables are just linked then you have to setup a user account in SQLServer for each NT user account that will be accesing it.

Projects looks for specifically for the SQL server this is why it 'uncharacteriscally' keeping the connection. If you move the location of the Database then the Linked tables will have a different path and therefore the ODBC will fail. When you email the database you will need to relink the...

I don't really know that much about the OnError part coding functions but I know it exists. If you set a button to perform a command like running a query then look at the code access writes for it you'll be able to see the syntax for the OnError. Basically though, you just say OnError Loop...

Sorry I didn't really read the question properly. Can you get the position of the objects from the other program, I don't thinkn you can do it from access.

When your importing from excel you can specify a cell range to import, I don't know if you can do that in a csv file, but you could probably convert it automatically using the FileSystemObject. Any chance it could be saved as excel to start with?

I think you just got the formula the wrong way round =IIf(5.15*(Sqr([Text1135]))>1,0,5.15*(Sqr([Text1135]))) Try that Can you let me know exatcly what your doing with it, is it in access/excel ar you coding it, is it on a form.......?

If FormulaResult < 1 FormulaResult = 0 End If hth

Oh I see use the DateDiff() function, check the help in access to find out exactly what to type but will be something like DateDiff(StartDate, EndDate, n) I think n is the correct letter for minutes output?? like I say check the help.

now()-now()=0 always

Break your hours into minutes divide by the number of completed pages = average time per page (in minutes) TimeTaken = (TotalHours*60) / CompleatedPages

I work with a guy who sometimes uses my db's, whenever he add's tables or columns uses THIS SORT OF FORMAT26032003, where as I opt for MoreRelevantFormat it drives me mad, I code in SQL/VBA and ASP and it takes me about an hour longer to get the work done. Also, coding across these langages you...

Maybe the 'other end' of the ODBC link is locked/unavailable at the time. If the the report is run automaitcally maybe it's not quite compleating one step before it starts another, try breaking it down. You can maybe code some error trapping into it, so if it fails, it keeps trying until it...

You can code it using the FilesSystemObeject something like this Dim FileName Dim objFSO Dim objFolder Dim objFile folder = "c:\" file = "fileName" Loop Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFolder = objFSO.GetFolder(folder) For Each objFile...

Do you have to do it in code? The easiest way would be to create a delete query and then set the After update event to run the query. DoCmd.OpenQuery "queryName"

Autoeng Am I right in saying that you cannot update data from a data access page?

OK that sort of works on the test. Cheers I'll look into this a bit more.