Search results

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...

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?