Search results for query: *

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...

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.

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.

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...

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.

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...

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.

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

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.

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...

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...

Great. Thanks so much for your help again.

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...

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...

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"...

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...

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...

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

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...

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