Search results

Great... it worked exactly as i wanted, thanks :) Why do we use Me. in VBA code? I'm looking forward to start working on VBA in next couple months. I just started Access 40-60 days back, so I'm looking to make all components work together before I spend myself for VBA. I'm working on one design...

Thanks eugin, I understand this is a simple code but is there a Macro variant please. I've not started learning VBA yet and trying to work things around with Macros for now. It'll be easy for me to understand.

Is there a macro which captures new record in a table or form please?? I want to place button on a form which should only appear for a new record form. Thanks.

Actually company purchased this system for a specific project and i tried to open it, but it is in .accde format and Shift key hasn't helpled. Is there a workaround please? What does generally a developer do to create an access system for MS Access please?

Thanks pbaldy. I'm using this query to fill up a combo box, while dquery() returns a single value. How could i fix that please??

There are not security levels at place except default Windows security features on folders. I've got a sample Access file from inside the company and it asks for username/password when you open the database. How could achieve so please??

What is wrong with this macro please: SetValue Item=[Forms]![frmEmployee]![TrainingID] Expression='SELECT tblTraining.ID, tblTraining.Description FROM tblTraining WHERE (((tblTraining.JobTitle.Value)=[Forms]![frmEmployee]![JobTitle])) ORDER BY tblTraining.Description' When I run this, i...

How could I make user accounts in Access 2010 so that every user has different level of access?? I've seen in sample Access database I'm provided that it is asking for username/password before opening the database file. I'm also required to do so at work. Thanks in advance.

Thanks for clearing things up about text fields. One things I need to clarity please. We normally use Primary/Foreign Key combination for this purpose. Primary keys, as ID's, can be generated automatically but we need someone to fill in Foreign Keys in the other table and no body wants to fill...

i'm working on a database about employees and training programs that they need to go through before they go for on-field work. On employee form my boss wants that as soon as I enter Project # and employee Job Title, it automatically search from the other table the required trainings against...

Hi Thanks. I understood most of the steps but I couldn't get over step 1, mainly because the guide is for 2007 version while I'm using 2010. Is it possible for you to explain 1st step from the link you provided in terms of Access 2010 please??

I cannot figure out how to cutomize my right click "Short-cut" menu in Access 2010. I need a right click menu with ONLY the "Print" and "Print Preview" options for my reports and I would like to disable right click in all other objects. I can't use VBA yet. is there any other solution?

Thank you, got your point on DateAdd(). It is much easier than what I got myself into with DatePart and DateDiff, and it indeed is the actual solution.

I've rewritten the query like this: IIf(((DateDiff("yyyy",[tblEmployeeTrainings]![CompletionDate],Date()) >= [tblWorkTrainings]![ValidityYears]) And (DatePart('y',Date()) >= DatePart('y',[tblEmployeeTrainings]![CompletionDate]))),1,0) I'm getting correct results now. Query is quite complex. Is...

Thanks, article helped. I didn't get a time how to use DateAdd function to get work but DatePart idea from the article helped me solve the issue. Posting the query renewed query below.

Thanks plog, yes you understood correct... i want to compare CompleteDate + ValidityYear to the current date. For e.g. there's a safety course on Hydrogen Sulphide (H2S) with a1 year validity. Now if the course was passed by the person on, let's say, on 30th Apr, 14. System should show renewal...

I need to generate a query where I've a requirement to show all employees who have their training validity expired once we compare the Completion Date field in one table with ValidityYears (validation on certificate in years) of training in another table. Attaching relationship screenshot, when...

Thanks for the reply, but I'm kindof confused!! When I implement both form as sub-forms and try Link Master or Link Child field, i receive error as "couldn't build a link between unbound forms". Is there a special way putting both forms as sub-forms to get rid of error please?? To clarify...

I'm trying to use sub-forms in split-forms mode, where main form displays one record and sub-form displays all the relevant records same exactly as in case of split-forms, but sub-form displays only one record. What should i do to bring the split-forms type functionality in sub-forms?? i've...

Thanks for the tip, it worked ) What did you mean by '...where you are coming from...'?