Search results

This link might help http://office.microsoft.com/en-us/access-help/examples-of-query-criteria-HA010066611.aspx

Hi Everyone, I Need help in order to filter a query based on the user who is crrently logged. I have used a workgroup before but this time, I want to use the database I have found in this site for the log in log out. My problem is that I cannot use the [CurrentUser] criteria anymore (as I am not...

How do I use this in a query and how I can do that if I am using a personlaize log in based on the database I have downloaded from this site (Database repository - 1st page)

Anyone who knows how I can filter a query based on the active user logged in? I am not using a workgroup so the the CurrentUser() does not work??? I am using the Login Database from the database repository first page

i agree with ghudson for the date picker... for the default date, I am not so confident with the now() function as it affects my reporting date especially when I have to pull or make a query dependent on dates... I use Date() for date today... With regards to what you want to accomplish, you...

yeah, I have a user level security.... another thing is that we are using the citrix environment

ahmmmm.... Use that formula on the form property itself and not on the table... I guess there are some values that would not work on a table.

i have this code on the sUBFORM with a UserStamp and TimeStamp field.

Tnx vbaInet for the follow up solution!

Because I have segragated the subforms with Tabs... The main tab has the live screen so that it displays the figures for each reason/column I want to count... Since it is a live screen, i want the data to refresh every 5 minutes.

is this UserStamp and TimeStamp?

Hi 3ammaksamer!!! I did not not include everything in that sample database... I have a main screen which I want to refresh every 5 minutes.... ehehehe

can I ask again? My challenge is, the error message will prompt but the user can still proceed when he closed the message. I want it in a way that user cannot proceed until he changed the ref doc value. Can you help me please?

Yep... Sory, i was soo occupied with the first message... ahahaha, anyways, I made some changes to the code because I only wnat the error message to appear if user choose AP AUDIT, its because I want the users to be able to use 0 as reference when the forwarded to field was Incomplete Request or...

Oops, sorry for that bro. I want my users to feel no difference between excel spreadsheet and access forms thats why I often used datasheet. In addition, it allows users to update multiple requests instantly. Regarding the Message box that will fire endlessly, I am not sure how it will happen...

Problem: Please see my sample database attached. I have a form called MAIN FORM with a subform called QryUnprocessed subform (datasheet view). The subform has a combobox field FORWARDED TO which I want to tie up to another field called DOC REF. What I want to accomplish was that if I select...

Ahmmmm... File/Get External Data/Import or Link? I dont know if this is what you need but I am using this... You can try that to other application like Outlook too.

waaahhhh.. I am still getting an error. It says sumthing like it is not bound to a column or query...

Thanks Khalil! Um gonna try that tomorrow in the office and see if it works... Sorry for bugging you,,, I appreciate your help!!!!!!!!! =)

waaahhh!!!! The codes still dont work... I had a form with several tabs.. Each tab has its own subform and when I use the code, nothing is filtered and debugs.. It says there was no form or query exist, somthing like that... Can sum1 help?