Search results

Hi, hope someone can help - I have a form (Suppliers) with a button that opens another form (Product List). At the moment the form (Product List) is set as a pop-up form and when opened lists all products. I want to filter the pop-up form to only display products for the current supplier...

Hi all, I have split the database I have created via the splitter-wizard and found that all tables with auto-numbers have re-set back to 1. How do I get around this problem - I have tried running an append query but it flags up an error message. For certain functions to work in the database...

Hey if anyone is interested I found a neat way around this problem (for multiusers who have no or limited access knowledge) I just hid the Navigation pain / display pane window - that way if the user minimises or closes any form window they cannot have access to any other tables etc etc - you...

Hi thanks for this but have already tried these options -the minimise and close window is disabled but the restore icon remains showing usable. I need to disable all three to stop users from gaining access to the other forms, tables etc within the database. I know you can write coding via code...

Hi all, I know this is a common question to ask but I can't seem to find a solution. I need to disable or hide the restore, minimise and close window buttons found in the top right hand corner of a form. I navigation buttons that controls open, close etc already set up. Can anyone give...

Hi thanks for the tip - have solved the problem so thank you for taking time out to help. Pauline :-)

Hi Paul, no the login form closes when the user logs in - the coding is: Private Sub Exitcmd_Click() On Error GoTo Err_Exitcmd_Click DoCmd.Close Exit_Exitcmd_Click: Exit Sub Err_Exitcmd_Click: MsgBox Err.Description Resume Exit_Exitcmd_Click End Sub Can you help me...

Hi, hope someone can help - I am trying to restrict access to users to prevent Level 1 users from gaining access to all the workings eg tables, queries and forms. I have a security table and a login form which brings each user to a specified switchboard showing command buttons to specific...

Your a champion in my eyes for all your help. Its nice to know a meaning behind the name - take care and you never know we may speak again :-):)

Hi Rain, just wanted to thank you for your help - managed to solve my problem and it works just fine :-)

PS is your name really Rain :) Im naff at psuedo-names hence Pauline123 lol

Hi that would be useful especially the user manual though seemed pretty easy to pick up from the quick look i had this afternoon. And wow 3.30 am you must be dedicated lol I can barely make it past 11 pm now-a-days :D I would not worry too much about security - I work for a painting...

Hi Rain, thanks for the database - this will certainly give me a lot to think about so will have a good mooch and see what I come up with. If I have any questions about what you have done I will get in touch. Pauline :)

Hi Rainlover, a copy of the database would be good. My database is for internal use for a Stores department so it only needs to be basic. My main problem is ensuring that items are not double-booked out when making the selection on the combobox list. If I can resolve this problem then I will...

Hi Rainlover, sorry have not dismissed your ideas just didn't know how to go about restructuring my tables but as it seems I am not going in the right direction maybe you could give me a few more pointers. I have read your comment again and believe I would have to create a Status table...

Hi, thanks for all your ideas and it has gotten me thinking - wondering if the default value for a plant item is a date, then run a query taking into account the stock date, issue date and return date to show a value, then set the criteria to filter out the -2 result in the "Current" field...

Hi, thanks for the code, works great - now just need to figure how to limit the list in the combo box - any ideas ! Pauline

Hi, I cant figure out how to write it - my thinking was: IIf(IsNull([ReturnDate],[Hired],True) but i keep getting an invalid syntax error - tried a couple of variations to no avail. I am relatively new to all this so would appreciate your help. Pauline :)

Hi all, many thanks for your comments and sorry I was not clear enough. The Hired Plant database is for equipment like ladders which are issued on a rental basis to customers. I want to limit the combo box "PlantIDcbo" to only list items not Hired Out. I would like to do this using the...

Hi, I am working on a hired plant database and want to limit the combo box on the hired form to only list items not on hire. I thought I could do this using the IssueDate and ReturnDate fields within a query with an IIf statement forcing the Yes/No field to choose Yes when there is a date in...