Recent content by hiền muội

HI All :)

Hi Greg :)

:) :) :) :) Hi all

I work to live

Nobody could help me?

I have a table : ID___ Code _____Numchar 1_____56_______ 1 2_____55_______ 2 3_____93_____ 3 4_____140_____ 4 5_____144_____ 5 6_____176_____ 6 7_____206_____ 7 8_____230_____ 8 9_____259_____ 9 10_____267_____10 11_____290_____11 12_____300_____12 13_____306_____13 14_____321_____14...

Sorry for my English if it gives you any inconvenience. Please look at my attached image. I have a table and I want to create a report with "Group and Sorting" [PO#] field, and combine the number Box size for L, W and H with the same number I appreciate your help Thanks a lot

How can I import forms, reports, macros, modules from an mde as you said to another database? Thanks!

@HiTechCoach,Georgedwilkinson: Thanks for your help.

Hi all, Sorry, my English isnt good, it makes me confused . How can we get all IP addresses on LAN using VBA? Thank you!

With macro condition you can use DCount function to preview report if their is data as a result of the query. For ex: Dcount("*","QueryName")>0

use code: docmd.openreport "Reportname",, acViewPreview,,[fieldname] = Forms![formname]![controlname on form] The fieldname argument is the name of a field in the underlying table or query of the report you want to open. The controlname on form argument is the name of the control on the form...

What action you use in macro,andmunn? Try code: [SalesID]=[Forms]![NameOfMainform]![NameOfSubform].[Form]![SalesID]

Value: IIf([quantity]<0 Or [Price]<0,0,[quantity]*[Price])

Use Event BeforeUpdate for txtPrice to calculator averageprice. Example: Private Sub txtPrice_BeforeUpdate(Cancel As Integer) Me.txtAveragePrice=... End Sub