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

So upon a little more investigation it turns out that the problem is switching between Access 2003 and 2007. I think the solution might just be to upgrade everyone. Any other ideas?

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

When I open the database a pop-up appears and says - Run-time error '429': ActiveX component can't create object. When I click debug it highlights the line listed above. I have tried google which is where I got the idea to update MDAC and JET. So far I can not find any other suggestions...

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

Private Sub Report_Open(Cancel As Integer) Me.RecordSource = Forms!CheckWhenRequest.FiQu End Sub Works! Thanks! :D

I am not sure what you mean by open event. There is code in the "on click" part of the button and the "on load" part of the report I am trying to open. Thanks! Amelia

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

Figured it out! In the on load code of the Result form I put Me.RecordSource = Forms!RequestForm.Listboxname Thanks for the suggestions! ~Amelia

So there are two forms. The request form and the results form. I have tried putting :Forms!ResultForm.RecordSource = Me.listboxname in the request form I have also tried: Me.RecordSource = Requestform.listboxname in the result form and neither work. Any ideas? Thanks! Amelia

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

Opps I should also post the link: http://support.microsoft.com/kb/197526

I used Method 2 as shown here. Thanks for all the suggestions. ~Amelia

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

If the Immunization_Date is left blank until the patient gets their immunization you can make a query searching Is Null and one that searches Is Not Null.

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