I can't help but notice that the filtering (right-click on a control of a form) is disabled in Access Runtime. There does not seem to be any way of covering...

tb1: =dsum(.....) tb2: =dsum(.....) etc. tbTot: =nz(tb1,0)+nz(tb2,0)+nz(tb3,0).... tbTot calculates too fast. It only catches the value of tb1. Needs to...

I have been trying to get my command button to print a report showing only the current record on the form. I have searched this and other forums and found...

My main form (form1) comes from a table (DSD Final). Some of the fields in the form are a calculated control source. I would like to replicated these fields...

Hi, I have a very strange problem with the forms on my database. I have 2 tables and 2 forms, one has date & time, one just has date. On the table with...

Hello, I am designing a data entry form in Access 2000 and would like to know which properties field where I can input the text info so when user put a...

I have an attendance form I use daily in access 2003. I use a checkbox to indicate whether the employee was absent or not. By default it is unchecked. Once I...

Hi hope someone can help I have a field which a user enters with a numeric value. On exit from the field I need to search through the same field in the...

Access 2003, existing DB, existing Form, no validation. Employee ID textbox at top of form - I want Employee ID text box to verify that the 6-digit number...

Can I set conditional formatting to white out a date field on the condition that a second field on the same form is not null. If so, how? -- DMainland

I have a number of controls on a report where the control source is a DLookup formula. I know that in a number of cases the data that it is finding are...

Some software has a small "?" in the top RH corner which can be directed to some control, and a help phrase appears on a left mouse click. Can I have my own...

I have a field call control_source that is a numeric field. I want to increment the field by one for every saved record. I could use an Auto number type...

Have vb code to update an Excel chart. Want to use a command button in a form to update the chart yet keeping the form open. My problem is that the chart only...

If two people come to the museum, and one person is from Overseas, but the other one is local, I should have two combo boxes: one with the values set to a...

I have an unbound text box in a form (frm_AssetsUnderMan) based on a table (tbl_Assets) that shows the count of any type of asset obtained from a...

I'm using the following code to make copies of files on a network drive: Dim fso As Object Set fso = CreateObject("Scripting.FileSystemObject") ...

I created a form (Shell) which house a sub-form. I use it as a modal pop-up to display details regarding a given record at the click of a button. This...

A drop-down box listing all of the world countries sure would be usefull for entering demographic information at the point of entry for visitors to a large...

Hi NG, how can I add a leading"+" to positive figures in a textfield in a form? Later I want to calculate further figures with that textfield. I have tried...