Hi Experts i have 2 tables Audit and employees and a form, now what i need is when enter EID in the form FName and Lname should auto populate in the form....

I want to make a automatic alert that will pop up when my date on a form gets old. I am an access novice. I don't know how to string code or anything like...

I'm trying to display (combine) two fields on a form using the following: =Trim( & ", " & ) But getting an error. #Name? What am I doing wrong? Thanks.

I have a for with a date field. in the after update If the date entered does not meet certain criteria i set it to null. This works fine When I add the...

I am creating a SQL statement on a form. I want to use this as the recordsource for opening another form. I am using the following statement:...

I have a form which contains an: id: name: Data associated with above. My user wants to search on either field (not both), the id or name field and have...

In a DIY synchronization scheme, I have a Projects table on each user's hard drive. When it comes time to resync their local tables to the server back-end,...

Dear All, In my DB there's a table of documents/images and I need to add a print button that will print the document out using the program associated to the...

Good Morning, I am attemping to place a default address to one of my address boxes and for some reason it does not like it... I am trying to add 12000 SE...

Had a string about this the other day but couldn't resolve the issue: I have a yes/no box that I want to be update to yes if the date in the date box is...

Thought this would be easy: I want a checkbox (Active) to be set to -1 (YES) if the date entered in a textbox (CallDate) is greater than today. Code compiles...

I apologize for my ignorance, but I'm hoping for a little direction. I'm building a tracking database with several very basic fields - mostly text and list...

Hello - I am very new to access and have a question: I have a screen with 20 fields on it. My users would like to enter information into eirther a id or...

I am trying to create a simple Y/N drop down (combo box). I create the field as a text field, then change it to a combo box. When I execute the combo box...

I'm new to access, trying to create a database. The problem I have is my form is not showing up the controls, just the header, a big coloured retangle (where...

I have created 2 tables, one for music titles and one for composers. The composer primary key appears in the titles table, and I have created the 1-many...

if i enter a "date" in the field for customer who made the last car payment, i like it automatic check the box "Paid in full", i think something to do with "...

Hello: I am very new to writing code and the code I am using I have gathered from these newsgroups and the web. I have the following code in placed under the...

Hello - How do I set the Visible property of a button to NO based on the value in another field for each record in the details section of a form? many...

Hi, i download the template "expense report database", and i modified it to a "service report database", everything looks great so far, just have one...