Search results

  1. G

    Hide field on report

    Hello, I have a report that generates a "Club Directory", with a page for every club showing the contact details of each officer. They now want to be able to produce a version with no email addresses given. Obviously I can do this by producing a second version of the report with the email...
  2. G

    Applying Filter causes odd runtime error

    I have a db where Users can Mark contacts for later reference by clicking a chkMark checkbox on the frmContacts (and in various other ways). When the checkbox is ticked it creates a new unique dual key record in tblMarkedPeople with fldPeopleID and fldUserID. When the checkbox is unchecked...
  3. G

    Code compilation problem

    Hi, I have the following function in my "General" Module (It's not code that I wrote myself - and I can't even remember where I got it from). On my laptop, using Office365, it compiles fine when I click debug on the module. However, on my client's system the line <<Dim LongLong As...
  4. G

    Combobox on continuous form only showing first record

    Hello, I have a db that stores information about clubs and people who are members and officers of those clubs. People can apply to go on courses and in order to add someone to the relevant course records I have form where the user can pick from the entire list of contacts nationwide in a...
  5. G

    Table minimised in query builder

    One of my tables has "disappeared" in the query builder. You can see the link going to the table and you can see the yellow highlight of the table being selected, but it seems to be reduced in width to zero, so I can't grab it to move it out to the right. Anyone got any suggestions, please...
  6. G

    If statement being bypassed?

    I have a form that allows the user to appoint members to various positions in a club. If the position is of a certain type, then I want the code to do certain things. For some reason, the code is running regardless of the position This is the relevant nugget from the beginning of a very long...
  7. G

    Code Gone Missing!!!

    Fired up my working copy of my db this morning, whole reams of code have vanished... :eek::eek::eek: Entire forms now with no procedures. There yesterday, gone this morning. Fortunately my backups are ok - but what the heck...?
  8. G

    Working with Sharepoint Tables

    I have an FE/BE db linked via sharepoint tables. It works, but it is really slooow. Usually a pause of several seconds for every form change, every data entry, etc. After a while, every second seems like an eternity. (It's slow everywhere, but this is really compounded by the fact that my...
  9. G

    Data disappearing from report.

    I have a database which stores information about clubs and their staff. I have a report which I use for printing a directory of each club in alphabetical order and their staff, with different staff types in 3 columns (subreports). On each club form on the database, I have a button that will...
  10. G

    Relative sizes of sub-reports and containers?

    Hi, What are the rules concerning the relative sizes of sub-reports and the "child" containers that they fit into? If I have a sub-report with a detail width of 3cm, can the "child" container on the main report be width 3cm without obscuring detail in the sub-report or does it have to be a...
  11. G

    Mark possible duplicates in Search

    I have been given a spreadsheet of people who have attended past events held by the club using my db. The available information is only FirstName and LastName and the event attended. I want to add them to my tblEventAttendees table. I have written the following code that will search my...
  12. G

    Report not printing all records.

    I have quite a complicated report that prints a directory for officials in clubs. There are three columns in the page and each column has one or two sub-sub-reports in a column sub-reports. Whilst proof-reading, I have observed that certain people seem to be being omitted, seemingly at random...
  13. G

    Subreport being cut short

    I have a report showing name, address and contact details for an internal directory of a membership organisation. The report has 4 sub-reports, one each for Directors, Secretaries, Chairman and Managers (see picture). The Directors, Secretaries and Chairmen have their own columns an then the...
  14. G

    Can't eliminate empty lines

    I have a report with a sub-report that shows an employees name and address. If there happens not to be a relevant employee, then I have some code that searches a different table and comes up with a different address, which I load into an empty text box during the report details on format event...
  15. G

    Print dots dots across page

    I have a report that lists employees by company for an annual directory. However, the directory also has an "index" at the back that lists all employees alphabetically with the Company they work for. So, this "index" report just has two fields: [fldName] on the far left and [fldCompany] on the...
  16. G

    Double Click event not triggering After Update event

    I have a form with a date field, that the user can double click to fill with a certain date. I then have code in the After Update event of the same field that adds a new record to a table if certain criteria are met. If I double click the field, it fills as it should and saves the date as it...
  17. G

    Get ID of created record overflow problem

    After lots of googling, I found an answer that says that if (and only if) you are using an access BE as well as FE, you can get the ID of a newly created record by filling a variable before .update. So I tried this code: .AddNew...
  18. G

    Backend link problem

    One of my users keeps getting an error: Unrecognised database format: "H:\Database\MembershipDatabaseBackEnd.accdb" Most of the time all works as it should, but when this happens she has to close the front end and re-open. Is this likely to be a db problem or a network problem? Thanks, George
  19. G

    Hightlight text in text box on entering

    I don't know the technical terms for what I'm asking for here, which is impeding my success on google. One of the main forms on my db is a search form with a listbox, which is filtered by typing text into a text box. Users can then double-click on a record in the list box to open their details...
  20. G

    Query updatable but sql not updatable.

    I have a sub-form that users can change the records displayed by choosing from 2 3-button option groups. I then use two nested select cases to choose an sql statement for the recordsource of the sub form. I want users to be able to enter dates into 2 fields. When I use the SQL in a query, the...
Top Bottom