Search results

If your are using the package and deployment wizard (as I presume you do) the COM components get registered on the client machine automatically (no matter what your configuration is). You can set the installation location of you libraries in one of the wizard's dialogue boxes. Well, what I am...

Hi Bert You could look up help for KeyPress Event of the form. Do not forget to set KeyPreview of the form to True. Basicly you should minitor the values in the KeyPress event and then respond by cancelling in KeyPress event. Hope it helps Kaspi

Hi John You can create table at runtime. You have several options: 1. You can use SQL - check CREATE TABLE statement 2. You can use DAO - check CreateTableDef method 3. You can use ADO (ADOX - Microsoft ADO Extensions 2.1 for DDL and security) Kaspi

Hi Werner Why do you need to replicate the records? You replication seems to be a bit unusual. Kaspi

currentdb - a pointer to your database (write as you see) strMyQuery - your SQL statement (string) - substitute it with your SQL dbReadOnly - constant (write as you see),agument of the recordset open method

Hi Chackster You can try smt like: Public Sub test_text() Dim ctl As Access.Control For Each ctl In Me.Controls If TypeOf ctl Is Access.TextBox Then If ctl.Tag = "tagRowTotal" Then ctl.Visible = CBool(ctl.Value) End If End If Next txt End Sub kaspi

Hi Chackster I assume that your fields are bound to controls on you form. If that is the case you could use something similar to: For i = 1 to No_Of_Fields if blah then me.controls("a"&i).visible = false next i Hope it helps Kaspi

Hi Ian You could check the help for: SysCmd(acSysCmdInitMeter, "Some text ...", iniVal) SysCmd(acSysCmdUpdateMeter, someValue) SysCmd(acSysCmdRemoveMeter) If you check the forum couple of weeks back someone posted a custum solution using label control. Hope it helps. kaspi

Hi Mike Try something like this Public Sub Test_OnClick(rpt_name As String) Reports(rpt_name).OnClose = "Run_This_Macro" End Sub kaspi

Hi Rob I do not think that you need to add any code to the database fe. The access is governed by the system log on. As long as the user has access to the shared folder on the server your linked tables should work. kaspi

I would try to use goup by clause to get rid of duplicates in your SQL statement.

If you wand only to copy files you could look into writing batch file (.bat).

Try to convert the textboxes into the appropriate data type. txtTotal.value = 154 + (clng(txtStops.value) - 1) * 10 + txtAddExpense + clng(txtMileageCharge.value) + (clng(txtMiles_RT.value) * 0.0697) Else txtTotal.value = clng(txtMileRate.value) * (clng(txtPounds.value) / 2000) +...

I don't think that there is a simple way to retrive the name of the procedure and the name of the module. I wouldn't see it as a big problem passing the name as a parameter to your Function or Sub.

Hi Pat I fully agree what you are saying in regards to the way how the data should be stored. I just would like to bring up that neither of our solutions fully addressed the problem of the comma. Just imagine that the first check box is not checked (you would get something like ",2,3"). I...

Hi It could be better to use the "Before Update" event of the form. In that way the code can be only in one place. It could be something like: me.status = IIf(me.cb1, "1,",vbnullstring) & IIf(me.cb2,"2,",vbnullstring) & IIf(me.cb3, "3,",vbnullsting & IIf(me.cb4,"4,",vbnullstring) 'to get rid of...

Hi Sara I believe that you could give a cross tab qry a try. With the products as col haeading Customer as your row and Sum qty as your value (if I understand well you have 3 tables tbl Customers joint to tbl Purchases on Customer_id and Purchases joint to Products on Product_id). In this...

Hi Dave You can use ListCount to get the number of rows in the list box. I am not quite sure what you want to achive. You may want to consider to open a recordset with the sql you create for the list box prior updating the list box, count the records in the recordset and display a message if...

Hi Jan Can you give more details what happened? Did you backed up your system?

Hi Jan I am sorry to hear what happened to you. Well, it's unlikely that the SaveSetting caused the disaster that you are talking about. This statement merelly creates a new entry in the part of the registry that is used for application installed on the system. It is restrictive but safe...