Search results

Hi I am writing an application which uses random acces files I can write my records to a DAT file, howver sometimes when I try and view the file in notepad (to verify that the record is being saved properly) I cant see the actual data that I entered, I can only see some control characters Any...

The data is a collection of strings (all fixed length), boolean, integer and date types The file type is a DAT type I am using PUT to write to the file and GET to read from it Thanks

I am trying to write records to a random access file All string fields in the record are of fixed length From time to time I get an error "bad record length runtime error 59" These appear to occur at random, I fix some od the code and they dissapear only to appear next time I try to use the...

Help wanted I need to build a DB with numersous forms in it Several of these form ask for alphabetic data only to be input (letters only) I can write, using keypress methods, validation routines for these text boxes individually. However, is there a way of writing a public function in a...

I am trying to build a database for a friend who teaches musical lessons in the evening. I have set up a trial database in order to work out a solution In a table called tblcustomer I am storing a customerID as a key field, as well as name, phone etc In a table called tbllesson I am storing...

I'm reading data into a 2D array and want to output the data to a form in tabular format. What i'd like to do, I think, is to use a listbox and to output each row in turn I can do this by concatanating all the elements in that row together, but I'm wondering if there is an easier way, using...

Hello, I have a table of pupils names and a form to view the data. What I want is a command button which would accept a surname to search for and then find the matches of that surname I guess a start would be to find the firstmatch so I tried the following code Private Sub...

How do I surrpress the default validation error message that occurs with a date field? I want to have my own msgbox triggerred by a isdate function, however I dont want the standard error box

normalisation Tried your suggestion and it works, however I have a question about normalisation If every team picked for a game has 5 players and 5 players only then how is it that the strucutre for table team teamid, player1id, player2id, player3id, player4id, player5id is not a suitable...

no luck Just tried this - doesnt work I have 6 fields in my team table teamid as a key field and then 5 fields called p1,p2,p3,p4 and p5 which each store the playerID of the selected player - essentially i want to prevent the playerID in p1 from popping up in the dropdown list of p2 through...

I am constructing a small sports club db I have a player table which includes playerID as the primary key I also have a team table which has a teamID field as the primary key and stores the 5 playerID numbers of the selected 5 players. I have used the lookup wizard in my team table to look...

I am building a database for my football club. I have a table containing players details and each palyer has an ID number as a key field. I also have a team table which stores the 11 players selected for each match. At the minute it is possible to select the same player many times in the same...