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!

Register Log in
  • Congratulations derfloh 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: DaveMac
  • Content: Threads
  • Order by date
  1. DaveMac

    Design Help with Printing Many Files

    I need a little design help on the follow problem, thanks in advance. Current state: We have 121 rtf documents that users open in word to prepare for a survey. Use factors: Users select between 5 and 25 documents to print and take with them. The selection is up to the user and cannot be...
  2. DaveMac

    Rarely used Method Help

    Sorry folks I know this is not a typical VBA question but it is driving me nuts. Situation: I recently changed jobs and have moved from a Blackberry to no work phone. I purchased a Driod and would like to get my calendar events on my Driod Gmail calendar. I can by using Forward as Ical...
  3. DaveMac

    Create Many Linked tbls Quickly

    Need VBA to link tables to many identical DBs I have 24 servers that are running the same application. I would like to connect to these via code rather than having to create 240 linked tables. Need: To link to 10 tables on 24 servers Good news: I have a local table that has all 24 server...
  4. DaveMac

    Help getting away from static criteria

    I have several queries that have static criteria typed in. These are each specific to the user. The users are spread out and need to only see their data sets so I set the criteria then rename and send the DB. My question is how could I point the various queries and various fields to a table...
  5. DaveMac

    Help with ODBC code

    I am out of my comfort zone and it shows. I would like to create a command button that creates an ODBC connection for users automatically. I do not care if it is “on the fly” or if the created connection is now present in their ODBC system connections. I have 2 tables in the DB that get...
  6. DaveMac

    How to make 5.5 by 8.5 pages

    OK I really tried to figure this one out and can’t. I need a report that prints Images from a table with images in it on ½ of a sheet of paper. The paper can then be cut in half to make a 5.5 by 8.5 page for books. So I need to know how you would format a report that is: Page size 8.5 by...
  7. DaveMac

    Design question. Should I use ODBC or is there something better?

    I have an access app that uses 2 linked tables that are linked via standard ODBC. I use a lot of linked servers in MS SQL and can create those dynamically on the fly. I would like to be able to create the most robust connection type possible given my need. The use would look like this: 20...
  8. DaveMac

    Format date-time so it can be used as filename

    And today is beginning like yesterday. Help with format date. As you can see I want a file saved at 8 am on Jan 1st 2011 to be strfiledate “0800 1-1-2011”. I just need a date/time down to the minute, seconds if it is easy, so I can ensure unique filenames...
  9. DaveMac

    Need a Data Last Updated Box

    This should be simple but as usual since I have never done it it is not: Need a control on a switchboard like form that says Date Last Updated. This will tell the users the last time the master data was pulled down from the master data server. I created a query that does a top 1 and get the...
  10. DaveMac

    Adding row number to a Query

    I need a row number field in a query. The query is based on a table that has an autonumber field however there are deletions so I have gaps that I cannot have in the query results. I have read the many posts on this but none of them seem to fit exactly what I need. In addition to the...
  11. DaveMac

    Combo not working or updating not sure

    I have an issue with a combo box. The box is on a subform that is linked to the main form via a field called formula on the subform and Child on the main form. I added a combo that looks at a tbl that has a field called Child. I then added [Forms]![Frm_Pack_Lineup]![Child] in the query of the...
  12. DaveMac

    Is a combo box really this hard?

    I should know this but I don’t. I have a combo box that is on a subform. The Combo box is sourced from a query of Partnbr, Description from tbl_parts I can get partnbr into tbl_needed_items(the source for the sub form) When I use: Me!Description = DLookup("descp", "qry_all_skus") I get the...
  13. DaveMac

    How to limit a subform combo to what is on the main form

    I have a main form with formula. In the main form I have a subform with Goods and qty. I would like whne I select a formula on the main form that the combo on the subform only shows the goods that are within that formula. I do have tables and queries with both formulas and goods so I was...
  14. DaveMac

    Need Help Creating Agents

    I love moving from Outlook to Lotus notes! Sorry I have to keep telling myself that so I do not loose my mind. That being said I really do see where Lotus can do so much more but since I do not know how to do it I am currently hosed. Help! I had lots of macros in Outlook to automate my...
  15. DaveMac

    Copy a Form and its’ subform data

    I have a form and a subform. The form is a work order type form and the subform are the expected tasks. I would like to make a command button that when clicked copies the form and its’ subform’s data. The link field is called WO_ID. So how do you code a copy of the me.form and the me.subform...
  16. DaveMac

    How to Sum a Text Field

    How to Sum a text field? We have this existing app that has a SQL DB. I cannot add fields but there are unused ones. The problem is the field I want to use is a text 2 char field. I can put numbers in it but no matter what I try I cannot get access to do any summing. I have tried...
  17. DaveMac

    VBA in Excel with Select Case

    I need to look at the Left 2 of a number and return a conversion. So here is the function excel has and worked but as you know it stops at 7 so how do I move this to VBA? Thanks...
  18. DaveMac

    SQL in the VBA for Excel

    Need help running SQL statement in excel. Not sure where to begin but here is where I am. I made an ODBC connection to an AS/400 DB I have an SQL statement that when run in WIN_SQL runs fine. I now need to add a text_box or cell that allows users to enter data and then click or something to...
  19. DaveMac

    Setting the Default cannot be that hard! Right?

    Hello, I have copied this code from a FAQ and it looks like it will do exactly what I need. There is one small problem, it does nothing not even throw and error. What am I missing????? I have two text boxes on a form that are from a table that I want to set to the previous records values. So...
  20. DaveMac

    Would this be a Crosstab or pivot or what?

    I already know this is bad DB design however I did not design it. Here is the issue. I need a query that results in: Item, Description, UPC, QTY, Tag_Num 55, Bike, 12345, 21, 77 71, cart, 55552, 39, 901 88, bike, 12345, 5, 901 Etc… From a table that is laid out as: Tag_Num, Description1...

Part and Inventory Search

Back
Top