Search results for query: *

Awesome - thanks Andrzejek! How many does an "abundance" make?...about 1800 different Excel files. So needless to say this will save me a ton of time cleaning the data before I build a database for it. Thanks guys.

I have inherited an abundance of Excel files that had some sloppy data input. Here is an example: BBR 689.5 - 690.5 683.0 - 684.0 673.0 - 678.0 LUF1 653.0 - 654.5 LUF2 632.5 - 636.0 MUF1 621.5 - 623.0 MUF2 591.5 - 593.0 589.0 - 590.0 Column A contains the zone name and...

No, not until you mentioned it. Thanks so much MajP...I can't believe how much time that simple (and very stupid) mistake has cost me. Thanks again!

I have a query that has a text field (Component) and a boolean field (bDozer). I want the query to filter according to a text box(txtType) on a seperate form (frmWork). So, within the query I put the following criteria under the bDozer column...

Great suggestions. Thanks for the help.

I was hoping to have my main parent form with a few command buttons on it. Each command button would open up a differnt child form linked to the main form via common unique ID. I am okay up to this point but now I want to be able to jump to the next record on my parent form and all of the...

I know this post happened a long time ago, but I recently had the same problem and resolved it after an agravating few hours. Here is what worked for me: Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmChargeBackBalanceLookup" stLinkCriteria =...

I have a simple query that I need to graph. The query looks like this: relMonth CountOfIssues RunTot2 Aug '03 12 12 Oct '03 1 13 Nov '03 7 19 Dec '03 2 21 Jan '04 2 23 Feb '04 11 34 Mar '04 5 39 Apr '04 31 70 May '04 3 73 Jun '04...

Duane, Oh wow, did that every make my life a lot easier. Star for you... Thanks, Rob

Thanks. I never even considered that yet it is so obvious. I am embarrassed but happy to have a solution. Rob

I can't seem to do what I want and I kinda think that it is out of the scope of Access. However, it would be great if it could do it. So can an Access report contain a hyperlink to a certain record? I have a form which collects a lot of different engineering information and thus creates a...

Is there a way to disable the mouse wheel on forms. The users of my database are complaining because they keeping using the wheel to scroll down the form but instead it skips to the next or previous record.

Is it possible to set a memo size? I am concerned that people will enter information into the memo field (typically less than 500 characters) and then go back and add a lot more at a later date. I have been warned that this can cause a lot of problems with the extra size overwritting the next...