Search results

Dear All, in the attached database file : there is a frm_Deployment Form . I need when I click submit : the [To site] Field which is shown on the frm_Deployment Form update the [Sites_Comp] Field to be [To site] Field in the tbl_Emp Table for each employee in the subfrm_Emp...

Dear Friends, I have 3 tables : 1-Emp ID_Emp (Primary Key) Sites_Comp 2-Dep RefNo (Primary Key) ToSite 3-EmpDep ID_Emp RefNo I have a form contains Dep and sub form of EmpDep This Form should contain RefNo and ToSite (Dep) related to them numbers of employees listed in...

Hello brothers, I have a table called "EmpVisaType" consist of EmpVisaType - date1 - date2 EmpVisaType CompDate1 CompDate2 A / 01/01 /31/01 B / 02/01 /28/02 C / 03/01 /31/03 D / 04/01 /30/04 E / 05/01 /31/05 F...

Hello Brothers, I would like to ask about how to make the database after finishing it to work on any PC. for example : I had finished a database and it's ready to be used but I have to install the visual basic and sometimes the "dll" &"ocx" files are missed,,, so I have to copy those files...

Hello Brothers, I would like to ask about how to make the database after finishing it to work on any PC. for example : I had finished a database and it's ready to be used but I have to install the visual basic and sometimes the "dll" &"ocx" files are missed,,, so I have to copy those files and...

Hello Brothers, I've finished a small database using MS Access and I need to add an option (Compact & repair database) , it's OK, but I'm wondering how to rar the whole folder of my database via command button. waiting any help Thanks in advance

Hi Brothers, I've a Sale Invoice form contains : Invoice No. , Invoice Date , Customer Name , Customer debts (Number) , Customer credits (Number) ,,,,,, etc. The field Customer Name is a combo box, it's row source is query contains : Customer Name , Amount , Status(Debt,Credit) I need to get...

Dear Brothers, Suddenly I found the Addin toolbar disappeared in some of my Access files I don't know why this occurred If someone knows and could help I'll be appreciated Thanks in advance

Hello Brothers, I have a form that requires serial no to enter the database this serial no is depending on the HD serial no after calculation but no way to enter. The code I'm using On Click event on the form: If (Me.HardiskSerialNo.Value - 479277050#) = Me.txtSerialNo1.Value _ And...

Hi brothers, I've a very bad problem with my MS Access files, suddenly corrupted and give message : "The Visual Basic for Applications project in the database is corrupt." The files could not be opened normally and when I click OK the buttons on forms are not working, in addition the modules...

Hi Brothers, I've a small database containing data about prices of shops, flats and lands all I need how to get results using price search between a range. for example : the client need to search a flat between : 15000 - 20000 $ Thanks for help

Hello Brothers,, I've a problem with calculating penalties I've a calculation report contains : ID - FullName - EntryDate - ResidenceExpireDate - Procedures - Penalty *The Procedures are : IssuingResidence - RenewResidence - Exit The penalty should be in some cases according to procedure ...

Hello Friends, Happy to see you again, I have a report that should display the following Job - Nationality – Number The data is selected by check box For example : Name - Job - Nationality 1- Joe - Engineer - American 2- Peter – Engineer – French 3-...

Hello friends I have a report about the Procedures Type. This report has group (ProcType) So, every procedure type will show related employees. The problem is : The committee need just 8 records per page, it's OK I did it, but if the no exceed 8 (for example 9 ) the report should show just 5...

Hello friends, How are you, here we're again I'm asking about how to create 2 timers on the same form I've a timer to play label with this code : Static C C = C + 1 Me.Label1.fontsize = Abs(C) + 8 If C = 10 Then C = -10 End Suband set the timer interval on the form properties to 200 Then I...

Hello friends How are you all ?? hope you're fine. I've designed an error message using VB 6 and need to link this project to my database (MS Access format). Any idea how to link or how to call from MS Access , and which be better to make it exe or Active dll. Thanks in advance, waiting to...

Hello Friends I'm asking about how to justify directions for text boxes in reports. I found many replies about Stephen Lebans Active X control, and installed it from his website. But I couldn't use it properly, if any one knows how to use to control the direction perfectly, I'll be appreciated...

Hello Friends, I've a new question How do I delete Forms and Reports after specific period ? What I need exactly : after specific period all Forms and Reports will be deleted without control from the user. which method should I use to do that ? Thanks a lot in advance

I have a problem with printing reports based on date query (the date is placed in a subform on the Mainform). What I need is to print these reports directly by one command button without showing the reports, under some conditions regarding multiple copies May be I couldn't explain my case but I...

Hello Friends I have a problem with printing reports based on date query (the date is placed in a subform on the Mainform). What I need is to print these reports directly by one command button without showing the reports, under some conditions. May be I couldn't explain my case but I will tell...