Search results

Hello, I am having trouble with a list/combo box on one of my forms. The form is running from a table that has multiple key fields(three to be exact). Anyway, when I use a list box or combo box for a seach, it always brings up the first record with matching criteria for one field only. I...

Hello all, I have a form named "Main_form" and in the form properties I have set the "Allow Edits" and "Allow Deletions" to no. I have a command button that calls a Macro named "MainForm_Macro.edit". In the macro I have tried to set the value "Allow Edits" to yes on the form. (Access 97) In...

Hello all, I am having a problem with a report and I have exhausted my resources. I have a report that I am running that uses a text box value in a 'where' statement created from a macro. ""[PIR_number]=[Forms]![PIRMain_form]![PIR_Number]"" The report contains a sub-report that brings up...

Hello all, I need to create a report that lists employees and hours they work for the week. I need to create a query that will tell a user how much time they have worked so far this week (starting monday). I don't know how to query my date field to only display the current weeks hours...

I have a combo box in a form. I would like to have the list in alphabetical order. The data in the combo box comes from a table. I have tried arraning the table but it doesn't have any effect on the order in the combo box. Could anyone please tell me how to bring order to my combo box...

Fumbuzled???? Hello all and please help, I really don't know how to explain this, so here it goes. I have a database set up that I would like to have excel spreadsheets displayed onto a form in access. The spread sheets contain pictures of engines. I have multiple exel files that contain...

Hello all, I am having a bit of trouble. I have several databases that I use and I just set a password for database a. Database b uses a macro to access information in one of database a's tables. What is the command that I need to add to the macro in database b to access information in...

Hello all, I have a list of serial numbers in a report. They are listed in rows of 6 per page and there are two pages worth. I would like to list the total number of objects on the list after the last serial number. I know the answer lies somewhere in the group footer, but I can't seem to...

Hello all, I have a group of reports that I would like to insert pictures into. Each reprot has a different serial number and a group of corresponding pictures. The pics are in .jpeg format. How do I set up a report that will show corresponding pictures? An example of a serial number is...

I am trying to print out a range of numbers in a report. Currently I am getting the field's data printed out on seven pages. I would like the data to print out on one page. Does anyone know of a funciton or setting that will allow the data to "wrap" or start a new colomn on the same page once...

I am trying design a report that will list one feild. I want the field to reach the bottom of the page and then start a new colomn on the same page (colomn wrapping?). I have tried setting up multiple colomn in the "page setup" area and I still can't get anything to work. Please help.:confused: