Search results

How do you filter the form? through a query? if this is the case, use the same query as the basis for your report then have a button of the form to lauch said report. If the filter of your form is not a query then I would create a new query. Dave

Hi Maxim, I had a project, long ago, which required number crunching bit time done by a large number of queries with lots of formulas. I used functions such as CInt, CDbl and CLng to create new fields. Did you try those as well? Dave

I do a similar process, using 1 doc at the time, without problems, the following is some of the code in the procedure: objWord.Documents.Open "G:\IPLTemplates\OtherDoc\AcknowledgmentCanb.doc" objWord.WindowState = wdWindowStateMaximize objWord.ActiveWindow.WindowState = wdWindowStateMaximize...

For instructions on manual mail merge see: http://www.leeds.ac.uk/iss/training/mailmerge/MailMerge.pdf for a sample of mail merge (Access 2000 but should be doable) see section "Super Easy Word Merge" here http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html Dave

in the criteria field type: Forms!FormName!cboName Dave

Access will not let you delete, add or modify data using a query that contains fields from 2 tables. If you will need 2 queries to do that or, if you have cascading relationships set up, you could do that directly from the form. Have a look at the following link...

Do you want to do this with code or manually? Dave

Hi, I am pretty sure you cannot send the values of only some of the fields. You could use a query (based on the temp table) to export text (check out TransferText in Access help) or modify the make table query to export only the values of the fields you need. BTW, acExportMerge is only for...

Don't know if I understood your Q properly. I use the following line of code to transfer the contents of a temp table to a 'hard coded' directory: DoCmd.TransferText acExportMerge, , "tblMailMerge", "c:\temp\MergeTable.txt", True Dave

Check out the DataEntry property in Access help. Dave

On the OnOpen event of the form you could do Dim intTemp as String intTemp = DCount("[FieldName]","qryName") If intTemp = 0 then msgbox "There are no records, form closing....." docmd.close "frmName" end if Dave

I use the following SQL to establish any missing SubID in tblSubmissions: SELECT T.SubID+1 AS Missing FROM tblSubmissions AS T LEFT JOIN tblSubmissions AS T1 ON T1.SubID=T.SubID+1 WHERE (((T1.SubID) Is Null)); Note: the SQL is stored in qryMissingSubID then I attach the following code to...

Create a button on the form and attach code to it. Roughly: DoCmd.GoToRecord , , A_NEWREC Me!FieldName = DMax ("[FieldName]","TableName") + 1 You might have to set the focus on the field before giving it a new value, if that's the case: Me!FieldName.SetFocus Dave

Is Null works in queries, IsNull works in VBA. When I tried IsNull in queries the results were erratic, sometimes correct other times not so. However, after many years and version of Access I have had to change some queries to If ([FieldName] Is Null or [FieldName] = "", etc Dave

I never had to find out about this, so I didn't. I offered opinions given by developers that are much better qualified then myself. So, if you need to, it is up to you to dig deeper ;) Dave

On the OnClick event of the button put the following code: Call MasterKey that should do it. Dave

Make the field taller? Dave

Have you got any of the following: 1) AutoExec macro to open a form 2) Tools ===>StartUp and select a form to be opened from the field labelled "Display Form/Page:" Dave

I haven't tested it myself but, apparently, the query is quicker then SQL because SQL is compiled every time that it is called while the query is compiled only the first time that it is opened. So, I think, while the first time the SQL and the query will (probably) take the same time to...

I have an archives of projects done by my section that requires an id for each project for each year (2000601, 2000602, etc) So I created a query that creates my new id: SELECT DISTINCT Year(Now()) AS YYear, Right([YYear],4) AS code, Max([Project No]) AS Num...