Search results

Hi, I have a single database form containing Supplier and Supplier Rating. I have all the records sorted Ascending. I need my report to have a box that Averages the rating#(in the form) for only the records specific to Supplier field. I hope this is making sense. I am assuming that an...

Yeah I want the concept of the combo box. How do I design it?

I am designing a form and I want a part number to link with its description. Can I make a special kind of combo box or something? Goal: So when a person puts in a part number, it already links to the part description. The need for this to be linked is so that there are not 10 descriptions for...

Hello, Can anyone recommend a easy to understand Access Program Help Book? Im thinking in the lines of an "Access for Dummies" type of thing. Thanks. john

Like a Tylonel 4....Thanks!

I got it to work, but it doesnt look like the example. I get the message for parameter 1 and then parameter 2. After I enter that I receive the report fine, but how do I make the pop up window to enter in the information to then preview the report? Thanks john

I have two Access Programs installed on this computer. XP and 97. I need to use the 97 version for older files and didnt want to convert them. Im on a network here at work and never wanted to take the risk in losing something. My problem is that 97 crashed on me and so I tried to unistall it...

I have a very standard database and want to make a report that shows certain records from a perticular month or time frame. I loaded up the demo "Time and Billing" from Access XP and in there is an example of exactly what Im looking for. Its the "Report Data Range Form" to preview a report. I...

I tried to import the Excel file into Access but I received 2 errors in the form of tables. Im figuring something isnt working with that. A hyperlink works, but Im trying to make Excel invisible. I maybe just stuck with how I have it now. Thanks for the inputs. john

I have Access XP, but that should open any previous version .mdb file right? Oh, another thing is that my Access XP keeps acting like 2000. Is there a setting to control this?

Its weird. After I finally get the file open and then close it. I can then go to the desktop shortcut and open the file. But if the computer is restarted then I get the same error.

That didnt help.

I feel like an Access Forum Hog, but Im getting this error: Unrecongnized Database Format 'F:\Gage Program\Gage Program.mdb' I have made a shortcut of the *.mdb file on my desktop and thats when I click on it I receive this error. But I can open up Access and then find the file, open it up...

Thank you - Thank you!

I have a form with 4 check boxes. They are all assigned to a table seperately by using the Yes/No Datatype. When I go to Regular view the check boxes are grey until they are checked. Is there a way to make them white always? john

Thanks for the replies Heres my objectives: To have an excel spreadsheet inside of my Access database. The spreadsheet will work like a worksheet where people will enter in data and spit out a chart with all the visual data. The main reason for having Excel inside of Access is for it to be as...

Hi, is this possible? Or am I wasting time? I could use some insight on where to go for help with it. I worked on it all day yesterday and am starting to curse the screen repeatedly. Thanks. john

Hello, My first post here. What I want is for Access 2000 to open up a Excel file, but not have excel open up seperately. I created a Macro RunApp and had it linked to the file but it opens up Excel seperately, so thats where Im at. Ive seen this is possible but dont know how to do it. If...