Search results

Hi Richard, thank you for the replying. I'm sorry for not being clear, but "reports" are just the name of documents (not the access reports). I just want to list the fields of my table in a list box (which is easy) - However, one of the fields is a hyperlink so how do I make that clickable in...

Hi guys, I have searched this forum, google and other access help but can't find a solution to this seemingly easy problem I have a simple table with the following fields: tbl Report: Repord Id NmeReport LocationReport - I added a hyperlink here and set it's field to "Hyperlink" What...

Yeah but who cares about the aesthetics! Plus, I can actually find out how you did this magic and then try to customize it a bit. thankyou sir!

wow! i cannot thank you enough!! I am going to play with this and try to learn as much as I can! Again, thank you so much! You are amazing!

Hi jzwp22, I am uploading the normalized database. How would I use this database to populate text boxes for each activity? What I would want to do is: have activities name fixed on the form - User can then select Available or Actioned from combo boxes (maybe) and have "Your Value" text boxe...

thank you for your insight! I will normalize my table and play around with append queries to see what I come up with. would it okay if I ask questions about this later when I'm done normalizing? thankyou so much!

they just have to see some numbers and type it in the database (simple entry) - the trick is to make the activities available with text boxes so they just enter - and data is recorded under their name for a particular date. For example: John, day time employee, logs in on 11th Augusut and...

No. Each user is responsible for entering their own activities. they might be part of "Day time employees", but when they log in, they enter their information only and it is independent of other users information.

there are sets of users for example: day employees, night employees, afternoon employees! the list of activities for each one of them is fixed - ( i guess I can put them in a multiple tab sheet). the database is for the users to enter the numbers they saw that were available and how many...

Yeah i know! i have been trying to tell this to my manager but he thinks it's not going to affect much. Here is the another version of application which has combo boxes - the thing is manager wants to make this extremely easy for the users (including not using combo boxes to select activity)...

tblEmployees is the main form. frmtable2 is the subform!

the thing is: My manager does not want to use combo box to select an employee. He wants it to be extracted from windows Id (which I have working thanks to your help before). What I want is to show the user their employee Id, their name - in the subform they select a date - If records exist...

I have posted the database - I will work on your suggestion and will report to youu!! Employee table is added in the query because I needed something to link the main form to the subform -

Hi, thanks for taking out time to reply. I really appreciate it! and date combo should be on the subform.

Hi, I have a subform with many text boxes - these text boxes are supposed to show the different fields in the original table. What I want to do is - let the user select a date from a combo box, and as the user selects a particular date, the text boxes are all populated. Also, the user should...

Hi, I have a subform with many text boxes - these text boxes are supposed to show the different fields in the original table. What I want to do is - let the user select a date from a combo box, and as the user selects a particular date, the text boxes are all populated. Also, the user should...

I have used the Now() function in the date to get todays date - I will look into the link and see what I can comprehend, thanks!! and i know my table is not normalized - i tried normalizing it but ended up getting more confused :/

Hi, I have this form which shows the different fields from a table. User enters values in the fields and it gets saved in the original table. What i want to do is - when the user selects a particular date, the form shows the values that were entered on that day, and changes can be made to...

oh i figured what i was doing wrong.. I was changing default view by going through the main form .. It works when I access the main form via the subform - if that makes any sense.. appreciate the patience!

I cannot open it directly. I can open it through the main form. Using Access 2007 - And I changed the property to "Single form", but still nothing works. Is it possible for you to look at the attached database (which I attached before) and see what could be the issue? can't thank you enough!