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...

Anyone have any ideas? :)

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.

It's a sum based on conditions of two comboboxes. Both of these combo boxes filter the records shown in the continuous form. I'm summing a field of what's shown in the form, based on the combo box values. SELECT (Sum([tblData].[Value])) AS Total FROM tblData HAVING...

Anyone have any ideas? :(

Hi, Thanks for the response.. It's still not working - I tried something to that effect earlier (except I didn't use the set focus thingy)... The listbox is summing up a field in the continuous form using a query - could that be why this isn't working? Would it work if I referenced the query...

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, Thanks for the reply. The report I have is parameter driven - I already use Docmd.OpenReport "Your Report Name" on the OnClick event for the report. It follows the same sort of schema as the crosstab report sample (under creating advanced reports) in the Microsoft Developer Solutions...

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.

KenHigg, Just want I was looking for! Works perfectly. Thanks!

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...

I didn't see a format property for this on a listbox... Do you know how would I do this within SQL, if it's possible?

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...

Showing a customized message box would suffice :) One msgbox pops up when deleting a record that does not have child records linked - "You are about to delete 1 row(1) from the specified table" I'd like to change this msg and when there are linked records, a key violation msgbox pops up...

Yep, my report's got a date field on it! Works like a charm :D Thanks!

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...