Yes, in the subform I just have a datasheet that show fields for my homebrew fermenting rack; what needs to be done, what date it needs to be done and a checkbox if it has been completed. This is where i am using this calendar stuff; makes it much easier to see the days go by than to count in your head!
I still can not get the focus back to the original record in the datasheet, but I am happy with the way it is working now!
...
viperRider
Last Activity: Sep 5 '08, 03:08 PM
Joined: Jan 10 '08
Location: Wyoming
-
K, hit a wall here. I get an error "there is an invalid expression in an expression" and it points to the cboOriginator.P arent.setfocus.
let me clarify my earlier explanation a little :) I am trying to point back to the original textbox which is inside a subform, on the form i am using. basic rundown - I click on the date in the subform, global variable takes on the values of the textbox, the calendar pops up, i click...Leave a comment:
-
Worked like a charm! I new there had to be a higher leverl for declaring a variable. and it is well commented!
here's a related question. I use that variable cboOriginator to set the focus back on the date i originally clicked on. but now when it comes to that point in the code - cboOriginator.s etfocus - it no longer sets to focus back to the original date textbox so i can hide the calendar. any thoughts?Leave a comment:
-
referencing a variable from a subform
Another question to people smarter than me! LOL
I have a form with a variable - Dim cboOriginator as TextBox - that holds the info about a textbox i click on. when i click on it, i have a calendar set up to "become visible" and show either the date in the field i just clicked on or todays date if null. all of this worked fine when i had the date fields in the same table as the rest of the data; but now i have this info... -
OK, I have been playing with this top 1 thing and have come to the realization that I do not know how to reference the particular record i need... so here is what i have!
I have a table - Master - that contains all of the records, except for the ActionText, ActionDate and ActionCompleted records. those are kept in table ActionTable and have a field linked back to the BatchNumber in Master.
I am trying to get the first...Leave a comment:
-
lol - i just had an idea like that - i only need the first unchecked record.
now i have a problem trying to display that record. on my opening form, i have it set to continuous and it pulls the record from a simple query looking for 2 fields to be false - meaning this batch is still fermenting.
i tried putting in a text box - but am having a little trouble merging the info you gavce me and trying to get it to work....Leave a comment:
-
Displaying the next action on a form
So, I'm not a total newbie, but I am stuck with this one. I have a database built up for my homebrewing operation. Each batch i make has steps like any recipe does, but these steps all have dates when they need to be done. When i open the databse, it shows me what i have fermenting on the rack (via a simple query - and i would like it to show me what "step" is coming up next. I have a separate table for these steps; with a number field... -
Well, the continuous form just displays certain fields from my database, enough to get the basic idea from each batch. to the left of each row is a button to take you to another form to edit the fields. The continuouos form displays all records, but not all fields. When i apply one of these filters, i really only need to be looking at 3 yes/no fields (Future, Bottled, Completed) and one text field for the type (beer, wine, mead, or soda). i can...Leave a comment:
-
Filtering a form with checkboxes
This question has probably been asked, I just can't find it - sorry if I am double posting.
I have a form that displays cselect info from my homebrew database (ie Name, date brewed, date bottled, alc. content, what kind of batch it is (wine, beer, mead) and certain check boxes for things like if the batch has been bottled or is completed)
From this screen I would like to have a few check boxes along the bottom in the...
No activity results to display
Leave a comment: