Search results for query: *

Hello everyone. I am trying to come up with the best way to make backups of my database. How do you back up your databases? Is there something better than manually copying and pasting the db files? I suspose I could come up with a way to run a batch file from code (using a shell command)...

Hello everybody. I have a form with 41 different check boxes on it and want to verify that at least one has been "checked" before allowing a user to exit the form. I am having difficulty getting my for loop to work, perhaps somebody could provide some assistance or reccomend a better way of...

Hello everybody. I have 41 check boxes (named chk1, chk2, chk3...chk41). I'm trying to use a do while loop to go through them all. I have the counter count up from 1 to 41 and I want to append the counter number to the end of the "Me.chk" part. Whats the correct syntax for the...

Good morning everybody! I need some advice on efficiency. My new databse is going to require the user to input data from a printed form. On the printed form there are, among other things, 42 check boxes. I need to be able to select one, many, or all of the check boxes. Would it be...

Hello everybody! I have a workbook that uses data validation to pick from a list. It works great, but I was wondering if there is a way to start typing in the cell and have it auto complete from the list? Any help is greatly appriciated. Please let me know if you need any clarification...

Hello everybody. I have a report based off a query. In my report I have many (21 to be exact) testboxes with a DCount statement as the control source. This set up works fine, but it is terribly slow (it can take in excess of 2 mins to create the report). Is there a faster alternative to...

Good morning everybody, I have a quick question. I have a secured mdb file on a shared network drive. right now it runs fine over the network speed wise. I dont particularily want to seperate this this into a FE and BE because I dont want the hassle of making sure everybody gets the current...

can somebody help me out with my quotation marks in this line? strSQL1, strSQL2, and so on are all strings. I want OverallSQLstr to be the string that is formed by the combination of strSQL1 through strSQL5 WITH the "(" brackets in it. How do I get the quotation marks set up...

Ok guys, this is probably a simple question for those of you who are more experienced with writing queries, but I'm stuck. I'm building a series of multi-select listboxes that come up with the criteria for the WHERE part of a query and pass the argument onto the querydef. All this is going...

Hello everybody. I am having some trouble formating my worksheet and I am wondering if there is a way to do what I want. Can I have a worksheet with varying colum widths? or example, I need A1:A15 to be at a width of 25 and A16:A25 to be at a width of 15. Can this be done? I am trying to...

Hello everybody. Quick question: What exactly does the Compact and Repair Database function do? I realize it probably does exactly as it say, compacts and repairs, but what is it compacting? And what is the reccommended frequency of running this? Are there problems with running it too...

Hey everybody. I just found out that the database I've been working on lately is going to be scaled up a lot bigger than I thought orginally. For example, my company will be entering some 65,000 records (projected figure) per year. After a couple years, isnt that going to be a bit much for...

Ok guys, I am realy stumped on this one. Heres what I have: In my database I have a one-to-many relationship where one WTL_id can have multiple Impacts. I store the TotalRegHours field in the WTL_id table. When I pull the info onto my report, if I have multiple Impacts, it shows the...

Hello. I had to change some code when we upgraded to Access 2K (from Access 97). the only bit I cant figure out is my table def. it will run, but it will not create the fields. heres the relivant code: ************************************************** Dim dbs As Database, tdf As TableDef...

Hello everybody. I dont exactly know where the best place to post this would be so I'll try here. I need some help with a Data Access Page in Access 2000. I am trying to use a dropdown based off of a query. The query runs fine (I have tested it alone and in a form) but for some reason it wont...

Hello everybody. I need some help with a Data Access Page in Access 2000. I am trying to use a dropdown based off of a query. The query runs fine (I have tested it alone and in a form) but for some reason it wont allow me to set the ListRowSource for the dropdown in the Data Access Page to...

Hello. I am working on a form where I need to select some criteria with a combo box and display the results (the rest of the record). depending on what is selected, one or more records may match that criteria. I need to display all of the records that fit the bill. Some of you may remember...

ok, I figured out my problem with my form. when I first open it there is a filter in place. when I right click and select remove filter my form will then work great. how do I get it to open and remove the filter automatically? I tried going to the form properties and disallowing the filter...

hello everybody. got a question about making a form in Access 97 for ya. What I need to do is come up with a series of cascading combo boxes to allow users to pick different combinations from the dropdowns. the contents of the second dropdown need to be based off of the selection of the first...

ok, heres a complicated one for you guys. I've busted my butt trying to figure this out on my own, but I'm not getting too far. any help you could give is greatly apprieciated. I'm trying to create a macro to automate a series of long and teadious tasks. this is what I need to do: 1...