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 strongm 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: *

  1. dynamictiger

    Upgrade advice

    I have a Dell Optiplex GX250, it has been a very stable platform. I bought this machine after destroying two previous machines with my requirements. One Gateway and one made by a local PC Shop. Most of the time the machine is used for Access development, however, over the years the needs have...
  2. dynamictiger

    Whoops ... How do I fix this?

    Thank you for the suggestion, however, once in safe mode what should I do then.
  3. dynamictiger

    Exit Routine from Sub Routine

    The approach that I would use is something like: Main Routine Dim blnDone as Boolean Call SubRoutine(blnDone) If blnDone then Exit Else Do Something End if Exit here This should acheive what you are looking for. HTH
  4. dynamictiger

    Whoops ... How do I fix this?

    I was playing around with my birthday present my wife gave me, it sends the signal from my video card to my TV, and I made a stuff up. I couldn't get the picture on the TV and fiddled around in the advanced settings. It seems I have overlayed the desktop with the secondary monitor desktop...
  5. dynamictiger

    Hard Drive Fingerprint

    I am not sure where to post this, as this is nt my area at all. A software application I have requires a hard drive fingerprint to validate the software. However, on my desktop machine the hard drive fingerprint is returning nothing. Why?
  6. dynamictiger

    A bit of a Quandry

    Thank you all for your advice. I cna now go to my store with a bit more knowledge than before. I use this machine for testing software, hence my requirement for various os.
  7. dynamictiger

    A bit of a Quandry

    I am not a hardware person, I only understand hardware from what I read in the magazines and can recognise a hard drive and RAM stick and so on on site. But that is as far as my interest goes. So generally I wander down to my computer store when things go bang, kaboom, or just aren't right in...
  8. dynamictiger

    Listbox Format

    I am using a list box to return contact details. Is it possible to have the listbox format each line to the appropriate mask for each number?
  9. dynamictiger

    Not Sure how

    I have a module building controls on a form. One of these controls has a control source of: =dpsStar([controlName]) I have the controlname currently as a string. How do I handle the change to populate the controlsource?
  10. dynamictiger

    Is this even possible with Image

    I have set up a class for scanning, it uses an invisible image to grab the scanner returned result. Part of the functionality I am trying to enable is to acquire the image without saving. This means I end up with code something like: ctl=Forms("frmInvisible").imgScan Whish VBA...
  11. dynamictiger

    Replace Function for Global Table Changes

    Create a recordset the way you want to ADO or DAO. Loop through the recordset in the field you want to alter. Use Replace as follows: Do until .eof .fields("myField")=Replace(.fields("myField"),"ABC","XYZ") .MoveNext Loop Should do it. I haven't...
  12. dynamictiger

    Problems with PostCode Inpuit Mask?

    You don't have to show your client a complex user interface. With a bit of imagination you can mask it and deal with the complexity in your code.
  13. dynamictiger

    Security Coding

    I have the following code in my application. The second set of functions dpsOkNew, and NoNew according to microsoft enable me to grant full permissions on the table for the duration of dpsUpdateTable. However, every time dpsUpdateTable runs I am getting a message that I do not have permission...
  14. dynamictiger

    Security Headspin

    I have been playing around with the security settings on a database getting it ready to dispatch. I've not needed security before so it is a bit of a headspin, and I am getting myself in bother. Initially I could not get any users to log in. I seem to have that sorted, but now I have secured...
  15. dynamictiger

    Subform Not In List Event

    I have made a form to handle not in list events. It works fantastic until I hit a subform. The procedure works by setting properties in the calling form for the the recordsource of the combobox and the field we are trying to add new data too. The newdata and the formname are passed as...
  16. dynamictiger

    Partition Query - Driving me nuts

    I am attempting to use a partition query to produce an aged equipment report. I set up a mock up attached that explains the problem better. I can get the query to function fine, but suspect there may be instances where the columns may be omitted due to no values returned. I would like to fix...
  17. dynamictiger

    Screen Sizes

    I have made an application and tested it fine on a target PC I own. I was just about to issue it and thought about the screen size. If my forms look fine on a 17inch at 800 by 600 will a 15 inch running at 800 by 600 look the same or will the forms be resized to the smaller screen? My forms...
  18. dynamictiger

    Play AVI from module

    I would like to create a custom menu to play avi files using whichever player is resident in the operating system of the client machine. Anyone know how to approach this?
  19. dynamictiger

    Keeping Form Fields Locked after exiting

    You need to tell Access in the Current event of the form what you want it to do. Try moving the code to the current event of the form, and give it some instructions like: If me.dataentry then Do something Else Do another thing End if
  20. dynamictiger

    Assign a Offline Recordset to SubForm

    myRS.AddNew myRS.Fields("CITY").Value = "Berlin" myRS.Fields("CITY").Value = "Frankfurt" myRS.update I do not know if this will fix your problem but it is required

Part and Inventory Search

Back
Top