Search results

Thanks pbaldy..i often use the =fOSUserName() on the "open" event of an form or on the "after update" event of an form..how would that work in relation to you suggested method? Thanks!

Hi all, hope this is the right forum for this question... I use this function to pick-up the system user and create a time/name stamp. Unfortunately this also can create a security issue since the username is to be considered “personal” and not be shared. How do i create an “alias”...

Its a date field..but i found out i need to format it... dd-ddd-mmm-yy..now it works..strange Thanks!

would it be possible to use this method to also exclude dater-anges from a query?..lets say i dont want to inlcude records "older" than 1 year to be included in my query..this to return higher performance... Thanks!

Hi all, i use this in the criteria for "due" date <=Date()..but for some reason..it does not return correct values..alos future dates becomes displayed... Why? Thanks!

Hi, I have enabled the filters in the datasheet but would like to save one filter...i have a “due” date for my displayed records and i would like to use the advanced date filters..especially the “before” criteria... Thanks!

My compliments to a great site bobLarsson..indeed.

Thank you BobLarsson..will look into this aswell.. Thanks!

Much appriciated Trevor... :-) hope this will decrease the number of forms with 50% Thanks!

I believe i have too many forms in my Access 2007 Application. Currently performing the “basic” migration to SQL i noticed that an open form “pulls” a lot of “power”... Where can i find some good examples of forms used for multiple purposes, “applets”.. One example: I want to use one form that...

So..it was my own stupidity that made this happen... 1, Read the instructions. 2. Read the instructions. 3. Read the instructions...bellow is the solution..I learned a good lesson :-) In the row source property of the combo box: SELECT DISTINCT AlertTypeEx.Alert FROM AlertTypeEx ORDER BY...

no..i must be doing something very wrong..i am following the example 2 in http://www.fontstuff.com/access/acctut10.htm by the letter.. not my day..

A combobox..controll is a dataype "text"

A character..

Thank you Drake..i did..but still no raction..i entered the "correct code".. The controll "AlertType" should present a value list.. strange..the code editor feels cold like a dead fish.. Private Sub Alert_AfterUpdate() AlertType.RowSource = "Select AlertTypeEx.AlertType " &...

Hi all, i pasted this code in a sub and expected an "error" or "debug" message..but nothing happenes..why? Private Sub Alert_AfterUpdate() On Error Resume Next cboCity.RowSource = "Select tblAll.City " & _ "FROM tblAll " & _ "WHERE tblAll.Country = '"...

Thank you, i will try this approach and let you kow the outcome, much appriciated.

Your words are very true, i have conducted tests overseas (one Continent) and received a positive reaction, however, connecting Continent 2, may return performance issues. The current solution, step 1, is to simply place the tables on the SQL, dramatic increase in performance over VPN, perhaps...

Hi all... Table A. 10 fields. Field 1, Primary Key. At the date entry process it is only necessary to populate Field 1 and 2, i then want to update the remaining 8 fields at a later occasion. I receive a report externally with Field 1 – 10 populated...but how do i update Table A with this...

Thank you very much Mr Doc...interesting indeed and very helpful..i iwill revert with results at appropriate moment.. Nothing can replace a grand pa, :-) And a valubale MPV indeed your..title or not.. :-)