Search results for query: *

With your control names: txtCountry = "" For iList = 0 To lbCountry.ListCount - 1 If lbCountry.Selected(iList) = True Then txtCountry = txtCountry & lbCountry.ItemData(iList) End If Next or if you want a semicolon inserted: txtCountry = txtCountry & ";" &...

You can try creating a shortcut to your macro in a directory on your PC or network by dragging the macro from Access to the directory window. Then you can drag that shortcut into the Task Sceduler (Control Panel). Right click on the task you just created and click "Properties" to set...

Did you include ;0 at theend of you input mask to be sure to store the space in the data?

Try this country = "" For iList = 0 To ListBox.ListCount - 1 If ListBox.Selected(iList) = True Then country = country & ListBox.ItemData(iList) End If Next

I don't know what the problem is. However, you can always use DoCmd.TransferText instead. Set up an export spec for tab delimited and name the file with ".xls" extension. SAMPLE: DoCmd.TransferText acExportDelim,"SpecName,"QueryName", "FileName.xls", False

I am sorry to say that there is no easy way around this problem. The best bet is to set up your own security by adding a users table to the database and having a form set up to verify the existence of the user and match the password. You can also add a table of user groups in order to set up...

I have the same trouble. I have used the Timer event to cause a short delay between the load event and the procedure call. (Timer Interval can be short - like 100ms) Private Sub Form_Timer() Dim iVar As Integer For iVar = 0 To 1 iVar = iVar + 1 Next 'ProcCall Exit Sub End Sub

Did you create a password for your user? Without a password you wont get prompted and you will default to Admin. Is the computer part of the same workgroup as the machine you created the application on?

One more thing- there are details at www.tekreview.com regarding this, and has some technical terms you can tell your carrier as well. One word- the *611 operaters don't know much about data services (call it circuit-switched data). The setting that needs to be changed is in their IWF...

Hi, This is the ATS7=90 problem. The default settings in the networks are *supposed* to be 1-255 seconds, with a default of 50 seconds. However, many carriers have limited it for some reason (with all network vendors as well) to 50 seconds as the max- not just the default. Many PDA's set the...