Search results

Hey All - I have inherited a huge database that needs to be cleaned out. The database is used to keep track of what is in our warehouse. Every container that comes in is given a number and every item coming out the container is given a unique id number. Then things are billed out to people...

I have a database that is access from several computers. On one of the computers the text in the database is huge. It is not because the display setting has huge text (all other applications have normal text). The menu bar is the normal size and some of the reports print normally. But with...

Hey All - I have a database that is being used on several computers. All computers run XP but some run access 2003 and some run access 2007. The database opens and a switch board comes up. This works on all but one computer (running access 2003) which will not open the switchboard. When I run...

Hey All - I have a database that is being used on several computers. All computers run XP but some run access 2003 and some run access 2007. The database opens and a switch board comes up. This works on all but one computer (running access 2003) which will not open the switchboard. When I...

Hey All - I have a database that runs on several computers off a network. The database opens with a switchboard that runs on all but one computer. When I try to open the database I get the error: ActiveX component can't create object. I have tried running regsvr32 with no effect. Any ideas...

Good afternoon - I have a form that opens a report with a button coded: stDocName = "CheckWhenReport" DoCmd.OpenReport stDocName, acPreview The report opens and the code on load is: Me.RecordSource = Forms!RequestForm.QName Then an error box pops up: You can't set the Record...

Hi All - I have a form that uses the code: RecordSource = "myquery". I have also have a form that has a nice drop down list box that lists all the different queries I would like to be able to apply to the form. My question is how do I get the list box value into the code. Thanks! Amelia

Hey All - I have a bunch of queries that all filter the same Main Table in different ways. I would like to have one form that displays the data based on a query that I choose. I found a past thread that mentioned using Me.Recordsource = "queryName" but I am not sure where to put that code...

Hey All - I have a combo box that reads from a table and has 4 columns. The name of the contractor, phone 1, phone 2 and fax. When you select a contractor the phone and fax numbers show up in their own text box. I also have a notinlist command that allows the user to add a new contractor...

Hi All - I would like the user to be able to import a month name (April for example) and then have access convert that name to a number (4) so that I can search for records that were opened before the month entered. I have been using: MonthName(Month([CompletionDate])) = [Enter Month] but...

Hi All - I have two queries that look up information on projects completed. The first looks up month to date and the second year to date. I also have a report that shows both queries - > Project Type, Count of Projects Completed and the Sum of the Cost. The problem - If a given project type...

I have a form with a drop down menu. If the user selects "school" from the drop down menu I would like for a check box to appear. Thanks for any help you can give me! :D ~Amelia

Hi All - I would like to create a report that showed me the number of records in a given query. I do not want to list the record set that is a result of the query. For example I have a query that shows me all the projects that were completed in a given state. Now I want a report that shows...

Hi All - I have a database that keeps track of project we are working on. There are 5 categories a project can be in, the projects are in 12 different parishes, and controlled by 3 different project mangers. I would like a form or report that told me the number of project in each category that...

Hi all - I have a table that is keeping track of projects we are working on. There is a field with the overall cost of the project and a field with the percent paid. I would like a field that calculates that amount still owed. Is this possible? Thanks! Amelia

Hello - I have a database which keeps track of the projects we do. As we complete the projects we change the status to complete and list a completion date. I now need to create a query that will show me all the projects complete in the current month. I tried using >=DateAdd("m",-1,Date()) but...

I have a form that has three different pull down menus. When I click a button on the form it opens a second form that is filtered by a query. In order to allow the user to leave a pull down menu blank the query has 6 different columns. Three are headed with the field name and three are headed...

I have a report that has a button. When the button is pushed a second report opens. After the second report opens I want the first report to close without any other user input. Thanks!