Search results

guys, i create a form that create an xls with the form's values. DoCmd.OutputTo acOutputForm, "ooooooo", acFormatXLS, "d:\ooooooo.xls", False then i try to modify it properties and to create a chart. Dim xlApp As Object Dim xlSheet As Object Set xlApp = CreateObject("Excel.Application") Set...

i solved the problem. i created a copy from the form which works and modified what i needed. thx.

it is back.........grrrrrrrr. here is more info. When both forms are loaded, all the fields are populated with a dlookup, using the number specified in the previous list. To save the new data i am using the above code and it works for the editing form but it doesnt for the validate form...

guys, i have a module called sending which contains a function to send emails through notes. i am trying to call this module from a form passing only 1 argument and it works !!!!!!!!. HOWEVER, if i try to send more than one i cant. can somebody hlp me, pls. this is the code in the form...

thx guys...fixed

thx guys. i dont need this functionality anymore.

guys, here is my problem. I created a tool to manage changes. As part of the process a support can edit a change to change the status and the requester can validate that the change is done properly. Both processes work in the same way, the diference is that the can modify different fields in the...

guys I will need some time to understand this code and test it. thx to all of you for your quick answer.

wayneryan, 1- i created a module called getUsers. 2- I also copied the code 3- I copied the suggested file into c:\winnt\system32 4- I opened the module and also opened a debug window 5- I wrote ?getUser() as a result of these steps the following error appeared: "Compile error. expected...

hey gus....How can i know Who is connected to the db? thx, Max.

solution yeatmanj, sorry for bothering u. I'd like to know if you find a solution to your problem, run a code while the DB is closed. I am haveing the same issue but i dont have a front end and backend, i have a db in a network resource and people access to it through a shortcut. thx, max.

hi guys.....here is my question: I'd like to create a process in access 97 which runs when the db is even closed. The main idea is to check if a record (problem) is reaching the due date but it needs to run at any time. More details: The db is located in a resource on the network and it is...

hi everyone........i solved the problem. Here is the solution.... I change the old dlookup by this one. DLookup("[comment]", "comments", "[change_id]=" & Task_Num & " and [modon]=#" & Me.modon & "#") thx max

well you may need more details....... this is what i am trying to do. I create a form, where a date control box is filled with a calendar. Then, the user choose an open task from a combo (the data from this combo comes from a query). The description control box is populated with the tasks...

hi guys, here is my problem. the error in the title appears when i try to update a record. the field MODON in the table is defined as a short date and an input date 00/00/0000. Here is the code where i insert and update the records: Option Compare Database Option Explicit Private Sub...

hi all. i 've got an easy problem.... when i run this macro it display the "Run Time Error 451 - Object not a Collection" k = 2 For i = 2 To 556 For j = 2 To 188 If Worksheets(4).Cells(j, 6) = Worksheets(4).Cells(i, 13) Then If Worksheets(4).Cells(i, 10) = "P" Then...

it happens that when nobody is logged in , i can close a task. but if somebody else is using the db i cant, the form doesnt update that table. thx

hi all......i really need your help. i have a db inaccess 97, which was working by last friday properly. it has 3 main forms: 1- add tasks 2- update tasks 3- close tasks the first 2 forms work ok, however, the form 3 doesnt. Before closing the form 3, it saves the values updated in 2 tables...

thx very much....it worked

I created a db in access 97. It has tabkes, queries, forms, modules and reports Now i am trying to convert it into access 2000 but .... thats why i am here. Here is what i am doing: 1- open access 2000 2- go to tools, db utilities, convert db to 2002 3- select the access 97 db After that...