Search results for query: *

I'm trying to use the default printer function but I'm getting an arguement not optional alarm. What is it that I'm missing? Private Sub cmdprint_Click() Call My_Print End Sub Function My_Print(frmblankreport As Form) As Boolean frmblankreport.UseDefaultPrinter = True DoCmd.PrintOut...

I'm trying to get my teams set up hours and production hours for certain jobs called project jobs. I'm trying to get them broken down by the Date entered the Dept. then the work center. I am only getting the Hours of production for one run. If two shifts run the same job on the same day I'm...

I have created a list box that is simply pulling in queried information. In this list are basic numbers and percentages. The table has been formatted to have 0 decimal places for the percentages and a Null value for default value. However I am getting .00% and a lot of 0 where no information...

Howdy, I'm in sort of a bind right now. Our I.T. Dept. "upgraded" our network and now several computers are missing a reference so I cannot use Environ(COMPUTERNAME). The reference that is missing is Microsoft Windows Common Controls-2 6.0. If I know what reference is missing how do I (can...

I asked this question a while back but didn't get anything to help. I have created a list box with about 12 columns. My problem is that when I scroll the last column width is huge. How can I correct this issue? Thanks, Rib Bartender:Hey aren't you that rope I threw out an hour ago...

I know this may sound like a silly question but if I knew the answer I wouldn't be asking so here it goes. I created a split database and since all the tables are in the back end of the project does it matter if I'm filling my list boxes/combo boxes with tables? I ask because if the queries...

Howdy I have some basic questions on a split database. I have created a project in which up to 10 people will be entering data at the same time. So, I've read that it's a good idea to split my database. I did this and I believe it was successful however I have some questions. P.S. I have the...

I recently got a newer computer and my program in XL ran fine. With this computer every time I open the file I'm automatically sent in to Break Mode. If I push play the program will continue with no error messages or alarms. Other computers with Office 2000 are fine. I'm running Office XP...

I recently got a different PC with Excel 2003 ( I think) and when I open a form that has an Auto_Open Sub the program stops and won't continue. I don't get an alarm or anything. Is there a setting that I need to change? Thanks, Rib Bartender:Hey aren't you that rope I threw out an hour ago...

I just switched computers and now I don't have any references. How do I get them? Any help would be super! Thanks, Rib Bartender:Hey aren't you that rope I threw out an hour ago? Rope:No, I'm a frayed knot.

I need some help transferring information from a recordset that I am retrieving from an AS400 dbase to a newly created table that is in Access. Below is what I have so far but I am stuck right now. Any help would be grrreat. Sub HELP() Dim cnt As New ADODB.Connection Dim rst As New...

I was just starting to figure out recordsets and ADO stuff in Excel when I thought I would try it in Access. I want to start out slow by simply adding a list of partnumbers to a list box from an AS400 database. Can someone bump me in the right direction. I'm trying to use the Object Browser...

I'm trying to pull in information using an ADO connection and I can't quite visualize how the column headings can be written to my XL sheet. Any help would be great. Sub Get_Info() Dim cnt As New ADODB.Connection Dim rst As New ADODB.Recordset Dim strSQL As String Dim strdb As String Dim r As...

I am connecting to an AS400 db from XL. I am bringing in part numbers that are based on a department number. The problem is the department numbers aren't just numbers they have a dash in them i.e. 121-5224,137-5417 121 and 137 are the department numbers. I am tring to use the Like statement...

I am trying to retrieve some information from an external data source but I keep getting a General ODBC Error. I'm pretty sure it has to do with my WHERE STATEMENT but I'm struggling. Next question can I do mathematical operations to records in the fields? I want to calculate the inverse of...

I have made a shipping receipt and what I would like to do is automatically fill in the number of boxes that are being shipped. The constant is 48 pcs per box. so if the person ships 41 pcs that would be 1 box and if he/she ships 51 pcs it would be two boxes and so on. I could write if...

I couldn't find this in the FAQ area but I'm sure it has come up. I have a table in Access that is receiving info from a form I have created. The user can have multiple entries on any given day. What I would like to do is sum the hours he/she has for the one day. I the example below I would...

I have an XL workbook with a few modules. I put a combobox in the worksheet from the control box toolbar and when I right click to view the properties I noticed that I don't have any properties at all. Obviously there is something I'm missing here at it's probably simple but what is it? Any...

I have a combo box that I added to a sheet and All I'm trying to do is clear it (empty it) before I add to it so I don't get duplicate data. There must be an easy way to do this because the way I'm doing it seems a bit verbose. Here is my code any thoughts? Option Explicit Sub ClearMe() Dim r...

I am trying to connect to an external source using an ADO connection but not having much success. I believe their is some type of security but I know the username and there is no password so I'm wondering why I cant open the connection. When I run the code below I get an error message that...