I am an expert user of Access but very green when it comes to code. I have a problem with a canteen databse I am designing. In short, each employee is listed in tblEmployees - they have a field (among others) for Username and Lunch Password and Visitor Allowed (some employees are allowed to order lunch for guests on the company account - I have made this a yes/no data type). I have created a parameter query as the source for the lunch order from so it that triggers the employee to enter their username and password. The subform contains the lunch order fields from tblLunchOrders. The problem is that - when this form is accessed from the switchboard - I need it to do 2 things...
Check that they have entered a password that is on the list - If not it should bring up a message and not open the form. I tried adding this code to the main forms "On Load" property...
Private Sub Form_Load() If IsNull(Lunch_Password) Then MsgBox ("Incorrect User Name or Password. Please try again.") On Error GoTo Err_Command67_Click DoCmd.Close Exit_Command67_Click: Exit Sub Err_Command67_Click: MsgBox Err.Description Resume Exit_Command67_Click End If End Sub
If the password is correct they might still not be authorised to order lunch for a guest so after checking the password it needs to check and see if the 'Visitor Allowed' field is switched on - if it is... it must open the form... if not it must bring up a msg and not open the form. I tried adding the following code in conjunction with the above on the main form (it didn't work) so I tried adding the code to the "On Load" property of the subform...
Private Sub Form_Load() If Visitor_Allowed = 0 Then MsgBox ("You are not authorised to order lunch for a visitor. Please contact accounts if you have any queries.") End If End Sub
Any suggestions. This database needs to go live tomorrow morning! It's now 8:30pm in SA. I am desperate and feeling very blonde and out of my depth. Would really appreciate the correct code. Many thank for reading this. Sharon King.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
back up files on external hard drive!! mirror hard drive, will keep corrupted file, it might cause further problems. you have lost some critical files, but you might have isolated a virus . Move on, do a clean install, after reload the backed up files one at a time.
Even if you manage to rebuild your database, you can't import the data into the windows outlook. Although both versions look the same, they use different database structures. just renaming the data file, only will destroy it, when you try to open it.
just Google for outlook data structure 2010 2011 and read what wikipedia has to say on this.
It will take an expert, to help you with this.
Launch Microsoft Database Utility. Type Database in Spotlight(Magnifying Glass in upeer right hand of screen) then choose Microsoft Databse utility. CLick main identity then Tick Rebuild Database. You need to quit all Microsoft Office Mac Applciations also before opening Databse utility. After rebuilding, click done and then quit databse utility. Then open Entourage. Hope this helps!
If you want to get rid of spy-ware, I would suggest downloading Spybot and Ad-Aware. Install these, update them and then scan your PC and remove anything they find. These tend to work much better than software you can purchase. Experts use both of these.
The newer versions (latest) of MS Office (Word, Excel, Access, PowerPoint, etc) were designed to interact with one another. You can pull a file from MS Word, and place it in Excel, PowerPoint, etc and Vise Versa.
Please let me know if you need further assistance.
Try the help built into Excel and give yourself time to absorb it; Excel has some of the best help in the business. VBA may be more complex than you need to solve a data entry problem. If you're trying to add data input masks in a database, why don't you try Access (the help for which is admittedly weaker because database programming is among the most complex of all productivity apps)? I learned VBA from 3 books I rented from a good public library over the course of a project that was about a month long, (because) at some point Microsoft abandoned the idea of teaching it via help screens. Still, you might join a MS developer site and those are loaded with detailed explanations and many other experts. I hope this helps... I feel your pain.
open the form in design view open the properties dialog box by right clicking in the general form area not in the gray area of the detail section. In the properties click on the format tab. In the format tab goto the default view and select continuous form. This should create a virtical scroll bar once a record in the data base.
Thats a lot of form work to be expecting out of Excel. You might be better off using Access, creating a table. If you need to export it back to a spreadsheet you can. The validation controls are better in Access and don't have a lot of limitations to them.
before this u should know what is databse.
ms access has various objects likw table,form,query,report etc..
table is a object which stores the actual data and form is used to enter the data in to the table and display the data from the table, while report is object which is used to desplay your data in required formate.Query is used to fetch the data from the table in customised formate.for that u should have knowledge of SQL.