Recent content by naomi1017
-
N
Calculating percentage complete based on checkboxes – setting a variable?
Got it! Here’s what I did: Created a new field (ReadinessLevel) that lived in the main table with the 4 checkboxes. That field was a number field set to 0. Created an update query that checked the first checkbox, if it was yes (-1), then the new value of the number field was... -
N
Calculating percentage complete based on checkboxes – setting a variable?
I have four fields that are checkboxes. I want to create a variable called ‘percentage complete’, and populate it based on the checkboxes. For every checkbox that is checked (yes, -1) I want ‘percentage complete’ to go up by 25%. I’d like for this to happen in a query, so that I can pull the... -
N
Query to get Count of items
Creating Pie Chart from Count Query My Data gets one of 4 labels: A, R, N, X. I want a pie chart that shows how many of each I have. I created a query (StatusCounts) using Group By and Count. It lists “OrderStatus” and CountofOrderStatus. Whenever I use this query to create a chart I get... -
N
Checkbox based on & updating a text field
My database has a text field "Status" where the text is either, A, W, C. There is a form to update this field; currently it uses a standard Access created text field. The users want a checkbox which will show up as checked when the status is W, if the status is anything else, the checkbox will... -
N
Switchboard OptionLabel7 problems
I recently inherited a database that seemed to be designed by an expert VB coder. After carefully picking through the code for about 2 days I realized the person had just used the Switchboard function. I made a few small changes in the switchboard (through the switchboard wizard), and everything...- naomi1017
- Thread
- Replies: 2
- Forum: Modules & VBA
-
N
Setting a field based on date in another field
You're right users shouldn't be in the tables... they update this information via a form. So the problem became how could I set the form to show a default value and then input that value back into the table? I could get the form to display the default value: Control Source... -
N
Setting a field based on date in another field
I have a database with a date field of 'ReviewDate'. In the same table there's a text field of 'Expired'. I want to set the default value of 'Expired' to be "Y" when the reviewdate has passed, or "N" when it hasn't passed. Users may also enter other options ("A" for waiting or "H" for on hold)...