Recent content by chris01252

Thanks Pat, yes it is m-m. Each supplier could possibly deliver to 100+ different locations. I have managed to put together the basic relationship. My next query on this is, is it possible to have a form with the supplier at the top and ALL the locations with check boxes below, the locations...

I am putting together a supplier and product database and have a slight problem. We have a large number different delivery locations and each of our suppliers deliver to a different combination of locations. I want to record where each supplier delivers. I have an idea of how how this could...

I currently have a database that is missing various pieces of information, we are getting a temp in to complete this. I don't want the temp adding data directly into Access so I have exported the table that needs updating into Excel. How can I then import the new data without altering current...

Thanks guys, that has solved part of it as I can place the form outside of the main access window. But when I select another program window that I am working on i.e. Excel it disappears to the back. I want it to be visible all the time regarless of which program or window I am working on.

Not sure if this is possible. So any help would be welcomed. What I want to do is have a small form sitting in the corner of my window that you can see all the time regardless of what I am doing in other windows (like the function in Winzip, to keep it on top). So I can just click on it...

I have a report that that when run, a 'Enter Parameter Value' box pops up for Total. I am 100% sure there is no tags in the report, i.e [Total] which would genrate this as I have been through it meticulously. When I run the query the report uses separetely it gives me the data I need without...

I am such a numpty!!!! found the other file (it was hidden) Cheers John

For some unknown reason I am unable to open the back end of my database, as far as I can see it has not effected people adding data through the front end, I just can't open the back end. I checked the file format and it has changed to a LDB file, no idea what this is or why it has changed, any...

For some unknown reason I am unable to open the back end of my database, as far as I can see it has not effected people adding data through the front end, I just can't open the back end. I checked the file format and it has changed to a LDB file, no idea what this is or why it has changed, any...

For some unknown reason I am unable to open the back end of my database, as far as I can see it has not effected people adding data through the front end, I just can't open the back end. I checked the file format and it has changed to a LDB file, no idea what this is or why it has changed, any...

I have a form where a user reviews information input by another user, once they have done this they sign it off by selecting their name from a drop down list. On this form there is a scrolling message which tells the user how many un-signed entries there are. This works fine until there are 0...

because I only want the back end to be password protected I am pretty sure the only way to do this is password it after splitting then the tables need to be re-connected. This will allow users to enter information via forms etc but not be able to open any tables directly.

I have recently split my database and added a password to the back end. I am now trying to re-link the tables as I have seen in other threads, but when I do this I am not prompted for the password I just get the message 'Not a valid password' I must obviously be doing something wrong, can...

cheers mate got it working now, I seem to have a bad habit of making things far too complicated than they have to be.

I have a standard Select query with various fields, three of which are: - Quantity Ordered (number) - Quantity Delivered (number) - Short Delivery (checkbox) Basically I want the check box to be checked if the qty ordered value is greater than the qty delivered. I have this code in the...