Search results

Ok, this is the name of my function :- Function Timesheet(Name_box As String, Period As String) and I call it OnClick with :- =Timesheet([Name_box],[Period]) It's Period that I want to be optional. The rest of the function is :- Function Timesheet(Name_box As String, Period As String) Dim...

Thanks for your quick reply Kodo ;) I tried something along those lines before posting, but I put it in the called module, obviously not helping. Where would those lines need to go? Thats whats stumping me. The module is one I made, does that also come with an Optional argument, or is that a...

I've tried looking for a solution to this one, but just can't find anything with what I'm searching under. I have a form with 2 boxes empty, awaiting user input. The first box specifies which excel workbook to open, and the second box specifies which worksheet to goto once it has been opened...

Thanks, can't get enough tips. ;) I'm sure I'll need many more before my task is complete. But they will be for other threads, unless I can find them answered already (very likely, as most problems seems to have been discussed at some point, its just finding them.) I've already passed on the...

No that doesn't work as the focus is on the form that is open. One of the side effects to the getting rid of the access window seems to be that once focus is on one of these forms, you can't move from it. I presuming that is something to do with either the popup or modal properties I turned...

Thanks for that, solves the problem nicely. ;) Just in case someone else was hoping for a solution to bringing the toolbars back, or incase I need to do further admin things to the database, is it possible? No hurry on this one, just for general info if anyone knows. Cheers :D

Getting back again I've got that working, and its looking good. However, part of the database is updated from an ODBC data source (fox pro) and when it has finished updating it doubles in size. I found out to sort this out I just need to use "repair and compact", but I can't use this if the...

Thanks very much, great advice, and quick too. I'm also glad that someone else was told by teachers that it was impossible, not just my teachers.

Front End Screen My first post, and its a general "Can Access do this" question. My boss, for the benefit of less computer literate employees, wants the Access system I'm working on to display a front end screen that is outside of the main Access window. That is, when opening the database...