Recent content by bosully

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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