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

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 have a start and end date fields plus a txt box called wDays. I'm trying to make sure the user puts in both dates but end cant be earlier than start and vs versa.... If not provide a message as to which is missing.... If alls well do the calulation with the module "GetWorkDays" I f everything...

This question isnt about any project or db I am working on. Its more about can this be done. Lets say I had to do the following: 1) I have a range of numbers from 1 - 10 2) I have to preform a task where I can choose any amount of them from that range(no dups) Lets say I choose 3, 4, 7, 8 3)...

I read a bunch of posts from this site and another and am tring to put the code below together. Has anyone else done something simular to this. I could use a example. What I have so far are bits and pieces of other posts.... Public Function MSExcelOpen() Screen.MousePointer = vbHourglass...

If I wanted to display the date when a button was last pressed on my form, how would one go about this.

Having trouble hiding a subSubform and referencing the controls on the subSubform.... Red certainly isnt correct... If Form_frmOne.frmTwo.Form.NewRecord Then Forms!frmOne![frmTwo]![frmThree].Visible = False Forms!frmOne![frmTwo]![frmThree]![MyFormLabel].Visible = False Else...

I'm trying to get the cbo in the right subform to be populated with the FootingID(s) related to the subform on the left of my main form. I cant get the sql correct...

I have a Star Office file that is 600 megs in size. Yep, 600.... It's a spreadsheet. I cannot open it because I dont have the 5.0 version of Star Office (which used to be a free download) Is there a way to grab the data using Access? I tried Excell but it will only import 20k rows and wont do...

I have 2 queries for 2 reports. Id like to combine them. Heres how they are: qry1: Employee, Project title, RecordID, Status qry2: Assigned Employee, Task, RecordID, Completed What Im trying to do is show what each employee has on thier plate. Only one employee is responsible for each project...

Can someone tell me how to set the linkCriteria to search on 2 different cbo's I'm tring to bring up all records that have what a user selects, in either of the cbo's. Just so you know, a record will never have the same value in both cbo's. stLinkCriteria = "[CatCODE]=" & "'" & Me.CatCODE & "'"...

Has anyone used Access to create folders on a drive? I have a db where if someone creates a new project I was hoping to have Access create a new project folder on the drive and give it the location to create it and a name based on one field from the form the user just created!

I have this code on a popup form. The user selects from the Combo2 then clicks find. This code works but it returns all records having data in either CatCode or CatCode2 fields or my Main form. I want it to search those 2 fields and return only records that match the value of Combo2 on my popup...

I have 3 tables. 1 has a field "itemNumber" only. The other "tblGovEst" has 8-9 fields, one of which has a cbo based on the tbl "itemNumber". It also has a field called "ID". The 3rd "tblMain" has many fields, one of which has a PK called "ID" When I use my main form, (source=tblMain), I link...