Thanks again for all the reply's,
My access database has been compiled as a MDE file. It allows me to design new queries but will not allow me to design any reports or even modify any reports. So im guessing that its locked me out, is there any way of fixing this? or will i just need to design the reports from my original MDB file and then compile it again?
DavidPT
Last Activity: Mar 12 '09, 02:06 AM
Joined: Oct 7 '08
Location: Sydney, Australia
-
Thanks for the replys,
I was able to compile it and all users can use it without a problem. Is it possible to uncompile once it has been compiled?Leave a comment:
-
Thanks for the replys this is the whole code
...Code:Private Sub Command45_Click() On Error GoTo Err_Command45_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 Exit_Command45_Click: Exit Sub Err_Command45_Click: MsgBox Err.Description Resume Exit_Command45_Click End Sub Private Sub Command45_Enter()Leave a comment:
-
Tried all of the above didnt work. If i change the code to much i think it will effect my access form.Leave a comment:
-
Just tried this still getting the same error message...Leave a comment:
-
Yeah i tried End Sub.
So what are you suggestingLeave a comment:
-
error: Expected End Sub
Hi,
Im getting this error mesage, for the below code. I have tried to add END Sub at the end but still didnt work
Any ideas?
Code:Private Sub Command45_Enter() Function updateList() 're-create query stuff Me.lstName.ControlSource = "Form_hours worked" Me.lstName.Requery End Function
-
How to compile Access database
Hi all,
I have setup a database and am trying to figure out the best way to compile it as a few people are using this database.
At the moment if someone logins to the database at the same time as someone else they are locked out of it and only given the read only version.
Whats the best way to fix this? -
Yeah thats correct. So its not needed for all sub tasksLeave a comment:
-
I have managed to fix just about everything the only thing i now need to do is setup in my form so only certain task descriptions need a sub task description.
Any help would be appreciated.
Thanks,Leave a comment:
-
Thank you very much for your help. Just a few more questions when i navigate to the next day it doesnt refresh the timesheet (frmhours) so its blank it still shows the day befores data that has been entered. Do you know how i could fix this
The last thing is will it be possible to setup the timesheet so when a different person logs in under another name they cant see what the other person has logged so its just a fresh sheet for them?...Leave a comment:
-
I have attached the database.
I would like the full name to appear in the combo box for both my logon form and Enter hours form....Leave a comment:
-
Ok i have already done this i just changed the properties for the combo box. So column count was 2 Column widths where 0cm;2.54cm and bound column 1
How do i do this so it looks like one field in my forms?
Would you like me to attach the database again so you can see where i am upto?...Leave a comment:
-
Ok thanks,
So what are the next steps i will need to take?Leave a comment:
-
Ok i have done as you asked above, bar the questions that i asked above.
will doing it this way still let me have a report (like the one i have setup in my database already) that i will be able to print out that will show me the descriptions not the values?Leave a comment:
-
Do i set the TaskID to number in the subtask table?
So in the hours worked table i am replacing subtask with subTaskID and setting that data type to number?
Can i use just one field for name so it is more user friendly (as i have now Full name) or do i need to have a full name field and last name field?...Leave a comment:
-
Its this business rule
Each TASK has many SUBTASKS
Each SUBTASK has one TASK
I have got around the error message in the form though now task is only giving me a choice of numbers in the combo box
Ok i have fixed the task combo box issue in the form now. It is only giving values in the query but as you said we can worry about that laterLeave a comment:
-
Yeah i understand and appreciate your help.
Task combo box is to describe the job in broad where sub task is more like the subject narrowing down what job was done. It was requested to be done this way (not my idea) Originally they wanted it so a sub task only needed to be chosen for certain tasks ie. HDT needs a sub task where as Project and thwe other tasks dont. But found it would be to difficult to setup this way(or i didnt have...Leave a comment:
-
Just to update line #30 now reads
Is that correct?Code:DoCmd.OpenForm "Enter Hours", , , "[EmployeeID]=" & MyEmployeeID
Leave a comment:
-
Ok i have got rid of the staff data table now and am only using the employees table. I have attached the database so you can see where im up to.
I am assuming i will need to change the VB code for the logon form...Leave a comment:
No activity results to display
Leave a comment: