I am buidling two forms (form1 and form2). They both update the same table but form2 is activated (via a macro) from form1 when a particular field...

If I want to put two pieces of code under the same action do i just repeat it or do i need to add a seperate sub or something. for example I have Private Sub...

OK, so I am designing a database...This may be a no brainer or difficult... I want a lookup column with 4 options, then I want a 2nd lookup column based on the...

Question One: When entering lengthy notes in the VB screen, how do I put a line break in that does't mess up the code? I'm really just asking for a line break...

I havenot been doing databases for a long time. I know some code but not much. I have had a great deal of enjoyment learning the ins and outs of creating a...

Ok so I know there will be a simple answer to this but my brain can't get there on Friday. I created a form that needs to run on to 2 pages. How do I get a...

I have a table with lots of dates. Some default to today when the record is created (=Date()) and some default to today (=Date()) when the user does...

I have 2 problems: 1. I don't know why the command sendkeys "~" won't work on my pc but it works on any other pc I run the program on 2. I have this form in...

Hi guys, I cannot seem to figure out two intermittant problems I am having. 1. I have a form recordsetclone and am looping throught the records, occationally...

1. I have a calculated value field on a form. ( = *). The calculation works fine. But how do I save the answer in a table ? 2. I have a subform on on main...

Hi all... Question #1 I have an add new/delete/close form button at the bottom of the form. What I would like to add is an update button. Some of the fields...

Hi all.. I am using the following search function to search my database: Private Sub cmdSearch2_Click() Dim strLastName As String Dim strSearch As...

I have a continuous form showing multiple projects. There is a command button on each line that takes the user to a screen that shows the...

Everytime I enter 2 or 3 records in one subform; the current record in the form appears 2 or 3 times. Can anyone help me? Thanks

1) how do I create reports from forms and maintain the identical format between the two without having to manually "fix" the reports to match the underlying...

I have Word 2003. The shortcut keystroke Control H and Control Home both go to the find and replace. I understasnd the Control Home is to take you to the...

I am using Access 2000 I want to create a form that indicates the employee who begins a job and the employee who ends the job - using their Emp ID#. I created...

I have a main form and 2 subforms. Subform1 links to the main form and is in datasheet view which shows a list of items for the individuals in the main form....

Hi, I have a form which has two subforms, and . Each subform contains records that the user can select to remove by first selecting the record's associated...

Hiya, I had posted this about a week ago and got an answer that unfortunately didn't help out. Since then, I had another project to work on, and have gone...