Recent content by bdubuc

I just thought of something: I had weird issues with security... can it be that I don't have access to the mdw datases anymore? How can I see what security file I'm using by default?

Thanks, but the options are always disabled, regardless of a DB being opened or not... :( All the options are disabled, not only those that need a DB to be opened: I can't even access the "Tools-Options" menu!!!

Hi. I lost a bunch of menu option sin my MS Access. In the Tools menu, almost everything is disabled (including Options) and in Add-Ins, all I have is the Add-In manager -and it doesn't seem to work as I readded all the add-ins and there ain't there. I tried repairing, uninstalling and...

Hi everyone. I have a setup where users have the "design" on their desktops and the linked tables MDB is on a remote VPN drive. The drive is setup so it reconnects at log on. No Active directory involved, just plain windows users. The problem is that when users click the shortcut to their...

You have to use the long syntax: forms!Form2.myfield you can use the expression builder to get the exact string you need. HTH

Is it possible to have an option group get its values from a table? I am building a survey application and I would like to have a form where I would show the question and the available answers would be presented in an option group (radio buttons). Tables look like this: table Questions...

I'd like to know if someone has some code that would do the following: I have a part form/table and an Assembly form/table. A part can be available for some assemblies but not for others (a one to many relationship). In my Part form, I would like to have the user select the assemblies for...

I haven't found one yet. What I'm planning to do is to hide the window before calling the maximize. this way, I think the user won't see the resizing. I just hope that it won't have the same blinking effect.

I tried many of the solutions I've found in this forum, but nothing seems to work. I want all my forms to be maximized. I added a docmd.maximize in the switchboard Access created, but when I'm closing a form that I opened with the switchboard, everything becomes windowed again. My forms all...

I have 2 tables: Hours, that contains one field and has records for every hour (9:00, 10:00, 11:00, ...). The second table, table2, is as follows: ID, date hour, 1, 2, 3, 4, 5. I have a query that looks like this: select table2.*, hours.hour from hours left join on hours.hour = table2.hour...

That's what I did (startup - ...). I have a splashscreen that displays OK, without the database window, but as soon as the switchboard form kicks in, the DB window reappears. I'm quite puzzled on this one.

I used the launch properties to hide the database window, but it somehow comes back! I am using code that the switchbaord wizard created, but I couldn't find anything that relates to the database window. I am a bit rusty, as my last Access application was done in Access 2.0, with the...

I found it. It's Forms!MyMainform.ActiveControl.Name. I must be to tired!!!

With the precious help form Ritchie, I decided to go with one subform for each timeslot. I have a lot of subforms on my main form, but it works OK. You can contact me if you have any questions. Thanks a lot, Richie.

I have a main form with 3 subforms named sub1, sub2 and sub3. All subs are in fact the same subform, but they have different recourd sources. I want to know in wich subform (sub1, sub2 or sub3) I am when I am clicking in a control in one of the subforms. Thanks