Search results for query: *

I have written a routine in VBA for Excel XP which imports a tab delimited text file into my workbook. The original file looks like this: "B3" "2421835" "2421835" "TP" 05/17/07 1175.00 "CEI" 05/06/07 "N9" "IT" "KUP" "N9" "BF" "YA" "N9" "PO" "CA23WHSEF" "N1" "SH" "CONOCO PHILLIPS" "N3" "KUPARUK...

Hi there - I need to be able to compare the percentage change for amounts over due (>60 Days, >90, >120). The table in which the data resides is Current Month Aging History. Here is the field list: CUSTNO NAME DATE OVER60 OVER90 OVER120 Here is the query I am currently using...

Sorry about the repost, but I received no replies, probably because I wrote a follow on so it looked like someone had responded. Microsoft Outlook appends the following text to the bottom of meeting invitations: =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~= Click the following link...

I recently noticed that Outlook has been adding the following to the bottom of my outbound messages: =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~= Click the following link to get a map and driving directions in Live Search Maps: http://go.microsoft.com/fwlink/?LinkId=65850&WIP=12...

Hi there. I have a crosstab query for reporting survey results by department. Currently it returns the number of times individuals in a given department chose a certain category. This works fine. In my report which references this query, I need to know how many individuals as a total percentage...

I'm using PowerPoint 2007 in compatibility mode for PowerPoint 2000 & 97 to develop a tutorial for software training. Most of the end users will view the show using PowerPoint 97. Here's my dilema: Users can click a hyperlinked text box labeled <Previous (it's on the Master slide) to view the...

I have a disabled textbox control that I would like to enable via a command button and a password form. As the available features in the database expand, I would like to be able to use the same password form over and over and just pass expected values via a function so that I don't have to write...

I have been tasked to develop a database which will allow absolute novices to MS Windows and its associated programs to track trucks in and out of a terminal. I am certain that I can do this fairly competently in Access. Here's my dilemma: I work from a terminal in Tacoma and the data may need...

I have a table called CNIDMaster with a single field called CNID whose data type is Long Integer (not auto increment the numbers are hand entered.) How can I use VBA to insert a sequential series of Long Integers into the table based upon a start and end integer that I specify on a form? Here's...

I am using a macro to repetitively paste a preformatted block of cells. This block will vary in size according to user input. Unfortunately, this means that occasionally a block of formatted cells will fall across a horizontal page break. If this occurs, I would like to paste the whole block at...

Hi folks! I have a query returning records from a linked table and joining them with 2 tables in my database. The goal is to have a list of clients who have a balance >0 and who are scheduled to billed under the current cycle so that our billers know who they need to charge on a given day. The...

I frequently see requests for book recommendations and was wondering if it would be worth the server space to create a forum for recommended reading. I can see from poking around a bit that we have a white papers section, but wouldn't it be nice if there was a directory tree structure with...

Hey everybody - I am using an Access 2000 form to compose and send an email to Outlook so that I can have a record of it in my db (I use it to report bugs in the database). Any idea why the message format is plain text even though I have specified rich text format in my code? I checked my...

Hi! I'm using VBA to write a formula to a cell via range. The formula string must be enclosed in double quotes, however the formula itself is examining text values which must be enclosed in quotes. Doing this causes VBA to treat the first quote of the text values as being the end of the...

How do I use this code snipet to read the row numbers which this return into an array? Right now, it just puts them into the debug window. 'Get row number of each booking For MoveCell = 1 To Target.Rows.Count Cells(MoveCell, 1).Select Set Target = Selection If Target.Value =...

How do I use this code snipet to read the row numbers which this return into an array? Right now, it just puts them into the debug window. 'Get row number of each booking For MoveCell = 1 To Target.Rows.Count Cells(MoveCell, 1).Select Set Target = Selection If Target.Value =...

When I attempt to make a copy of a worksheet in my by holding the Ctrl key and dragging and dropping on the sheet tab, I receive a Name Conflict error message. The same error occurs if I try to use VBA to make a copy of the offending sheet in the workbook. Here's the strange part: I have...

How do I get Access to let me have a large blinking cursor in a text box? I have already tried modifying my cursor size in my control panel and it works fine in the address bar of my web browser, but in a Datasheet text box or a Form text box, I only get the skinny little blinking cursor. Know...

How do I refer to the active control in a continuous subform in the CURRENT RECORD? If I try to use code to change the backcolor of the active control, it changes the backcolor of every instance of the control on my continuous form. What I am trying to do is show visually where my insertion...

Hi! I have an option group named QueryDriverGroup on a subform embedded in a main form named Drivers, and I want to use it to apply one of three queries as a recordsource for my main form. I looked over faq181-447 concerning subform syntax and wasn't able to find a line that would work. My...