Search results

sorry for the late reply. No - what I am trying to say is that if the users come back on the same day then they see the data they had entered before for that date. Now they could edit it as well and it will Overwrite the record for that day (hence no multiple records for the same date). but...

you'r right! I explained the idea of normalization and he bought it. I made a separate table for Adhocs and linked both the subforms with the EmployeeID from tblEmployees - thanks for your help! Now to problem # 2: As you can see in the first screenshot, I allow the user to enter data. There...

I have placed the tabs on the main form - within each tab, I placed a subform!! here are the subforms in design view.

the two subforms are linked to the main form via EmployeeID (which has been made invisible)

here is the screenshot! thanks guys

well I had 2 tables: tblEmployees and tblActivities tblActivities had many fields - each field representing a report I made 2 subforms - 1 subform representing DailyReports, the other subform representing Adhocs I couldn't just put all the fields in 1 subform because there were too many...

Sorry for the confusion, Gina! If multiple subforms are based on the same table (half of the fields in 1 subform, and half of the fields in another subform), then when you move between subforms (placed on the main form), a new record is added - how do I sync both the subforms to have the same...

Hi, I have a main form with 3 subforms in it - These subforms are based on 1 table (which i know is a horrible design idea, but this is how people at my work wanted) - these subforms are called subreport1, subreport2, subreport3 a user will have to enter data in subreport1 AND...

The issue is that a user might have to enter data in 2 subforms on the same date. When this happens, I want only 1 record showing that User has entered numbers in report 1 and report 2 - Right now a new record is added when user adds data to any other subform even though its on the same date...

Hi, I have a main form! The main form is used to enter data - This main form has 4 subforms where each subform represents a report. So the user logs in (I use date() function to get the today's date) and he enters the data - Sometimes the user might want to enter data for 2 reports (using 2...

Thanks chris! the form takes quite long to open when I put the backend on the network shared drive. This doesn't happen when I put the backend on my local drive. why is that happening? and any solutions, if possible? thanks again!!!

Hi, I am done with my access application thanks to this amazing forum! I already feel that I have learn so much in just a month. Anyways, this application will be used by multiple users on a network. Application is about data entry for each of their users - Now, where should I put the...

thanks bob! i used Forms!frmEmployees!frmReportdates.Form.txtfrom AND Forms!frmEmployees!frmReportdates.Form.txtto and it worked.

Hi, I have a form called frmReportdates - This form has two text boxes txtfrom and txtto (for the dates) & a clickable button which opens the report - In the query of the report I set the dte criteria to : Between [forms]![frmReportdates]![txtFrom] And [forms]![frmReportdates]![txtTo]...

I used "date()" and it worked. Thanks!!!

hey! do you happen to know how to use todays date to show a report? I want the user to see data for today only (I don't want them to enter the date themselves). thanks!

thanks maria! it was driving me insane as well. You saved me alot of trouble :)

how would i do that? MS help didn't help much!

sorry but it went over my head. It describes a function and all but I don't get it.. my list box has many rows - each row being a hyperlink field - how do I reference that in the VBA? :S

Thanks spikepl! what would be the follow hyperlink method? I know it's a small line of code but I don't rememeber it correctly :S