Search results

Are you just looking to give the end user an easy way to get the data displayed? You can create a main form with a subform, and link the two so that the subform displays the data of the selected record on the main form. Easier yet, Have one form with all of the fields on it, and add a combo box...

I have read your post and looked at you example, but cant quite grasp what it is your attemping to do. What is the overall goal here, what data are you wanting to track. I am guessing that you have various clients, which are assigned either one or many machines. Each machine contains various...

Alot will depend on you web development tools. Are you going old school with staight HTML, or will you use a nice application like FrontPage (blah) or Dream Weaver? I know that access can allow you to develop web interfaces that can fill the basic needs, but if you want something a bit more...

Is Not Null

WEhy not get the structure tighter and create another table. Pull the student and room ID from the Rack table, then create a junction tbl by putting all three keys into a single table?

1. In the TOOLS > STARTUP option you can set the form to load when the mdb is opened. You can also make sure the database window doesnt show. 2. Are you having them log into the database or are you talking an OS log on? If its just the database, then when they do log in store thier id in a...

Try changing the me.[newdate].setfocus to frm1.newdate.setfocus where frm1 is the actual form name the field resides on.

Sorry, went vba there. You can add them together easily. Use the query builder to see if you can get your results TotForDis: [Field1] + [Field2] and then switch to SQL view to see what it shows SELECT Table1.Field1, Table1.Field2, [Field1]+[Field2] AS TotForDis FROM Table1; This sql adds...

First get a good plan to go by. Look up normalization here on the threads, it will give you a good place to start. Figure out what tables are needed and what thier structure and relationships should be. Use a form to make the selections. Use querys to retrieve the data. Use reports to display...

Not really. Are you stating that you want to basically pick and choose data from different coulmns? Sounds possibly like you may have an issue with your table structure. Sounds as if the table is flat and not normalized.

What is the table structure here? Are the P.O. numbers in the same table as the parts ordered? They should be in a seperate table and linked in a one-to-many relationship. If this were the case you could easily query just the P.O. numbers. As for now, add that as the only field and use the...

Set the after update query of the option group to trigger the appropriate code depending on the return. If Frame1.Value = 1 Then me.txt1.visible = true me.txt2.visible = false me.txt3.visible = false End If If Frame1.Value = 2 Then me.txt1.visible = false me.txt2.visible = true me.txt3.visible...

You need to assign the return vaule to a string. DIM VBAnsw as string VBAnsw = MsgBox("You have a chosen to deliver on a Saturday! Are you sure?", vbYesNo, "Scheduling New Date") If VBAnsw = vbYes then yada yada yada else nada nada nada

So you are looking to pull data by multiple criteria? You can use an OR statement >#1/1/2004# OR IS NULL

So only a single user will be inputing the data. That does simplify things a little. How many punches are you planning on recording for a single day? 2? 8? You state you have many users, but need to address 1 at a time, which we have figured out. Now you want to address 1 user for the current...

Ok, what i was thinking is that your table should hold at least one entire days worth of punches. tblPunches PunchPKey - Autonum PunDate - Date/Time ~ Date punches occured PunIFD - Date/Time ~In for Day PunOB1 - Date/Time ~ Out First Break PunBB1 - Date/time ~ Back from first break...

Were not compiled at all. This is simply a database some third part designed and it includes refrences that are not accesible from the new version of access. I will make note on these and further research MS on them. I appreciate everyones help.

Switching is not an option. The new version is on a new box, and the old is getting replaced.

I appreciate the suggestion on the MDAC, but would that update the refrences? I do know where to look, but the required ones are listed as missing. I have just started at this place and they had this running fine on 2k, but we just gave them a new box with XP pro and 2002 on it, and now it...

Once you add a drop down combo to the example I sent to you are prompted with 3 options. Choose the third option and the drop down combo will allow you to select a name, and then the form will jump to that record. As for the restriction on one employee record set per day, here is my suggestion...