Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: RDM23
  • Order by date
  1. RDM23

    Help-Linking into BusinessObjects using Access

    We use Business Objects to get data from Taleo. Appears we don't have the access we need because we were set up with ZABO "Zero Administration Business Objects". If we can't ODBC into the database, would like to at least get a file generated with Business Objects each morning automatically...
  2. RDM23

    Help-Linking into BusinessObjects using Access

    We have Business Objects 6.5. Not sure how to answer your other questions. Have not looked at Business Objects much. Just trying to see if there is a way to link into the tables? If not, wondered if there was any type of scheduler that would output a file automatically each morning. Thanks.
  3. RDM23

    Help-Linking into BusinessObjects using Access

    We have a system that uses Business Objects. I have never used Business Objects before. Is there a way that I can link to the tables using MS Access? Wasn't sure if anyone has used Business Objects and linked using Access. Thanks in Advance.
  4. RDM23

    Help - Query Formula

    I am writing an Access query where I want to query records in a certain pattern. An example of one name is ILT-QM-SAP-0007. I know that the first letters ILT will always be in the field name, and the 3rd set, SAP, will always be in the field name. Is there a way to write a formula that would...
  5. RDM23

    Help - Displays All Records on Data Entry Form

    I still want to be able to data enter names. I would like the form to open and go to the end to enter a new contact name. I also want the user to be able to go back through the records be selecting the back button on the bottom of the form.
  6. RDM23

    Help - Displays All Records on Data Entry Form

    I have a database that has a form that gets filled out that writes directly to a table. The information is employee contact information. We have records in the table. When we open the form, it only shows 1 or 1 record which is the new record. We would like to be able to scroll through the...
  7. RDM23

    Help! Reset Auto number in table back to 0

    My bad, the Repair and compact did work that VRoscioli suggested. I just had to clear out the table first. Thanks for all your help. Issue resolved.
  8. RDM23

    Help! Reset Auto number in table back to 0

    That didn't reset the tables auto id field back to 0. Any other options?
  9. RDM23

    Help! Reset Auto number in table back to 0

    I have a table that I deleted all the records out of. The autonumber field continues to count from the previous deleted records. How can reset the "autonumber" ID field back to 0 in this table? Thanks in advance for your help.
  10. RDM23

    Help! Using Scheduler to update Databases

    Thanks for your help. Is this for bypassing the "network" user id and Password? If so, Scheduler already handles that. I am looking at bypassing a password on the actual database. Here is my current run path in the scheduler program. "C:\Program Files\Microsoft...
  11. RDM23

    Need Advice on Process to update Database tables each morning

    I have macros that run early AM that update data tables on other network drives. Is there a way in Access that I could run the database macros locally on my machine, then copy the entire database to their network? I looked at the macro options, but only saw the options for copying tables...
  12. RDM23

    How do I undo Hidden Attributes on an attached Table

    Great. Thanks so much for your help again.
  13. RDM23

    How do I undo Hidden Attributes on an attached Table

    I had a table linked through ODBC. I didn't want my users to see this table, so I right clicked on the table, then selected properties, then checked the box next to "Hidden" box next to attributes. The table is no longer displayed. Question is, how do I get it back so I can view it? I know...
  14. RDM23

    Help! Using Scheduler to update Databases

    The database is Password protected. With this being on network and connected using ODBC, it also requires a username and password. The Username and Password is set right in the schdule task program. The database password is what is giving me issues. When it prompts for database password and...
  15. RDM23

    Help! Using Scheduler to update Databases

    Thanks. I added it to the command line and it is still prompting me for a password to logon. Does it matter where I put the command? Below is where I put it. Password is mars I tried it with and without the " " around the password "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"...
  16. RDM23

    Help! Using Scheduler to update Databases

    Each morning, I am running a macro to build data tables. These tables are built once each morning. My database has a password for security purposes. I am using Windows Scheduler program to execute the macro. Problem is it prompts me for the password. Since I want this to run early AM when...
  17. RDM23

    Help! Change query to pull from Combo Box to a List Box

    I currently have a form where I select from a combo box on a building location. My query then reads Like [Forms]![Form_Distribution_Selection_Criteria]![Building] This returns the building I selected in the combo box. I would like to change from a combo box to a list box so I can select multi...
  18. RDM23

    Help! Output table to Excel File without getting popup

    yeah, I don't know VBA, was hoping to do it with just Access. Thanks.
  19. RDM23

    Help! Output table to Excel File without getting popup

    I am running a macro that will output the file to excel to a set path and file name. I would like this process to just overright the existing file automatically. However, when my macro gets to this part, it prompts me and says current file will be overwritten, press OK to overright, or not to...
  20. RDM23

    Help! Query on Form

    Great Idea. Thanks so much for you help. Very much appreciated.

Part and Inventory Search

Back
Top