Search results

Thanks, but I was hoping to avoid that. This is going to be done on a regular basis and was looking for some kind of code that could take care of this.

Hi...I have a Job table that has the following fields. EmpID JobNo JobClass BgnDate We track job history for up 5 jobs for each employee, so the field [JobNo] will have a value from 1 to 5. Your first job will be "1", your second job will be "2" and so on up to 5. If an employee starts a 6th...

Thanks!! That did the trick.

I looked at that link already and I was a little confused. Do I type in the word "Parent" like this: Me.Parent.Parent!TabCtl0.SetFocus I'm guessing no, since that didn't work. Also, once I get the Focus to the Tab Control, how do I set it to a certain tab? Thanks

I'm trying to Setfocus to a certain Tab (Tab2) on a Tab Control that is located on the Main Form (Form1). On the Tab Control I have a Subform (SubForm1) and on that Subform is another subform (SubForm2). Main Form Tab Control SubForm1 SubForm2 So, I'm trying to set the...

I found the problem I was having. The first subform name was wrong. DUH!! Thanks for all your help.

Ok, I tried this: Me.frmClient.SetFocus (frmClient is the subform) and it gives me an error "Method or data member not found" I also tried this (which is the format I found on a different thread: Me!frmClient.Form!frmPets.Form!frmPetList.Form!List0.SetFocus (frmClient is subform1...

Let me try to explain this.... I have a form with a subform on it which has a subform on it. The second subform has a listbox. The listbox is pulling data from a query. The query is driven by a field on the main form. How do I get the listbox to refresh/requery when the field on the main...

I know that it can be done, but I just can't figure it out... I'm creating an employee database and I want to be able to link their picture to their record and display it on forms and reports. I think I'm supposed to use a Bound Object Form and then put the location of the file in the data...

Ok, thanks. That's what I thought. Just wanted to make sure.

I'm trying to place a smaller Tab Control on a main Tab Control on a Form. The problem is that I can't seem to bind it to one of the main tabs. The smaller Tab Control shows up on all the main Tabs and not just the one I want it on. :confused: Any ideas? Thanks

Thanks... Thanks for the info. I figured I would have to do it that way, but was hoping I could do it a different way. Yes, I know that I can add as many tabs as I need. I was just trying to group certain things together within one tab and save space as well.

Hi all... I am creating a Form with a Tab Control on it. Is it possible to have a second Tab Control on one of the Tabs from the main Tab Control. I put the second one on the Tab I wanted it to be on, but it is still visible no matter what Tab I go to. Thanks, Jeff

Ok, I have a question that I don't know how to really explain, so here is an example of the table I have: 35 5101 57.32 35 5102 267.44 35 5103 72 The first column (35) is Employee ID. The second column (5101) represents a certain time code. And the Last Column (57.32) represents an amount of...

Thanks for the help. That worked great.

I am trying to find the position of a "," in a data field. I was trying the SEARCH function I found in Help "SEARCH(',',[emplname])", but I am getting "Undefined function 'SEARCH' in expression." when I run the query. Any ideas? Thanks, Jeff

Is there a way to print out the field names in a table? Not the data, just the field names. Thanks, Jeff

I have a ID program that uses an access database and saves the jpegs into a directory giving them a unique name and putting the path and file name into a field in the table. I want to be able to query the table and copy the jpeg files from the default directory that they are in and put them...

Great! Thanks for your help.

Hi, I have a text field in a table and need to convert it in a query to a number field for sorting purposes, but not have it change in the table. Thanks, Jeff