Search results for query: *

Any ideas how to do this one? I have a combo box and I would like the row source to change dependant on what page of a tab control a user is looking at - so if the user is looking at page 1, the rowsource is taken from the contents of text boxes on page 1, if looking at page 2, the contents...

This sounds so simple I'm certain I'm missing something. Is there something along the lines of { NumRec } that would give the total number of records in the datasource for a mailmerge. For background what I'm trying to do is to control the mail merge. I'm using the NEXT mergefield to show...

I can't believe I can't work this one out (feeling it's very obvious) Is there a way to tell how many records there are in your data source in a mail merge? I want the equivalent of a { NumRec } field! any help would be much appreciated.

I think this is pretty basic stuff, but that's probably why I can't work it out... Can you have a string and execute that as if it was a line of code, e.g. CodeStr = "Forms![Form1]![Control1].setfocus" and then a command or something along the lines of RunCode(CodeStr) I'm on...

Can anyone help with details on how to change the printer properties using VBA code? For background, I am using Access to load and run Word and then run mailmerges in word using info from Access. For each merged document, I need to print one copy on headed paper, one copy on plain. This was...

I have developed a very annoying problem... For background, I am using Access to load and run Word and then run mailmerges in Word using info from Access. For each merged document, I need to print one copy on headed paper, one copy on plain. I had originally recorded a macro to print both...

I have developed a very annoying problem... For background, I am using Access to load and run Word and then run mailmerges in word using info from Access. For each merged document, I need to print one copy on headed paper, one copy on plain. This was working fine, and I had originally recorded...

I posted a query earlier about mailmerges and blank date fields being populated with the current date, but I've since discovered an equally annoying problem. I'm using access in the UK to run mailmerges in word. In Word 2000, this worked fine by setting the regional settings of the machine to...

AHHHHHHH! I have just discovered a very annoying problem. I have a quite complicated system set up in office 2000 using access to run mail merges. In Word 2000, if a date field in the database is blank, then the merge field is blank (sounds sensible to me). I then have IF fields which ensure...

I am trying to do something which I think is really simple but I can not figure it out. I am setting out a timetable type document which sets out a lists of dates for things to happen, i.e. next week, four weeks time, 10 weeks time. Effectively what I want to say is {(Date + 28) \@ "d...

I have discovered a strange thing with my database today. I have input mask "09/09/0099" in text boxes linked to date fields. This works fine. (btw, I'm in the UK since we're talking about dates). I have come across a problem with regional settings. If the regional settings do not...

I am using the code below to detect word (MyWordApp is a global variable): Public Sub StartWord() On Error GoTo Err_StartWord Dim wrdTmp As Word.Application 'On Error Resume Next Set wrdTmp = GetObject(, &quot;Word.Application&quot;) If Err.number <> 0 Then Set wrdTmp =...

I've got a main form with a tab control with 10-12 pages. Most have subforms on, and most of those have one further subform. . The main form takes some time (about a minute) to load up now and taking its time closing for that matter. Ideally I would like to add further subforms to the tab pages...

I am basically trying to use word to show a list of people, with just name, address, etc in a table in word. I have all the details in an access table, and maybe I am missing something very obvious here, but I can't find a way to show more than one record (person) on the same page. (I know...

I wonder if any of you bright sparks can help... I have a main form showing client details. Each client can have details of several contacts, shown on a subform. I have a combo box which allows the user to select which contact's details to look at. Here's the pinch - I want to use the combo...

I'm trying to refer to an appendix worksheet (i.e. see appendix 7). I keep having to insert new worksheets. At the moment I have all the worksheet appendices number 1 to x. The worksheet header refers to the sheet name to number the appendix, but I can't work out a way to refer to the sheet...

I'm trying to include both text and a dates in the same cell. The date just comes up as the date value (eg 37352). Is there a way to format the date without using the cell format (doesn't work) or maybe a way to convert the date to a string? I'm hoping there's a simple answer that I've missed...

I really hope there is something simple that I'm missing here... I'm running a client database and then producing standard docs via a mailmerge. When you select a document, a pop - up, modal form is opened which asks you to select options for the requested document, you then click OK and off it...

I'm trying to run a procedure in a module under a separate form, i.e. open a form, run a procedure but pass some variables to that procedure as well. I can just use onload event and put the variables I want in a control on a form and refer to them that way - not very elegant. What's the syntax...

General query... I've got an access database, running one main with several subforms, all with a fair amount of code underneath them. The main form is currently taking about 10-15 seconds to open. Is converting the database to an MDE file likely to speed this up by any significant amount?