Search results for query: *

Hi, I have a button on the menu (copied from the default menu) to compact the database. I would like it to run some routines or functions before it actually tries to compact the database, how could I do it? Thanks, Klasse

Hi, Is there any function with which I could get the last day of the month in the format 31/01/02 (for this month for example)? Or at least, a function to get the number of days of this month ? Thanks, Klasse

Hi, I have two lists and three boxes with items. On the afterUpdate event of one list (list2) I have: For i = 0 To lists1.ListCount If list1.ItemData(i) = list2.Column(1) Then list1.Selected(i) = True Exit Sub End If Next i That is, I go through each row of list1, compare it to...

Hello, I have a recordset with which I get values of a table (customer address, city, country) and then I want to put it into a textbox, everything into one. I tried to do something like txtbox =!CUST_ADDRESS & CHR(13) & !CUST_CITY But this wouldn't work. It displays the address, then a...

Hi, How can I add from code, a new control in the default menu bar of Access? Thanks, Klasse

Hello, I have a form from which users will operate and open new forms. I would like to keep this one opened in a corner of the screen, on the top left corner, so I will open the other forms on the rest of the screen. How can I having the main form initially on the center, position it to the...

Hi, I am trying to design a form similar to a tree structure. Then I have My Database |_products |_provider I want to click on products and I should have My Database |_products | | | |_add new product | |_edit a product | |_view all products | |_provider Now...

Hello, Situation: I have a table that is created when the user wants to open a graph, and it is deleted when the user closes such graph. I read data (dates, eg. 30/10/01) from a txt file into an array. My array has two columns, one the dates and the other a sum of the coincidences of the month...

Hello, I have an array (1 to 150, 1 to 3) where the first column values will be dates and the second integers. The array gets the values from a txt file. I create a table and then fill the table with the values in the array. I need the values in asc order by date. Any ideas? Thank you! Klasse

Hi, I have a database consisting on the back end and the front end. It will be placed on a network (NT) drive. I want to disable people accessing the back end. The only access to it should be through the front end. Any ideas on how to do it? Thanx! Klasse

Hi, I have the following code ' create the table USAGE DoCmd.RunSQL ("CREATE TABLE USAGE (MyDate date, MyUsers INTEGER)") ' Put data into new table USAGE. Dim MyRst As Recordset Set MyRst = CurrentDb.OpenRecordset("USAGE", dbOpenTable) With MyRst While arrayusage(m, 1)...

Hi, How can I display only the button to minimize a form, without displaying the X or the maximize button? I would like to add a bit of code to my Form_Load event. Thanx, Klasse

Hi, is it possible to show a message box with a button, and close it automatically after 5 seconds? Thanks Klasse

Hi, I have an application in VB 6. Users log to a Ms Access database, then I keep in a hidden form the name of the user. Also I have the following code in a form where I the only object I have is a datagrid (datagrid1) and nothing else. ***************************************** Private Sub...

Hi, I have a form where users enter a date that later will be use for other stuff. I am looking for some lines of code or a function to put on the After Update event in order to check the validity of such date. Thanks, Klasse