Search results

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...

I have been looking around quite a bit to see if I could find an easy answer (its never easy), but have had no luck. I have an Access system that runs fine in Access2K, but all I get are reference errors in 2K2. Is there a simplistic way to get these refrences to register? Would creating a form...

Here is a very small example of what I was stating. You will notice that only the data related to the individual displayed in the main form will show in the subform. With further tweaking we could get the subform to be filtered by date and such.

I think you misunderstand. If you create a form that displays a single user at a time, and put a drop down menu on it for quick record selection - you have about what you developed so far. Now, you should have the user data in one table and thier time records in another table - with a 1 to many...