Search results

  1. G

    primary key in VBA

    Guys, I make a table using VBA, and I want to put a primary key on a field using code Any ideas? Ive trawled the web with no joy. M :-)
  2. G

    requry a subform

    Hiya, I have a form where a user updates the textbox "Criteria" Once this is updated I want the results of the query to return in a subform. I have designed the subform and created the query... How (and where do I put the code) to make it update? Do I need a button? Also can I get a...
  3. G

    Nested iif using AND

    Hi All, I cant find the answer tp this one using the search, although Im v sure it must be a common problem..... Im trying to do the following. If [Limit] = 0 then "No Limit" If [Limit] > 0 < or = to 1000 then "Limit up to £1,000" If [Limit]>1000< or = to 5000 then "Limit between 1,000 and...
  4. G

    string formula

    Hello's I have a huge strings of text in a column. When the word "exclude" is found in the text I want to print all of the text to the right of it into a new column.... can anyone help me with the formula please? Tnx, M
  5. G

    Delete records to a diff table

    Afternoon All, My user occassionally inputs incorrect data and wishes to delete it from the main table. They sometimes input the same new employee twice with slightly diff spellings etc. When they notice this they want to be able to open the form with the incorrect data in it and delete it...
  6. G

    onChange / OnDirty etc

    Hi all, Im not sure which "on" event I want to use.... Everyime a user updates a field on the form I want the form to loop through on of my macros.... so everytime a change is made I want the code to execute..... I didn;t want to have to put an "On Change" on every individual text and...
  7. G

    validation and combobox entries

    :) Afternoon all, I have a combobox so the user can select values that are valid. I only just realised that the can type directly in the cell and ignore the values in the drop down if they want (eeek!) How do I MAKE the user select a value from the drop down and not be able to type...
  8. G

    Drive mapping problems

    Hi all, I have a drive called ="T:\Team Data" I need to export a file to this drive... A colleague has this same drive set up as his K drive and I want to know how I find the address of the drive? The full name of the drive is: Wb2p on 'NetApp Filer - Manchester, 208 Bishops cab 20/01...
  9. G

    DSUM slowing down my report

    Hi all, I have a normal query which cross tabs my data and then populates a report. The user wanted a "Total" to sum up the row table so I added a DSUM based on the underyling table which all of the queries are run off. the DSUM works and gets the correct total. The problem is that the...
  10. G

    Link Access to a folder to store emails etc

    Good afternoon All, I have created an issues database (v basic) and the user would like to be able to attach "issue related" files to the particular isue so they can access them all from one place. These could be emails, word docs, excel etc etc. After reading through some posts on this...
  11. G

    Select all query.....

    Afternoon all.... I have a form with a combo box which filters all of my queries. When a user selects a "manager" they get a list of all of the employees associated with that manager. This is because the user wanted to be ble to send individual "manager" reports to the managers concerned. I...
  12. G

    requery a query for a report based on combobox

    Afternoon ll, How do you refresh,reload,requery the underlying queries that a report and subreports are based on? My report opens from a buttonclick on a form based on criteria in a combobox on that form. I selected one option from the combobox and then clicked to open the report. This works...
  13. G

    "Page" on a form - need to reference

    Hi all, I have a text box within a "page" on a form. this text box is used to filter one of my queries, previously I had it on the form and the syntax was: [Forms]![frm_Select_Tier_II_Owner]![cbo_Select_Tier_II_Owner] What syntax do I now require to reference the Page within the form as...
  14. G

    As-at date filter

    Good afternoon all, I have the following challenge (!) I have 200 employee's data which is historised for changes. When a change is made to an employee (using a form) the change is date stamped and held in an audit table. I have been challenged to do the following: Run as-at reports...
  15. G

    ~~sub reports, darned subreports~~

    Hi All, I have 2x subreports on a main report. My subreport1 is 1.5 pages long and the subreport2 is starting immediately after this. Is there any way to force subreport2 onto a new page? So if my subReport1 grows to 2.5 pages, subreport2 starts on page 3 etc? Many thanks, Mandy
  16. G

    Subreport on a new page

    Hi All, I have 2x subreports on a main report. My subreport1 is 1.5 pages long and the subreport2 is starting immediately after this. Is there any way to force subreport2 onto a new page? So if my subReport1 grows to 2.5 pages, subreport2 starts on page 3 etc? Many thanks, Mandy
  17. G

    ~~Dcount / Subform issue~~

    Hi All, I have a Dcount formula in a normal report that is working fine. When I try and put this into a sub form it falls over and returns #name. Do I need different syntax when doing a subform dcount? Ive been working on this for several hours and have gotten nowhere.... Thanks, Mandy
  18. G

    subForm issues

    I have 14 rows of data in my subform, and its duplicating the table 14 times?!?! Any idea why it would do this? Thanks, Mandy
  19. G

    Need to protect db from users!

    Hi all, Is there a way to stop users from accessing the data tables by pressing F11? Thanks, Mandy
  20. G

    Interesting Problem

    Does anyone have any thoughts on how to do the following: I currently have code that loops through all of the fields on my form and sets them to enabled or diabled. I would prefer to hold this logic in a seperate table and loop through the table. All field names will be in the table and an...
Top Bottom