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

I ended up using the .GetOpenFileName method in VBA. Thanks for the help

No I haven't I will take a look at it. Thanks, RB

Sub ImportExcel_Staff() ' ' ImportExcel_Staff Macro ' Macro recorded 12/4/2006 by Rayna Brandt ' ' Keyboard Shortcut: Ctrl+Shift+S ' ChDir "V:\FGS\Data_ARCHIVE\DataOUT" Workbooks.OpenText Filename:= _ "V:\FGS\Data_ARCHIVE\DataOUT\FGSClaimStaff_20061204_072051.txt", Origin:=437 _...

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

Thanks Skip, This is what I did: ElseIf .Value Like "" Then Else If TargetSheet.Cells(TargetRow, 1).Value = "" Or Null Then TargetSheet.Cells(TargetRow, 1).Value = TargetSheet.Cells((TargetRow - 1), 1).Value TargetSheet.Cells(TargetRow, 2).Value =...

Skip and all others, I have a question, here is what I have inserted into my loop: With SourceSheet.Cells(SourceRow, 1) If .Value Like "Group*" Then TargetSheet.Cells(TargetRow, 1).Value = Mid(SourceSheet.Cells(SourceRow, 1).Value, 12, 6) ElseIf .Value Like "*PREMIUM*"...

Thanks Skip, I will try this out tonight and let you all know ! Thanks, RB

Skip and all others, The format I want the file to end up in is: Group Number Service Code Sell Price 211111 21 3206.25 211111 22 7425 211111 58 4556.25 211111 125 7.64 211111 CFN -15,187.50 211111 COM 15,187.50 So what I have so far is: Public Sub CopyRows() Dim SourceSheet As Worksheet...

Skip, That is the most fantastic idea! Thanks so much, I wouldn't have thought of that. I will try it and post any issues. Thanks, RB

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

Thank- you that was exactly what I needed!

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

Golom, can you give me an example of how that call would look? here is my calling statement and procedure heading: strList = FillCombo(cboFromDate.Value, cboToDate.Value, cboSalesperson.Column(0), 1, _ ' intOption, fraBusType.Value) Public Function...

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

How would I change the default invoice form for the companies?

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