Search results

Take a look at this and tell me if I am on target or not. If its on track with your train of thought, take a look in the event procedures to see what code was used where.

Ok, I have re-read your post and thought about it some more. Knowing your level here, i will break this down. You have an established system which consists of a form and report and an additional table for the data IF it needs to be saved. What is missing from this equation would be another table...

Just a thought, but... I would assign the text to a varible to aviod the loss. Im not sure if this would rectify your situation, but you could give it a try.

You could try the after update property of the combo box and set it to refresh the subform.

If I understand, I think what you need to do is set the subform up for datasheet view. Check out the example and let me know if its what you mean.

The problem is the EmpID is the primary key in both tables. You need to tke the Primary Key settings off of the EmpID field in the table CellPhone. If this table will require a primary key, just add in another autonumber field. You have it set up right except for that one point. If you try to...

You could define the back color to match your form. If it truly were transparent, whatever is behind it would make the text harder to read.

Useing VBA you could place code behind the checkbox after update event that would change the Enabled property to true if it is checked and false if its unchecked. Set the default values to enabled false and the default vaule of the check box to false. So when the check the box, they can enter...

First off, you should never allow users direct access to you tables. Once they get in they have bad habbits of thinking they are in excell and end up hoseing up the works. :) You would be much better served if you displayed the results of a query or create a form (GUI) for them to use to...

Say for the months, you should only need to filter the query with criteria. What I have done is thrown together an example that illistrates the Select Case statement. What this does is allows you to select an individual and a report. What you could do with this is pass the values to your query...

This is appearing off center? Even after closeing the db, saving everything, and reopening it?

Take the names from a combo box and use an option group for the report selection. Useing a comob box for the names allows you to add or remove employess from the system without changing the form itself. Useing option groups for the report selection would allow you to use the same report in...

Since the form builder is actually generating the proper code for everythign you do, it would highly recommed building the forms in design view. If you would like to create advanced features, then you have to resort to the VBA side of things, but otherwise you just creating more work for...

Are you creating this msgbox via Macro or VBA? Try setting it to MsgBox "You Text Here", vbApplicationModal and this wi;; force them to click it befor they can proceed. It shouold also appear in the center.

Take a look at this form. I based it off of my earlier description. What I have done is 1) relate the 2 tbls 2) create a form based off of the tblEmpData 3) created a subform for tblOtherData to be displayed 4) added a combo box to the main form to quickly refrence individuals by first...

I think what you are getting at is 1) You have a form for entering data with specific fields you want to auto populate when an individuals name/ID is entered, and 2) You want the data stored into another TABLE so that you can keep this basic infomration seperate. Heres how I see it based off of...

Keep in mind that the default for Access XP is actually Access 2000. You literally have to change it to 2002 mdb if you would want to take advantages of any of the few changes that were made. Anything you develop in 2002 should be based on the 2000 system.

Is the initial form within access? Are you wanting to populate a new database with information from a current database? Or are you wanting to populate a new database from some other source?

In the criteria area for the queries date field put this [Please enter a date] This will change you regular Select query into a parameter query, and every time it is opened it will prompt for input from the end user. Whatever you place between the brackets will appear in a pop up message box...

Try adding a new combo box to the form. Whe you do you should be prompted with three options. Choose the third option "Find a record on my form based on the value I selected in my combo box", to get the results you want. If you already have the data source set properly (data shows up in Form...