Search results for query: *

Hello, I am in MS Access 97 and I have three simple query windows open. I want to be able to ALT + TAB to each query, but that doesn't work. Any idea how to get that same functionality in 97? Thanks,

Hello, I am using MS Excel 2002, I want to add one day to a date using the DateAdd function. So I have the following: Function Add_A_Day(CellValue As Date) Dim LDate As Date LDate = DateAdd("d", 1, CellValue) End Function In the cell I want to contain the new value I have...

Hello to all, I have read the previous posts about using the macro recorded to import a text file into excel. My question is, what if the file is not the same name every time? how do I code that? Thanks, RB

Hi All, I need to take this: Curr Loc Location Name Social Security Number Class Description Coverage Tier Med Admin Cobra/HIPPA PPO Fee UR/CM Billed Amount Coverage Month Count 207 7005 IAD Doe,John A xxx-xx-xxxx FULL/EPO/PHCS e 13.7 1.75 6.75 2.75 24.95 08/2006 1 207 7005 IAD Doe,John B...

Hello all, I have a really ugly text file that I must get into a usable format in excel. First here is a sample of the data: BILLI NG CODE SUMMARY FOR CITY Bi lled fro m 05-01- 06 To 05-01-06 PAG E 1 Grou p : 211111 Company ABC 6/23/2006 10:07 2006...

Hi, What I want to do is sum values in a column if the policy number ( stored in one column) and the service code (stored in another column) are the same, if not I don't want want to sum it, I want to start a new sum IF Cell A2= a1, if c2= c1, L2= d2+d1, " " Here is a sample of data: a...

Hi All, Ok first this is what I want to do, I want to fill a combobox on a form based on the user selection from a different combobox. The combobox I want to fill will contain a sales ID and a salesperson name. I would like to use my existing function to fill this combobox the function is as...

Is it possible to return multiple values from a subprocedure or function?

Hello, How would I have a logo that changes based on the company the report is being generated from? This is on the invoice blank form report Great Plains 8.0 Thanks, RB

Hi All, I have a small function that evaluates a string looking for an apostrophe, I call this function from within a do while loop on a recordset that is inserting into a table. How do I get the result of my function ( string without "'") back? here is my code: Do while loop Public Function...

Hi All, I have a recordset in my application that combined 4 different companies data, I want to create a table based on this recordset. The end output will be an access report, or an export to excel. What is the best way to accomplish this? Here is the SQL statement for my recordset: SELECT...

Hi All, I am getting a syntax error: Syntax error (missing operator) in query expression 'B.WB_NewRenew'. in the following and I can't figure out what is wrong a 2nd pair of eyes would be greatly appreciated. SELECT A.CUSTNMBR, A.CUSTNAME, B.SLPRSNID, C.SPRSNSLN, Sum(B.WB_COMM_CALC) AS...

Hi All, What is the appropriate syntax to referenc the value of an option group in a query? I currently have: Like IIf([Forms]![frmMain]![fraBusType]![value]=2,'*',[Forms]![frmMain]![fraBusType]![Value]) But that doesn't seem to work. Thanks,

Hi All, I am attempting to pass a sql string to a function. The function then creates a recordset. what am I missing? I keep getting 'No value given for one or more parameters Public Function FillCombo(FromDate As Date, ToDate As Date, SalesPerson As String, intOption As Integer) Set...

Hi all, what is missing in this if statement for a query? I am trying to say if the option group is 1 then pull all records otherwise, pull just selected role. IIf([Forms]![frmMain]![fraICRoles]=1,"*",[Forms]![frmMain]![cboICRole])

Hello, I have 4 companies, each one's data is stored on a different database. I need to pull all of them together onto an excel sheet for a pivot table. I have created a union query between the 4 companies, however this is very very slow, and it is in MS Access, the end user for this is not...

Hello, I have 4 companies, each one's data is stored on a different database. I need to pull all of them together onto an excel sheet for a pivot table. I have created a union query between the 4 companies, however this is very very slow, and it is in MS Access, the end user for this is not...

Hi, I have a pivot form in access 2002, there is a field called WB_TIER that has values ranging from .08 to .00008, when I pull the field into the pivot, the only option is '0', how can I keep the precision on this field when it is pulled into the pivot form? Thanks, RB

Hello, I am inserting Social Security Numbers into a table (tblStagingTable), the field is set to text length of 9, with an input mask of social security number. The tables containing the SSN are also formatted as listed above. My insert is done via VBA code: Public Function ImportRecords()...

Hello All, OK this is a little tough to explain, so let me know if you need more information. I have a table with the following info: (tblOtherInformation) ASSGN_TRANS_NBR SOC_SEC_NBR LINE_DESC_CD OTHER_INFO_TEXT fldPlanSponsor fldClass fldLineDescription 428934 394866113 D...