Search results

Hey all, I have a table like this Unit.........unitCount........WoNum F001....... 1........xxxx F001....... 2........ F002....... 1........xxxxx F002....... 2........ F002....... 3........xxxxx F002....... 4...

Whew!! Gee god, thank you. I thought that was an easy question. The differences between VB and Access VB are subtle but quite important. Many, many thank yous. PB

Thanks so much you 2. My 'Ruler' was turned off. I knew I remembered that little grey box but it was gone. Also, I keep forgetting that the menu is different in code view. Thanks PB

Yes I understand that, I was just under the impression that the code was supposed to ... wait.... while the other window was in focus..... I guess I am wrong. I'll try moving the if then to the button_clicks on the form. Thanks PB

Hi all, I'm trying to, at a button click, show another form with a yes and no button on it. Have the user click one and then the form needs to go away and return focus to the parent.... what is wrong with my code. The form just flashes on and is immediately gone. Thanks everyone. PB Private...

Hi all, How do I access the properties for a form. I'm trying to right click on the form away from any components, but i keep getting the properties of 'Detail' instead of form. Also, is there a 'Project Explorer???'. It's not under 'View'. Thanks PB

Good day all. I have a directory full of files (.xls) that I need to open up and change but I can't be sure what the file names are going to be. Is there a nice way to use 'File System Objects' to loop through all the files in a folder? Any alternate suggestions would be greatly appreciated...

Thanks I wasn't sure how the nesting should go. PB

Hi all, I have a query that returns a list of ten items. Select distinct(departmentInfo.Dept) FROM departmentInfo; Is there a way to modify this query to give me the count rather than the list (in one query, I'm trying not to break it up) I'm just looking for a result of '10'. Thanks...

Hey, for some reason, my higher faculties are not functioning today. I'm looking at this query and am kicking myself that it's not coming out. Table:Equipment ID........PM..............Norm.........Abnorm.......InstallDate F001....$50............$250.........$75.............data...

heh Thanks, sometimes the answer is so simple it's transparent. PB

Hey all, I have a database that auto launches a form called MAIN MENU. ie In tools/startup/Display Form/Page MAIN MENU is what is typed there. When I go to the forms tab and the pages tab, there is no MAIN MENU form or page. What is happening behind the scenes? I need to see what the code in...

Hi, everyone. I have an Access application that a previous employee wrote and it needs revision. When I open the file (Tracking.mdb), it goes straight in to the program and hides the database window and Access Menu Bar. How do I gain access to the tables and reports and such without these? I...

Super Thank you guys. I knew left joins combined but the requery on 'null' was just barely outside my intuitive abilties. Superb PB

Hey all. I've got a query on two tables. One is TruckNumber...field.... field2..... T001................xxx......xxx T002................stuff....data T010................xxx......xxx T012................xxx......xxx T015................xxx......xxx the other type........EQ9...

Bwa ha Hi, thanks for responding. I had a buddy drop by my desk and look at the code and said "where is 'Option Compare Database' ?" Well that fixed it all. Sometimes the answers are too simple to see. Thanks PB

Hey all, I have an Access database with many forms and macros. It runs fine on my PC but when I move the file to another PC and try to run the Macros, it crashes at the first implicitly declared variable. Option Explicit is NOT in the code. Is there a setting in Access that is causing this...

Hmm Hey, thanks for the responses. Perhaps I am asking the question incorrectly. The code I have Works. There's nothing wrong with it. When I move to a different PC than I wrote the macro on, it crashes. The file Is there and the path is the same. Why should the same version of Access on...

Hi, all. This is probably really easy. I've got a macro that calls Excel from Access. It works fine on my PC, but when I try to run it somewhere else, it keeps crashing (probably a setting I need to change). Whenever I didn't explicitly declare a variable it would tell me that the 'project...

Hey Just to see if you still need help..... The above statement about parameter queries. [Please enter the value to search for:] breaks down like this.... Go to the query tab. Select new, design view or view an existing query in design view. There will be several rows in the design column...