Search results for query: *

I'll try to keep this brief. Its an important step for me to ask this forum for advice. My career in IT started in 98, I moved up the ranks of phone support and spent the last 5 between server pre-sales/tech sales/tech support for a very well-known PC company (just not for servers). I innovated...

Access 2002/XP I'm needing to import data from a .csv file that uses " to separate text from tab. However there is one field that is text and contains " as part of a description field that I can't skip. When trying to import using the " as text delimiter, the fields get off track on some of...

I have no relationships between the tables Cases CaseNo, AssignedTo Activities CaseNo, CreatedBy There are many Activities for each Case (calls in and calls out) and both tables have many many more fields than I have discribed above. I need to identify a percentage for each owner (grouped by...

I may have gotten myself in trouble when I half stumbled/ half rushed through the building of my queries and overall reporting design to meet some deadlines. I pull data from Siebel and then do a number of things to manage the data in the Access 2002 database. On a level of 1-10 in Access I am...

This is a aingle table, simple query problem, I think. I am prepared to feel and look stupid with your response, any response, and any good Access/VBA/Sql resources online you can recommend will be greatly appreciated! Within one table, there are two columns I need to report on. tblRecords...

Hello world, I have unfortunately spent too long trying to make functional a network configuration in my home. I cannot find the problem with this configuration that I have built from checking some very good and useful resources. Here is my config: Wirespeed DSL Router external IP: 1.2.3.4...

For anyone who knows how to use outlook forms and vb. How do I use a value in a custom field on a form to create a hyperlink, then 'execute' the hyperlink to bring it up? For instance: Field01: 012345678 Hyperlink format: http://server/01234/012345678.htm Once I get this info, my next...

I would like to select the Contacts folder, not the active folder. This must be simple! How? This script sets the form or "message class" that contacts use. But, if I have inbox selected when I run it, all items in that folder will open in a contact form. Ouch, can't do that. Thanks...

Ok, nobody in the office forum has responded, so I am taking my chances in here. I have tried many different codes that I have found on tek-tips, as well as google groups, and the help files, and microsoft MSDN. After 3 days I can't find anything to make this work properly. I need an outlook...

I have tried many different codes that I have found on tek-tips, as well as google groups, and the help files, and microsoft MSDN. After 3 days I can't find anything to make this work properly. I need an outlook contact form to have a button or control to open an excel spreadsheet and copy data...

Hello, I am using Office 2000 (Outlook and Excel 2000). I have been playing with outlook contacts and using a custom outlook form that I designed with a button labeled "Export to Order Entry Form". What I want this button to do is: 1. Open excel 2. Open an order entry form made in...

Here are my goals.. All I need to know is the concepts needed to acheive it. 1.import a worksheet from an .xls file into a new table with a standard table name (different than .xls file name). 2.append to a table with more fields (like rowid, a date-time, .. btw I made a field a primary key...

Help w/ Access 97 Query I need the average of a count. (Actually, I don't even know what I need really). I have a timestamp for calls. I need to break them down into a daily count, then average that. I tried SELECT avg(Count(*)) AS Expr1 FROM tblNewCalls WHERE...

I'm looking to add a field with a browse button to a form that I can use to select a file, which puts the path into the field on the form. Can it be done in Access 97?

Here's my back-end: tblAuthors AuthorID Autonumber AuthorName Text tblDocs DocID AuthorID1 AuthorID2 AuthorID3 AuthorID4 I have two list boxes, with two buttons between them (> and <). I want to be able to see a list of all the authors, and author ID's on list1, and be able to...

I need to edit a macro based on a value on my form. Here's an example: macro1 action transferspreadsheet c:\my\file.xls I have a form with a value for c:\my\file2.xls I want to click a button, and have the button use the value in the field to modify the macro. I know you have the answer...

I am trying to determine the number of records I have where the date field is not more than 60 days old, but not less than 30 days old (last month). I use the following to determine how many within the last 30 days: =DCount(&quot;*&quot;,&quot;tblNewCalls&quot;,&quot;[Date] >= Date() - 30...

I'm using the following Shell Command to create a new Outlook message to send a fax: Shell &quot;C:\Program Files\Microsoft Office\Office\Outlook.exe /c ipm.note /m [fax:Someone@Fax] Now, It lets me do this: Dim Var1 Var1 = me!Contact Shell &quot;C:\Program Files\Microsoft...

This might be very very simple (hopefully). I have an application named Vantive. I need to use the sendkeys command to input the value of the Event # field from the frmNewCalls form. Here's what I've got: Private Sub cmdSendEventToVantive_Click() Dim Vantive AppActivate &quot;GCS Event...

Using a NAT server to share a resource, yet placing a web server behind it on the private network. NAT Server: Internal 192.168.1.1 / 24 2nd IP 185.0.0.1 Nat mapping 80 to 185.0.0.2 Web Server: Internal 192.168.1.2 / 24 2nd IP 185.0.0.2 If the web server can ping other servers on...