Search results

Pfoooh, I'm sure it works fine but I was looking for a simple calculation to insert in a query. Anyway, thanks a lot!

Thanks but the InStrRev() function doesn't exist. :-( Any other suggestions?

Version I'm using 'Access 2000'

Is there a function that will retrieve the last 'word' typed in a field. For example: "My name is Anna" = "Anna" "My father's age is 56" = "56" The function 'rightwords' doesn't seem to exist in Access. Thankyou for reading and eventually answering my question.

I linked an Excel file to a table. Changing the data in the table works fine. But when I use this linked table in a subform (or a simple form), the data isn't entered in the Excel sheet...why? The subform behaves normally and I can even ad several records in the subform but they don't transfer...

Date converting problem in function. I think this might be an interesting one. Here we go, I used a function "OfficeClosed" (from the Microsoft site) to know if a specific date falls on a Saturday, Sunday or Holiday. Determining whether it's a Saturday or Sunday happens through the built-in...

The key field of one of my tables which is set to autonumber has unexpectedly reset and starts counting from 24 as where it should be 1410. No query was run. Is there a known virus that causes such things to happen, cause I'm worried. Thankyou for reading and eventually answering this question.

Sometimes I'm able to create/delete/modify a record in a query (with multiple linked tables), when other times it just doesn't want to work. Can somebody explain to me when it will and when it won't. Thanks!

To avoid Word to open your database for a second time while doing a mailmerge there is a simple solution. Go to the tools menu - select 'startup' and set the application title to: "Microsoft Access". Et voilà...everything should work fine.

Hi everybody, When I run my query by opening the Word Merge document on my computer everything works fine. Only on another system Word opens my database twice (and I've adapted the links so that's ok), so doesn't seem to notice it's already open. Anybody knows why? Thankyou for reading and...

Hello all, I develop in MS Access and Filemaker (nono don't get upset). In Filemaker it's easy to find out who created a record and who modifies it, these are standard fields you can create. Unfortunately it doesn't seem to be this easy in Access. Or maybe I missed something... The solution I...

That's the part I know but thanks anyway. I even write some code. But I get lost with this kind of long 'code' it doesn't work that way. It exists of different parts... Any suggestions?

I found the answer to my question in this forum : http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=41391&highlight=file+path I should use this code: http://www.mvps.org/access/api/api0001.htm Only I just know how to start an event from a button. I don't know where I...

Yesterday I asked about distributing a 'secured' database. I ran the security wizard and now my database is ready. But I'm afraid I don't understand quit well how it works. If I install the database on another computer, will it work? Or do I have to include the workgroup (I secured my database...

Thankyou for your answer, Guess you're talking about redirecting a shortcut here. I'm afraid this solution isn't of any help, even though I appreciate your effort.

I've created a new workgroup and defined all the security I want. According to this book I have I should be able to distribute my .mdw file with my solution but when I move the .mdw file (which is on my desktop as well as the database currently) my database won't open anymore, even if I move...

I'll try to explain what I'd like to see on my form A calculated field which contains the value of the field (fieldA) that belongs to the record with the most recent date. Finding the most recent date isn't hard, I made a calculationfield called (MaxDatefield) with the calculation...

This must be so simple... 2 tables: dealers customers Every customer has a field with the keydealernumber in it. My relationships are correct: one-to-many (dealers-customers) with a cascading delete. When I delete a record in the dealer table, it does exactly what it has to do - it's...