Search results

Hi, Is there a simple way to add optional criteria in a query for a subform? Basically, what I'm trying to do is have a number of comboboxes in the parent form that indicate what records are shown in the subform (these records could then be added and/or deleted). I would like to be able to have...

Hi, I have a form with a text box using a mask edit. How would I go about "exiting" the form by pressing on a button? DoCmd.Close will not override any incorrect entries in the textbox - Is there a way to "undo" anything in the textbox so that I can exit the form after clicking on the command...

Hi, Not sure if this is possible (sounds simple hopefully) but I was wondering if there was a way to sum certain fields in a record on a continuous form. E.g. Field1 and Field2 in record 1. Is it something simple like summing columns, i.e. Sum(Field1)? Any help would be much appreciated.

Hi, I have a crosstab query that groups by week to obtain columns for monday to sunday. Is there a way to obtain the actual dates that these columns represent? Any help would be much appreciated.

Hi, I've got a combo box that uses DatePart("ww",[Date],2) AS WkNum to obtain the week number. How would I obtain the start date and the end date from just the week number? Is it also possible to change WkNum to the week number of the selected month? E.g. if December is selected, instead of...

Hi, I'm wondering how to set the default value of a combo box to the Monday of the current week (it's grabbing a date field). Many thanks in advance.

Hi, I want to check a listbox value (the listbox is in the parent form) after updating a subform field to see if the listbox value is greater than 8.5 after updating. If it is, I want an error message to pop up and I want the field that the user is on cleared. I think I might be referencing...

Hi, I currently have a report that is driven by a combobox. I was wondering if there's a simple way to create a report for each of the entries in the combobox through a "All" combobox entry. (i.e. instead of selecting each entry, one by one) Any help would be much appreciated.

Hi, Is there a way to automatically choose a value such as 0 if the expression goes to a negative number? E.g. I have a query that will subtract a numeric field from 10. If 10 - [numericfield] is less than 0, then I only want it to display 0. Otherwise, it can display the value if it is...

Hi, I'm trying to get a total which runs off of a query in a listbox (disguised as a textbox) to always show 1 decimal place. Right now, it'll show one decimal place only if the number is rational. If the number is whole, it doesn't show any. E.g. For 8.5, it'll show 8.5 For 8, it'll...

Is there a way to show the earliest and latest dates of a report generated by a non-date field? E.g. I generate a report based on Food, and it'll list the days that this food is associated with. Is there a way to show the first and last day that appears in this report (i.e. the range of dates...

Hi, I'm trying to have a button on a form that would delete a record from a table only if there are no child records linked to it. If there are child records for the selected record, the button would be disabled. Is there a simple way of doing this? TIA.

Hi, I'm trying to reference a control in a subform from a module but I keep getting errors! Here's what I've tried.. and what error I've been getting: First try: GetCboEntries = Forms.frmMain!frmSub.Form![cboEntries].Column(1) (where frmSub is the name of the actual form in the subform...

Hi, In a form, I am using two comboboxes per record (i.e. when you add a new record, two more comboboxes for that record appear). My goal is to have the second combobox show entries specific to what the first combobox was, with certain caveats (see below). My current approach is using three...

Hi, I currently have a form that creates a report based on a query that takes in a start date and an end date. What I would like to do is to create comboboxes that will let the user choose a month and year for the report. Is there a simple way to choose an entire month in access? I've tried...

Hi, I'm wondering how to do the following: I have two combo boxes that exist on a form record (i.e. two combo boxes for every record on the continuous form): mainCategory and subCategory. Currently, I can choose a mainCategory and depending on the mainCategory, I have certain values available...

Hi, Is there a way to get blank fields to sort to the bottom rather than the top when sorting alphabetically in access? TIA!

Hi, Is there a way to totally remove the navigation button bar? Even though setting form navigation buttons to "No" removes the buttons, the "bar that held the buttons" remains in it's default gray colour. I'm trying to make a subform blend in with the main form but this is posing to be a...

Hi, I was wondering how difficult it would be to do the following: 1. A user opens up a form. 2. The user uses a combo box to select his/her name. 3. There is a date combo box on the form and by default, it is set to today's date. So when the user selects his/her name, the records for today...

Is this possible, if using the following: SELECT DISTINCT (Format([Month],"mmm yyyy")) FROM Table; Adding a ORDER BY [Month]; gives a "distinct and order by" conflict... Is there any way to alleviate this? I want to display a "mmm yyyy" formatted combobox in order (i.e. Jan 2005, Feb 2005...