Search results

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...

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...

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...

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...

Following an earlier discussion, I've set up a database which has an AutoExec macro that prints out a report and shuts itself down again. I'm using NT4 (native) scheduler to do the task at a fixed time, and I've made a batch file that gives the instruction: "c:\program files\microsoft...

I would appreciate it if anyone could advise me on how to implement this, if it is possible... Thanks! Marko.

I hope someone can help me... I've been trying (partially in vain)to set up user-level security in Access 97. I created a new workgroup, joined it, added myself as a user+administrator, revoked administrative rights from the Admin user, created a copy of the whole database whilst logged on as...