Search results

Bob Yes but the PrintOut statements are all commented out so that I can save straight to file. '.PrintOut 'PRINTOUT STATEMENT BELOW PRINTS ONLY THE FIRST PAGE '.PrintOut True, , wdPrintCurrentPage, , , , , 1 'PRINTOUT STATEMENT BELOW PRINTS ALL PAGES '.PrintOut True, ...

Bob Yes I have generated 320 documents, they are all saved with seperate filenames to a folder. The problem is when I open one it looks fine all bookmarks are filled as I wanted but, when i hit the print button from Word the document on the screen reverts to empty bookmarks and the printed...

Hi there I have a strange one here, I am producing TOC's for a number of dossiers using Access as my database and then outputing to a Word doc. the process seems to work fine and all of the documents are produced correctly, I can open one and view it and the book marks are filled with data...

MStef / neileg or anyone else out there I think I messed up here in my original post, I should have said that there are 3 scenarios that I am trying to report on but only 2 outcomes. If mytable[system]=700 (AND mytable[Etot]=0 AND mytable[Itot]=0)Then "N/A" If mytable[system]=700 (AND...

many thanks to you both neileg and MStef, I just couldn't get the syntax right before!!

Hi there I'm trying to write a query using an IIF statement in the "Field" property of the Access Query Design Grid the new Column is called F: there are 3 Columns, System, Etot, Itot in a mytable Basically in English the query goes, IF mytable.[System] = 700, mytable.[Etot] = 0...

Hi there I am trying to use a list box and multi select from it as a source to enter data into a bound field in a table. I found what I thought was just what I need but I keep getting error 424 object required! The list box is on a form bound to the field [comments] that I want to update. The...

Guus2005 Thanks for the info, I think the Temptable even if it is linked might suit as I have added a couple of columns to the end of my maintable now since the first import. I really only need to update one field that changes, and of course add new or delete old records. Batwings

Hi there I have a spreadsheet that I have successfuly imported into Access but now I would like to maintain it, update/append/delete records etc. The spreadsheet is produced weekly and Intend to import it into my Access database on a weekly basis there are around 20,500 records and 15...

Hi there Is it possible to change the ColumnCount of a combobox using VBA? I want to have the Filter2 combobox listed below to use the column to it's right to give me the "Description" of the Item that is selected in the Filter2 and then this text will be output to my report as below...

Bob Thanks for the reply I tried your suggestion but I may have messed up as i am receiving a run-time error '3075' now. Here is the whole Select statement I am trying to use Is Null, Is Not Null or "*" to produce results from queries where mytable.[field7] rows have Data, don't data and...

Hi there I am struggling with the correct syntax for using "Is Null" , "Is Not Null" and "" when using them in a variable to pass back to an Access Query I have code, just a segment of a query below using "Is Not Null" Dim strmystring As String strmystring = "Is Not Null" Only problem when I...

Gemma That sounds like another good way but my VBA skills are pretty limited, do you have an example of nested cases or a URL where I might find some examples? Thanks to you to for responding so quickly B:)

UncleGizmo Yes you have it correct only thing is I am trying to filter from 2 different fields within the same table, is it just a case of writing an SQL query for each Select Case Statement to cover every option? like below but all the different scenarios? SELECT mytable.[field1]...

Hi there I am trying to use 2 option groups both having 3 radio buttons to filter the rowsource of a combobox, I was thinking of using 2 sets of Case Statements but do any of you know if this would work or is ther another way? It is a case of the user can select one button from either group...

qdogfball The reporting from the other database does not give me what I need. I have read only access to it but can export all the Fields I need in an Excel spreadsheet but still have to manipulate and filter the data to produce the report I require. All I needed was some help in how to...

Moniker As I'm new to VBA and feeling my way here, how exactly can I use your suggestion? Create the temp table, then import the spreadsheet data to temp table from the spreadsheet and then append the data to Test table.. What i mean is I am not sure how to use the CurrentDb.Execute "DELETE...

Moniker It seems to be the best idea,I will go with that i'm just not sure how to purge the main table of all records before the transfer from the temp table to the 10+PK Table. To answer qdogfball, the reason I do not use Access for the source data is that the spreadsheet is generated from...

TransferSpreadsheet DCrake Sounds like a great idea, only one question though, is it possible to add other columns to the linked table from inside Access? I have 2 additional columns that are not on the input spreadsheet. I was really looking for a VBA way to import/update/append now that I...

Hi there I have managed to import a spreadsheet from Excel to Access using a command button on a form and adding the code below to the onclick event. And it works well but:- The spreadsheet table1.xls I use is updated frequently! how do I go about dropping the data in the Access table "Test"...