Search results for query: *

In Word... 1. Click the "Tools" menu and choose "Options". 2. When the "Options" multi-tabbed dialog box appears, click "General". 3. Uncheck "Allow starting in Reading Layout".

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

Well then...I probably have my syntax wrong. SELECT IWA.*, Servers.* FROM Servers LEFT JOIN IWA ON Servers.Server LIKE "*IWA.[Production Servers]*";

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

So simple! I let it pass right by me. Thanks for setting me straight.

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 see what you're saying, but what I'd like to do is take say Table A and combine it with Table B. Table A might not have a Make listed whereas Table B does. Table A's data is otherwise complete and reliable. I just need to append Table B's model listing. Is this possible?

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

Actually...it goes beyond the Null issue. I have the two tables linked by Application ID. IF the main table has an application id but the attribute table doesn't have a matching ID, the record for that application will not be returned. I want it to return the application info and if it doesn't...

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

Got it! Thanks!

Works wonderfully! Thanks!

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

There has got to be a better way to do this...What a hassle to bind it to a textbox to "interpret" it. No doubt it will work, but does anyone know of a better way? Maybe a script or something I could run on the table to convert all the -1's to 1's? I'm going to use this data piped to...

Got it working! Thanks so much!

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

I figured it out! Woo hoo! Thanks for your help.

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?