Search results for query: *

I currently have 1 field in my database that has 5 different components all seperated by a delimiter (dash) Example: abc-12345-defgh-678-ijklmno ... is the text and I need to place each component ito its own field via an Access query. Currently I export to Excel run the text to column function...

I am trying to design a report that only displays the latest(date or invoice number) record based on a grouping within the report. Example - My report has invoice data for each sales person and all sales people could have numerous invoices for the month but I only want to print one (the latest)...

Our company also has the 5 user CR Server that comes with CR XI and I have created hundreds of reports that are auto scheduled at various intervals with various file types (.pdf .xls, .txt etc) for our clients. Is there any way to get a single itemized list of these hundreds of reports and ...

I have a form based on a Parameter query which displays all records for the company based on user input. I then have 26 command buttons on the form which filter passenger names within that company based on their first letter. Private Sub P_Click() DoCmd.ApplyFilter , "[PASSENGER] Like 'P*'"...

Was wondering if it was possible to send MSAccess data from a query -OR- using the VB send keys function onto a specific browser window currently open on the desktop. My delima is that there could multiple windows open and the internet application in question sits behind a user ID/password...

I'm currently using Crystal Reports 10 with Enterprise 10/Express and was wondering if the scenario below was at all possible. I have a simple report whereby a parameter field lists all customers in the regular drop down box. I initially built the parameter field using fields taken from a...

I have been unsuccessful trying to resolve an issue for quite some time now regarding NDR's. Any help will be MOST appreciative. The scenario is this ... If we type in a wrong email address (gary@abc.com instead of garry@abc.com) for a user on our exchange server we do get the NDR if emailed...

Sorry if this is a basic question, but I'm still a bit of a newbie with Crystal Reports 10. I have a table with multiple invoice records whereby 1 invoice can include one or many different items and each item would be a separate record within the table. I'm in the travel business so an example...

I am currently running W2K Small Business Server in mixed mode which is also being used for VPN access. Need to assign a static IP address for our VPN clients, but can't do this via AD as the "Assign a Static IP Address" is gryed out in the Dial-in tab of the user. I was told it's because of...

Sorry if this seems like a basic question ... I'm a newbie at SQL admin. Running MSSQL 2000 on a win2k server with a database consisting of various linked tables having multiple customer information. I would like to setup a user ID to have access to this database but only so they can view...

I am attempting to import data from an Interbase 6 database to a Microsoft SQL 2000 database utilizing the DTS Import/Export Wizard. I am able to connect and import 1 random table at a time however when I select multiple in the wizard (0) records get appended to each of the selected tables and...

Recently I have been getting an error message box popping up while navigating in Windows Explorer. "Couldn't start the Dispatch Table" I'm just moving from one directory to another and no file actions are being performed. Have looked far and wide on the internet and am unable to...

Is it possible to add multiple field values displayed in a single combo box to a new table. Example ... if the Combo lists CustomerID (index visible)and CustomerName how can I take both fields and add them to a new table? I know I can do it for the (bound) field but I'm at a loss as to the...

Can somebody please help me with this error. Most of time when I compose a new email and do a cut and paste to my new message, Outlook shuts down and the error comes up which says "OUTLOOK.EXE HAS GENERATED ERROR AND WILL BE CLOSED BY WINDOWS". Then, you have to re-do it again. We...

Can somebody please help me with this error. Most of time when I compose a new email and do a cut and paste to my new message, Outlook shuts down and the error comes up which says "OUTLOOK.EXE HAS GENERATED ERROR AND WILL BE CLOSED BY WINDOWS". Then, you have to re-do it again. We...

Is it possible to email multiple "objects" (Access tables in Excel format for example) in one email utilizing the "SendObject" action? It works for 1 object but I would like to add 2 or more to the same email. If not , is there another way? thanks

Is it possible to update a table's record when a comparison is made from a field in the previous/next record? For instance, the table is set up like ... NAME INV_NBR INV_DATE INV_DIF INV_DATE_DIF ---------------------------------------------------- smith 25266 8/10/02 ...