Exporting datasheet to word, how is this possible using vb. Actually, I do have a thread in Form forum. But, I think not a lot of people visit that place. Anyways, I have created bookmarked and used datavariable to export the data (by ansentry's help). But the only thing that it exports is just one selection on that datasheet, instead of all the chosen rows.
I am exhausted now after searching everywhere, and not finding a clue. How to resolve that situation. If there is an example that I can use, that would be gr8.
How to match 4 character word or number or combination by identical 4 characters word or number or combination in one word have 10 or 15 characters.
I have to two separate tables (Table A and Table B). Table A has one column (Tag No) and Table B has about 15 columns with one column name Tag No as below
Table A
Table B
Tag No
Tag No
2009
ZZZ-2030-DC
2010
ZZZ-2010-M9P
[code]....
They're both in MS Access.I am trying to match 2 tables - columns (Tag No) with join query, but not success. I want to match 4 characters in Table-A with 4 similar characters in Table-B (Tag No) cell.What query is suitable to compare two tables.
There is a requirement for 1)Populating a datasheet in a subform with a querystring which is dynamically built in VBA.This querystring is constructed based on the search criteria fields selected by the user in the main form.How can this be immplemented?
2_To click/double click a record in the datasheet,extract data and populate textfields,comboboxes with it which are in the main form.How is this achieved?Also,I can't find click events in a datasheet.
My end goal is to populate a pre-existing table in an MS Word document with records from a query. The easiest way I've found (through scouring the internet) is to start with the code below (ran during OnClick() even in Access) to get the table the same size as the recordset:
Code: Dim wDoc As Word.Document Dim wTable As Word.Table Dim wCell As Word.Cell Set wDoc = appWord.Documents.Add(strDocLoc) wDoc.Visible = True
[Code] ....
The code will shrink the table down just fine if the table has more rows than the recordset +1 (for header column). My hangup with this is the last line ("Selection.InsertRowsBelow 5") isn't executing; rows are not being added to the table. I get no errors -- it just does nothing. I set it as "Selection.InsertRowsBelow 5" arbitrarily just to see if it would even add rows, and sure enough it's not.
I have an access 2000 db. My users open the DB and I have it launch a simple “startup” form with various buttons for the most used features. I have one button that launches another form. The default view of the form is supposed to be in ‘datasheet’ view. However when I click the button it opens in ‘single form’ view.
What can I change on this vb code to allow it to launch in datasheet view instead of single form?
Private Sub cmd_su_checkpaid_Click() On Error GoTo Err_cmd_su_checkpaid_Click
Dim stDocName As String Dim stLinkCriteria As String
By using a datasheet view in a subform and a custom popup menu I can allow users to filter down to the records they wish to view, in whatever order they want, and then allow them to open/edit said records with a Double-Click Event.
Fact is there are so many ways that different departments wish to filter this works in theory and in a sample I have created. A search or filter form would be huge. This seems simpler.
Ok, all good in theory, I can restrict “new” and “edit” etc, but I can just see users resizing the datasheet view to something only brain dead users could do or hiding columns. <SHUDDER>
So my question is, can or is there some why that I can use the OnOpen or OnLoad event to re-size the datasheet to a default size? (Well the fields in the datasheet mainly) This would allow you average bi-polar user to mess and re-size until their coffee mugs run out and the next user doesn’t get left a mess. (Which would then force them to ring me!) <SHUDDER>
I hope this makes sense, I really hope someone can point me in the right direction. Have a look at the sample database attached to get a better idea of what I mean.
I have subforms that are datasheet view, if the user rearranges the coloumns, or resizes etc , I would like to save what they have done so it is as they left it next time they open up the screen.
This works fine with an mdb (all my forms are set to close acsaveNo).
However in an mde this doesn't work.
Can I get this to happen in and mde.
(A button that saves a layout change would be fine for my purpose)
HI i never needed help this much. i worked on an access application for 1/2 year. Everything went fine. But now we wanted to start working with it, some older acces versions are acting weird.
I have a form that contains a subform datasheet, and the datasheet has a datasheetsubform aswell.
This works fine in 2003. De datasheet is displayed, and when you click on the plus, the other datasheet opens in the maindatasheet.
But in 2000, you dont see the plusjes. It is a major issue that i fix that! can some help me to solve this?
Is there a way to set the background color of a datasheet? I don't mean the color of the cells, but the datasheet itself outside of the rows/columns as shown below (dark grey color):
I have a form and a datasheet subform in Access. A form has person info and datasheet subform has 4 fields: QuestionID, QuestionNumber, QuestionName and Answer fields. The Answer field is a dropdown field and has 3 items: Yes, No and N/A. If QuestionNumber from 3 to 6 the answer was Yes or No then lock the Answer field in Question 7. Any idea how to do it?
I'm working on someone elses database, and I'm not too familiar with access.
He's got this form called Customer_Select, and when you click on a check box for a customer, it's option value is recorded in a field called Product, which then corresponds to the product/customer id located in a table called CustomerCharacteristics.
The problem is that I just realized that this Product field existed. When I view the form as a datasheet, I see the fields: Product, Lot_Nr, Version:, and Last Update: However, when i look at the field list for the same form in Design view, I get: DateTime, VersionDisplay, and Description.
Does anyone know what's going on here? I need to reference the Product field in a query I'm modifying, but the expression builder can only 'see' the fields that are visible in design view.
Is it possible to switch the view of a subform to datasheet when a command button on the mainform is selected?
I know it is something involving acFormDS...but I cant figure out the rest of the code! I appreciate your help in advance!
(P.S. I know you can right click the form and select datasheet. Unfortunately there are not many people here that are familiar with MS Access and I dont trust that they will know this)
I am reviewing a program that in datasheet view has '+' signs in the left-hand column -- it displays rows of companies. When I select a '+' another 'sub-datasheet view' of employees of that company appears, partially covering the original datasheet view of companies. Is this the way sub-forms look in datasheet view or is something else involved? Thanks
I'm trying to make a Navigation form for end users that can open a datasheet from a control button on another datasheet. I've got that but when you click on the control button in the first datasheet to bring up the second datasheet the second datasheet comes up like the normal datasheet view in access, not in my navigation form. Is there a way to make it come up in the navigation form? Or maybe I'm going about this the wrong way.
I am exporting a table to word and I have come across a problem. My code opens a template, creates a table with the correct number of rows and columns at a certain position, and then adds data to it. At this point, everything is fine. But, here is where the problem sticks its ugly head out. I am modifying the column widths and every other time I run it, it crashes, saying something about not being able to access the remote server. Run time error 462. I have checked in the task manager that word is being quit properly each time and tried going to different templates. The first time I run it, it runs fine. The second time, it crashes on the line where I change the width. Here is the line of code.
mytable.Columns(1).Width = InchesToPoints(1.2)
I have found that if I close the document after it is created and leave word open, it will run fine. I think I am in the same boat as mrpauly. But his post date is 23rd April 2001… http://www.access-programmers.co.uk/forums/showthread.php?t=26363
Has anyone else seen or heard anything like this? I’m really confused… Thanks for any help anyone can give.
Hello, I made a database application and i need some help: in the application i use a script that modifies word documents by opening ms word application, but some customers don't want to install ms word. I'm asking if someone knows tto exist some kind of word runtime that i can modify word documents without having word installed. I'm using also vb6.
Hi, can someone tell me if there is a way to save several different datasheet views? I have a large database with many fields. I use forms for data entry, but to view the data I use the table datasheet (so I can see multiple records at a glance). But every time I have to manually move, freeze, and hide columns to get the view I want!! Is there a way to save several different datasheet layouts that I can access the view I want with one click? because I am tired of freezing/hiding columns every single time.
I have copied and pasted some data into a table from Excel but Access wont let me add in any more data to the table - a notice comes up saying "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data".
How can I add my extra information to the bottom of the table?
I am new to access and am finding it difficult to do some simple things.
I need to know how I can set the properties of some of the fields in a datasheet so when clicked on a drop down menu appears.
I have an add record form where on one field the user can select a number of options from a drop down menu and this is then added to the table, however on one of the following forms I have a datasheet in a subform that is set to allow edits. I want a drop down menu to appear when the user selects the field that also had a drop down menu on the add record form.
any ideas on how this can be done would be greatly appreciated lads?
I have a datasheet based on a query and wish to count the number of rows in the datasheet. There is no single unique key in the datasheet, the unique number comes from a combination of two fields. How do I get the datasheet to return the total amount of rows?
I have a form (Main) with a subform (MainSub) set as a datasheet.
The main form holds details of employees and the subform holds targets and dates for the employees.
the subform has 4 fields, Target, StartDate, EndDate, AchieveDate.
What i would like to do, is show the date of the target that was achieved last on the main form.
For example,
Joe Young has 3 aims, 2 of which are complete and 1 which is still ongoing. Joe achieved his targets on 31/11/04 and 31/12/04. On the main form I would like to show a control called 'LastTargetAchieved' as 31/12/04.
If I am not making myself clear I will see if I can get a sample uploaded, otherwise, thanks for any help.
