Search results

I'm sorry to tell you... But when the Cancel-button is pressed on an Inputbox, the function returns a string with length 0 (""), and that's the same as when the user didn't give in something and pressed OK. Maybe you can do something with the argument 'DefaultValue'?

I was glad to help you... :) Greetz (to your boss :D ) Bert

Yes, it's a machine-setting. If you want, you can set this machine-setting also by code, using SetOption. For more information, see this link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/achowSettingOptionsFromVisualBasic.asp

I knew :D Glad to help you Maybe interesting for other moments that you've to work between Access and Excel: Use CreateObject only when you declare xlApp As Object. Now you declared it as Excel.Application, so you've to set it as follows: Set xlApp = New Excel.Application Or: Dim xlApp...

Mike, Put this code in a standard module:Public Function SelectAll() On Error Resume Next Dim ctl As Control Set ctl = Screen.ActiveControl ctl.Selstart = 0 ctl.SelLength = Nz(Len(ctl.value),0) End FunctionIn the 'On GotFocus' property of the textbox: =SelectAll()

I'm sorry, but I don't work with an English version of Access, so I'm not always sure of the correct names... Glad I could help you :) Greetz, Bert

Kimberly, I had a look at your database. The problem is the DLookUp in the Form_Current Procedure, that tries to set a text-value in the numeric field. I figured out that you didn't set a controlsource for your comboboxes (Category and SubCategory). Set this controlsources to the right field...

You're right, but the reason I mentioned that option is that the value you want to select can be dependend of another (known) value, that's in another textbox of variabele. It all depends on the way you want to use it. Greetz, Bert

Or this:Me.lstYourListBox = 9Where 9 is the value of the bound column of the listbox

You can create a second table, with two fields, that both contain the ID of the first table. Than you can create two one-to-many relationships, from the first table to both fields in the second table.

I thought I heard sometime that the message can be prevended by an action SetWarnings=False

The most simple way is to run a requery on the combobox in the GotFocus-event. I always do it by putting this function in a standardmodule:Public Function RequeryControl() On Error Resume Next Screen.ActiveControl.Requery End FunctionThen in the On-Focus-property of the combobox(es) put...

Hi Durdle, This code does the same, but quicker:Private Sub Command12_Click() FollowHyperlink "K:\Todayis\Friday\JustaFewmorehours.xls" End Sub

Hi, Base your combobox on table LangChart, with the two columns. First column is Code and second Language. Set the bound column to 1 (code). You can hide that column by setting the columnwidth to e.d.: 0;3 The controlsource of the combobox must be the Code-field from table Language

then here it is with both versions

Wayne, Changing the Rowsource doesn't need a requery I thought? Greetz

Hi, Can you post the SQL of your query (View, SQL) here? Maybe you've to check the column-widths, for six fields you can separate the widths with ; ie: 0.5;0.5;0.5;0.5;0.5;0.5

You can do that by using SELECT DISTINCT in your SQL-statement, instead of only SELECT

Wayne, I'm sorry... but you're right :D :D But how about Iskuff? As far as I can see (how far? :) ) the problem is solved? Greetz Bert

It must be rptCompanyPrintPages() (sorry, I wasn't clear enough). Attached an example