Search results for query: *

Greetings! I heard that you can set the dev option in the tabs onclick property to set the user access. Is this true or does it make any sense? Or is this impossible? Thanks again for your help.

Greetings all! I need to do exactly that; control which security groups can access which tabs on a form. Is it possible? And if so....how? Thanks for your help it is greatly appreciated.

the form is bound to a query/table that has over 500,000 records in it and growing exponentially, they are call-monitor forms for a call center. The form is pathetically slow, it takes seriously over 90 seconds to create a new record. And when the click on a button to show a different catagory...

Greetings! How should I set up the following? Form on front end based on empty query when end user is done entering data to that query, on close, a form pops up with a button to run an append query to take the new records from the form-based query and append it to a linked table, then delete all...

great thanks for all the help I appreciate it! :)

super thanks for your help I appreciate it.

Greetings! I could use your advice. I'm looking for a book or website with comprehensive lengthy information on not just building access databases, but on how to build them efficiently as in what are the best naming conventions; when to use code,sql,or querys; how best to set up relationships...

oops my bad it is a number field, and I need to have it since this field is the primary key of the parent table. What would be the syntax if I were to keep the recordid and format it as a number field in the sql string?

ah no its not it is an autonumber. How would I adjust the syntax?

Great thanks all :) I tried it today and I'm still getting the debug error saying there is something wrong with the sql syntax but it doesn't specify. The code is highlighted yellow in the debugger but I don't know specifically what is wrong. I'm sorry I can't give you more specific...

I have a query based on two tables with a one to many relationship. Employees Table recordid (one side) Attendance Table recordid (many side) type from to returndate daycount Attendance query - has all the above fields. and a form... Form field/controls (data source is not based on...

Has anyone done this to their database? Would you mind pasting your code so I have an example to follow? Thanks a million!!!

Ah but of coarse! Thanks that did it. I must have been braincramping today that never occured to me. Thanks again for the help!

Oh I forgot to mention. I need to remove that filter when the report closes.

Greetings all! I have a main report with a sub report. The sub report is linked to the main report. The sub report contains a "violations" control/field. I'd like that sub report to only display records that contain 'callout' in the "violations" control/field. The underlying query for the...

sweeet thanks that looks like it will help alot!!!

Greetings Friends :) Is it possible to create a module that will build a menu bar and set it as the default startup and hide all the other menu and toolbars? I've done it manually, but I have to recreate it everytime I rebuild the front end database. Thanks heaps!

Wow thanks!!! Ok, I chose "Blanks" again from the list box and hit the run report button and got the following messages. First message: Me.lstpertrainer: Blanks Second message: strWhere Used: Trim(trainer & ")= " And low and behold the report showed all the records with the "trainer" field...

Thanks a million that did the trick!!

Khewl thanks! When "blanks" is selected in the listbox the first message box says "Me.lstpertrainer:" and the second says "BuildWhere used", and no records show in the report. When nothing is selected in the listbox, the same messages show up, and all the records are displayed in the report...