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!

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

Recent content by bosully

  1. bosully

    Transfer Text - Getting No Data

    I did a bit of work with the TransferText macro recently and when I encountered something like this, I found that Access was taking in fields from the text file which were numeric, assigning them to integer variables and then failing to load them to the tables as the fields were set as Text. It...
  2. bosully

    Can Data Environment connection be changed in code

    Yes, I've done this before. Naturally you must have some connection specified using the Data Environment interface when developing and compiling your app but you can change the connection dynamically by editing the connection string as follows - DataEnvironment1.Connection1.ConnectionString =...
  3. bosully

    HOW TO CAPTURE USER ID AND USE IT IN QURTY.

    Declare the following api call in a module - Public Declare Function getUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long - and then add a function like this - Public Function getUser() As String 'Generic function to return...
  4. bosully

    Newbie to DB, several questions

    You can get Dark Basic in stores okay. I got a boxed version with a full printed manual and tutorials, though I've seen a more recent version in a PS2 type box where manuals and tutorials are on the CD in pdf format. The docs that come with the CDs go into a good depth with explanations of all...
  5. bosully

    "Total" Field in A Query/Report

    How you format the results within Access, I don't really know but to get the answer you want you need to do an embedded Select query like this- Select MF, Store, Branch, Model, Size, [Serial Number], (Select Count(MF) from TableName TN1 Where TN1.MF = TN.MF) From TableName TN Order by MF The...
  6. bosully

    Want to automate display of OLE object from field in a table.

    I recently had to design an Access database with a chunk of functionality through VBA modules and forms. The brief I was given was that the database is for a web download and should be a single self contained file. As such, no add ins were allowed. I got everything done and as a bonus, I...
  7. bosully

    Graphics card or monitor?

    Joe, I'm no expert on graphics issues but if the problem persists when accessing DOS, I think its pointing to your monitor. As far as I'm aware, using a command line interface makes little or no calls to your graphics card unless your running DOS games or visual editors/spreadsheet programs...
  8. bosully

    "FREEZE !!"

    Is this occurring regardless of the application you open? If it's the one application again and again, try re-installing. Otherwise check for processor overheating (make sure the fan's working okay), or chip creep (just make sure your processor and memory chips, graphics and sounds cards are...
  9. bosully

    Computer will not power up properly

    I'm curious, how did the problem start to manifest itself? I have a Celeron PC (on a micro ATX) that recently gave me big trouble. Problems started with program freezes and spontaeneous reboots while running memory intensive software. This continued until the system was virtually like yours, ie...
  10. bosully

    Other Date Problem

    Access sometimes interprets dates in the American format. That means it reads #3/01/01# as March 1st and #6/07/01# as June 7th. That's why June 28th is missing. I have never really found a good foolprood way around this. I generally make my dates explicit, like #03/Jan/01#. This may work for...
  11. bosully

    Enable/Disable "AllowByPassKey"

    The "AllowByPassKey" function allows users to bypass any forms that load when your database is kicked off (by pressing the shift key as the database is loading) and get straight at your database tables. To get the function to disable this working you have to call the function in your...
  12. bosully

    password tables

    Michael, I had to do this as whoever set up the Access workgroups security where I work hadn't done such a good job. Joining the workgroups set security measures on Access in general and not just the database I wanted to protect. I didn't set the Database Password under the tools option...
  13. bosully

    password tables

    This is how I did this recently in a database. You need to create a recordset which calls all data from the Users/Passwords table, a record at a time. This ensures that each User is associated with the correct Password. Dim rs_check_users As Recordset Set rs_check_users =...
  14. bosully

    Delete messages in Access table

    Delete * from Board; This will delete all records/fields in your table. Brendan
  15. bosully

    Compare a Date/Time with current system time

    You can also try the DateDiff() function. DateDiff("h", dteDate1, Now) > 3, will return true for any value of dteDate1 which is more than three hours older than the current time. One thing to be wary of using this is that it works in whole hours and doesn't consider that more than...
See more

Part and Inventory Search

Back
Top