Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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