Search results

*SORRY I MEANT LEFT JOIN * Probably a basic thing but I cant seem to think of the right keywords to search for it! I have lookup table I use to return names for various "Sales Class" codes. It all works good but if there is a code that isn't in the lookup table it leaves that field empty. I...

I have a report that uses this query which lists the ACTIONS for each ELEMENT of each PROJECT. This works fine. I have attached an image of the query layout and its SQL is below. How can I get it to also include a row for any ELEMENTs or PROJECTS that dont have any ACTIONS associated with it...

I have a report that I want to run with various WHERE conditions. There is no problem if the user wants to print the resulting reports, it just prints one at a time and closes it. But what if the user wants to just view the reports? Can I have multiple versions of a report open in Print Preview...

I have a form that runs off a Query, it all used to work fine. Then I added some fields to the query that are based on aggregates from another query. So those are read only, but I want the other fields to still be read/write. Is that possible? It causes an error and says "Recordset Not...

This code uses the LaunchApp32 function to silently run an image manipulation program called IrfanView (freeware). A copy of this program must be available to the database. The attached database includes a form that allows you to do LOTS of cool things to images, without visibly leaving the...

Hi, How can I prevent people from including quote marks when entering data? It messes things up when I try to use that field later in an SQL statement from VBA. For example, I have a field called [Comments1] and someone enters: This is a very boring "comment". Then later I run this from VBA...

I am opening a text file, counting the number of lines, then processing it. I am sure there must be a simple way to get back to the first line after counting, but I cant find it so I just close the file and open it again... Open "M:\Mining\Unibis\oe404v3.txt" For Input As #1 'count number of...

Hi, I have seen many posts about hiding the Database Window (the one you can access all of the Tables, Queries, Forms etc right?) But is it possible to just minimize it using VBA instead? I have some more advanced users who may want to use it, while hiding it from most people. I would...

I have been trying to figure out how to get my Access frontend to connect to my SQL server backend (linked tables), without having to manually setup peoples ODBC's. I believe this can be done with a connection string but I am having great difficulty understanding it all. I have tried...

I have a QUOTES table that has a LOT of fields I have a search engine that compares the input keyword using LIKE to each field and returns any matches Is this the fastest method? (I am using an SQL Server 2005 backend) I am wondering if making a query that concatenates multiple fields and then...

I have a QUOTES table and an ITEMS table There are multiple rows in the ITEMS table for each quote linked by the QuoteDBID field. Can I write a query that will return one row for each QUOTE with a column containing only the first value for that quote. I have this, but it returns a row for each...

I have a form which is basically just a progress bar. I have the code set to run on Form_Current But my DoCmd.Close command at the end causes an error saying "this action cant be carried out while processing a form event" I can't figure out what event to put my code in so it executes as...

I have some code that counts the number of records an SQL statement returns. It works fine, I am just wondering, is the recordset being left open and eating up resources? Will it be closed when the VBA Sub ends? Or when the form is closed? [CODE]SQL = "SELECT COUNT(*) FROM QuotesQueryLimited WHERE

Hi, I have a database where a lot of the table fields contain spaces. I would like to rename them but if I do I will need to edit all the Queries, Forms, VBA and Reports that use them right? (Thats a LOT) Is there any way I can do it automatically? I heard there was a utility by Chas Dillon...

Is it feasible to use a MS Access frontend with an MS SQL Server backend over the Internet? Or would it be too slow? Thanks, Trevor.

Hi, I have a MDB (Access 2003) database frontend and backend and I want to move the backend onto our new SQL 2005 server. I know I can use the wizard in Access 2003 to do this, but would it be a better idea to use the wizard in Access 2007? Im just thinking maybe they fixed a few bugs since...

Hi, Is there any way to find out an MP3 files bitrate using vba? I am making a music database that scans my mp3 cds, and this is one bit of information I would REALLY like to be able to capture! Thanks, Trevor.

I was looking for a way to do this for a long time, and the solutions I found were not very good. Then I finally realised you could just select a folder, and return all the files in it! Hopefully someone will find this useful. Just put both these functions in a module: Public Function...

I have created an image manipulation form, so that users can very simply rotate, crop and resize photos without leaving the database. It uses the excellent free image software Irfanview, with a Shell call and command line arguments. (You put the path to the Irfanview folder at the start of the...

I have created a new function that I think might be useful to other people. I am not an experienced programmer and so would welcome any thoughts on how this could be improved to be more efficient, customisable, or usable for public release. It calculates how many office hours are between two...