Search results

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

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

Hi, just wondering if anyone's got any good solutions for sorting numbers in which 03 (meaning year) when sorted descending is greater than 99. As of now it sorts say from 99 down to 90 then switches to the year '03 to '00. How annoying.

I have a listbox that is populated depend on my search criteria. Unfortunately it doesn't work. I've also made a button called ViewAll so the user can view all the files if they so choose instead of seeing the search results. I figure if i can get this working the rest would be easier to...

now this may sound silly, but I had a form that could search for items based on values entered by the user and displayed in a listbox. It works perfectly, so I thought I would do a "save as" and make a second record searching form very similiar except for the minor changes in labeling and table...

I have a combobox for users to choose from the pull down, but occassionally they find they want to deleted their selection altogether (but not the entire record). Problem is I have an index field that is filled in depending on the selection, which is used later in another form and things get...

I have a db that is split. When I try and access the tables thru the FE the records of this one particular table is locked! Why is this? It's very frustrating.

I've tried searching for this but still can't figure it out. I have a write conflict whenever I close this form. I've figured out that the cause for this is a couple calculating functions that I've made up. Basically all they do is add up number from fields in a subform. I think the problem...

Ok, I've come to the conclusion that there must not be a way to print values in my listbox in a report. I have a listbox that is filtered/populated depending on what letters I type in textbox (eg. find all entrie starting with "tri...") For each entry you can double click to open a form that...

How do I write an if statement checking if a certain tab has been selected in my tab control in my form?

i have an array(9) and want to fill corresponding txtboxes so that array(0) fills txtbox0, array(1) fills txtbox1, array(2) fills txtbox2. is there a way to do this with a loop?

I have a combo box that searches for a record based on the name selected. Each name is associated with an SIndex. Is there a way for it to display a record based on two indexes? The reason is from FormA w/ unique YIndex, all the corresponding records in FormB w/ unique SIndex, are display...