I need users to be able to pick a file from any directory on their hard drive or on the network.. i basically need a input type="file" from HTML, but on an...

I've got this annoying thing where the reference to formfields are not recognised in the VBA module if I refer to them by their name only. I need to include...

Background: In my main table, I have a field that must be completed before they enter a new record. I selected "Yes" under the General Tab labeled...

I have a main form / subform setup. The subform has a field that is a yes/no data type, represented by a checkbox in the field. How do I set up a control on...

I have tried every thing I can find so far to set the date to display both on the form and in the table as dd/mm/yy even when it wants to display as...

Access 2003 search form frmSearchDonors will have 1 field "txtSearchPhones" it will also have one button that is meant to open a form with the donor record...

Hi, I have a form which contains a text box, when you enter a number in this text box it displays the results in a another text box below, because it is...

Hello Forum Members: I'd like to have some help on the following codes on the Access 2000: On the Form Header, I have an unbound text box called FindWord, in...

Hello, I have a form with filtered records. What VBA code/ option can I create a command button to export the filtered records to MS Excel? I tried the...

I have an employees table and a sitehistory table. 1 to many relationship. One employee may have been assigned to more than one site historically. I want...

I have built a calculation in access that takes "time 2" - "time 1" and provides a result of the lasped times. The expression gives back the answer. It looks...

I am using Microsoft Access 2003. I have a tabular form for data entry with a number field named "Volume". These volume numbers the user types are often five...

I have a be file for our database. When one computer opens their own front end, it puts a ldb on the back end, which locks the other front end??? The only...

I am using the fOSUserName functionality in my DB. I would like to use it to dynamically preface comments a user types into a text box. Scenario...user opens...

I have a form that saves "99" for a particular field if that field is left blank (which for us means that we tried, but weren't able to collect that...

I have a form which has a calculated control "txtYear" on a subform where the control source is =Format(,"yy") which works fine. I have another calculated...

This code is giving me a syntax error. I can't find the problem. CurrentDb.Execute "INSERT INTO " & zDepartments & "(, ) VALUES ('" & NewData & "', dirid );"

I would like an Error Message to display the names of the Fields missing data entry BEFORE the a macro to open the next form is intiated. The forms are mostly...

I have a subform that is based on a query but when I open it I can't enter or edit any data. The Recordset Type is set to Dynaset (Inconsistent Updates), the...

Hello, I am trying to create an event where the code will look for no results after a query. If there are not results I want a prompt to ask the user to add...