Recent content by rogerarce

Thanks Randy

I have created a table with names and address of customers in it. I have their firstname and lastname but want to create labels. How can I get only the first letter of their firstname and lastname to I can either store it in a field in the table when new people are entered etc., so I can pick it...

Hello. I have 2 databases in the same directory. One has a linked table. Everytime I need open the one with the linked table I have to go to the linked table manager. I would like to avoid using the manager; is there a way to do it with just one button click? DB1 c:\inventory\inventory1 DB2...

Hey! dhookom it worked great! Thank you for your help! Is there a web that you can recommend I should read to lean more about this? Regards!

Can someone help me and tell me what is wrong with this code?: dbs.Execute " INSERT INTO Pagar ( Factura, Bodega, item, Cantidad, Monto )" _ & " SELECT Facturas.FacturaID, Factura2.Bodega, Factura2.item, Sum(Factura2.Cantidad) AS SumOfCantidad, Sum(Factura2.Monto) AS SumOfMonto " _ & " FROM...

Hello Majp: I´ll work with the code you pass. Thanks for your help. Regards

The code i use in my form is very easy and simply. I have one field with date format. field [Date]with date format: date 01/04/2010 I have one more field [week] with WW format =[date] Then when you type the date on field [date] it shows the week number in field [week] Ej. [01/04/2010] =...

Hello friends: I made an order entry application 2 years ago. The orders ship by week number. The problem is the following: If I enter 12/31/2009 happens to be week 53 but if I enter 01/01/2010 happens to be week 1? I have 2 printer calendars that show week 53 from 12/12/2009 to 01/01/2010. This...

Thanks for all the ideas.

I hear about a code to check for the HD serial?

I had changed the Plant and labor fields to numeric, that why I did not include the & Chr(34. I just changed the [preciounitario] to unbound, but it presents the same problem.:(

I made a small application at work, some people use it and I do not want anybody to take the application with them when they change of job .How can I prevent someone to run it in a different computer? Thanks

Here's mu code: COMBOBOX1: SELECT DISTINCT [codPlanta] FROM precios ORDER BY [codPlanta]; COMBOBOX2: SELECT DISTINCT [Labor] FROM precios ORDER BY [Labor]; Filed LABOR: after update Me![PrecioUnitario].Value = DLookup("[preciounitario]", "[precios]", "[Planta] = " & Chr(34) &...

Fneily: Is the one you provided: fneily (Instructor) 18 Jun 08 10:56 I created two comboboxes. The rowsource for the first was: SELECT DISTINCT [Plant] FROM customer_table ORDER BY [Plant]; The rowsource for the second was: SELECT DISTINCT [Labor] FROM [customer_table] ORDER BY [Labor]...

There's something funny happening with the code: If we take this example: plant Labor Price 01 01 0.20 01 02 0.15 01 03 0.10 02 01 0.30 02 02 0.45 What happens is that the code will always return the first price from 01 01 $0.20 even if 02 01 is...