Hi I need to write some code that will allow the user to browse through any path/folders/files, select the file and then import the file into the database. In...

In the report I have field labels and field text boxes. I inserted field lables in page header and inserted text boxes in detail. i need each record of field...

I have a form called Assign based on Students, with a subform based on an Enrollments table that links Students to Sessions (SessionID , ClassID). The subform...

I can't work out how to do this! No problem after all of mainform record completed - I can Recalc. But I want to update the subform immediately the combobox...

Ive build a simple database to keep progress notes on my clients. I have a form for the client, and a sub form for the progress notes that is linked to the...

I’m struggling designing a time log database. Each employee currently makes a separate Excel spreadsheet for each 2-week period, manually filling in the...

I have two fields in my data entry form and I want to validate that the sum of the 2 fields is equal to 100 so I created a calculated field that sums the 2 and...

I have created a Weekly Absent Report. I have to report weekly about our department employees absent report. Database fields are as below : Employee Name, ...

I'm trying to set up two slightly different version of the same access database on on our server. The only difference between the two is that I want the...

Is there a way to have a database that has a list of fields from multiple tables where the end user can select the fields they need and drop those fields into...

I have an access report that prints a double header on two pages. In the design view it only shows one page. I tried using the help option to no avail. I...

Access 97, Win 2000 Have a form with several subforms. Works fine with tables linked to an Access Back End Now linked to an SQL Server BackEnd Form...

I initially created a form using the wizard from a table called training courses , which did not have a look up option for one field. Although I can create a...

Hi all, I have an appearance issue that I can't seem to solve. I have a number of checkboxes, listboxes, combo boxes and one option group on a form. If the...

We are designing a database for fire hydrants. When I enter the hydrant serial number and location, I want access to automatically enter this data in the...

Hi As I am pretty new to access I will try to explain my problem as best as I can. Tables Symbols - which contains the Symbol Description, Symbol...

This is kind of a cross post from my own post of a few days ago, I have the code that is presented below that gives me a number based on some choices made in...

Hi, I seemed to have lost the thread from before - so here is my problem that is still unreolsved as before; I have a MAIN form with unbound combo boxes on...

Hi, Im trying to enter a validation rule for two controls on my form. These controls hold two dates. DateSent and DateReturned. My rule for DateSent is; ....

Hi: I have the same scenario, i.e. the txttotal shows the total. However, I added a checking wherein the form will not close if the the txttotal is not equal...