Search results for query: *

OK SM, thanks for your quick response, I will try to explain some more. I have recently been but in change of all the Bill of Materials (BOM’s) and routers in the engineering module of our oracle system. The BOM lists what components are needed to do the job while the router list what resources...

OK, you all are my last hope in fixing a problem that I am having. First off, please excuse some of the wording that I may use in this post. Just to let you know, I am not an Oracle admin. I am just a simple minded engineer that is having a problem with Oracle routers. I can tell you that we...

Thanks for your response. We are using Cleo for synchronizing our data. I talked to support about the issues that I am having and they stay that I am not the only one having the problem and that I should start with our brand items first. The problem with this is my superiors want me to start...

I was asked to implement UCCnet with my company. First off, please excuse my lacking familiarity with UCCnet. Basically my questions is this: I work for a pharmaceutical company that does products for over 100 customers but on 95% of the items, we are not the brand owner. The customer provides...

I am not an expert in any way so please excuse me if I don’t explain my problem with the correct terminology. I have an access DB that linked to our Oracle system and generated a “snapshot” of the tables that I needed. Every night, I had a marco run in access that updated the data from Oracle. I...

Thank you for the super fast reply, I will try it a let you know. 15 hours is too much for one day. THANKS

Hope you can help me out with this, I am really having trouble figuring this out. Basically, I am pulling data from an AS/400 into access. I have a table that is for comments. The comments go something like this: Field1 Field2 Field3 1 1 This is a test of the emerg 1 2 ency broadcasy...

Thanks for the response. I think I forgot to add something. I link about 20 Oracle tables to Access and then I run a “Make-Table” on all of them to get 20 tables. From there I generate reports. But every time I close access, I lose the ODBC link. So when I open the database it gives me a ODBC...

I have a database that I setup to pull data (snapshot) from our Oracle server using ODBC. Every night it take a snapshot of some of the important tables so that I can use them in access. I had it on a computer in my office that ran the update every night with no problem. The higher-ups along...

Thanks Fancon99, that did the trick. I don't like the fact that I have to relink all of the tables but know I know for future use. Thanks Again.

OK, I have a database that is connected using ODBC to out Oracle server. I run several query’s that basically takes “snapshots” of the data so that we can use in access. What I want to do is set it up so that it runs my marco at a certain time at night when no one is on the system. Every time...

Believe me, I know how important it is to jump the fence and I will work on it. Jeremy I tried your idea to convert the Macro to VB and I get that error “Object Variable or With Block Variable not set". Right now everyone really likes the way that the DB works but in my free time I and...

Thanks for your fast response. Unfortunately, I am sorry to say that I am one of the people that knows a decent amount of access but little VB. I am working to correct this problem. Fortunately, I am happy to report that I fixed the problem. When I used the OpenReport command I used Print and...

Hello, anyone.......I am starting to go through AIM withdraw....Please help with the above post. Thanks

OK, Simple Macro OpenReport (Opens the report I want Printed) PrintOut (Print out the Report) EVERY time I run the macro, I get the message "Object Variable or With Block Variable not set" when it runs the PrintOut section of the macro. The reports prints out but I am attempting...

When using Imesh or other similar clients, the request comes through the ISA server as an anonymous user instead of having an associated NT domain user ID as happens with Http and Ftp requests. Thus when I restrict access you can not be authenticated and access is denied. I need to restrict...

Thanks for the help, it worked great.

I have Definity system with an Intuity mail system. The system is currently setup so that if someone does not pick up the call it goes into his/her mailbox. If the person presses 0, it goes into the auto-attendant with options to either press 0 to get the operator or 2 for security. For some...

I have an excel sheet that I am trying to link to my access database. The excel sheet is information that is scanned from another department. 99% of the time, the information in the excel sheet is numbers. The problem comes up when the excel cell is a word (Non-Number). In my access database...

I remember that we use to have a setting on our old Audix Integrated Solutions III. When that crashed, the company went and bought a ***USED*** Audix Intuity system. The system works fine. The question is where would I go to set two different greetings? Currently we have only the night mailbox...