Search results

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

I have a query linked to some combo/txt boxes on a form so the user defines which categories he/she is looking for then presses button and query comes up with relevant results. This works fine if the user inputs information that is actually there, but if they leave it blank it goes all wrong...

cheers Golfer that works! Is there a more secure way of doing this, could I put a password on it so if user does not enter password they can only enter data rather than being able to muck up the form designs etc.

this does not seem to do anything

Thought I best ask this question BEFORE I run into trouble. If I were to set my database to hide the database window and all menus on startup so that users can only do what I want them to do and not edit anything. How do I go about reversing this if I needed to edit something as I would not be...

cheers moniker, that has done the trick!