Search results

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.

Thanks Thanks heaps, works a treat. Would love to know how that calculation works ie Value = Fix..... Would never have figured this out on my own.

I wish to find data which does not equal (eg From_Depth in two different tables), and am using the criteria From_Depth from table 1 <> From_Depth from table2. This is working partly as is giving me the data which is True for this criteria, however I am also getting some data which do have equal...

No doubt this is simple! I have numbers in my database which have a large number of decimal places and I would like to change these to two decimal places, with rounding. I figured out how to just chop the numbers off but cant get it to round. I found a mathematical function in a book, CEIL(X)...

When I create command buttons on a form (using the wizard) eg Close Form, I can go and see the code the button uses by going into the Class Module. I would like to do the same with some macros I have created so that I can learn the VB code. How do I view the code for my macros?

Have had a look and cant find the LeftMargin property, there is only the "text align". There is a field called "Left" but all this does is move the box, not the text within the box. Is this LeftMargin property possibly a feature of a newer version of access as I am only using '97'.