Search results

Sounds good. I will certainly take your advice in the future. Thanks again.

Galaxiom Always like things easier Found another table that was designed like a spreadsheet. Bad idea i agree. Problem is that the data from this table has 25 tank levels. Each tank level is entered every day 12 times a day. If I create a table that stores this data over a ten year period of...

Thanks again. I did as you suggested and renamed the Date to StDate. I realize about the reserved word thing, but I inherited this database and am trying to fix it up (15 years of data). I have a feeling as I delve into the db deeper I will be using several union queries. Thanks to Galaxiom and...

Thank you for all of your help. I have a bit of a dilema. I created the SQL below as you suggested and it works fine. My problem is that included in the Shift table there are 5 more pump stations but some have only one pump and some have none and the gallons are totalized using a flow meter...

pbaldy Does this mean i have to create 16 different select queries to include in the union query as there are 16 different station fields in the original table. Galaxiom Im all ears if you have something. Because I really like drinking heavily

Thank you for your reply. Now all I have to do is to extrapulate the existing 4,000 records to 62,000 records into the new table. Guess what i will be doing this weekend! Besides drinking heavily.

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)...

Thanks BOB. Worked just fine. Like they say. Keep it simple.

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...

Thank you for your advice Nigel I am turning off the buttons on the main access screen not the form. If there is a better way Im all ears. Sorry Bob I will comply in the future

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...

Nigel Thank you for your response. Something I failed to mention originally. The database was a 2003 converted to 2007 db. For some reason I couldn't get the code to work in the converted db. So I created a new db in 2007 and inserted the code. Worked just fine. Looks like I have some work...

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...

Just a follow up to this post. I found that by creating the yes/no field in the forms storage table this did not work because every time the user went to a new record the yes/no was changed. The resolution was to create a seperate table with only a yes/no field in it and one record. This also...

Thank you both for your replies I resolved this problem by doing as you suggested. I created a yes/no field in the forms storage table. I then placed the yes/no control on the form with the visible property set to false. I then change the check box to either true or false based on the condition...

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...

Yes I see your point. Actually the fields i put this code into are short data entry fields. ae: duedate is a month/day entry, another is a currency entry of usually only 100 or less dollars. So the ability to do what you said is really not that much of a problem. In other words the user can...

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...

MStef Thank you for your reply Im familiar with the outputto method but cant use it because I am exporting to the same excel file over and over and outputto replaces the workbook. I can create another excel file that links to the file created by the outputto but I am trying to avoid having two...