Search results for query: *

Hello, I'm looking to write some code to automatically copy MS Project data into an Excel spreadsheet. I'm doing this so that all I need to do is grab an updated copy of the project and it will update the data and charts in my Excel spreadsheet. Having a bit of a difficult time. This is what I...

I have a table with server ID's...I want to join it to a table containing applications. This application table has a string field with servers. How can I say "Give me the server information from Table #1 and the application information from Table #2 where the server ID is listed in the...

I'm trying to search a field in access that contains server hostnames. For instance, I want to find av3300. A string might have av5500,cad1100,av3300,test1213. I want that application information returned if the av3300 is found. Ultimately I'm goning to take a list of servers I have, compare it...

I have 17 tables all with server related data (Make, Model, utilization, etc.) There are duplicate fields across all the tables (i.e. Table1 has Make, Table2 has make). I want to create a query that builds a new table by combining the info of all 17. The catch is, I want to be able to rank the...

I have a database containing 3 tables. If I run a query calling for values from all of the three tables, the only recordset which is built is that of items with values in ALL 3 tables. For instance, if my attributes table doesn't display a value for languages on application ID # 1234, 1234 will...

I have a form (frm_Main_Form) which can be called up one of two ways, either by imputting a value into a form (frm_By_ITMS_Number) for the ITMS number or by Selecting the person on a separate form (frm_choose_user). Both should call up (frm_Main_Form). Each have corresponding, predefined queries...

I have a form (frm_choose_owner) with a listbox which I would like to dynamically build based on the values in a specific field in a table (tbl_ITMS_dump)I have. Trick is, I don't want duplicates in the listbox. The values dynamically added to the list box will allow the user to select on and...

How can I set a value from a listbox as a parameter in a query?

I'm currently working on a form which has two tabs...The form opens using a query which asks for an application ID. The information gathered through the query for that ID is displayed on the first page. The second tab has 4 subtabs underneath it. Each have different attributes about the...

How can I get a form check box to input values into a table as 0's and 1's instead of 0's and -1's?

I'm working on a short project in which I have a form based on a query. When you open the form, the query is kicked off and you are asked for an ID number. The query runs and the info is displayed. What I am trying to do is add tabs to that form where, based on the input ID, the relevant data...