Hi all,
I need to insert data from recordset to the new MS word document after the user clicks a command button in a Form. Is there anyone with the solution for this?
Your assistance will be highly appreciated.
Regards,
Kassimu
Kassimu
Last Activity: Nov 20 '08, 04:53 PM
Joined: Apr 18 '08
Location:
-
Inserting HTML table into New Word doc
-
Changing Form Headers Properties
Hi there,
I have a database with 30+ forms. The forms were generated using one of the Access 2007 theme. The problem is, when MS office color is changed say to black - everything changes to grey. I want to lock the properties to the state they are now-regardless of the office color. I have considered manually changing the properties but the workload is huge, at least for the time being.
Is there a VBA code that is able to change font... -
Bullets in Memo text Field
Hi All,
I have a memo field in my report and I want it to be displayed with bullets. The problem is I cant automatically apply bullets to all the records since access has facility to apply them to the selected text. Is there some VBA codes or macros to do this?
Your assistance will be highly appreciated. -
To query subdatasheet/subform
Hi all,
I have a table which has a subdatasheet. I need to create the query that will have additional field(s) for each record in sub datasheet. How can I create such a query?
To bring in the actual picture; I have a form frmOrders_Main which is bound to the table tblOrder_Main and it has the following details, OrderID, OrderDate and Customer along with a subform listing all the products with their price for that order. I need... -
I have got it sorted out! I changed the code to:
...Code:Private Sub Form_Load() Dim vntTempData as Variant Dim rstUpdates As DAO.Recordset Set rstUpdates = CurrentDb.OpenRecordset("SELECT * FROM [Daily Fault Update] WHERE [TT_Number] = " & [Forms]![TXFaults].[TT_Number]) While Not rstUpdate.EOF vntTempData = vntTempData & rstUpdates!Description rstUpdates.MoveNext -
I am still getting the same error!
I remember to have read somewhere that One has to define Query parameter If I s/he has to use query as the base for the recordset.
How to do that?Leave a comment:
-
Filtering Recordset in MS Access-Run Time Error, Too Few Parameters!
Hi there,
I have a table [DailyUpdates] with thousands of record entries, usually the user searches this table through SearchForm resulting into some recordset. What I need to do on this recordset is to concatenate the contents of all the records for one field-[Description], and populate the resulting into textbox [FaultComms] of a form [UpdateSummary]
...Code:Private Sub Form_Load() Dim db As Database Dim rstUpdates
-
Bellow is the code I am using but i am getting errors
[tblMasterOrders].[Communications] = [tblMasterOrders].[Communications] & vbCrLf & vbCrLf & _
Format(Now(),"m m/dd/yyyy h:nn AMPM") & vbCrLf & _
GetUsername() & vbCrLf & _
[txtNewEntry]
Thnx and regards...Leave a comment:
-
Updating MS Access Memo Field
I need to update the memo field in the access table. I have unbound form frmNewEntry with two text boxes [txtNewEntry],[txtID] and one command button cmdSave. Usually the user opens the frmNewEntry to add new information when s/he presses cmdSave the content of [txtNewEntry] is added to the memo field [Communications] of the table tblMasterOrders whose record ID equals to the value in [txtID]. Furthermore I need additional information added as well;... -
Kassimu started a topic Searching Access by a Form with Textboxes and Display Results in Another SplitFormin AccessSearching Access by a Form with Textboxes and Display Results in Another SplitForm
Hi guys out there,
There is this database Iam creating, I have a table with 40 fields among which there are Date/time, Text, Number, Memo and Yes/No fields and I have created the form bound to that tabe. I have also created Unbound form (for searching purpose) which is similar in layout with the bound one; in this search form the user will fill-in the keywords in as many text boxes as he wish to narrow down the search. The search results...
No activity results to display
Leave a comment: