Search results

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

JANR 's code is correct You can't use Form_frmCase.txtCaseNum = & Me.ddCaseNo.Value when you try to open frmCase

You mean, when you type a value in field1, field2 have value as field1?

First: ds,rs you declare for what ? Second: strMap in code is exactly a string "Select Google Map From Residences Where Address = your address---> it 's not a sql ---> Try following: Private Sub Command45_Click() Dim rs As DAO.Recordset Dim strMap As String strMap = "Select Google Map From...

Example: CCC Gate Report has Recordl Source:tblCCC_Gate (ID,Col1,col2,...) If you want to print ALL Records--> Where Condition : none If you want to print some Records which ID="x"--> Where Condition:[ID]="x"

Hiii, I like this forum. I can improve my English and Access. Thanks a lot!!!!!!