I'm trying to create forms for adding data to tables, trouble is when you close the form, if there is anything in the text boxes it tries to update the...

In a continuous form, I would like to set the value of one field based on a date in another field. The fields on the form are , , , , and . Licenses are...

I will explain this situation using a scenario. Let's assume that i'm working on a library system where i need a loan form that will only show books that are...

I am trying to to make a field that uses a value from another form (A) in a calcuation for a field in form B. I've made the control source the field in Form...

I have a database, lets call it DB1.mdb I am building a form on this database to display student information The form has NO Recordsource and all textboxes...

Hello all, I have seen this question asked before, but I have not found the answer I am looking for. This is what I am looking for. I have two options that...

I'm sure there's an easy way to do this, but, being new to access, I haven't figured out how. I have a form with a field that has combo box to select...

Hi Guys How are you all?, hope you're all welll and dandy :) Hope you can help me?, i am creating a form and on the form we will need to add in a customers...

I'm having difficulty in figuring out how to make my existing SQL string to up date my table for the bound text box. The text box is comments on the activity...

Hi, I have a form with 2 combos; second combo value list depends on the value of the 1st one. It works fine in single form view. But I want to display data in...

I have reviewed as many postings on this topic, but am in need of help generating the actual code to accomplish it. I appreciate any help! After a new record...

Being relatively new to Access, I am trying to make a form auto fill several fields for me. I understand this is possible yet, I haven't had any luck in...

do you ever get so far out in left field that it's hard to find your wasy back to the dugout where everyone else is sane and speak's english

Hey Guys (and Gals), Having fun with Do Until statements, can't get this one to work... What I want is if you double-click on one field then clear the...

I'm not sure in which group I should post this, and I had a hard time coming up with a descriptive subject line. I have asked about this topic before, and...

Hi, I copy words from a word document, Eng 97, which include double-quotation mark and paste it to a Access 97 form which field type is memo in...

I have two tables that have a 1-to-many relationship. When I went through the form wizard to design my main form, I got to the step that shows the fields...

Good morning, in my openings form I have a button search clients. It works fin, when I give in the name of an existing client. When I misspell the name a...

Appreciate any help. Chai

Good morning, After validating data in the BeforeUpdate event of a 2 field form, I want to close the form if the data is good or, if the data is bad, keep the...