Search results

You don't need to worry about anything that is deleted. It will just bypass that in the code. But if anything is added to the spreadsheet initially which then changes your input table, you would need to add that column information in the translation table.

Did you call that function in an AutoExec macro?

1. Me. is for VBA only, not macros. It refers to the current class object (form, report, or other class). 2. If you haven't clicked the Show All Actions button on the Ribbon you won't see it. Click that button and it should show up for you.

You could do it that way but I like to keep things self-contained so you aren't reliant upon external factors (like if someone moves the spreadsheet). The Translate table is just a table that holds the full values of the field names and the truncated values and is able to be used to search...

You can try using this code (put into a new standard module): Option Compare Database Option Explicit Private Declare Function GetSystemMenu Lib "User32" (ByVal Hwnd As Long, _ ByVal bRevert As Long) As Long Private Declare Function EnableMenuItem Lib "User32" (ByVal hMenu As _ Long...

Why do you need multiple tables? One thing to take notice of is that you don't need to include lookup tables in your record source in order to display the values on the form. You can use a combo box to display the text values for id's if that is what you were adding those other fields for...

True, but that form would be more logical to me anyway. But whatever works should be sufficient.

A word of caution though - If you don't need to relink often, not a problem. But if you do, it can be a real pain so I just learned to deal with it.

Can't see anything wrong with that myself. I guess I'd use Paul's method if you can. For Macros you would use the SetValue command.

Posting that without giving the exact error is not very helpful for troubleshooting. It can speed the process if you provide the error too.

You will have to add the field you want with the data type you want, run an update query to move the data over from the other field and then delete the old one. And I highly suggest that unless you are using a Web database or have a very specific need to save calculated values it is not good...

Go to SQL View and then copy and paste the SQL string here. To get to SQL View go into the query in design view and then on the top left (I'm using 2007 so it may be slightly different for you based on version) and click the arrow below the spreadsheet icon that has the word VIEW below it. SQL...

^^^^^^ +1 ^^^^^^^^^^

Not sure as I can't replicate your problem. It works fine for me. Is this on a business network? Could it be that the network administrator has a group policy in effect which is interfering?

I'd change the = "Fixed" to <> "Fixed" as you have = where it should be <> from what I see there.

Just use a query to export instead of the table and don't have those columns in the query.

Just create a table which can "translate" for you. Like this: tblColumnExpNames ExpNameID - Autonumber (PK) TableFieldName - Text (255) ExportName - Memo Then you would need code to Substitute the field names once you've exported. This is untested "Air Code" so some changes may be needed...

Change this: "WHERE (((ProjectT.Project_ID)=[Forms]![Order F(Blank)]![Project_ID]));" to this "WHERE (((ProjectT.Project_ID)=" & [Forms]![Order F(Blank)]![Project_ID] & "));"

Use a form for inputs and then you can have a hidden text box on it which you can refer to in your query and you can format that text box to show the data without the dash.

What version of Windows are you on and which version of Access? Are you using the SQL Native Client 10 driver or just the generic SQL Service one? If the later, try using the Native Client 10 one instead.