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...

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...

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,

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 Again.... This site has been a great help for me studying my projects. It seems my subject has been posted already sometime but anyway I hope anyone can point to me in the reight direction. Question: I have a set of text box which forms like a navigation menu. I would like to do is...

Hello everyone! Is it possible to make the listbox.backcolor to be transparent? Pls help me if this is possible. Thanks in advance

Hello everyone, I have an OLE field [photo], which placed on my form. Now I was hoping that when I click the Bound image field "photo" it will open the browse window to link the images. its like I should call the proper Common dialog box for it "Insert object" thing... Can someone redirect...

Hello everyone, My database is about employee records. The process is I encode applicants records and then later I browse them and search which one will be hired from the records. Now the records will be transfered to the other table [tbl_emp]. I have 4 tables and 2 forms namely: emp...

Hello Everyone, I used the script below in my form to show an unbound image sourced from a directory in drive C:\, which worked well! Now, Im hoping to figure out how can I do the same thing in the report...Show the unbound image.... Here's the Script used in the report. Please check what Ive...

Hello everyone! I tried using the search keywords but its quite difficult to browse all of them that pertains to my questions. ihope anyone can guide me through it... On my form, I have 2 fields namely: fname and Lname Now I have an unbound text box which supposedly to find the record in the...

Hello everyone, I dont know if my this question has been posted before... I'd like to calculate the employees date hired to the present date. and be able to output the ff: 1. Years in the company 2. Months in the company, including DAY (for probationary employees) 3. months/Days left...

Hello I know using OLE object in tables makes the system slower esp as the files gets bigger. I have a 201 files with pics Id like to show/get the pictures from a directory (i.e. d:\HRD\employees\) I can reference the images with their employeeID no as its filenames. (e.q. emp01.jpg) Can...

Hello everyone, Can you direct me on how to use function keys on forms?Ive seen some codes but it didnt' work well Ive tried ' If keyascii=vbkeyF5 then keycode=o docmd.save endif Anymore suggestions? pls and Perhaps adding CTRL+F5 - etc...