Search results

  1. Z

    Syntax error in append SQL string

    sqlAdd = "Insert into [contacts] ([CONT_TYPE], [INC_OUT], [FACILITATOR], [CONT_PERSON], [PREM_ID], [CONT_DTTM], [NOTES], [OUTCOME] ) " & _ "VALUES ('" & v_cont_type & "', '" & v_inc_out & "', '" & v_facilitator & "', '" & v_cont_person & "', '" & v_prem_ID & "', #" & v_cont_dttm & "#...
  2. Z

    Startup problem

    Hi, I've created a new database, and unticked the options in Startup which mean the various menus at the top are hidden - and I don't know the keyboard commands to get them back :S Daft mistake, I know!
  3. Z

    Connect to Business objects universe

    In the same way I can "Get External Data" and link Tables to an Oracle database, is it possible to connect to a business objects universe and link the tables? I don't know a great deal about it, but would it be at all possible?
  4. Z

    Maximum number of objects in report

    Hi there, I have a report created in Access which is an assessment form - a questionaire. It is 4 pages long, and has lots of controls on it. Over 1000, I think. The problem is that Access only allows 745 (I squeezed the extra in by copying and pasting existing ones - it gives an error, but...
  5. Z

    Find a record, and creating a new record.

    Complete Access newbie, here. I have a table with 2600 entries on it. Each record has a unique number. I created a form, based on this table. I have a search button on the form, and when I enter the unique number, hit search, it brings me back the correct record. That's fine, it took me a...
Back
Top Bottom