Activity Stream

Thanks for your help. I used your second suggestion but doesn't seem to work. I'm sure it's my mistake. Here's the whole text box: ="After the...

What is the value of when it fails? You may have a date format problem: http://allenbrowne.com/ser-36.html#Format

Thank you for the insight, I am going to do some research on those queries to make sure I am properly searching for my indexed fields. Thank you!...

Try format(14271,"$###,###.00") perhaps format(,"$###,###.00")

Google/Bing can often be used to find examples of code and concepts. M$oft example here.

June7 -- thanks for chiming in... 'appreciate it. Would you mind posting that sample database? Thank you!

Thanks for responding, I'll try this out. I may be back with further questions!

OK. Thanks for all your input so far. A web database might well be the way to go in the future once I've learnt Access but I'd rather keep it in...

I have a db that does not require user to enter a username/password. Code simply grabs their network username and matches to a record in Users table...

You are free to modify either of the apps yourself, but a few warnings. The password form is deliberately designed to work with encrypted...

Date/time fields require # delimiter, not apostrophe. & "',#" & Me.Cust_PO_Date & "#,'" & & "',#" & Me.Cust_Requested_Date & "#,'" & &...

Because of issues like this I often set up a template in Excel and export the raw data to it. I just find Excel handles charts better.

I can't open your db because I only have Access 2010. There must be features used that are not backward compatible.

On my ReceivablesFrm, I'd like a button that creates a record in the depositstbl with the date and amount total and then updates the accountingtbl...

Not much there to go on, but I think you want Do Until rs.EOF do stuff Loop

I'm afraid I can't really comment on anything you're asking about Access that involves eCommerce because I have no experience with that. Have to...

Makes perfect sense. Thanks

Maybe try to search for the message id:...

presume you mean the control name?

You're welcome. When linking Excel files the wizard looks at the data in the first few rows to determine the "appropriate" data type for the linked...

I'm curious if it works with Date() now, since you said it worked with Now() anyway. I didn't notice that the control had the same name, which...

I changed the field name to txtDate and the control source to: =Now(). All is well. Thanks

isladogs - your "Check Database Users" form looks much cleaner. WRT the 2nd database, I changed the scrambled PWD to another password (not...

Just use order by after the final union