Search results for query: *

Background images are not flashy flowers or scenary. The client appreciated the images. It is a diamondplate image. If you knew the client, you would understand. Making them linked saved a lot of space. There are 10,000 lines of code in this application with lots of comments for maintenance...

hwkranger, Only have three small macros left that will be removed before release (made it simpler to clear records using a macro to test app as a new install). Based upon your suggestion, I did drop one more macro and placed that in the code. It was only a six-step macro and did not take up...

Ken, Tried it and only gained 4Mb more. Find that the 'Access-Bloat' phenomenon can make the MDB double in size , especially during a development cycle. That is why I have set it to compact-on-close. This application is going to be distributed outside of my office, so setting the MDB to...

Thanks LittleSmudge, When I first started the development of this application, the images were Linked rather than Embedded and then I did not like the annoying 'rendering' box that flashes on the screen while the form is loading, but I did not realize how much space Linking would, in fact...

I have an application that is complete. The tables are linked to another MDB, but the forms, queries, and code are included in the applciation MDB. The size of this single file is in excess of 70Mb when compressed. Upon exiting the MDB is compressed each time. On slower PCs this takes about...

I have downloaded an example for paired listboxes from http://www.helenfeddema.com/pub/Controls 2000.mdb. It works well for a single selection, but I want to implement it as a pair of multi-select listboxes. I have changed the listbox parameters as extended multi-select fields and have gotten...

Duane, Thanks for your help. Discovered that there is not much online help on multi-column reports in Access. Nothing at all either in the two Access2000 Development books I have either. It is interesting that I have found most of my Access Dev help using this forum and have pretty much...

I have a report to be created will need to look like: Date Hours Date Hours Date Hours Training Course #1 02/01 2 05/20 2 08/20 2 Training Course #1 04/01 1 05/10 1 04/20 1 The data comes out of an activity table in sequential record format by...

I want to build a form using two listboxes. The list box on the left would contain all of the records from a query of a lookup table, but without the records either previously selected or moved from the left list box to the right. The intent here is to use the left listbox as the master list...

I've seen the threads for allowing a multiple selection in a listbox. How would you select multiple records in a listbox of 200 records based upon a table query? This should display a list of records with multiple selections previously saved in the database table. For example: Dim qualList As...

Thanks. Will try.

I have a form that has a starting date (txtStartDate) and a stop date (txtStopDate). How do I set up a for next loop to enter each date as a value into a table?

Tried that already. I think the problem lies in the fact that by clicking from one tab to another, the records in the previous tab are not saved to the database table and when the second tab is opened the records it seea have not been refreshed. How would you save the records in a tabbed form...

I have a tabbed form with four forms attached; Employees, Station Manifest, Daily Roster, and Activities. The Daily Roster form is unbound but are populated currently from a query. All but one of the fields on the Daily Roster form are locked, since they are read from the table query. I have...

How do you make combo boxes in a continuous form operate independently for each record in a subform? I have a combo box that is populated using a query. When I pick a value from the list, EVERY combo box for each record changes simultaneously rather than being able to select a different...

I am following this example in an app I am building where a button in one of two subforms that is located on a tabbed form. It is to be tasked with the ability to set the visibility of this subform to false. I have the following code in the click property of the button...

Access 2002 (10.3409.3501) SP-1

That did it! Thanks [medal]

Lets restate it another way. How do you set up a relationship between a date field in a Master form and a start_date and end_date in a Subform? I want to input a date into the Master date field and have the Subform respond with records that are between the start_date and end_date. For...

Well, almost. How do you you write the code block to set up the LinkMaster and LinkChild relationships using a SELECT statement from a table? Do you use a Filter call on the subform within a Subform_Enter block?