Search results

Thanks, all. I've got it working (with an unbound text field for the date) and it's been delivered to my boss who is very pleased with it (so far). It probably isn't very elegant when it comes to the programming (I'm no where near as good as you guys -- yet)... and I've printed and saved this...

Thanks, Brian, I'll give that a try too... And thanks to everyone, for the help, suggestions and PATIENCE.

Ok, done! No more error message but now it's propagating a time (as opposed to a date, to be specific "00:01:36" or 30/12/1899 if I force the form to use the dd/mm/yyyy format in that field) in my date field. The code is currently: Private Sub Form_Open(Cancel As Integer) Dim DefaultDate As...

Ok, pasted in the code. The first three lines went red. Changed "myControl" to the name of the textbox (the date box). Saved depite the red. Closed the form. Opened Form as user would. Error message about compilation and syntax. Instead of opening the form it opened the code page and showed...

Ok, pasted the code in. Changed "MyControl" to the name of the date field. What do I have to change "myDefaultValue" to to get Access to prompt the user to enter the desired date?

Please, guys, I'm really grateful for the help but I'm now officially, hopelessly lost. I do not know how to create new properties for forms (more than willing to learn but please, only one method at once)... Anyway, I'm not worried about allowing the user access to the database window for...

Clicking on it in the database window.

Ok, thanks alot all the same... I wouldn't mind learning both methods, though... just not simultaneously...

I already have the following DoCmd.GoToRecord , , acNewRec '**** as the form open event... Can both bits of code go under form open event? Or will one (which one) have to be moved to the (wild guess) form load event?

Thank you for the code... But I'm still rather clueless... Where should the code go? Is it part of the "dim a variable at the module level of the form"? Or is it part of using a hidden text box to store the date? (Or is that two ways of saying the same thing?) Or is it part of the "reference...

umm... just call me clueless... that sounds great, but I haven't the faintest idea what you mean or how to do all that... (I am sorry to be so dense... but my access ambitions far exceed my access skills...)

No, it will almost never be the date of the day... It doesn't even have to be a "default" per say, just prompt the user to enter the date desired and then automatically enter that date for the user in the "date field" of each new record created until they close the form...

Another quick question (with an easy answer, I hope): Is there any way to set up a form in such a way that the user, when opening the form, is asked to enter a date, and the date they enter becomes the (automatically entered) default value for the "date" field until they close the form and open...

Here you go...

The zipped file appears to be too large to attach... even when I delete most of the data and all but the form in question... how should I go about getting it to you for you to see? I do hope there is some way to get a continuous display going because there are usually multiple TimeSheets per...

Further progress... I've been fiddling and futzing... and am not even completely sure what I've done but it now works (with one major glitch): It lets me choose a Category, displays the appropriate list under Sub-Category... and even records the sub-category in tblTimeSheets as it should...

Well, I've gotten it to offer the proper choices in the sub-category box... I set its source to qryCascadedSubcategories. And changed the WHERE line of the SQL for that query to: WHERE CategoryID = [Forms]![MyForm]![cboCategory] But when I try to enter a second (or third, or 4th) time data...

Making progress (thanks!) but... I must be missing something because even though I *think* I followed your instructions, it isn't quite working... I'm stuck on "Form 2" and the comboboxes... (Haven't tackled the menu form yet...) The data entry form is set to display in continuous mode so I...

Thanks! But... um... (warning: stupid questions coming) when I build the form to be filled out, how do I go about adding the drop-down list for categories that will filter (not sure that's the proper technical term) the contents of the drop-down list for sub-categories? Do I need to define a...

Time sheet: date numer of hours spent category sub-category (task) Oh, and the final reports that I need only have to give: the total number of hours (and days=8hrs) for each category and sub-category, since the beginning and between start and end dates (that I know how to do already).