Search results

First Create a query that would capture 3 sample data. Select * from Table1 where Provider Name = "Kay" and Contract Type = 'T" and Eff Date = '11/23/2004' Assumptions - your formname is formupdate and the text in your forms has all the fields from the table. 'On After Update of the...

Can you paste the old and NEW SQL?

The insert SQl is the same as the append query in MS Access You might want to create a link to your server tables than create an append query with the Access table as the receiving table. Ask clip - How to append data OR Append Query

Reports: Save a report's output as a PDF file* Author(s) Keri Hardwick If you have Adobe Acrobat installed on your machine, you can output a report to a PDF file for viewing and easier electronic distribution to users. Follow these steps to get the various pieces together. Buy...

Ask the clip on how how to create a query.

Check the visible property of the subform if its set to no.

http://www.microsoft.com/money/default.mspx Try it first, if thats what you are looking for, I'll send you my copy. I got it free with a laptop i bought from dell. I cant find use for it, don't have much money to keep track. :) Send me a PO box address or whatever address by private...

Sorry. Thanks John A for correcting it.

I would probably create query subsets, like four querys designed to get subset from biggest set. create querydef by code, then just delete it once you're done. Ask Clip for: CreateQueryDef Method Example Other than that, can't think of simpler way, Sorry.

On click command box dim db as dao.recordset dim rst as dao.recordset set db = currentdb() set rst = db.openrecordset("TAbleNAme") msgbox rst.recordcount if rst.recordcount>0 then msgbox "no records" else ' open form - for syntax, use the wizard in creating command button, open form end...

MS has this free software MONEY, I believe.

If its only one person who is using it, better to increase hardware in C.

Have you tried using an alias? For example Select TablewithaVeryLongNAme.Field1, TablewithaVeryLongNAme.Field2 from TablewithaVeryLongNAme can be truncated by: Select A.Field1, A.Field2 from TablewithaVeryLongNAme as A

can you break it down into four different variables? Sql = String1 + string2 + ....

I created reports A with Subreport ASUB. Check the source, I created a string out of the four groupings you want so I used this new string to link it to the subform. BOth of the forms have the same query source. The sub however has 31 columns while the parent is a single column. I deleted...

did you get my message? Still waiting for your email, Sent you my work email address.

Option Compare Database Dim Num1 As Integer, Num2 As Integer, Num3 As Integer Dim CompareStringtoArray As String, WINarray(6) As String Sub DECLAREARRAY() WINarray(1) = "334" WINarray(2) = "314" WINarray(3) = "346" WINarray(4) = "456" WINarray(5) = "342" End Sub Sub GETThreeStrings()...

If your concern is how to associate the photos with the winning number combination, I would probably have a table with two fields, NumberSpin as Integer and Link as String, your photo files must be in the link as stated in the field. OR you can take a look at the Categories table/form if you...

Just to make sure I understood it, when you said column , you are referring to the column format that could be access by File, page Setup and Columns, correct? You are not referring to your tables having 10 columns a.ka. fields. Do you think you can send me the report with the table? Thanks.

I am assuming that your data is on a flat file format, like Excel, where you have three fields, CustomerID, Customer Name, Customer Address? Export this table into Access, using the append query, ask the clip how to append query, append the CustomerID, NAme to the first table. Then the...