Recent content by ghnat

Thank you PHV .. it worked like a charm amd will save me a lot of time! Most appreciative. Gary

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 went into ... View/Code/Tools/References ... to make sure it was checked ... and it was. Still however not working properly .. have spent hours trying to get what initially seemed to be an easy issue to resolve. The filter buttons on the form always prompts for the parameter value on the...

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*'"...

What I currently do while in MSAccess is ... Private Sub UpdateSabre_Click() On Error GoTo Err_UpdateSabre_Click Dim stAppName As String Dim stMSAccess As String stAppName = "C:\SABRE\SV.EXE" stMSAccess = "C:\Program Files\Microsoft Office\Office\MSAccess.exe" Call...

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 never thought of that .... will try that tonight. Thank you very much ghnat

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