Search results

  1. A

    mail merge records counter

    hi all, i am using word 2003. i have a mail merge document which is getting information from a spreadsheet. the form is great and works properly. the merge mail toolbar has the ability to navigate records and also shows you in which record you are. Problem: when you are in record 100 or higher...
  2. A

    locking a word

    hi guys, i think this is a very simple question. can i lock a word in a word document? example: i have a doc with a request # and a table request # 1111 name surname description can i lock the request #, so nobody can modify it? thx, max
  3. A

    cant replace a highlighted word

    Hi guys, thx for your time and hlp in advance. Situation: I am highlighting a word that i want to replace and then typing the new word. Problem: Instead of replacing the highlighted word starts typing the new word at the beggining of the old one. ex: before... my computer hates me. (computer...
  4. A

    mergemail wrong format

    Hi guys, Here is my problem. I have a 2k access database with 1 table. I can successfuly merge everything into a new word document. However, i have 2 issues: 1- i have a date field that is displayed like 12:00:00Am when is null 2- some numbers (single/decimals/2) are shown like 12.700001 when...
  5. A

    jet database engine cannot find object 0

    hi guys. here is my problem. Info: I have a form with several filters (14). Once this for is opened a report with all the data is opened in background. Then the user uses the filters and finally press the apply button to apply the filters to the report and reduce the records on it. Here is...
  6. A

    can not quit access properly

    run-time error 2450 can not find login form Hi all, thx 4 your time and hlp in advance. Info: I migrated a database from access 97 to xp. Everytingh worked perfect in 97. Situation: There is a login form. Once the user is logged in the login form is hidden and the main menu comes up. Here is...
  7. A

    run time error 5

    hi guys. i am trying to run a batch file from access. Dim RetVal RetVal = Shell("c:\winedb\email.bat", 1) i am getting the following error msg. "run-time error 5 invalid procedure call or argument" Could u pls hlp me..thx, max.
  8. A

    library not found

    hi guys, i am trying to send emails with outlook from access. i get an error "path or library not found" can somebody let me know which libraries i need in order to do what i want, pls? here is my code. Dim olApp As New Outlook.Application, olNameSpace As Outlook.NameSpace...
  9. A

    dont know how to open a db from citrix

    Hi all. This is my problem. I have a db located in a citrix server in the usa. Also, 15 pc's connected to citrix server using that db. But they also have a dummy db in their pc's. Do any of you know how to open the dummy db in the user pc from the db in citrix? i spent the hole day looking...
  10. A

    cant save into a specific pc from citrix

    Hi all, here is my question. Context:I have a db (A) in a citrix server, which is located in the usa. Then i have 5 users (1,2,3,4,5) in australia connected to the citrix server with a citrix web interface. One of the 5 pc's (5) has a db (B) with one table only where i need to insert records...
  11. A

    i cant see a table's contents as it is

    sorry for the title. i didnt know what to write. this is the situation: i have a form where it populates a table in access (ssmdata) from an oracle table w_ssm_data). this works perfectly. Then the form read the hole new table in access (ssmdata) to update a specific field. Problem: If i open...
  12. A

    cant read a linked table from oracle in access

    hi all, thx 4 your time and hlp in advance. I linked a table which is in oracle 8. what i am trying to achieve is to read the linked table and populate another table but in access 2000. the problem is that it is not reading the data coming from the linked table. this is my code: Dim...
  13. A

    report form does not appears

    hi guys, once again i need your hlp. i created a db which hides the access environment using the following code when the login form is open: loX = apiShowWindow(hWndAccessApp, 0) mi problem is: i have a reports menu, where the user can select a report from a combo. then they press the view to...
  14. A

    wrong access icon

    hi all, this morning i installed the ms access 2000 runtime and then i uninstalled it. After that i had some problems and there was no other choice than uninstall and install the office 97. Now for some reason the access 97 works BUT the mdb files have a notepad icon instead the access 97 icon...
  15. A

    corruption question

    Hi guys i will appretiate it any hlp you can give. A few weeks ago i started to experiencing problems with my access2k db. Some times i could open it and sometimes an error like this one. "Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. It...
  16. A

    forms with hidden access

    hello all ! here is a new challenge. I have an application in access 2k, where i am hidden access environment using code. Because i am hidding access environment the popup and mode properties are in YES. Situation: i have a form with a combo list, where i can select a report, 1 button to view...
  17. A

    printer issue. urg!

    hi guys , i need some hlp. I am hidding all the toolbars when a user loging into the database, with the following code: For i = 1 To CommandBars.Count CommandBars(i).Enabled = True MsgBox i Next i The problem comes when a user select a report from the main menu. i open...
  18. A

    recordset error 3021

    hi guys, i hope somebody can hlp me with this.....thx in advance, max. I am trying to compare to tables (pop and tempwinestatus). The idea is look for the same ponumber in both tables. If there is a match, ask for the qty value in table tempwinestatus, and if qty is 0, then modify ifsstatus and...
  19. A

    visible false in an event

    Hi guys, here is my problem. thx 4 hlping me. i created a form to work as a menu. At this point the menu has only one option (File) which is a text box. Once the user click on the text box FILE, a list box appears below, leting the user select between a few options. When the user clicked one of...
  20. A

    there is no EOF in my code

    hi guys.....something is wrong in my logic or code. and i dont know why. What im trying to do is: select a code from a combo in a form. Then go to a table permitdetails and see how many records i have for that code and send those records to a word doc. The thing is that i cant send more than 5...
Top Bottom