Search results

It is actually possible to enter the values through the DataSheet - Range objects from the Graph hierarchy. However, I would not recommend using it, reason is that the graph is quite difficult to program and tend to be unstable.

To maintain the variable I would use SaveSetting and GetSetting statements to write and retrive the value to/from registry. The use of the two statements is very easy, check the help file. Hope it helps kaspi

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "Training Cost Summary Actual", Me!Filename, True,"Totals for Year" If you still have problems try to use named ranges instead )if it is a viable alternative.

Hi Jeff I wrote this little function for deleting tables. I am not getting any confirmation messages even though I seem to be using the same technique that you tried to usu. Anyway, here you go: 'Delete table - if table does not exist or can't be deleted set the fancktion to false else true...

Hi Pete If you are using Access 2K there is a very handy function Split. You can define a character you want for the split. The result is an Array of values. If you are using access 97 you have to write your own function using Instr function. However, you are not able to use this solution...

You can look up help for Createcontrol. The problem is that you can create control only in design view. The reprication of that are that you have to play with echo and screen updates. Well, may advise would be to try avoiding creating controls at runtime. It is usually better to create more...

Hi Sara You can use Aggragete finction "FIRST" in your SQL (query). e.g. SELECT FIRST(id_field) From TABLE kaspi

Hi Freak One of possible solutions would be to toggle the value of the Yes/No field. Presuming that you have a recordset bound to your form and the name of the "Yes/No" field is 'Test_Yes_No'. You could toggle the value in the recordset like .... Private Sub cmd_Yes_No_Click()...

Hi Chris I would try to explicitly ask for values from your form controls. E.g. Me.cboCustomer.Value Also I would make absolutly sure that the form controls do not have same name as the recordset field e.g. Me.inv_no - is name of the control not the name of the field (if inv_no is the name of...

Hi Purdue It seems to me that you should check the sources of your controls on the form. I would suggest that you use unbound controls or even levels to display the info you want to display and handle the inserts into the table seperatly. The info display could look like me.label_1.caption =...

Hi Sonya Try to rename your text box (txt_Box) and change the reference in your query. (It seems that the control name is the same as the field name ??? (Access can get confused) Kaspi

Hi Big Jim It seems to me that you may be better of using access collection. dim col as Access.collection dim var_Cur as variant set col = new access.collection col.add str1, "1" col.add str2, "2" etc for each var_cur in col ''you code for working with your strings next var_cur...

Hi Judy To get the dialogue for the file selection is not as simple as it should be. What I am using is a module from the Access Developer's Handbook. (Copy it into a module and use the ahtCommonFileSaveOpen, which displays the dialogue and returns the selected path) '***************** Code...

Hi Rony What you are doing should work (at least it works for me). Just make sure that you set all the object variables to nothing and then close the database. If you cannot get it working send me the code and I have a look at it. Jiri

Hi If I understood well, you want to store the new Id on flopy in the excel spredsheet(questionaire). Well, one of the options would be to create a connection to the spreadsheet trhough ADO and either use the rocordset and find method to locate the record and update the Id or use command object...

Hi Marko I would use the subform recordset to move around in the subform. If you put a button on your form and put code like this Private Sub cmd_Move_inSub_Click() Dim rs As DAO.Recordset Set rs = Me.Controls("Subform").Form.Recordset 'establish a position of the pointer (use find etc) 'you...

Hi Squirell I believe that you should consider creating the relationships between your tables rather then trying to put all data in one table. Even if you do not imlement relationships you can look up the the value for Nt and Pc in combo or list boxes and write the appropriate data into...

Hi Mark One of the possible solutions would be to store your last (highest) number in a table. When inserting a new record get the value from your "Id" table and increment it by one. Make your new serial and write the new Id back to the "Id" table. Good Luck Kaspi

Hi Aziz Why are you using GoToControl method? Kaspi

Hi Aziz If I understood well, you just need to generate a new reference from that looks like "62600000000000047624" from two reference "626" and "47624". As it seems that all your references are fixed strings you could try the following. Create a query from your "tblLO's" table and create a...