Search results

I was trying more testing with the packaging toold that comes with the developers extension. I packaged my database and everything worked well on the computer without Access 2007. However, when I made changes to the FE and wanted to update the deployed version. I could not overwrite, delete...

I have been working with a client who is looking to expand on the original capabilities of the database. Basically he would like to be able to access his data remotely. Background: Database is designed to track donors who contribute to various charitable funds. The one table is loaded with...

I've done this tons of times but for some reason I cant figure out whats wrong. I have a query where criteria is passed through a form (frmContactFinder). After writing the query I tested by using "Run", I was prompted to enter First Name, then MI, and then Last Name. I entered a valid name and...

I've never thought about this for the back end. I usually just provide detailed instructions, stating that after clicking Extract All files, input "C:\". Then again I am using Windows Vista and 7. What are the pro's and con's of using something like UltimateZip vs the manual method I mentioned...

Thanks Bob, your a great help! I think I even bought a book based on your amazon review awhile ago!

I have a packaged database that runs smoothly on the network. However I would like to be able to have the option to export certain queries to excel for "one time" analysis from time to time. The computers this program is installed on do not have MS Access and thus are running Runtime. How can I...

I could be completely wrong but that action should look more like this: Private Sub cmdOpenQryALL_Click() On Error GoTo Err_cmdOpenQryALL_Click Dim strDoc As String strDoc = "qryBatches" DoCmd.OpenQuery strDoc, , acReadOnly Exit_mdOpenQryALL_Click: Exit Sub...

Okay lets try again. In Access Create a new query using the Query Design Now select Table "Oregon Cities" and click add Double Click the two fields ( Cities and County) to add them to your query In the criteria line under city, enter: [Forms]![frmName]![cboCity] "[frmName]" -- This is...

You will need to create a query based on your table that contains City and County. Such as criteria for city would be: [Forms]![frmName]![cboCity] This would return the correct County or counties with the selected city. I also assume that the City and County selections will be done by use...

I have had a similar issue with Access 2007, however, I went with the theory that the computer was old/not updated with the latest windows updates. I did realize that if I hit refresh (F5) the graph would show on that computer.

Geeeeez! I won't be making anymore jokes ever! Anyway, all of the information given is highly accurate but after clicking the link I felt that someone with no knowledge of normalization would still be left confused and thus the joke. Although Bob and Banana's (and msft) answers are correct I...

It means you should split up your tables into dozens of tables, preferably no more than 2 fields per table (not including a primary key):D

Scooter, thanks for this! my brain stopped working as this is a massive table with over 300K records and endless fields. It's really ridiculous, and had you not suggested your answer I was going to to do a query that searched for donors who did not meet the requirement. And then use a find...

For more extremely limited and minor security, you might want to consider hiding all of your tables, queries, forms and reports. That way even if they "accidentally" open up the view pane, they wont see anything. Now if someone is intent on seeing and manipulating your DB this will do absolutely...

Not sure exactly how you split your database or what version of Access your are working with. However, if you have your original unsplit database try this: Open your "Unsplit DB" Open a New Access Database Copy all of your tables in unsplit Paste your tables in your new access database...

Seems resonable. This got my curiosity because all of my very few clients either only need a single user or I set up their network also. However, the "suitably empowered user" part of option two, leaves me with a bad feeling, LOL.

This is an interesting question.... what if you were to supply the front end using Access runtime, how could you possibly link the data if you haven't already put the back end on the server????

Trust me I know the client pushed excel to the brink, with different people adding to the monster over 6 years. So they have provided me with all of this wonderful data in one table!

Currently my brain is fried and I can't think of a way to qrite a query that is based on multiple fields. Example: 5 Fields: Donor,2002D,2004D,2006D, 2008D - Donor is the names, other fields show if they donated that year (Y or N) Question How do I query to bring back records that show...

I am using my network to test before I deliver to my customer. Although this is happening on only 1 of my 4 machines, I don't want this problem to creep up again on my clients network without me having an explanation. Currently the data is being stored on the "main" computer in a "public...