Search results

Change the acViewPreview argument to acPrint (I think!)

OK - found this and was able to use it straight away! http://www.mvps.org/access/modules/mdl0059.htm

I am also getting the same problem. I am using GW8 - not sure if this affects things. Could someone post a working sample DB? C

Problem changing linkchildfield and linkmasterfield Hi I have been trying to do something very similar to the examples above, but get a Runtime Error 2101 on the second attempt to change the subform and its related links. The code is below - I am using a treeview Control called axtreeview to...

Same problem with Win XP Pro & Access 2003 Hi, Am having the same problem with report settings disappearing on save Can set all the report-specific printing options and everything works fine, until you save the report and re-try. Then some - but not all - of the settings disappear. e.g. I...

Hi there peeps I would be really grateful if anyone could tell me if it's possible to have a horizontal scroll bar on a form that only moves part of the form's contents... similar to the freeze panes option in excel. Obviously vertically you can use the form header and footer, but there...

I have tried making tables locally and then performing the UNION from there. However, Access seems to fall down at some point. There should in effect be 53 unions (one for each week in the year, plus a spare). Access gives the message 'query too complex'. Is there a maximum number of UNIONS...

Len, Thanks for your reply - I would agree with what you are saying. However, our Oracle system is provided under license and therefore we do not have the relevant permissions to create views, or make tables on the Oracle server. Any further ideas appreciated...

Hi, I am trying to translate data from 3 linked Oracle tables to perform a Make Table query in access. Each person has many registers for a particular year (average is about 12), each register contains 53 fields (one for each week). I need to get the 53 fields (all equally set up) into 53...

Please help if you can.... (before I go insane!) We have a table of addresses for people (linked on PersonCode). The relationship is a one-to-many link. Tbl Addresses (a linked Oracle table) has the following fields: AddressID (primary key) PersonCode (linked) AddressType (S, P, T or E) Start...

I have a multi-user database that contains several tables containing static reference data. The reference data comes from a large Oracle DB, and for ease of speed, the Access DB has local tables made. When I want to refresh the local tables, I have a macro "Update from Oracle" to run. It's a...

Hi... I've got a main form (containing field PERSON-CODE), with a subform, with a ComboBox on the sub. The options in the combo box relate to an underlying query with PERSON-CODE as one of the criteria. OK, everything is fine so far... apart from, when you move on to the next record, the...

Hi I have an append query that runs from a select query. Before the append runs, there is a make table query that indicates what the next "batch" should be called It appends the first 10 records using this batch number. I then want to repeat the sequence until there are no records to append...

I have a list of departments and sub-departments, of which I would like to be able to show a form giving info on the sub-department. I'd like to use TreeView if possible, although I can't get the Treeview wizard to work for some reason on my m/c. I would like the parent nodes to be a list of...

I have a small problem... How can I get a subform requeried? I have tried Forms!MainForm!SubForm.Form.Requery but no help - any ideas please????? Chris

I want to be able to write a report that shows a timetable block between certain times in a report. Any ideas?

You will need to use a Union Query to produce a list of all of the dates on one line each. The MS Access Help files will help you, but you will need to use the same table upto four times in the SQL. It sounds complicated, but believe me it's not that bad.