Search results

Thank you very much. One more question. Do I need a DoCmd. and what would be after the DoCmd.?

Have some information in the tag property of a form that I would like to change by using code or delete by using code. I'm not sure what the syntax would be to delete and reference the tag in visual basic. I originally used DoCmd.DeleteObject ([Forms]![FormName].Tag), but I don't think that is...

Thank you for the reply. I've found a low security issue to resolve most of my problem. I was wondering. Is there a way to clear the tag entry of a form? I've tried to look at something like docmd.deleteobject, but I have no idea how to reference the tag on the form.

I've got to present my database to a customer in two days and the beta is almost complete. I would however like put add a lockout after a specific date and prompt the user to input a key to continue using the software. In my mind I was thinking about making a password table, having some type of...

I understand how to make a report base on a query. I typically create a form to enter the criteria in to the query and open the report from a button on the form. However, sometimes I would like to keep some fields out of a report. So, for instance if I have a table for example with the fields...

I was able to get the error handling issue resolved. I found a similar issue and copied some code to fit my database. Here is what I used. Private Sub Command6_Click() On Error GoTo Err_Command6_Click If Me.StartDate > Date Or IsNull(Me.StartDate) Then MsgBox "Must enter a start...

Here is my debug info. Private Sub Command6_Click() If Me.StartDate > Date Or IsNull(Me.StartDate) Then MsgBox "Must enter a start date before or equal to today" Cancel = True Me.StartDate.SetFocus ElseIf Me.EndDate > Date Or IsNull(Me.EndDate) Then MsgBox...

Hopefully, this is my last question. Where do I put the code for the debug? Do I put in the code for my on click event for the button that opens the form or does it go in the on load of the form that is being opened?

I entered the code on load of my form which works, but I get an error of: RunTime error "2501" The openform action was cancelled. Is there a way to keep the debugger from coming up with this error? If the error didn't popup everything would be working as I wanted it to.

If I try to enter the code On Load I get an error. I put in If Me.RecordSet.RecordCount = 0 and then go to enter more code I get: Compile Error: Expected: Then or GoTo.

I've got another question, but I've got the code in place for the on click. It's checking the validation of both my StartDate and EndDate boxes and if both validate it opens the form. Here is the code: Private Sub Command6_Click() If Me.StartDate > Date Or IsNull(Me.StartDate) Then...

Thanks guys. Now I just need to figure out the code to get it to open my form. I normally use the regular access property builder to select, on click, open form, select the form name, etc. I should learn VB.

I have a daily time time. Two of the field in the table are employee name and date. I have a form for this table to input data. I also have a form to allow me to easier find specific records. Basically, another form allows me to enter part of the employee name, a start date, and end date and...

Problem resolved. I went back and put a DailyTimeID in the Billables table. One to many relationship between DailyTime table and Billables table joined by DailyTimeID. I changed the data entry on the billables form to "no". At first I still had issues, but they went away after these changes...

I opened my billable form in design view and the data entry propery is set to no. When I open my Daily Time form I first get a popup asking to enter the parameter value for BillableID. I bet I've changed the layout of this database 5 times to get it to do what I need with no luck. Can I attach...

I was mistaken in the last post on the relationships. I had added a dailytimeID field to billables and it was the one to many relationship with the dailytime table. Once again, I don't know if that is the way to go in doing what i'm trying to do. I've recently taken the relationship out and...

I think I may have many mistakes between the forms, subforms, and possibly relationships. Let me throw out some more info and see what you think would be the best way to accomplish things. I want to be able to open my "daily time form" choose the employee, job location, hours worked etc. I then...

I have a table DailyTime with a form for DailyTime. On the DailyTime form I have a subform called billables. This subform is in datasheet view and is linked to my billables table. The billables table contains the fields item, pricy, and qty. When I open my Daily time form I can enter the data...

That helped a lot. Thank you. It also helped me find some flaws with how I was actually pulling and storing data.

Table: Employees has a field employee and a field EmployeeID. Table: Daily Time also has a field EmployeeID. My daily time form has a combobox that populates employee name from the Employees table. I have an EmployeeID field on the form as well and I would like for it to enter the employees ID...