Search results

No, ghudson, that will not work either. I tried it by maximize the database window first, then double clicked on the form to open it and no matter what sizes you set, it'll be maximized anyway.

Hi Pauldohert, I'm guessing this is what she wants. Let's say that you have one main form with has buttons to open other forms. If you max out the main form, any other forms that are opened by the command buttons will be maximized also. What she wants is that even the main form is maximized...

Counter+Password See attached

My sample is a "sample" only, it has none of "your" forms in it. Look for how I've done it and use it for your form.

See attached.

Form's AutoResize property I think you're using the AutoReSize property inproperly. When set to true, the form will load to the size of your form's size. What form's size, you'd ask? When you create a new form in Design View. You initially get a blank form, see attached. That gray box...

Here is the syntax of DLookup: = DLookup("[ColumnName]", "TableOrQueryName", "[CriteriaControlName] = something") and notice that your linked table's name is tblaccess (from your comments), not Access as shown in your code.

Wrong box!!!!!!!!

Someone else may have a better ideas. This is what I would do for now. I would create a one-column table, ExcludedDates. Of course, every year, these dates will change. You will have to enter in the table all the dates that you want to exclude, weekends and holidays, for one whole year or...

You're welcome! You're are indeed correct. It will be difficult because as you know, weekend dates changes every month and year but why bother, just leave them in there. Holidays are better though 'cause some of them are set-dates. So yup, we can exclude holidays. This just creates more...

yes, it does if it's the page header.

See attached, you'll get the ideas. Life goes on!!!

You may have to refresh your main page. I would do a quick refresh by uh...close and open the form back.

See attached, you should get the ideas. Life goes on!!!

Somebody may have a better idea, by the way. I'm just brainstorming about this. In stead of using two columns for StartDate and EndDate, I would use just one, DateOff. An employee will still be able to select the StartDate and EndDate but these two are unbound controls. When an employee...

Can you post a small-sample version of it? It always helps that way. Thanks

This can be accomplished very easily. I would create a public "flag". When flag is 1, open building, 2-open doc and 3-open assessments. Clicking a command button on your main page not only opens up the login form, it also sets the flag. For example, clicking on buildings will open the...

It always help to attach a small sample .zip database for us to look in.

The search utility is there for your convenience. Try searching under Getusername or something like that. Good Luck!

Go to your Access menu, select Tools, Database Utilities and then select Compact and Repair... Doing that will reduce the size dramatically. Give it a shot, will yah?