Search results

Hi all. I created form when user click in text box it display current time. But I would like to display current time when user open form and when user reopen this form again data of time field keep previous value. How to do it? Thanks.

Thanks for replay. My database open right now. And don't wont to lock whole DB. I would like to lock some DB's tables. And rest of tables and other database objects to leave open. Is it posiable and how to do it? Thanks.

Hi All. I would like lock part of the tables in my database. If is posiable how to do it? Thanks.

Hi All. Is this possible? I need import 30 Excel spreadsheets from different Excel files to one Access table and update this table. Thanks.

Hi All. Is it possible to import Excel columns to Access record. It means in Excel I have: AAA 45.23 BBB 65.63 CCC 15.01 DDD 55.02 EEE 84.31 In Access record should look like: Name AAA BBB CCC DDD EEE ---------------------------------------------- Comp...

Hi All. I created report and I would like to print list of user the same like phonebook where Lastname biginning on the same first letter will print on other pages. How to do it? Thanks.

I not realy familiar how to delete record automaticaly by schedule. Can you explain me detail? Thanks.

Hi All. I need to modify my database that give me ability to delete all record form table for last month. How to solve that problem? Thanks.

Hi All. I format cells in my spreapsheet like MM/DD/YYYY and typed 122606 but got not the same date like expected. Is it possible type number of date without slashes and receive correct date value? Thanks.

Hi All. In my employee's table I have EmployeeName, Rate, Date and I need create query to calculate Rate for each eployee between Date if ration during this period of time was diferent. Thanks.

Hi All. I created simple form with combobox to select device and button that run report. Report Record source is: SELECT Request_id, Date, Device, Request, Amount FROM qRequest WHERE (Device=Forms!fSetRequestRpt!cboDevice) ORDER BY Date; When I select device in combobox and click button to...

Hi All. Need union three TableA, TableB and TableC into one table called TableX? All table has same column name. TableX shouldn't has dublications. Thanks

Hi All. I have Request, Device and Receive table. All table has DeviceID. I create query to calculate total amount of each type of devices which was requested by link Request and Device tables. And query to calculate total amount of each type of devices which was received by link Receive and...

Hi All. I created form with MouseMove method. When mouse on label it change color. When it move color of label change back. My problem is when mouse on form all elements of form is blinking. How to avoid it? Thanks

That is Module code to change color of caption of button Option Compare Database Option Explicit Dim NameOfActiveControl As String 'Private Const ActiveForeColor As Long = 16711680 'color contents button Public Sub ChangeColor(ActiveForeColor As Long, _...

Thanks for replay. I did like you suggest and got same error msg.

Hi All. Access2003. In my code: If NameOfActiveControl = Me(NameOfControl).Name Then Exit Sub End If I got error msg Ivalid use of Me keyword. What is wrong? Thanks.

Hi All. When I run DB I'm getting Security Warning message to open database. Is it possible to open database and avoid that message? Thanks.

Thaks it works.

I would like to open report rDelivery by click lable lblDelivery and get first message to enter Start Date and then get second message to enter End Date. If you know how to do that for better way I will appreciate if you show how to do it. Thanks.