Search results

Anyone have any direction...?

Hello, I have a small project that I want to create but felt like running it by everyone for some input... Basically, the docs will all be the same format such as an interoffice memo. I'm not sure the best route to take but the following are a few elements I would like to include in a DB that...

The Solution ! ! ! Hey Wayne, That was it! I included the (-1) and it checked the checkbox in the new record. Many Thanks again for your time and patience!

Hello Again... Wayne, Thanks again! How can I insert a checkbox to be checked or set to Yes/True...? The sample code functions and inserts a record but I can't seem to include setting the checkbox to True... Any ideas... My previous post has the code that includes the checkbox variable and...

Gettin' Close... Hello Again, I utilized the following code was able to add a new record like I want; however, I'm having difficulty setting a "Yes/No" field to True or Yes... The functioning code: '========================================== 'Adding new record in tblEmployeeOvertimes mySQL =...

I'm Back... Hello Wayne, Thanks again for the reply! As it is right now I'm receiving an error for the line db.Execute (mySQL) in the following code: '========================================== 'Adding new record in tblPersonnalOvertime mySQL = "Insert into tblPersonnelOvertime (EmployeeID...

Hello Wayne, Thanks for your reply; however, as you are confused by my table structure, I'm confused by your forms layout... Just for clarification and anyone else reading, I need to create a system that can track Overtime occurances, hench the table "tblOvertime". The list of available...

Repost w/ DB Attachment Hello Wayne, Here's a quick breakdown of what I'm envisioning this small project should do... Main Form: frmOvertime Create new Overtime Records Unbound Subform: frmEmployees Displays Employees' eligibility or ranking by cumlative OT Number of Hours Subform...

Stuart, I had a recent post on this very topic but couldn't get any good results... I'm just attempting to write a new record to a table and refresh the SubForm that is based on the table. I haven't tried your approach of utilizing DoCmd.RunSQL; I was using Execute(variable here)... I did...

Thanks again Tim! I Thank you for the suggestions; however, up until the error mentioned earlier, everything works... I just cannot seem to add a new record into the table "tblPersonnelOvertime" with the Employee ID currently displayed on the main form... This is the second way I've attempted...

Thanks Tim ! ! ! Here's the complete sub I'm attempting to utilize for adding a new record into the table "tblPersonnelOvertime". I need to associate the new record by EmployeeID (txt data type) to maintain 1 --> many relationship with parent table... There's a few other things in here... I'm...

OK... I get a "compile error: Expected: end of statement" for the following line of code. Access is highlighting the "," (comma) just after "& EmpID": Code Snippet attached to Click_Event of cmdButton: Dim EmpID As String Dim rst As ADODB.Recordset EmpID =...

Thanks Tim, I'll give this a try and see what works best...

Thanks Pat! That did the trick!

So... The best approach may be to develop a central DB on Employee Data and link tables within the other applications based on the required data from the Employee Data DB. Everyone concur... Thanks again!

Hello, How can a reference the value of a ComboBox that user hasn't selected a text value? The ComboBox is based on a value list. I have a checkbox on the form that if unchecked by the user or left unchecked will need the user to select a value in the ComboBox. My thoughts were to evaluate if...

Access 2K... I recently read that I may have to declare the DB as follows: Dim dbs As DAO.Database Additionally, is there a preferred method listed above for inserting new records into a table programatically... Either utilizing: sql = "Insert into MyChildTable (F1, F2, F3) " & _ "Values...

Anybody Willing to Help... Hello, Just looking to solve this problem... I've tried a few different combinations to no avail and have no idea on the Dim dbs As Database Error... Thanks in advance, Jim

Many Thanks!!!

How can I stop a form from creating a new record when tabbing through the controls on the form...? My end users are continuously creating a new record on tables that have one to one relationships. I want to stop them from doing this... Any direction appreciated!