Activity Stream

I created a Pallet table with just a Qty and WorkID field. Then I created a form for the user to fill out. They stated how many items could fit on...

lmjconvey89, The forum serves a wide and varied audience. Perhaps you could describe or show readers your solution in keeping with the intent of...

If IsNull(me.txtstartDate) then Docmd.openquery "qsAllRecs" Else Docmd.openquery "qsDateRange" end if

ok thanks to all

OK - Sorry but I can't replicate your issue.

unfortunely i have that message and i cannot do it anymore since a couple of months...don't know why...

Hi Orange, I've worked out a way to achieve what I needed to do, thanks for the help though.

Thats great I will investigate this, as this is exactly what I am after. I know the end users what it to do magic... , but this makes sense For...

I do believe it is because an Access select query will retrieve a set of records up to a certain size from a large set and present enough of them to...

I've looked through the code for the Excel Submit_Click() and it seems pretty straight forward. And it looks like you have at least 2 worksheets....

OK, now you are changing the FORM's record source, bypassing the query. This is OK as long as it works for you - you get to decide the method you use...

Just retested in the current version of Access 365 and in Access 2010 You can still drag database objects from the navigation pane of one database...

Thank you very much... your code worked well for me and I understand why it did not work before. :)

FYI...acSaveNo does not refer to not saving Data...it means not saving changes that have been made to an Object...a Form, in this case! Linq ;0)>

Not all will cause issues but I have encountered some. Once had to rename a field before query filter would work because even wrapping in didn't...

Why is user given choice to unlock? Should be prevented if approvals are not done.

Figured it out. Added ServerName to query

Undo works good thank you!

Hummm. lots of reserved words....who knew! tks

Come to think of it, this does seem kinda convoluted. Making a change is locked behind some logic, however if you choose to unlock and then edit...

Then you need to run UNDO command. Why would you want to negate user work?

Should have gotten a warning when field was created. Review http://allenbrowne.com/AppIssueBadWord.html

thanks, works perfectly.... i wasn't aware there were "reserved words" who knew.... : )

thanks, for no other reason than it looks better on the form (all in 1 line like this)