Search results

I had this problem when using Do Until blah blah, it was doing this because at the last cycle it was going past EOF, by adding On Error Resume Next just after the Do statement, it worked ok.

Tools > Add-Ins > Linked Table Manager

thanks for the info I achieved what I wanted, but the powers that be dont want it like that!!! basically they want to turn the whole thing on it's side so instead of field1- field2 - field3 - field4 - field5 etc want to transform it to field1-- field2-- field3-- field4-- etc is this possible?

I don't think Union Query is what I want current status table field1 - field2 - field3 - field4 - field5 - field6 - field7 - field8 what I want to achieve is -------field1 as colum headers field2 field3 field4 field5 field6 field7 field8

I've never created a union query, is there a good example flying around anywhere?

Is it possible to get more than 3 row headings? I have a database and I have 12 fields which I need to format in crosstab style, is there any other way to do this? EDIT - Can this by done by exporting to Excel? If so can I have a little advise?

You may be able to use the LDB file to get that information, but I don't know how. you could also try adding a script that will kick users off a database when you want to make changes. an example can be found at Rogers Access Library

Dim rstVendorID As DAO.Recordset Dim strID As String Set rstVendorID = CurrentDb.OpenRecordset("tblVendorID", DB_OPEN_DYNASET) rstVendorID.MoveFirst strID = rstVendorID.Fields("vendor_id").Value DoCmd.OpenReport "rptApprovals", acPreview, , strID

EDIT - that wont work, I'll have another think

Me.TextB = Me.TextA check that texta/b are the names of the text box controls, not the field names

File > Get External Data > Link Tables then link all the tables and it should then be OK

use the code builder instead

when you have a form based on a table, there are 2 ways to add to a field on a second table like you want 1) the field in the second table is linked to a field in the first (usually of same name and type). 2) create a query that includes the fields from both tables, and base the form on this query.

you could try this in the after update Me.TheNextField.SetFocus Me.Q1TC.Visible = False

why are the 2 fields in seperate tables? Are these tables linked in any way? you could try making a query and basing the form on the query instead of the table.

quick draw

try on exit instead

txtboxB = txtboxA

CurrentUser() will return the Access user name

early morning idea create an OnClick event to filter the subform by a field