Search results

your query is labeled: Women Radio Membership DB Query, but it pulls only Men so.....shouldnt it be : Men Radio Membership DB Query Dont you also need a table to track Membership dates , BeginDate, ExpireDate to know when membership expires? What about payments?

another way: Public Sub btnOpenRpt_Click() Dim sSql As String, sWhere As String sWhere = "1=1" 'the query is built depending on the various filters the user picks... If Not IsNull(cboState) Then sWhere = sWhere & " and [state]='" & cboState & "'" If Not IsNull(txtName) Then sWhere =...

on the form ( fMyForm), a combo box holds ORIGIN items. also a subform that holds the list of all Products the list has the PRODUCT field and CHOSEN check box user selects the origin & checks all Products wanted. then clicks a CREATE button this runs an append query i.e: INSERT INTO...

in the query add these calculations to get amts per CommType: select [field], AgentAmt: IIf([field]="Agent",[Amt],0) ,AdminAmt: IIf([field]="Admin",[Amt],0)... from table then sum in the footer: =Sum(AgentAmt) =Sum(AdminAmt)

all tables are 2 dimensional as is your example array. the table/recordset IS the array, what more do you want to do with it?

a report, using the same query in the subform.

if the sub is in the form, and you call it from the form, you can just use: formulaire2 RechercherProcedure () not needed if you are calling formulaire2 from outside the the form, then make the procedure public: PUBLIC sub formulaire2() end sub then you can call it from anywhere...

you should be able to use code: DoCmd.SendObject acSendReport, "rTest", acFormatPDF, "w.e.coyote@ACME.com", , , "Subject", "message" tho, some older Access versions may not be able to use PDF. but you can use RTF ( acFormatRTF )

if the odbc is working if the recordset is dynaset then: with rstSerial .edit .strL = "02" .update end with

uses a query , not sql: docmd.OutputTo acOutputQuery ,"qsMyQuery" ,acformatXLS ,vFile

These work for me. only page 1 shows the section data. 'PAGE FOOTER Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer) Me.PageFooterSection.Visible = (Me.[Page] = 1) End Sub

with a single click , access will make a form and put the fields in it all connected to the data. why do you want to make more work by putting code in it? (besides, you cant load multi record forms using vb that way.)

It looks like youre looking it up twice. can you just use: DMax("[Sample Date]","DDW_Import")

When db is close to 2 gig, it will throw random fake errors.

1 think that takes all the memory is multiple Tabs with multiple datasheets in them. all sheets will fill with data, sucking all memory. Instead, use 1 subform with 1 datasheet. then when tab changes, swap out the subform source. It frees up a LOT of memory.

DoCmd.ShowToolbar "Ribbon", acToolbarNo

nope. afterupdate is best. my guys scan, then press enter.

usu if it asks for parameters, then a form or query has a criteria box waiting to be filled, but the form or source query is no longer open.,

you dont need dbo to run a query. you only need 1 line: docmd.openquery "MyQryName" and it may tell you the params needed. but you do have embedded queries there.

the denied may be a false msg due to another error. Use this: Copy1File sSrcFile, sTargFile Public Function Copy1File(ByVal pvSrc, ByVal pvTarg) As Boolean Dim fso On Error GoTo errMake Set fso = CreateObject("Scripting.FileSystemObject") '(reference: ms Scripting Runtime) fso.CopyFile...