Recent content by Juniour

Good Morning Guys. Thank you for all your inputs, This is exactly why I wanted to discuss this. You have been a great help so far.

Thank you for your suggestions and attention. I will consider them.

attached is a brief content, I am also unable to attached the excel sheet. if this might help

Thank you so much for your reply, All of that is important I agree. I was thinking of starting with baby steps. A basic structure has been developed so far. I also have an Excel sheet of what they currently used. It comes down to personel tracking of flight and duty hours and a basic summary...

Afternoon, I was task to create a Pilot Logbook in MS access. I know there are several applications availible on the market but the requirement came in as our company systems are starting to interface with access. I know forsure this is not impossible, So my questions are - Do someone have a...

AWESOME!!!!!! Your Amaizing. Thanks!! I removed the Higlighted below to make it work. Seems like I have a lot still to learn about syntaxes. strSQL = "Update TimeLog " & _ "SET TimeEnd = #" & Format(Me!txtTime, "hh:nn:ss") & "#, " & _ "Type_Of_Duty = '" & Forms!frmTimeClock!Combo508 &...

Thank you so much for your response, I agree with you on the query statement it works better for me. Unfortunately the code was writen before me and it works without my addition. Now I want to add fields to the table. Could you assist with adding my 2 new fields to the existing code?

Good day, I know this topic has probably been discussed many times but I am struggling to find the approriate information. Could someone please show mhere I am going wrong with this Update query? Your help would be greatly appreciated.

Thanks, I will test it. You guys are awesome. Thanks for the help so far. The data base is 3.03mb when zipped

So Sorry, I have tried to Split the database. Back end is fine but Front end is still to large. Any suggestion how I can send it to you?

Thanks, See https://www.dropbox.com/transfer/AAAAAHON7PK5Z98yJau39oiBxcGdRkzh8QeEIZBiq8JVTun-zv8K2Mw In short - I am struggeling with user authorisation to access certain forms. Codes are loaded on the Login button and ADD AIRCRAFT button/FORM. Its a basic system, I am new to this and trying to...

Good day, Thanks for the help. It seems like i am missing something stupid. Can I send someone my database to assist in solving my issue, I think it will be easier than trying to explain where I am getting stuck.

It is a Text box, I am sure it wont make a difference if we make it listbox or combo box. My login coding looks as follows: Private Sub Ok_Click() If IsNull(Me.User_Login) Then MsgBox "Please enter User Login", vbInformation, "UserLogin Required" Me.User_Login.SetFocus ElseIf...

Thanks for the feedback, Could you give me an aexample to set the control on the form and how to bind it to the table field?

Hi Thanks a million. I have managed to sort the location of the tempVar. That help a lot. I am a novice to this. So my tempvar looks like this: Dim TempUserLogin As TempVars TempVars!EmployeeType = Me.User_Login.Value Itis suppose to pick up the numeric value that corrosponds to the user...