Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: afryer
  • Content: Threads
  • Order by date
  1. afryer

    British Summer Time in Microsoft CRM

    Hi All, I have a problem with Microsoft CRM that seems to be a common problem, but also one that I can't find an answer to. Basically since British Summer time start CRM is taking an hour off dates entered into the system, for example: 29/04/2008:00:00:00 would be become 28/04/2008:23:00:00...
  2. afryer

    VB6.0 Data Grid, odd behaviour in Change event

    Hi All, I have come across a problem today that is really bugging me and hope someone here can help. Basically what is happening is the following: 1) I have a data item which reads in data from table in the database called RECURRING_FREQUENCIES, which contains two fields...
  3. afryer

    Inet control FTP problems

    Hi All, I am developing a VB application, which uses the Inet control to perform FTP operations. The website I am trying to connect to is Oracle FTP site, but the only type of user name you can create is in an email format and this cannot changed. This means that my FTP login string looks...
  4. afryer

    100% of CPU usage in infinite loop

    Hi All, I have written an application in VB, which runs a constant timer to keep track of various events. Basically what happens is when the application is started a function is called from the Form_Initialize event to start the timer. The timer is in an infinite loop of the following format...
  5. afryer

    Selecting a full row in a datagrid

    Hi All, I have in my application a datagrid, which is linked to a data environment. What I need to be able to do is when the OnClick () event is called on the data grid I need to select the entire row. Is there anyway I can do this? Thanks in advance Andrew
  6. afryer

    DataEnvironments and DataGrid/Combo Controls in VB6

    Hi All, I am developing an application using VB6 and as part of this I have created a new DataEnvironment, which connects to my backend database. I have created three commands within the connection, which are as follows: cmd_profile - linked to a DataCombo box on the main form and displays...
  7. afryer

    Getting the difference between two dates in VB6

    Hi All, I am working on an application, which uses a timer consisting of the year, month, day, hour, minute and second fields. I need to be able to find the exact difference between the two dates (one of the dates is based on the current system date and the other is inputted by the user, but...
  8. afryer

    Missing drives in Windows Explorer

    Hi all, I have a strange problem with my works laptop at the moment, which someone hopefully might be able to help with. Basically when I load Windows Explorer it displays only the desktop, it doesn't show any of the other drives I have - including C:, D:, The CD-ROM or any networked drives...
  9. afryer

    Creating a new database in Microsoft Access VBA

    Hi All, I am running an application in Microsoft Access and within that I need to create a new database. I have managed to do this, using the CreateDatabase method, but I also need to do the following. If anyone could help with this then I would appreciate it: - I need to create a new Module...
  10. afryer

    Returning Workgroup name in Access

    Hi All, I am running an application, which uses a command line to connect to a user-defined workgroup file. I need to check at startup to make sure they have connected using the command line and not simply double-click on the application name. Does anyone know of a way (in VBA) to return the...
  11. afryer

    Securing Access Databases part 2!

    Hi All, I have posted a couple of questions recently regarding securing my access database and have managed to get part of the way, but I have come accross one last problem that someone might be able to help me with. I am using a bespoke workgroup file to connect to the database, using a...
  12. afryer

    Securing Access databases

    Hi all, I am working on a Microsoft Access database that I need to secure using a user-defined MDW file. When I connect the database to this file it also applies the security to all of the databases, which is not what I want - does anyone have any ideas how this could be done, so that only...
  13. afryer

    Determining Access group membership through VBA

    Hi All, This is a follow on from a question I asked previously regarding Workgroup security in Access. Basically what I need to do is the following: - I have an application, which connects to a user-defined workgroup file containing a list of live login IDs. - I have managed to change the...
  14. afryer

    Controlling Access MDW through VBA

    Hi All, I am working on a Microsoft Access 2003 application that connects to a user defined Workgroup file. Are there any API calls I can use to perform password changes on this file whilst the application is running? Thanks Andrew
  15. afryer

    Disabling keyboard shortcuts in IE

    Hi All, I am working on a locked down version of Internet Explorer 6.0 on Windows XP. I have reoved all menus, address bar, toolbars etc to try and prevent the users gaining access to the internal workings of IE. I have been unable to remove the keyboard shortcuts however (CTRL+H for History...
  16. afryer

    Converting a string to a date

    Hi all, I have a string value read in from a file, which I need to either store in a date variable or convert to a date. The string read in is in the format YYYYMMDDHHMMSS, i.e 20060509140900 would be today at 14:09. I have tried using the format function to convert this, i.e myDateVar =...
  17. afryer

    Mapping a drive programmatically in VB

    Hi all, This is related to a previous query I had regarding embedding DOS sessions in a form, which I have realise I am probably not going to be able to do. What I need to do is the following: - Attempt to map a drive to a remote machine (I know the user name and password) - Determine whether...
  18. afryer

    Displaying a DOS box in VB Forms

    Hi All, Does anyone know a control that mimics the DOS box (displayed by entering CMD). I am looking, ideally for control over this so that I can send commands and parse the output from these commands (even using something as simple as myDosBox.Text). Any advice would be welcome. Andrew
  19. afryer

    Trapping the close button message in VB

    Hi All, Does anyone know how to trap the close button message when the user clicks the close button at the top right of the dialog? Thanks Andrew
  20. afryer

    Populating multi column list boxes in VB

    Hi All, This is going to sound like a really stupid question, but I can't find the answer on here or on the Microsoft site... Basically I have a multi-column list box, which needs to be populated from a file read in a loop. I can populate the first column fine, but how do I populate the other...

Part and Inventory Search

Back
Top