Search results for query: *

Yes, I have user security. That's what is so strange. I did exactly what you said Jerry, but it didn't work. I'm not at work today so I won't be able to tell you exactly what happened. I'm hoping my day off will allow me to look at it with a fresh eye tomorrow. I've been struggling with this for...

Yes, it seems that would be the first option, but it didn't work. The user picks an employee name from a drop down box on the main form and the subform opens to the record selected from the main form. If I set the subform to DataEntry, I get a datatype mismatch error.

Hi, What can I do to allow a certain group of users to add records to a table, but not edit them? I have a subform that opens with certain options visible according to the group to which the user belongs. The form works great, but it seems that no matter what I do, I can't set the subform to...

Thanks, Golom. The questions that you asked are exactly what I am struggling with. I think I've got it figured out though. I can subtract the absence date from the anniversay date and base everything on whether the result is positive, negative, or zero....maybe. Any way that's the angle I'm...

I have an Attendance database for employees. I have a table named tblActiveHourly that holds employee info such as: EmployeeNumber DateHired Department The Attendance table contains records of days absent with fields EmployeeNumber Date Reason Predefined reasons for absence are selected...

Thank you sooooo much, AceMan1. Works like a charm. All I needed was a little hand holding. Well....a lot of hand holding maybe. 'preciate it!

Thanks for the responses PH. I played around with the WHERE clause and the OpenArgs, but I just couldn't figure out how to get it to work. As usual I just approached the problem from a different direction and everything is working fine. I'll wait a few days and try it your way again. Sometimes I...

Well, I've looked at that, but I don't know how to apply that to the items that the user can select in the combo box on the form that is opened. Currently, when the form is opened, it shows the usernames and departments for all of the different departments. I want the combo box limited to the...

Ok, picture this. Here is a menu form: Open Department A Form Open Department B Form Open Department C Form Each of the items on menu opens the same form. The form has an unbound combo box that pulls data from a query. What I would like to do is have the combo box selections limited to the...

tranman, It worked! Thanks!

I have a form with 10 combo boxes. Each combo box has the same 10 list items, and each combo box has a corresponding text box. Selecting an item from any one of the combo boxes populates the corresponding text box. It seems like there would be a way to use one combo box to populate the ten text...

Thanks! That's what I was looking for. Hopefully, I can figure out how to do that. If not, I'll be back....

I have a form with 10 combo boxes for 10 possible fields in a lot number. The following is the code for the first combo box. Is there a way around coding all of this for each combo box? The combo box is bound to a table of lot number fields. Once the fields are selected, I string them all...

Thanks for the replies. You both really responded quickly! I fumbled around and figured it out for myself though. Here is what I came up with. Format(Format(Date, "yy"), "0") Again, thanks.

Is there a way to format a Julian Date so that the year is displayed as 5 rather than 05? I am trying to format lot numbers that include the Julian date but only 1 digit is allowed for the year. I suppose I could take the easy way out and use the number 5 rather than the Julian Date, but then...

Thanks, I'll take a look.

I have an Access database with links to Excel documents. Is there any way to print the hyperlinked document without opening it? It would be nice if the user could just click a button and print without ever having to see the Excel application in the background.

How about "You toucha de database, you losa de hands!"? Seriously, would it be possible to make up a modal form to start up on the backend? That might confound a few more users. Of course you would have to allow use of the shift key to by pass start up commands, or you wouldn't be able to get...

Oooops.....I apologize. I had forgotten that I am using a timer on my startup form. You were right. I temporarily removed the form from start up until I finish my code and the list constants are cooperating with me now. I didn't realize that the timer would do that. Thanks a million!

No. That was a very good guess, but I'm not using any timers.