Recent content by sonny

Is there a way a button or two can be created on a summary worksheet when clicked on can take you to the detail worksheet? I am going to have alot of wooksheets and could use a way to get to any one of them quicker then back to the summary worksheet the same way....

Is there a way to have a list with sub categories that uses a node type function OR Is there a way to go thru this list and hide the sub rows row if main column has a zero in it? Herer is a sample spreadsheet with data..

I am tring to seperate a field using a query that has data like this: 02 04 08 18 20 25 31 32 35 39 41 45.... (10 sets of numbers) into there own fields... I cant seem to find something along those lines!

Is there a excel function that I could use to calculate the numbers of months I have left on a loan given the balance and %rate along with what I want to pay each month? What I want to do is enter my balance in 1 cell, my desired numbers of months to repay in another cell, and my % rate in the...

I have this formula in a cell but dont want it to add the Salaries if one or both of 2 other fileds are empty. =SUM(D35:D46)+Salaries!C5+Salaries!C6 Salaries!C5 needs to be added only if cell D34 has a value Salaries!C6 needs to be added only if cell D47 has a value I cant figure out how the...

If the 2nd field is a cbo then it must have a qry or a sql as the record source. Either way, click the build button next to it while viewing the properties for that field and it will open the QBE. Once there you can right click in the column that has the filed holding the A,B,C ect data and...

Can you post a sample

Just set the fields value using code on the after update event .

Did you try a refresh of the form...

This is very simple and there are many posts on this subject. Use the search.....

Just a suggestion, are you using tab controls. If you are on a field on the 1st page and click a tab to go to another, and that one has a tab control set which just happens to be at the bottom of your page, it will jump to that control....??? Check the tab controls???

Here is a sample that I use to compare 5 fields between 2 tables. I put my table on the left and a contractors table on the right and my 5 compare statements between them in order to view the results clearly.... SELECT HURRICANE_ROE_DATA.ROENumber, HURRICANE_ROE_DATA.Plastic...

How do you do the checking? In the same form as the users? Or some other way? I have a db that I run a query to view the records then make it an update query that up updates a field that I use to lock the current record. My field I update is a yes/no , so I update the records that match my...

Does your db have any user password features. If so you could certainly lock a record down.

I now have the form bound to the tbl but when I add a record on go to the edit record form the cbo to navigate has the new record in it but the form does not have it, unless I close the form and reopen it. Some how the tbl the edit subform is bound to, wont refresh.... The form is hidden until...