Search results for query: *

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

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.

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

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

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

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

I have a form where I need to audit to see if either of the options are checked. Something like If Field1=-1 or Field2=-1,"Yes","No. (This is for a checkbox on a form. I need to ensure that only Field1 or Field2 is checked which would display a -1. This is just an audit on the bottom of the...

I have a query where I select a persons name, and it appends the records to a table and then opens the form for that employee. On this form, I need to enter a few other fields. I need to set the fields to be required in order to save the record. Is there a way on the form to set the fields as...

My access database is acting differently. If I build a simple select query, then want to exit, it only asks me to "save as". The only want to exit this query, is I have to save the query. The default name comes up with "query1". The only options are OK and Cancel. I am also noticing that if...

I have a form where data is entered. I have a field where they need to enter a date. I would like to provide a calendar option so they can click on the calendar and pick the date. Is there an easy way to add this option in Access? Thanks in advance for any assistance.

Below is a copy of the query that returns either Pr, Sr, or Alert. For the Pr and Sr part, I also need to include if [Level]=M4 and [Type]=EX. I want to include that so if Left 2 of decription is Pr, and Level=M4, and Type=EX, then return Pr. Same for Sr, so if Left 2 of decription is Sr, and...

I have 3 fields I am trying to combine. These are name fields such as Last Name, First Name, Initials, I am able to combine these using this formula. Name: [Last Name]+", "+[First Name]+" "+[Initials] My issue is, sometimes the Initials field is blank. How would I write the formula to...

I am looking for a way that I can have a calendar on a form so I can select the date I need. When I click on this, it would then populate the date field on that form. Is this possible using Access? Thanks in advance.

I have 5 separate reports that I run each day. These are just data audit reports. Each is based on different criteria. Is there a way that would allow me combine all these reports to one report instead of generating 5 separate reports? Thanks in advance for any assistance.

I have an Access form with various buttons that run a macro when selected. I would like to add a "note" or something that would show more details if they clicked on it. In Excel, I know you can enter a comment on a field. Wondering what this is called in Access and how to add it. Thanks in...

I have a query that pulls data based on a form that uses a "Combo Box". Based on what I select in the combo box, it returns that information. I would like to change the combo to a "List Box" so I can select multiple fields. I know how to change it on the form and to select multi select...

I am trying to write a formula in Access to evaluate 2 different parts and return Yes or No based on if both criteria is met. For example: If Field A is not equal to Field B, AND Field C = Null, then Yes, otherwise No. Can someone let me know what the formula would look like? Thanks in advance.