Recent content by skate

Are there any issues with converting an older 97 database to 2003? Is it a straight conversion, or will there be differences that affect the way the database will run if converted? I've read somewhere that it is possible to use the newer version to open the database w/o converting it. It...

I wonder if someone can give a suggestion on how to start this database. I am doing a material list database, but i've come across a situation where certain materials require a lot of text entry as opposed to some of the others where you simple enter data such as " density, grade, strength...

this may be a simple question, but i just can't figure it out. I have a database who's entries need to be cleared to zero at the end of every year. I would prefer to do this than just delete all records as there is some data that needs to be saved. I can't simply highlight all the cells in...

I have a write conflict error. I have a subform that adds 10 records and displays the data in a field in the main form. Data from the subform is based on one table, however b/c there are so many datafields in the table, it would not all fit in form view (at least in the format I need). So, I...

I have a form that views one record at a time. I want to create a button that opens a specific text file (eg. word) depending on the current record. I was thinking it would be along the lines of Shell "C:\Folder1\Folder2\mydoc.doc", vbMaximizedFocus but possibly having a variable for the...

I found some code as to how to merge access data to word to create mailing labels. The problem is not only does my word doc open, a new one opens as well as two more access db's. How do I stop this? I just want to have my original db open, click a button and a word doc w/ the mailing labels...

what does it mean to normalize a table?

thanks so much! that's exactly what I needed

where do I find the detail print event? Or how do I use it? I can't seem to find it in the help menu... (sorry, beginner)

Basically in the report, if MOrder=1 TextboxA.visible=true; MOrder=2 TextboxA.visible=false. I put this code in the report. The report is opened from the form by DoCmd.OpenReport "ReportA", acViewPreview, , "[MIndex] =" & Forms!FormA.MIndex MIndex is the Key field MOrder is just a field that...

I am having some problems regarding using code in a report (as I've never done this before). I have a function that makes a textbox visible/or not depending on the value of another field MOrder, which is somewhat like an index field but can only be a number from 1 to 12. Normally the report is...

How do you make a button control enabled/disabled depending on which tab is being viewed? I've tried Tab.enabled and TabMenu=0, but neither work? I've put the code in both current and the control click but it doesn't work

I have a combobox in a form that displays the record and all it's entries based on the selection. How do I make the form load a blank record so that none of the fields are filled?

I have a form displaying the values for a record. A combobox displays the selected record. The problem i have is everytime you add a new record here and go to the combobox it is not updated and put in the list. When I close the form and reopen it is there. I put the code: [Combo1]=[Company]...

actually I am storing a number as text b/c it is actually not a date but a job number that begins w/ the last two digits of the year. Using a text is my only way to overcome 026013 not changing to 26013, but then I have the sorting issue.