Search results

are they on the same table or two different tables? I know you said a form is based on a table but does the form has a subform?

docmd.runsql sql = append query

Open a form in design mode, view code, then click on help, ask it for OpenAsTextStream method Study this: The OpenAsTextStream method provides the same functionality as the OpenTextFile method of the FileSystemObject. In addition, the OpenAsTextStream method can be used to write to a file...

create a query, drag all fields, put under the field -not null . If you ask the help button in MS access "The clip" You wont have to post here, saves you time.

Create a DELETE table with fields user name, date of deletion, and all the data deleted ( one per field or you can create a memo field that would keep the whole record - (Name = Smith, Amount = 22,etc) Before you run the delete querry, append it first to the table. For the username function...

You are the only who would know what else you want in your database. You can always add another field and update it should a requirement comes up.

Are you using a reference that might not be checked with this user? Have you tried uninstalling and reinstalling MS Access to his computer. Just an idea, won't hurt to try, right?

Has anyone tried using MS ACCESS with Advantage database server?

You have to assign recordset to the table then update the recordset field to whatever the total is. Ask the clip for recordset update.

Idea A cut out from one of my programs. I hope this helps you somewhat. Public Sub parse() Dim excel_app As Object Dim excel_sheet As Object Dim rowvalue As String, colvalue As String, combined As String Dim row As Integer, column As Integer Dim trailer As String Dim v() As String...

MDE, Corrupt Database, Front End, Back End, Never Ending Problem/ CALLING PAT HARTMAN I have a database that both have a back and front end. I may not know what I am doing so please bear with me if you think I am a bit ignorant. I made my front end database an MDE so users won't alter the...

Create a query that would show sample phone number together with the record ID Number. Use that query to open a recordset. if the count of the recordset is > 0 then msgbox "There is a duplicate entry See list?" else continue update. Put the above procedure in Before Update. IF yes, see...

Thank you.. so much THE JACK COWLEY. You are the MAN! Kiss! Kiss!

I have a front end and back end database. The form is in the front end and the table is in the backend database. The field is of memo type. When I enter data using the table, everything is fine. When I enter it through the form however, it is truncated. Help.

If the only value is X and Null, you may sort the query by descending. The x values would come first. Either that or I do not understand your problem.

Is there a criteria or is this random selection?

FIrst create a crosstab query using the orders table. ID- Group By Date-Order- Last or Maximum then link the products table to the Crosstabbed table.

iif()

datediff()

I have created a label report of names, address of records that True value for field called MailThis(?). After I print this label report I would update the boolean field called FinishPrint. Which event do I put the code for the update? I could create a message box after deactivating the...