Search results

I think I didn't word my problem properly. sorry about that. i can access the property sheet (for both the form and the subform). but I don't see an option of "-->Allow form view (change to yes) and then change Allow Datasheet View to No) " in the subform. I only see this option in the main...

Yeah that works for the main form but not for the subform! those properties don't even show up in the format tab You can see this problem in the database i attached as well - i don't know what it is :(

Yeah that's what I thought, but in my database the "form view" is not clickable for the subform!! I right clicked on the subform and it's only showing "datasheet" view only :S

hey! so I was just playing with the database and I came across one thing. (i'm attaching the database here) In frmemployees - when I click "Add record" the first name and last name disappears. how do I prevent that? the employees will be entering multiple data in a day - Currently if an...

got it! my network uses the same format (firstname.lastname) thanks :)

wow!! thanks for putting your thoughts into it. one thing - when I open your database, the windows ID gets updated, but when I "click to continue" to gives an error saying Invalid use of Null :S thanks buddy! :)

Yes it is over a network!! But when I split the database, the form doesn't work - It says that the table it is connected to is not available :S Also, I created a module and used the code from the website you provided. How do I activate the module? I'm sorry for asking so many questions (some...

I created a form which was bound to the tblQuery (which had all the necessary fields as I made this table using a query). Does that make sense? and yes, different users will be using this application. Could you please point me a bit more towards the splitting function? again, I appreciate...

"that allows access to read the user's information*"

ahhh figured it out.. was easy lol anyways, I would really appreciate some more insight into this matter. So I have my tables working... I can add data to the form and new records are being displayed in the tblQuery. one thing I wanted to ask is that I have heard that there is a...

Hey! so i used the tables you suggessted: TblEmployees (Employee_Id, First Name, Last Name) TblActivities (Activities_Id, Activities Name) tblActivities_Act (Employee_Id, Activities_Id, date, time, Amount) Now I made the relationships and a query which seems to work fine. I am trying to...

i am just going to use your approach to see what I come up with. thanks for your time :)

thanks!! but I need to enter "numbers" for these activities. For example, John found out that there were 12 Caseflow available products, out of which he actioned 8 of them: Caseflow Total Available: 12 Caseflow Total Actioned: 8 now these are the two fields names.. how should i incorporate...

Thanks for your help mate!! so there are different activities an employee might do in their shift. for example, they might "slot" the products from an area of lower demand to an area of high demand (Im working for a warehouse distribution center). Other activities might be to see how many...

Hi guys, I have this huge table with the following columns: Id Date Employee Initials Time of Schedule For Report 1 (Total Available Products) For Report 1 (Total Actioned Products) ........ ... .. For Report 15 (Total Available Products) For Report 15 (Total Actioned Products) Now I...

oh shooott!! it;s "COLUMNS'' this time instead of "COLUMN" it works now. great! thanks :)

i tried the new formula, but that just returns the values of column B in the YTD column :S thanks!

thanks NBVC!! that's exactly what i was looking for. But I have 1 question just out of curiosity: My first column is the name of the rootcause for these cancellations, so I started the formula from B1, and it doesn't give me the right answer. but when I start from A1 - it gives me the...

thanks NBVC! I actually used vertical look up function and made a new worksheet which had all the weekly data - Now I can manually sum up all the rows n columns to find YTD values - but how do I automate the process? I mean is there any function/macro/formula where YTD gets updated everytime a...

Hi all, I have an excel file with multiple tabs. Each tab represents data for a week i.e total number of product cancellations in a week because of a particular reason. I want to create a YTD worksheet which would show me total cancellations of a product/reason.. the problem is that...