Search results

I've done some testing on this now and it works great, but I don't know why! Can you explain the logic here please?

Thanks, this looks exactly what I need. I assume this will also work for months (getting the first or last day) as well?

OK thanks anyway. Any more takers?

If only it were that simple. I need to calculate the last quarter end (which is where I'm having a little trouble) and then use that date to establish whether or not 8 weeks has past. I can do this by writing a select statement with hard coded quarter end dates, and then use another statement...

I need to work out whether the last quarter end is more than, or less than, 8 weeks prior to the current date. Anyone got any ideas for a quick way to do this?

What I need to do is pass an integer value to a function that returns the name of the month (i.e. 1=Jan, 2=Feb etc). The above would work fine if I was passing dates, but not integers. Any ideas?

Other than using a select case statement to calc month names, is there a function that accepts an integer value and returns the name of the corresponding month?

Nope, still not working. What I need to do is dynamically change the query criteria. I think I will use the CreateQueryDef method instead, but thanks for your help anyway.

Tried this before and it didn't work. I get a data type mismatch. The return type of the function is Variant and the query field being filtered is an integer???

Hello, I have a query that uses a function to return the criteria for filtering records. This seems to work ok except when I want all records included. I want the function to return a string that uses the "*" operator so that all records are shown......but I can't get it to work. I've tried...

I've been thinking about doing some freelance work (Access development / VB ). If there's anyone here who does this already can you please give me some tips? 1) How much work is out there, is it the right time to consider such a move? 2) Do you get much work from the web? 3) Do you use any of...

I agree I've heard this kind of promise before and it usually amounts to just placing your CV on a website. Have you used National IT Training Centre? Are they any good, what are their costs like? There also seems to be a great difference between the number of study hours required between...

Hello, I'm trying to find a good training company to see me through MCSD. The best I've found so far is Computeach, but they are rather expensive. I don't mind paying the money if they are good and have a high success rate. Has anyone used them before? If so what did you think? Also they...

Ah yes thanks, this is the type of thing I have done in the past. Presumably there is no alternative then?

Can someone please tell me how to return the path to a directory, from a full file path? Basically I want to use the filepath returned by a "file open" function to convert to a path to the directory, which I can then use as an argument in TransferDatabase.

I am trying to set up security for a multi-user database. I want to set up a new workgroup for this database but can't fathom how to create the relationship between a specific database and a specific workgroup (if this can be done). Everytime I set up a new workgroup it is used for all of my...

Does anyone know if you can programatically change the shared/exclusive access settings?

Thanks for your help anyway. Looks like I'll end up having to set up Access security control to solve the problem!

Simply points to the .mdb on the network drive.

Do you have Access user level security implemented? No Do the users have to go through a shortcut to open the db? Yes Are some of the users finding a way not to use the shortcut to open the db? More than likely. Got any ideas?