Recent content by Zooropa

I got it, it works with: v_cont_notes = Chr(34) & v_cont_notes & Chr(34) 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 &...

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 & "#...

Excellent, the left shift did the trick, thanks!

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!

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?

The report is only 4 pages, but yeah, I see where you are coming from. Split the thing into 2, Report 1 being pages 1 and 2, Report 2 being pages 3 and 4. That could work, although I can see myself getting tangled up in the VBA. It'd have to say: Print record 1, of reports 1, and 2 Print record...

The questions come in groups like "Where Living [ ] (Please enter one number from the list)" 1. private Residence 2. Long stay NHS Ward 3. Supported accommodation etc Unfortunately, that's not really up for discussion, it's always been that way and I can't see the powers that be moving on it...

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

I have something very similar to this, but when my form loads, the form is completely blank. No text boxes visible, just a big white box. I have feeling it's because it's pointed at an empty query? I have a SearchBox, with a search button next to it. I enter an ID number in the box, and hit...

Got it. Just got the button to run an SQL query, using the value in the text box as a variable. Private Sub Command14_Click() Dim Pimsno As String Dim strSQL As String Pimsno = Me.Text10.Value 'MsgBox "" & Pimsno & "" strSQL = "INSERT INTO [New Tracking Table] ( [PIMS Identifier], [Planned...

I've had a look, and it all seems fine for copying a record to the same table, but nothing seems to be mentioned about copying it to a different table.

Excellent, thanks very much.

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