Search results

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...

I re-arranged things in the code to try to make it clear as to whats going on. But I'm at a loss to why the qry will only run once. When I open the db and add a new record it works, when I try to add the next one, it doesnt.... Is this an issue with Access or is it me? I stripped it down in...

Why does my form go to the next record when I reach the end of my tab sequence. And who does one get rid of the controls in the tab list. I had controls on there at one time, but now I dont and the control names are still in the list. But my biggest problem is why its going to the next record!

I forgot to tell you that theres another popup in the code that allows the user to make a web connection to the US Postal servise to check the zipcode if its not one in the zip table. Basicly it allows the user to use one thats no in the table for the single record but the code never gets added...

You'll need to reference the DAO under tools in vb...

Maybe this would help. After a user enters a zip, a popup form opens if there is more than one city for the zip. The user only selects the city and the county and city populates the main form. Otherwise, if ther is only 1 city that matches it does its thing without the popup form. I have most of...