Search results

JamesMcS, I just tried actually using Year(Now) instead of Year(date) in the actual sentence, and it worked!! :) I didn't even try to use it in the actual sentence the last time, as Year(date) and Year(now) made the same output in an msgbox, so I figured they would be the same. Thanks a lot...

Both Year(now()) and Year(Date) works fine, no problem there :) But I need to make the date 01/04/[current year] I just can't seem to get my dcount sentence to accept any other input that a date enclosed in #'s.

No difference when enclosing it in brackets... Have to use Year(Date) and not Year() though. It is working when I am using #Date# instead of Dateserial, so if it is a typo, it would have to be in the DateSerial-part somehow... Must be another way of creating a date of the current year? Edit...

Dim Ut_teller_dato as Date Ut_teller_dato = DateSerial(Year(), 4, 1) This gives me "Argument is not optional" Could the DateSerial usage be inaccurate? edit: DateSerial(Year(Date), 4, 1) works, but now I get "You cancelled the previous operation" when I run dcount... Still works with...

Ut_telleverk = DCount("[Medlemsnr]", "bestilling_ut", "Nz([Medlemsnr]) <> chr(48) AND Nz([Dato]) Between DateSerial(Year(),4,1) AND Date()") This line gives me this error though: "Wrong number of arguments used with function in query expression 'Nz([Medlemsnr]) <> chr(48) AND Nz([Dato]) Between...

Hi! I have a little VBA-line that needs a bit of changing. It is part of a bigger procedure that calculates how many boats a company has on their docks. With this code though, I would have to manually go in and change the date every year. It should preferabelly be counting from the date April...

There is no front end / back end, it's all in 1 file that is stored on a server. The users tunnel inn with remote desktop in multiple sessions. Or atleast that how I imagine it will be, I'm currently in the testing-phase of the DB.

Hi Again :) I was wondering if anyone knew of any way to prevent a form from updating its content against the tables dynamically? I have some subroutines that check what values the fields have, and deactivates some of the fields based on the values. (Every field that is not "0" is deactivated...

To be honest, I didn't quite follow that :p but I think it's working pretty well with the method of substituting the error messages with my own routines. Just need to get rid of a few new problems, but I have started a new thread for that :p Thanks for all the guidance people :)

Hi there! I have a scary problem, I have just redesigned my database for supporting multiple users. I am currently in the test-phase, where I simply open the database twice (hereby refered to as two sessions), and then I try to produce errors by typing in data in the same records at once. I...

And now for the quadruple-post :) Here is the solution, this code replaces the default popup when a record is locked.

Seems I have to take to my senses and try to use the integrated record-lock function after all... all I would need is a way to replace the standard message with a function of my own. I know it is possible with error-messages, any chance it could be done with the recordlock-message too?

While programming, I do see what you mean though. Setting the lock-flag is very easy, but unflagging it is worse. There is no event that I can see that triggers when you change to another record.

I agree that locking records in random creative ways is risky, but I was planning on simply letting the users automaticly skip the records that are "locked". They aren't really locked, I will just program in a function that makes the db skip those records. That way nothing could really get...

Thanks John :) but my 'booking' system is made in a very weird way, as I just put it together one step at a time without really knowing what I was doing, so I don't think that would be a problem with my db. I can definately work with the Locked-field solution, now I just need two pieces of...

That is pretty much what I am looking for yes! I tried to think of ways to program something similiar, but that sound really simple. Thought of doing it with a textbox in the form, but that would flag every record with true :p I think i might actually be able to program this, or else i will...

Yeah, I know, really annoying, only effect it has is that the users get this message: "This record has been edited by another uses since you started, wish to save record or scrap changes?". I guess that would be a solution in many cases, but in my case the users should not be allowed to...

Yeah, I know it could be quite risky, but I got some experience with totally stripping down a computer for public use. Removing access to explorer, taskmgt, helpmgr etc, so I guess it would be quite safe. I read about the programs on your link, they seem great, but I have some very necessary...

Since I was planning on letting the users dial in with RDP, it wouldn't really be a network share, everything would happend locally on the server.. The idea of making the bookings go into a separate form, and then letting another function assign the bookings to the actual schedule is a good...

Yeah, I have found that one too, it's not really having any effect though :/ I believe I read something about it only taking effect when it is opened from a network share etc..