Recent content by Oscar

I have a table in Access with defined field types eg SampleID = text. I've designed a macro using transfer text to import a csv into this table. I'm having trouble with type mismatch as it seems the macro is looking at the first ? values in the csv and deciding what field type it is??? As the...

This is very similar to a question asked a few days ago. My VB is very poor and would like a step-by-step account on how to make a query use selected criteria from two listboxes on a form (the listboxes are not multiselect). Your help would be much appreciated.

I have a photo database where I go and link jpg files to a table in this database, then view them in a form with other details. The database is getting big in size very quickly. I have reduced the size of the photos but it doesn't seem to make any difference. I also periodically reduce and...

I have a stack of open queries in a macro. At the moment all the queries open up even if they have no results. Is it possilbe to have as part of the macro, to close that query if no results. Your help would be much appreciated.

Hi, I have got some notes from Access Security FAQ with steps on how to protect a database. I have created a new Workgroup file, log in as Admin and added a password for this user. I then created a new user called DBA and added it to the Admins group. The next step says to quit out of Access and...

No need for help, just found the SendObject command and works a treat.

I would like to create a cmd button on a form which opens the email program (can get this far with OpenApplication macro). But would like to have a certain email address already selected, and a database attached. So that people only need to push send! Can all or part of this be done?

Wonderful, just what I was wanting. The Ezy Documenter is great, you have saved me a lot of time and grief. Thanks

Thanks heaps, works a gem.

That works fine if the info I'm trying to concatenate was along one line for the hole ID. However, this is not the case and is what is causing me dramas. I have a Hole WSGC1010 which has several From Depths down a table eg Hole ID, From_Depth WSGC1010, 2 WSGC1010, 10 WSGC1010, 11 and I want...

Was wondering if there is an easy way to generate a list of all forms & reports in my database with their associated queries and subreports/forms they may use. I have seen the Documenter but this gives me all details, which I don't require. Your help would be much appreciated.

I have a table which is grouped by hole ID and has target From Depths along with other information. I would like to report by Hole ID the from depths in a concatenated view. Can I do this, and if so how? eg Hole ID Target From Other Info...... WSGC11 2...

Because one table stores from - to depths of Mineral Gold occurence and all the data relating to that eg size of gold etc.., the other table stores samples from - to depths with assay results, methods etc... I need the Mineral Gold from - to depth to be the same as a sample interval so we can...

I have tried to do this using several queries, but can't get it to work and is very messy. I think it would be easier to do this in VB code but don't know where to start. I have two columns "from depth" and "to depth" in two different tables. These tables are linked by HoleID. I want to find...

I would like to start writing VB code and need some help. Can any one suggest good books for beginners - intermediate knowledge. I live in Australia, so ideally I need to be able to buy it over here.