Search results

Working on redesigning a previously created database. The existing database has a table to store pump station data. The table looks something like this, with no related tables associated with it. (50 Fields) Wasn't me StatinID pk StationGals (16 Pump Stations) StationPump1Hrs (16 PumpStations)...

I have 2 buttons on a main form that select or deselect multiple check boxes on a subform. The reason is when a user selects from a combo box it could populate the subform with 100's of records. I want the user to be able to reset his selection if he made a mistake after selecting all of the...

Thanks to Nigel for direction on this For those of you like me who like to: Hide the minimize,restore and close buttons Show a particular ribbon for reports Create splash screens This is what worked for me: First download this ribbon (FREE). Very user friendly...

I believe i found this procedure on this site somewhere. Option Compare Database Public bolpress As Boolean Private Sub cmdHideRibbon_Click() Dim strform As String strform = "frmStartUp" Select Case bolpress Case False DoCmd.SelectObject acForm, strform, True...

I wish allow the user to enable or disable several controls on a form based on certain conditions during the year. I have no problem doing this when the form is open using a command button but after leaving form and returning the controls revert back to there original state. I would like to set...

I have a query that extracts the month and day of a bowlers birthday for a selected week and year (Done from a form). The query below works fine until the end of the year when the ScheduleDate crossover to a new year. At that point the query wants to include all of the bowlers birthdays even...

After some exhausting searching for this solution in this forum. I found this on another sight posted by Steve Schapel http://groups.google.com/group/microsoft.public.access.forms/browse_thread/thread/989538da2c476b07/5cd980561ac938d6%235cd980561ac938d6 Thought I would post here to save...

I am doing a transferspreadsheet method for a query result in access. I am exporting to the same file every time the method is ran. The problem I am having is I want the results to go to the same worksheet every time but I keep getting a new available worksheet whenever the method completes. ae...

Have searched but could not find my solution. I have a bowling league database and I am doing averages based on games bowled. On certain averages the results are incorrect. Such as Tot pins = 1169 divided by tot games = 6 the result should be 194.83 but the result in my query is 196 have...

Thanks in advance Searched birthday in threads and couldn't figure this out. I have a select query and I am trying to retrieve a birthday that is between two dates. This is how I set up my expressions: chkBirthDay: Format([BirthDay],"m/d") Criteria for chkBirthDay Between...

Not sure what your looking for. But I have a form that begins on start up. This form allows the user to choose a season number from a combo box. Once that is done the form is hidden and all of my queries concerning any particular season the criteria in those queries is based on that form. Is...

I have attached a word doc showing my table relationships. I would like an opinion on as to whether it is normalized correctly. It is for a bowling league that has 10 teams and 50 bowlers. The team names, lane assignments will change every year and the bowlers will be on a different team from...

I am using the outputto method to export an access report to excel. Theres no problem there except whenever i close the excel file i keep getting the message: WonLoss is a Microsoft Excel 5.0/95 Workbook. Do you want to overwrite it with the latest Excel Format. Is there a way to avoid this...

I am trying to create a bowling league db in access 2003. I believe I have started with the right structure but I am having some trouble with recording the scores of the bowlers. Attached in a word doc is how I have set up the relationships. Any thoughts would be greatly appreciated. D.J.

Using access 2003. I have a command button that exits the database as well as quit the application. docmd.quit worked fine in 2000. but now gives me this message in 2003. You Cant Exit Microsoft Office Access Now If your running a visual basic that is using OLE or DDE, you may need to...

Hello all I have 5 different reservoirs and keep track of the rainfall at all 5. I want to total all five together and then only show the maximum value on a yearly basis. But I also want to include the individual fields for the reservoirs in the record. I hope I'm making sense. DJ

Hello All I have a form that I use to select a month and year for a query. I am using two seperate combo boxes. Month and Year. What I would like to do is have the current month and year display in the combo boxes whenever the form is opened. Tried setting the default value to...

This is probably a stupid question. But I've been reading the threads on saving records. I always thought that once you have entered data into a field or moved to a new record that its added to the table. Why would there be a need to save a record? Am I way off on this? Or is this for some other...