Search results

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

I still can't get all the time slots to show. I only time slots where there is a meeting. I am missing all the free time slots. What I have is a table with all time slots between 9:00AM and 5:00PM (every 30 minutes) in a table and a meetings table where I have the date, time and people you...

I tried that, but it didn't show all time slots. Can you please detail your table structure or if you can, send it to me? Thanks

I am looking for tips or a template that acts like the Outlook agenda. I have to display all hours of the day on a form and the meeting description if there's one at this time. I cannot use Outlook as this would be a standalone application. I have tried the following: a table for the hours...