Search results

I have a report that is based on a table. Pretty straight forward so far. I have the design and layout that I like with the appropriate fields. I have several queries that are based on that same table. Each query outputs the same fields. The only difference is that they differ greatly on...

See Attached Db's (Filtering Form Using Query) Please find the 3 attached MS Access 2000 databases that have been considerably simplified in order to demonstrate my dilemma. I want to know why Db1 works and Db2 and Db3 do not. The desired result is to run “Macro1” and have it perform the...

I thought that the report ran the query automatically, but it didn't look like it was doing it. You were exactly right on that the underlying tables were not being updated. I don't know if it's considered good form or coding practice but I just put the following in my VBA code before opening...

I have a report that is based on a query. When I open the report from a VBA module, the report does not show the current values in the query. Even when I switch the report into Design View and then back to Report view, the data stays the same (OLD). If I manually run the query, close it, and...

I could try that, but I can't open the '97 database in 2000 to even view the objects. I'm going to have to have access to version '97. I'll look into purchasing it since I appear to need both of them.

I have seen the database in action and it doesn't have a switchboard. Assuming I tried the "Shift key trick" correctly, I got the same response - - - a blank screen. I held down the shift key and double clicked. It prompted me for conversion or opening. I tried both options, also holding...

I have a database in ACCESS '97. I tried to convert it and/or open it in ACCESS 2000. It asks me if I want to convert or open. Either answer results in the same thing - - - a blank screen staring back at me (No database present). I've waited up to 5 minutes and nothing. Its not a very big...

I'll have to put this into my specific application, but the reference you gave me looks extremely promising. It also answered my question about ADO and DAO (it appears to be dependent on the version of ACCESS). I'm using ACCESS 2000 to develop the database but plan to run it at work using...

Thanks!!! Let me take a look at it, and I'll let you know how it goes. Where can I read up on the advantages of ADO vs. DAO???

I think I would like to work with either the DAO/ADO recordsets, but I'm not up to speed with them. The help files in ACCESS seem to refer to the "recordset property", but always in the context of FORMS. Can you point me to any sample code where I can get an idea of how to work with these...

If I need to edit data in a table via VBA code, do I have to operate on the data through the form object or can I do it directly to a table. I've tried it for data on a form, but it doesn't seem to work when I tried it directly on the table that a form was based on. The reason I ask is because...

I wish to have a command button on my form that invokes a file browser to allow the user to search for the desired file. I then want to store the path and file name in two separate fields for later use in addition to storing the full path in a hyperlink field. My main questions are: 1)...

Pat, Thank you for your blow-by-blow explanation. I tried it out on a mini database and I now understand. Thanks to everyone for their responses. It took me a while, but I'm much better off. Thanks again. End of thread.

I'll work on trimming down my database to post it if I need to (and thank you for the offer), and I'll have to get permission to post it, BUT..... I will make the following comparison..... My database holds more than 255 pieces of information about a person. This could be the person's height...

Rich, Thanks for your patience. Yes, I've looked at some of the databases supplied with Access, but maybe not the one I need. Or, I may just have to think about this for a while. I follow your company/products analogy, but I haven't been able to map it into what I'm trying to do. I'll go...

Thanks for the pointer to that list of articles. I hadn't seen that before. However, my data structure does not repeat information from field to field. The only duplication is the field that links the tables together in the relationships. I actually have thousands of fields that hold data...

From my experience, Access has a limitation on the number of fields for an individual table (255). General Questions: Is this accurate? If so why? Query time performance? Any work arounds? Does this limitation apply to queries as well? My Specific Application: I have created a database of...

I read that Access saves the formatting of a report (ie. margins and landscape vs. portrait). Sometimes it remembers them and sometimes it does not. The database is used by several people and I need to ensure that when someone opens a report it is brought up in the correct format. Is there a...

Thanks for your attention. I finally got it solved. My stacked graphs are now showing up. You're suggestion made me take a closer look at the table I was using as the source for the chart. It was not structured correctly. Thanks again!!!

I am using a chart in a report. I tried your idea of changing the chart type, much like I would in Excel, but it did not respond. I tried moving the data to be in one field with multiple records AND with one record and multiple fields. Neither appear to work. The chart retains individual...