Search results for query: *

Hi folks! just having a dilemna on this, a form that has a subform. on the main form there's a First date and a last date fields, Now on the subform a field named: remarks I would like to placed the code on the after update event, when updated it will update/write in the field: [Issue date...

Hello guys, I have a button on the form "PROCESS" where If clicked it will run an SQl (make-table qry) and Im hoping if the made table can be transfer/send out to another database file..can this be done automatically or be included in 1 process button...? thanks mybers

Hello everyone, Im trying to figure out how do i make the Icon dynamically attaches itself or the access finds its icon where the mdb file is also located...in short wherever I might transfer/move the access.mdb to another location..the icon will dynamically connect/attach..is this possible...

Hello guys! Id like to have the Icon to be set dynamically when I open my access. is this possible? let's say...I placed my access file on c:\rciis\test.mdb, also the test.ico as its default icon on the same directory. is it possible that when I change the source directory to c:\test.mdb the...

Thanks Dhookim When things get rough, brains screws up! Thanks.....got it now....I should be more familiar with naming conventions Regards, mybers

Hello guys,, So far this is what I wrote: [highlight yellow]Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)[/highlight] Select Case Len(Me.name) Case Is < 20 Me.[highlight blue]name.[/highlight]fontsize = 22 Case Else Me.name.fontsize = 20 End Select...

Hi Agif Sorry for not able too to explain it clearly. On the text field: "complete" I have placed/wrote this statement: =Nz(DCount("Remarks","tbl_training inventory","Remarks='DROPPED'"),0) Now, it showed all the records indeed from the [tbl_training inventory], However I would have to...

Hello dhookom It gives me an error msg "compile error invalid qualifier' How do I get go around this?

Hi Agif It surely worked! However, the continous form is filtered by a certain parameter. Ex. Schoolyear=2003 The form is set as a subform i.e. [forms]![frm_rcy detailed trng]![submain]![remarks] How do I get around with this? Thanks

Hello guys! On my continuous form, a field name [remarks] has 3 value list namely: complete;incomplete;dropped Now, I would like to get the total/Count of all the [remarks]=”complete” values only. And the other values separately. I have placed this on the page footer so far and still to no...

Hello Guys, Is it possible to resize a textbox if the length of the text becomes higher than 20 characters making it smaller like from 24px to 22px? Ofcourse, the succeding pages will not be affected as long the length of the text remains below 20. Please save me from this agony of...

Hello Everyone I have this Certificate like report where I have a field of [issued date]. My problem is that I would like to have an output something like this: Issued this day of 23rd day of May , 2004. The source field is set to #5/23/2004# Is there a way to add "rd" or "th" on this...

Hello RezaNana I tried making a bmp file with a filesize of 8 kb only. apparently, when i execute the mdb file it gives me an error and "Do you wish to repair" etc.... Was there something I have missed or not getting it right? pls help

Hola! Is there a way I can replace the MS access splash screen on open? or at least have the control not to show the splash screen... Pls help...thanks in advance regards, mybers

HiAll Short question I hope, I have a subform that has a listbox which contains Employee's names, Time-in/out etc.. which is being used/updated by the minutes or hours etc...from a Third party VB program. Now Im hoping to write a code that will requery the listbox on a timer basis. I hope...

Hello I have a switchboard form which has sets for menus. In a button or a labelbox clicked it will open an external or another MS access file. Ofcourse all/ any external access files are linked to one table source. How do I go about this in a Module? Regards,

Hi evansc Have you tried using hyperlinking the text to a particular word file?

Hello I dont seem to find any issues of making the tab control pages to be transparent nor make the tabs color change... more specific directions please... Thanks in advance

Hello everyone here.. short question: Is it possible to change the backcolor of the tab control page (i.e. =white)? or at least make it transparent? Thanks

Hi AccessGurucarl The sound script seems to be complicated for now, Anyway I would like to focus on the OnMouseDown/Move for the meantime. I have set of labels now forming like a navigation menu. What I want to achieve is that when the Mouse gets over the Label will change and back on...