Search results

yes, i think my file "bloats" after some time as it uses insert and delete queries to create, add and delete records. as for splitting to front-end and back-end, i have seen videos on how to do it. but i have reservations as the shared drive (microsoft one drive) in my place is rather unstable...

As i develop my database in Access, i notice the file size can double and then halve after I click on the Compact and Repair Database option. But if i release my database as a standalone to my users, how can they compact & repair? Is there a need? Is there a way to include a command button with...

what does the line "Dim ctl as Control" do?

Dear Pat, That thread looks great. Let me try it.

Thanks for the information about special characters. Please do explain how to implement the above without using class modules. Cos I have yet to learn about using class modules in VBA. Thanks!

dear arnelgp, thanks for showing me the clsTransactedForm class. how did you "apply" it to the form, I presume, you apply it to the Analyst_Edit form. Also, i note that the record is now saved only if i click the Save & Edit button. But I noticed the following two observations too: 1) If I...

Hi, Database as attached. Open Main Menu form. Click on Admin tab. Click on View/Edit Analyst button to open up a Form that shows a datasheet-view of analysts. My story starts here. In the above datasheet, clicking on the Edit hyperlink next to an Analyst's name will open up the form...

The form, Task_Detail_Interface, displays the list of tasks in a datasheet format. It has a column of "Assign" hyperlink for users to click on so as to open up a form, Task_Detail_Add_v3, to edit the details of each task. It draws info from Product Table as the Task_Detail_Table only has a...

Right now, what i have done (on the actual database) is that i placed a line of VBA code in both the date textbox and analytical method combobox that requeries the subform in the After Update event. This helps to update the subform. I guess i could add a "Refresh" button with the same requery...

yes, you are right. myQuery_for_Analyst_Time_Used doesn't work. It is one of my earlier attempts at trying to create a complicated (to me) query. The query used for the subform being discussed for this thread is myQuery_for_subform. As for the form/subform, go to Main Form, click on "Assign...

no worries, i'll attach it in this post. Thanks for helping.

oops, i forgot to attach the file. just did so in the earlier post.

update: i deleted the old subform and created the new one. and i see what you guys are talking about with the master/child setting. so i linked Task_Detail_Date in the main form with Work_Date in the subform; Analytical_Method_ID with Analytical_Method_ID. my test file is attached for you to...

the main form displays records from a table, Task_Details. 2 of the fields, Task_Detail_Date and Analytical_Method are used by the query in the subform to display a list of available staff. I have added the names of both controls in the criteria line for the query in the subform.

I have a form where I can select a value in a textbox and combo box (e.g. date and name of analyst) I have a subform in the above form which is based on a query (let's call it query_for_subform) that returns a few values. Two of the criteria for this query_for_subform uses come from the above...

i have no idea how to declare the parameters to achieve what i wanted to achieve. hence, my original post.

I'm not sure what you mean by that. I have textboxes for users to key in the From and Till date. If I add parameters to the Parameters header, when I run a query, there will be an inputbox that pops up asking me to key in the value.

Good afternoon, The end goal of my Access is to have users use it in standalone (runtime). As such, it is not ideal for them to edit the tables of records directly. Also, the tables may not be readable as some fields are foreign keys (autonumbers instead of corresonding value, eg analyst_id...

i was doing that initially but then it got too lengthy. condition 1 was checking for empty fields and i wanted to tell the user to fill up all fields before clicking on the button. condition 2 was checking for valid dates (eg Till date is after From date), and i wanted to tell the user to key in...

thanks! I note that you added subroutines to the On Change event to both textbooks to save the value to 2 variables (dte1 and dte2). Then the macro of the command button not only opens the query, it also SetTempVar to create 2 Tempvars which is used by the query. Could the SetTempVar have...