Search results

Wicked! Actually, the Format thing has worked wonders for me. It sorted *most* of the dates out correctly when I applied it to the outer statement which reads the output of a date-returning querydef. It sorted out *all* the dates, though, when I applied it within the date-returning...

Thanks for that! I always tend to use Datevalue and enclose the date as a string, as it seems to work (up till now). I also thought that any SQL statement executed in Access is processed by assuming the dates are American. Can you say a bit more about this difference between strSQL and SQL...

Please guys, this is a matter of principle!

I've just tried to use that method. However, the SELECT part of the query needs to use the keyword TOP and an associated ORDER BY clause, all in the context of the INSERT INTO statement. Access doesn't appear to like this, and gives an error message saying that 'event_date' is not a field...

I would do that, but the thing is that my only means of retrieving the date (which changes in each loop) is a SELECT statement. The output of this SELECT statement (the date) therefore serves as one of the criteria in the INSERT statement, and would have to remain such regardless of whether the...

Yes, that aspect's in order. Everything is set to English. I don't actually have a wider problem with dates. In tables, dates always appear normally. For instance, 31/08/01 will appear as just that, not as 08/31/01.

Hi there! Every time I think I've understood how to handle dates in VBA programmes, it gets back at me big time. This time, I have a select query which picks up a certain date (select top 1 event_date from x where person_ref=y). This query is in a loop, so the date differs each time the query...

At the risk of being expelled from this forum, may I give a simple but probably misguided suggestion: Would it change things if you put a colon next to your label in the GoTo statement (e.g. "then goto LABEL:" rather than "then goto LABEL".)... Perhaps the highlighted statement is a red...

I have the exact instructions for this on a CD at home. However, maybe the following will help (if not, I'll look it up): Access instructs to export all objects from your own database into a new one, once users have been created and what-not. The point here is that the new database will be...

Hello, I'm getting really confused... I have a listbox which allows multiple selections. The listbox is called "lstResultList". I'm trying to use this code (it's in an OnClick event in the form that has the listbox in it...): If Me.lstResultList.ItemsSelected.Count > 0 Then For m = 0 To...

Hi there! Does anybody know how you could allow a user to choose multiple selections from a list displayed via a form? I wanted each selected item to turn blue, as it does in most commercial software. If it entails VB, I do use this although am in need of learning a lot more! Thanks. Marko...

Yes, essentially to update it at a fixed point in time, to show when a box has been ticked. At the moment, I have an invisible textbox on the form which has the relevant date field as its source. That way, I instruct Access to change the value of that box, and then refresh the tabledefs...

Hi there. I was wondering if you could help me. There is a certain query which simply doesn't work when I try it in a module. However, if I transfer it into the query window and press the exclamation mark, it DOES work. Here is the text (Access 97, by the way): Dim qryN As QueryDef Dim...

Thank you for your tips (I think this is probably currently the most discussed topic here!) I don't actually have any security set up on the application at the moment, so I don't think that's the problem. I'll try changing the workgroup name to 'system', but I think it's all probably a...

Yes, it's called mywrkgrp.mdw, but the thing is that the database opens OK when I run the batch file by double-clicking it (the file tells Windows to open Access.exe followed by the .mdb file). When I SCHEDULE it, that's when the problem occurs, but it's the very same batch file it's running in...

Thanks. I'll give it a try!

Thank you for your advice. Sounds good, I'll give it a try. P.S. Tried it - I think Access 97 hasn't got a Form.Recordset option, but it worked via RecordsetClone bookmark synchronisation (sounds very advanced). Ta. Marko. [This message has been edited by Marko Stojovic (edited 03-22-2001).]

Thanks for the advice. I've actually already got such buttons installed. The problem is, I need to move to the next record programatically, and I can't seem to find a command that would carry anything like this out on a subform while it is open in the context of the main form. I just get the...

I hope someone can help me with this: How do you move programatically to the next record in a subform? I tried Forms("mainform").controls("child1").form.controls("text1").SetFocus [which works!] followed by DoCmd.GoToRecord acDataForm, [...]("child1").form, acnext [which doesn't]. Go on...

I just tried out your suggestion. The only difference is that my workgroup file address starts with \\... (a drive on the network), so it went something like "c:\program files\...msaccess.exe" /wrkgrp "\\pad-nt-...\mywrkgrp.mdw". Unfortunately, I keep still getting the message "cannot find...