Search results for query: *

We are using a database in Access 2013, but the original file was created in perhaps Access 2000. It was later upgraded to ACCDB and actually the version the users use is ACCDE. Anyway, the original file got a bit corrupt (I couldn't delete things like queries and such and other strange...

Hi! I'm creating a Word 2010 add-in coded in C#. I stumped a bit here. I want to create a new label document and show it on the screen. I have this so far: Word.Application wordApp = new Word.Application(); wordApp.MailingLabel.CreateNewDocument("L7163", "Name and address here")...

Hi all! I have a table with some amounts, a date and a region. I'm building a crosstab query to display a the date (consolidated into quarters) as row headings (so four rows Q1, Q2, Q3 and Q4) and region as column heading and of course the amount as value. That works perfectly, only I want to...

Hi all! First of all, I know of the implications of using multivalue fields. The data I store in the field is on the fly data (what the user has selected for filtering). So, let me first explain the setup: 1. Table (filter) that contains a few fields that for each user contains what the user...

I have a script that among other things finds every comments in a sheet and processes them with this code: Set rngComment = Sheets("HelpSheet").Range("E5:E300").SpecialCells(xlCellTypeComments) If rngComment Is Nothing Then GoTo bla End If For Each rngTemp In rngComment...

Hi everybody! I don't know about accdb, but mdb remembered what sorting the user had selected in a certain view before closing Access. So that when opening the same form, the records (in continious form) would be sorted the way the user had last. I'm talking about the two A-Z and Z-A buttons...

Hello! I've have created this query in MSSQL: SELECT gr.year, gr.col1, s.col1 AS prevyearcol1 FROM table AS gr LEFT JOIN table AS s ON s.year = gr.year-1 ORDER BY gr.year Access 2007 crashes when running this. Is it possible to get this result by typing it in another way? I simply want each...

I have a table that looks like this: id country region level 1 England uk 1 2 Wales uk 3 3 Ireland uk 1 4 Italy seu 2 5 France neu 1 6 Belgium neu 3 (those are just some made sample data, but that is the way, the correct data are stored. Exactly 3 levels, but with 6 different regions)...

I maintain a large Access database that contains a lot of scripts, hundreds of elements like forms, queries, tables, reports and such. The user base is between 50 and 100 people. The users get the database in ACCDE format, while I keep the ACCDB for further development. This has worked so far...

Hi! In Access 2007, I'm creating a dynaset recordset, which among other fields, contain a multivalue field. So I have this code: Dim LocalFilter As DAO.Recordset Set LocalFilter = CurrentDb.OpenRecordset("SELECT * FROM ProjectFilter WHERE user ='" & CheckUser() & "'", dbOpenDynaset)...

Is there a way to use a listbox control, that allows multiple selections, in a query? I mean, say you have a listbox with values 1,2,3,4,5 and it's possible to select one or more of those. Then I have a table used in a form (via a query), which contains a field number that ranges from 1-5 in...

I learned using collapsing ranges when constructing entire documents on this forum a while back. I love the way it works and especially the speed contra building from selection. However, I'm having a hard time now with a table cell. Usually I collapse the entire document range, add text or...

Hi! I have a template I haven't created myself, but it's made with an older Word version. When it's loaded it adds, in Word 2007, a button in a group under Add-ins called Menu Commands. I want to remove that button from the template, I can't find it anywhere. There isn't much VBA code in the...

Can it really be true, that there is no way to catch whenever a certain already opened document gets focus/is activated? I want to run a small bit of code whenever certain documents gets focus.

Can it really be true, that there is no way to catch whenever a certain already opened document gets focus/is activated? I want to run a small bit of code whenever certain documents gets focus.

Hi! In Word 2007, is there a way to, programmatically detect a specific user created ribbon tab>group>button? It's a specific button in a custom added tab, that needs to be launched via sendkeys (don't ask why :) ). Problems is some only have that specific used added tab, which means shortcut...

OK, so I have a template (.dotm) in the STARTUP folder. This templates includes a new ribbon with a few buttons. Now, the users are using other templates to create new documents. So they are having the main template opened in the back, providing the buttons and then they are working on a new...

At work, users are in these days getting Office 2007 rolled out. Especially Access 2007, though, is causing trouble for a lot of users. Unfortunately, everything for me personally, and that makes it hard to pinpoint the error(s). So, we have certain databases that many users use. Some forms in...

Quick question: Is there any way to indicate (format) the "real" header row, so it is easier to spot. I have some long documents with many tables, that look the same and some of them spans pages, and therefore have repeating header rows. But it's confusing to look at. I guess there is no way...

OK, so I'm totally new to creating ribbon menus with Custom UI Editor for Office 2007/2010. And I have a problem I hope some of you can solve. I have a .dotm template in Word 2007's STARTUP folder. In that I have added XML which adds a custom tab in the ribbon: <customUI...