Recent content by jaf893

For users to access Access over a network is it just a case of: Storing the .mdb file on some shared network space and giving everyone usernames and passwords?

There are going to be a lot of calculations so I will use a query :) Does Access see the ouput of a query as being pretty much the same as a table? The reasons I ask is that for a lot of things such as reports it asks you to select a Table or a query.

In terms of calculations, searching etc are there anythings that you can do to a query that you can't do to a look up table?

Is it possible to insert a powerpoint presentation into an Access database and get it to play? I can insert a powerpoint presentation into a Report but it just displays the first slide :confused: TIA Joe

I have downloaded your browsing database but I keep getting an error whenever I click import I get: 2391 - Field 'F1' doesn't exist in destination table 'tImport.'

I am trying to speed up the process of importing text. So far I have written a sendkeys macro which loads up the import file page. Is it possible to write a macro that loads up the import file page, waits for the user to select a file and then sends some more keys? Thanks in advance, JAF893

Thanks mate I've got it sorted now. Whilst trying to sort it out I realised you don't even need to go into Design View. If you load up the form and then right click in the left hand margin you can change "Record Selectors" to No from there.

I need a book to teach myself VBA. I am a complete beginner but ideally I am looking for a book which will take me from beginner to advanced level. Does anyone have any suggestions?

Please see the attached Image. How do I remove the margin down the left hand side of my forms? JAF jaf893@gmail.com

I have "solved" the problem :) I use GNU AWK to merge all of the text files together. I then imported them as one big text file and used the table analyser to separate the data into seperate tables. Thanks again for all your help.

This may sound stupid and obvious but have you tried sending the error report? If it comes back with a dialog box with a more information link then there is a good chance there might be a fix available.

That didn't work because they are stored in seperate text files. The massive table looks a bit like this now # # # # # # # # # * * * * * * * * * * * * * * * * * * * * * * * * * * * * * The # are the field titles. The * is the data. the left hand * are from the results and the right...

I have created a query but I can't work out how to import text into it.:confused: JAF jaf893@gmail.com

I have a database with the following one to many mappings: Prototype => Device => Test Conditions => Test Results When I input data manually the database works fine and each set of results is associated with a set of test conditions which is in turn asssociated with a device etc. However, all...

Thanks for all your help. I've just got one more question I've been talking to my supervisor and he is keen for me to seperate the test conditions out into a heirarchical structure made of three tables. It makes sense because it will mean that the same data won't need to be typed in several...