Search results for query: *

Hi, I have a simple ACCESS (ACCESS 2000) form which allows users to search the table by setting 1 or multiple of the 5 different parameters (i.e. customer name, order date, order ID, customer phone number, product name). Some of the parameters use a drop-down menu, and some allow users to...

Happy Friday! I am having some hard time with a query I created... My current query: SELECT Code.h_codeid,Code.h_instance,Code.h_code,Code.h_date FROM Code INNER JOIN Account ON Account.SSAccountID=Code.SSAccountID AND Account._counter=Code.claimlink WHERE Code.h_codeid IN ('DI','PR')...

Hi, We use a communication PC to connect to one vendor's system for cost reason. Sometimes, when end users call the procedure, the PC would try to query and build up a long queue since no results are returned. The wait counter would just keep running. Is there a simple way to monitor the...

Hi, I am not sure if this can be done, but I sincerely hope someone can help me out. I have a table with data like this: counter salesrep PostDate BillDate -001234 Adam 2006-9-23 00:00:00 2006-9-24 00:00:00 -001234 Alice 2006-9-25 00:00:00 2006-9-26 00:00:00...

Hi, I am trying to split rows in an Excel spreadsheet. My spreadsheet currently looks like this: Procedure Description Category Price Modifier1 Modifier2 001234 Plastic bag V $12 TC890 TC990 001235 Paper box V $15 TB003 001236 Tin can J...

Hi, I need to write a VBA function that allows users to find specific text in the macro and replace the text with a new text without using the FIND & REPLACE feature in Excel. The macro I wrote imports file with names like filename08072006.txt. I am trying to create an form that allows users...

Hi, I am trying to build a SQL-based simulation tool which will apply complex rules (rules stored on a rule table) to different scenarios. The logic is to throw all the rules onto a rule table, and then create a form which users can enter a scenario (i.e. 21-year-old driver with no DUI record...

Hi, I used autofilter first, and then I would like to delete all hidden rows (the rows that do not meet the criteria. My coded did not work the way I wanted though: Columns("C:C").Select Selection.AutoFilter Selection.AutoFilter Field:=1, Criteria1:="=HA*", Operator:=xlAnd...

Hi, I am some problem copying data from one sheet and paste it to the first empty row on another sheet. My code: Sub findlastrow() Dim lRow As Long Dim Range As Range ' Find the FIRST EMPTY row by adding 1 to the last row With ActiveSheet ' Determine last row lRow =...

Hi, I have 5 columns on the spreadsheet plus rows of header and footer for each page. I would like to delete the header and the footer and just keep the "meat" on the spreadsheet. Here is a sample of the sheet: Good Morning Distribution Page 1 Date: 07/25/2006 BT SalesName...

I am working on a reconciliation project. Basically, we download a spool file named "Claim Trans 20060724.txt" from our system and save it as a text file in a central location daily. There are two challenges I ran into: 1) how do I write the VBA so that Excel will import the text file which...

Hi, I creatde a view, which contains three fields, Username, Number of Changes Made, FieldName. The table shows how many changes each user has made to each field. I would like to write a query which displays each user's top 3 fields (the 3 fields each user made most changes to). I ran the...

Hi, The table I created has UserName, ClientAccount#, and AccountChangeDate. My report shows: User Name AccountChangeDate # of Changes Made Amy 7/13/2006 449 7/14/2006 582 Total...

Hi, I am creating a report which shows # of changes made for each customer account by account executive. I would like to be able to show the counts by week, month, quarter, or annual. I created a query: SELECT [UserName],[ChangeDate], Count[UserName] AS [Total # of Changes Made] FROM...

Hi, I imported data from a SQL database to create an Access table. Since the SQL database is updated daily, I would like to know how I can link the Access table to the SQL database so that the Access table can be updated automatically whenever new data is added into the SQL database. Thank you!