Recent content by Fabian1675

Hello everyone, I got a quick question to the experts I have a form that has 3 textboxes named: StartDate, EndDate and Name. What I'm trying to do is have the user enter a start and end date then the name then click the search button, when I click on the button it does not return the date...

Thank you that worked perfectly!

Hello Everyone; I have a table called MyTable, a form called MyForm in MyForm there's textbox named Count What I would to accomplish is to use the Update Query to update one of the entries in MyTable named Total Count from the value entered by the user into the textbox named Count. Not...

Hi, I'm not sure if I quite follow: Me.[Field name] =? is this the field name from the table? or from the query I built?

Hi thanks for the reply. I created a query that filter's out certain criteria base on the user input. I used that query as the new control source for textbox1 it looks like this: =DSum("UserInputValue","QueryFilter") The UserInputValue is a field on the QueryFilter. So whatever value happens...

Hello everyone; I got textbox1 in a form that is bound to a control source called NumberOfEntries what ever value the user inputs into textbox1 it gets recorded into the table. What I did is change the control source to the textbox1 so the user no longer need to manually input the value; it...

You sir is the man! that work flawlessly just like how I wanted it. Thank you very much. :)

I've tried searching for a solution to my problem but to no avail. I have a query with a field name Date Field: Date Criteria: Between Date() and Date()-1 The criteria above works just for filtering between those two dates, but what I would like to do is to filter with date and...

Thanks, creating a query and doing all the manipulation from there is a much better choice. It works just like how I expected it to be and with the criteria that I want. The only thing I would like to do now is to filter the sum for the current day from 8:00AM current day to 8:00AM the next day...

Thanks, the subform currently gets it's source directly from a table can I apply this function into the table source or is it better to just create a query?

Hey thanks I never tthought about adding a summing function at the bottom of the form. Would I be able to sum up each Textbox based on it's input? for instance: Textbox1 = a And Textbox2 = a And Textbox3 = 2 and Textbox4 = a Textbox1 = b And Textbox2 = a And Textbox3 = 3 and Textbox4 = b...

Hello; I have two forms one MainForm and StepChildForm and I have the following content on each form: MainForm has a: ResultTextbox1 and ResultTextbox2 that I need to keep track of the entries from the StepChildForm. StepChildForm has a: Textbox1; Textbox2; Textbox3; and Textbox4 base on...

Hello this question may have been ask before, but I can't seem to find some info about it, or maybe I'm not posing the right question. Here's what I would like to accomplish: I have a continous form one of the entries on that form called is named textbox1 it's purpose is to hold a number...

Yes I looked at it but I'm not quite sure where to place the code under so I went ahead and stuck the entire code under the duration_beforeupdate textbox looking like thie: Public Function Duration_BeforeUpdate(DisplayInterval As String, _ StartDate As Date, _...

I tried the code I'm sure the problem is me, quite new to access world. What I did to test this out is I created a table, querry and a form with a text boxes called StartDate, EndDte and Duration all in date/time data type. I then went to my form and pasted the code under the duration text box...