Search results for query: *

Hi, I have an access database that has 1 table. In this table it has 4 fields. Student Id, Student Forename, Student Surname, Photopath. It has 200 records. Below is example of one: 01234 Richard Williams R:\photodir\p0008345.jpg When I look at the data in crystal I see the path of the...

I recently bought an ECS K7S5A v3 motherboard and have had endless problems with it which I won't bore you with. The current problem I have is that when I switch the power on, I do not get anything on the monitor - it switches off. I have narrowed the problem down to the network card and/or...

I'm trying to write code for my database to control the database and recordsets in Access, but when I try to use the line: Dim dbs as Database Access doesn't recognise the word "Database". The list that appears as you enter a datatype doesn't mention Database, DAO, tabledef or...

I am currently going through all of my Crystal Reports, printing out the formulae used. I know you can export the report as a Report Definition file, and this is what I've been using so far. Is there a way to simply output the list of formulae in a report or is the Report Definition the only...

I have an unbound checkbox on an Access form and I want to set it's default value to FALSE. In the past, I have been using Access 97 and it's accepted: CheckboxName.Value = False Now, I am using Access XP and trying the same thing gives me the RTE '2448' message: "You can't assign a...

I'm attempting to add some items to a tree list and it's ****ing complicated and frustrating, so I would be extremely grateful for some assistance! :) I am attempting to write a new Script Editor utility for the game Operation Flashpoint, and I am using the treeview control to hold the Weapons...

Hi. I'm writing a VBA program to assist in writing Crystal Report Formulae. Basically, I want to avoid writing the same piece of code several times when all that is needed is to substitute a different field or value. An example of this is working out the number of students enrolled on the...

Hi In the latest update to my on-going database project, I wish to write a log-file when the user performs certain actions (e.g. importing trainee data, printing reports). Writing the log-file is easy enough, and the code is already in place. What I want to do now is when the user runs a...

Hi I just bought an ABIT KT7A motherboard this morning and, while everything else seems to work fine, it refuses to detect any device attatched to IDE2. I've tried connecting my DVD Drive and second Hard drive to it, using different cables, but the BIOS doesn't detect anything and neither does...

Hi A colleague of mine in work today asked me if there was a way of outputting the filenames of all files a specified folder to a text file so that she could copy and paste the filenames into the document she was writing, rather than have to type the names out (there are quite a lot of them!)...

I've got the following piece of code: --- With Application.FileSearch .NewSearch .SearchSubFolders = True .MatchTextExactly = True .FileName = "data.mdb" If .Execute() > 0 Then For i = 1 To .FoundFiles.Count...

I just bought a 4D optical mouse for my mum's computer because she's constantly moaning that the mouse that she's currently got "is sh*t". The core of the computer is about 4 years old (we bought it way back in 1997). The motherboard is a Pentium P51430TX Titanium 1B motherboard with...

One of the functions of the database I'm writing is to create a backup of the data (in a file 'data.mdb'), then use the command line parameters in Winzip to compress the file. As I'm still using the unregistered version of Winzip (naughty me!) I'm using a piece of code by Terry Kreft to pause...

Hi I have a file of CSV data which I want to import into an Access table. The table contains the following fields for each trainee record: NI number, Surname, Forenames, Employer, TLO*, Date Finished, Day Count. *TLO = Trainee Liaison Officer The Date Finished is the date that the trainee...

Hi Since Access 97 doesn't seem to allow use of the File Open Dialog box, I am trying to write my own crude version. Basically, I want to display a list of drives, then when a drive is clicked, to display the files and folders within that drive, and in each subsequently clicked-on folder...

Is there a way to pause program execution in Access VB while an external application is running? I have written a piece of code to copy a database file to a location, compress it with Winzip, then delete the copy of the mdb file. Since program execution does not stop when Winzip is running in...

As part of added functionality to my database, I have a backup facility from the menu which currently copies the database to a separate location. I have added the code to compress the copy into a Winzip file, but I'm having a little difficulty. I have a line to run Winzip (using the Shell...

For the database I'm writing, I have got a CSV file from another database full of trainee names which I want to import into an Access database. The import side of things is fine - I know how to do that, but the problem I'm having is that the column headers in the text field are labelled...

I have an Excel worksheet ("RLD") containing a combobox which I want to populate with a range of values in a second worksheet ("DATA"). I have the code to do this, as follows: RLD.lstSubject.Clear For i = 2 To c - 1 RLD.lstSubject.AddItem...

How do I use File Dialog Boxes in Excel through VBA? I have a command button on a worksheet that, when clicked, I want to display a File Open dialog box, get the filename and load the (Excel) file. How can I do this? Thanks