User Profile

Collapse

Profile Sidebar

Collapse
d4zza
d4zza
Last Activity: Mar 14 '14, 08:45 AM
Joined: Mar 10 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • d4zza
    replied to HD Cloning/Imaging Software
    Thanks for the suggestion. If I'm looking at the right package, like others, it seems a bit complicated for what I'm wanting to do.

    Casper is the closest I've come so far with being able to copy direct from one external HD to another external HD. If only it could also create an image file.

    I'm not adverse to using more than one package though. Casper fulfills one need. Anyone have any suggestions on another package...
    See more | Go to post

    Leave a comment:


  • d4zza
    started a topic HD Cloning/Imaging Software

    HD Cloning/Imaging Software

    Hi, I'm looking for some cheap options for hard drive cloning and imaging in a business environment.

    Recently I had a scare with a PC with specific software nearly going belly up with hard drive failure. My intention to create a disaster recovery system has now been accelerated to top priority.

    I am looking for a cheap solution to carry out a few simple tasks. I intened on running the software on a dedicated desktop...
    See more | Go to post

  • d4zza
    replied to Create button to copy values over worksheets
    Actually, now that you mention it, I suppose it would be better to do it that way!

    You know that way you get so wrapped up in some things that you fail to see the obvious? That's happened here! lol

    Thanks!...
    See more | Go to post

    Leave a comment:


  • d4zza
    started a topic Create button to copy values over worksheets

    Create button to copy values over worksheets

    Hi, I'm looking to create a button which will copy values entered into particular cells in one worksheet to the next blank row on another worksheet.

    Basically, I have a finance type spreadsheet whereby I use the first worksheet (called "Invoice") to enter in income and expenditure, then calculations are done on these figures, and then I print off the worksheet in an invoice style.

    After that, I go into the...
    See more | Go to post

  • d4zza
    started a topic Hitting a file limit while transferring data

    Hitting a file limit while transferring data

    Hi,

    I have a situation I am trying to transfer data from hard drive to USB hard drive and am having an issue that relates to the amount of files per directory. System doesn't seem to like any more than (roughly) 23000 files in a single directory.

    To explain a bit more, I have a non-networked PC - Windows XP SP2 - that runs software which is constantly writing small files - which it's supposed to do - and due to this...
    See more | Go to post

  • d4zza
    started a topic How to get DISTINCT to work properly?

    How to get DISTINCT to work properly?

    I'm trying to run a query on specific archived documents (relating to networking documents) where the reference number may have more than one superseded version, but I don't want to return duplicate reference number records, I only need to see the reference number once, the version or date isn't important. I can't seem to run a query using "SELECT DISTINCT" where I'm selecting more than one field.

    This code returns all unique...
    See more | Go to post

  • d4zza
    replied to How Do I Create A Search Box?
    Hi, sorry for late reply, was trying various solutions.

    Just wanted a simple search once function, no filter. Unbound text box, txtTextToFind, on the form is used to enter a string of text to find, then user clicks a "Go" command button, and the form will find and highlight the first instance, no find next required.

    I did crack it this morning though. Based on the result with previous script, where nothing...
    See more | Go to post

    Leave a comment:


  • d4zza
    started a topic How Do I Create A Search Box?

    How Do I Create A Search Box?

    Hi folks, looking for help on what I reckon should be easy, but can't seem to find an easy solution.

    I've tried searching loads of different solutions, but none seem to be for what I'm trying to do, a simple search box.

    Using Access 97, I've created a form - frmTests - which shows, in Form view as continous forms, all records from a table relating to items being tested.

    In previous databases, I would have...
    See more | Go to post

  • d4zza
    replied to Access backend with HTA frontend
    Thanks, Mr Deej.

    That's certainly an improvement over what we currently have, and it's certainly something to consider.

    Although I've been told the central IT guys are wanting to phase out access-based databases and go with SQL/Oracle backends, so I'm wanting to get myself trained up on alternative frontends, and this HTA idea seemed to hit the spot. I can learn how to create these frontends, but (hopefully) still link...
    See more | Go to post

    Leave a comment:


  • d4zza
    started a topic Newbie question on HTA's

    Newbie question on HTA's

    Hi,

    I currently create Access 97 applications, with installing a frontend on local PC hard drives, and have the backend tables on a server. I use VBA to create functionality on the frontend interfaces.

    I'm sure I'm not alone, but I'm trying to get round the old issue of how to update the user interface with as little trouble as possible, and had seen an application with an HTA extension. After reading a bit about it,...
    See more | Go to post

  • d4zza
    replied to Access backend with HTA frontend
    Thanks Smiley, I'm not even sure if it was an HTA, it's just something that rings a bell with what I seen. I'll try looking into what it is a bit more.

    I have an opportunity to influence the way future updates are handled, so thought I would look into alternative frontends instead of locally installed MDE's and thought an interface that can be updated in a similar manner to a web page would be great.

    thanks...
    See more | Go to post

    Leave a comment:


  • d4zza
    started a topic Access backend with HTA frontend

    Access backend with HTA frontend

    I'm currently in charge of around 2 dozen Access 97-based databases in a 150+ Windows XP client environment. One of the issues I have been tasked with solving is rolling out new frontends for theses databases and I'm looking to get around the issue of deploying Access frontends for future frontend updates. As it stands, I have an MDE frontend installed on local PC's with the MDB backend on a Windows 2k3 Server, access by a network drive mapped...
    See more | Go to post

  • I gave the code a little tweak to satisfy my needs, and it works!

    I'd have preferred the BeforeUpdate event to just go straight to a module, but if it's only 1 line of code needed for each form, then that's better than the whole module being repeated for every form.

    Help, as always, is much appreciated.

    Thanks...
    See more | Go to post

    Leave a comment:


  • I'll give it a try, but I'm not sure that'll work using the Dirty property as it's not exactly a Save Record that I'm prompting the user for. The variable mstrRecordChang ed is set to true only when certain text boxes record a change (using the individual text boxes OnChange event). If the user changes any these text boxes, then they have two command buttons offering options of writing these changes to a historical sub-form and/or printing them...
    See more | Go to post

    Leave a comment:


  • The form's BeforeUpdate event is set to "=BeforeUpdateR ecord()" to call the module before updating. "Cancel" is set using a public declaration as Integer.

    The module looks like this...

    Code:
    Public Function BeforeUpdateRecord()
    
    On Error GoTo Err_BeforeUpdateRecord
    
    Set mCurrentForm = Screen.ActiveForm
        
    If mstrRecordChanged = "True" Then
    ...
    See more | Go to post

    Leave a comment:


  • d4zza
    started a topic Can't get 'Cancel' to work properly using a module

    Can't get 'Cancel' to work properly using a module

    Using Access 97 SR-2 with Windows XP.

    I have form with a BeforeUpdate event which checks a true/false condition of the record being updated. When the user moves to the next record or leaves the form and the condition is true, then a msgbox asks if the user has saved the record. If the user clicks "No", then the form cancels any movement and remains at the same record so the user can then save.

    This works...
    See more | Go to post

  • I've seen a solution being used with a batch file being initiated during startup script for domain users whereby the batch file removes an MDE front-end from the local hard drive, and copies the new MDE front-end to that location.

    I'm not too familiar with how the technique works exactly cause server stuff ain't my bag, but if you or someone you know is, then this might be a possible solution.

    I've also wondered about...
    See more | Go to post

    Leave a comment:


  • Thanks, Smiley. That works ideally!!! :)

    When I tried it first time, I missed the "me." when setting the value! yeah, silly, I know. :doh:

    thanks...
    See more | Go to post

    Leave a comment:


  • I've tried doing this, but it's not working. I do know, however, that it's because I'm not sure how to do this.

    If I call the textbox txtqryDueDate, can you provide the code to do this please, and what the SQL query would then be?

    thanks......
    See more | Go to post

    Leave a comment:


  • I'll try using the unbound text box just now and post my result.

    thanks...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...