Search results

Version: 0.8-2.026-204.32 and still in BETA Revision Date: 05/03/2015

Nothing further stands out to me. Except if Selling is not locked and values can be added. Otherwise. Maybe someone else can assist you.

Are you sure you field name is Selling? Verify

Are you sure their is a value in (3) ? Verify. Post pic of your query.

Their is no way for us to know without seeing some data or pics. Are you sure you have both values (2) and (3) in record source?

What have you done so far? Can you show your relationships? Form Designs?

I did not download your db but it sounds to me that a subform would work for this. As for the time/date you can simply do a requery.

After spending hundreds of hours designing,implementing and testing I handed over my database to a close friend of mine for some hopefully valuable input. I am about 90% completer with it and am at a major crossroads. I don't have users to test the data with but really wanted some expert advice...

I was wondering, if you send someone a db that is in your trusted location, i.e. a named folder and they place the db in the same folder, will it open enabled or not?

Personally, I would use a command button. OnClickEvent

The Great State of Texas.

Here is an Example using the OnLoadEvent for a Main form. AnyDate = Date Monday = The current Monday. Replace with your criteria and form name. If Me.AnyDate = Me.Monday Then 'Payroll Reminder. DoCmd.OpenForm "frmPayrollChanges" If not, Please explain further.

Then simply add in our query grid the field in your listbox for the criteria. And then of course using the OnClickEvent run the query. HTH

What do you mean by show? In the same form? Fill in some fields? Here is an Example of what I think you are asking. 'Append Multiple Email Addresse To EmailTo Field. If Me.lstlist.ItemsSelected.Count = 0 Then MsgBox "You must select at least 1 Item" Exit Sub End If Dim strEmail...

Your telling it to export a file named cbtTab , is your file not named this?

Yes, it's called form filters. Then it's a matter of setting code for the value of the checkbox if it's true or not. Here is an Example of a filter. The following example uses the ApplyFilter method to display only records that contain the name "King" in the LastName field: VBA...

One way would be to simply refer to ONE combo in your query. You could also use the not in list event to add your message and or limit to list.

So you are doing the calculation in the subforms footer? Is this a calculated expression in your query or just and expression? Are you using the forms afterupdateevent or the controls afterupdateevent? Here is an Example: Total: CCur(Nz([qty],0)*Nz([cost],0))+[FT] 'In Query FT...

You could do a Me.Requery after entering the item.

Your going to need a lot more than a cross tab query to get what you described. Would need a lot more information to advise further.