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...

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?

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...

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.

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?

When I align text (in a text box) to the Left, it is hard up against the edge of the box. The only other options I have under properties\Text Align\ are Right, General, or center. Can I display the text any other way e.g. 2 spaces from the Left?

I have a column in a table which I would like to update by using a calculation involving other columns in the same table. For example ColumnA * ColumnB updates ColumnC. I have got the calculation I want to use by building it in a query and it works. However, I don't know how to make it update...