Search results

Hello I need a query to copy records from a table to another table without duplicates. Many thanks in advance and your help is most appreciated. Carlos

I've created a form with its subform to enter tasks of employees. however I need filter records only for active employees The form has as a source, the table CARD_EMP (employee card). It has a field ST_EMP for the employee status (Active , Pasive) In the Event Form_Current I wrote...

I have created a first form (LOGIN_FORM) with a username and password With other form named CHANGEPW_FORM the users can change their password. (Table: USERS Fields: IDUSER -Autonumeric-, NAMEUSER -text-, PASSWORD -text-) A user enters their name and password. After that if the form...

Hi EJSTEFL Thanks for you answer, but I need to review each record. Something like that: do while not eof() compare PERSONAL_lastname with CUSTOMER_lastname if p_lastname = c_lastname then save p_lastname in Table EQUALS endif skip enddo Thanks again Carlos

I have two tables named PERSONAL and CUSTOMER PERSONAL table has fields : ID_PER, P_LASTNAME, (key = ID_PER) CUSTOMER table has fields : ID_CUS, C_LASTNAME, (key = ID_CUS) I need a process to review each LASTNAME in PERSONAL table and to search if there is a equal LASTNAME in CUSTOMER. How can...

Hi Paul Yes. the form was opened Thanks

In a report, in the header there is a control defined by the formul : "From date: " & Forms!Sales!Begin & " - To date: " & Forms!Sales!End In the print preview the data is showing up correctly, but when you go to print the report it is printing #name? Any suggestions would be very much...

There is a form ORDER wich works with table TORDER One of its text box is NAME I need insert the the name's data in the table TPERSONAL (other table) , in the field NAMEPER How can I insert a record in that table ? Thanks in advance CM

In a form named PRODUCTION there are 3 text box for invoice data: xtype, xserie, xnumber I need valid this data from the INVOICE table, where its key is a compound key (TPINV+SERINV+NUMINV) I tried with Private Sub xnumber_AfterUpdate() Dim searchinv as string...

I've designed a form to show records about "Marks" When I select option "All class" (gpoClase<>1) the report show results, but when I select the option " A class" (gpoClase=1) and enter a class, for example '10´ , it doesn´t show any result. What's happening ? I've attached the mdb file This...

similiar problem with textbox in report Hi Paul. Thanks for your advice. I've created a form and a report with: Form: frmTest Texbox: monthx Texbox yearx Report: infTest Textbox: period If I would show in the report, for example: "February / 2006" , (the concatenation :monthx+yearx) In...

I've designed a report with a header which has a special title that it depends on a previous form's textbox In the header page I used a textbox with: =Forms![formname]![controlname] This works fine on the first page. However next pages displays an error: # name I need show the title on...

I've designed a form to register the parametros of a world-wide statistic report In the form I have a combobox to select by pais, but additionally I need the option 'ALL' for to inform about all countries How I can include the option ALL in the combobox ? Thanks Carlos

Hi Pat Sorry. I'm late Yours answer helped me a lot Thanks Carlos

Sorry. I'm late Yours answer helped me a lot Thanks Carlos

I've used a form with labels for building a menu options ¿How can I do to enabled or disables a label ? (each label is a menu option) I've tried to use: label1.Enabled = True but don't work Would you help me ? Thanks a lot Carlos

I've used a form with labels for building a menu options ¿How can I do to enabled or disables a label ? (each label is a menu option) I've tried to use: label1.Enables = True but don't work Would you help me ? Thanks a lot Carlos

In a Library database, there is a form about Books Lends o returns (table: MovBooks) When someone needs a books, I need verify if the book is lended or not. (Table: Books, field: Status -Yes/No-) and update if its free I want to resolve this problem using Recordset. Thank you very much

Thanks Maxmangion I'll try it Carlos Lima-Peru

I've got a form about personal attendance list (table: ATTENDANCE) where I need show their photos (these OLE images are save in another table PERSONAL) How I can show photos in the attendance form ? Thanks