Search results

My head is spinning from reading posts from every website on the best method for deleting dups. I could use some direction on the best method and sql/vba code to do this: I have two dbs, I want to merge these 2 high school tables. Problem is each table has dups and then I want to merge as...

I searched all over for a good example of filtering a recordset then refiltering and want the most efficient way of handling the following: I have query returning all people as level name 10 smith 20 jones 20 jackson 40 simpson so my db.OpenRecordSet ("qryAllPeople") will give me...

I have a client with their access db on a virtual machine running only access. They use a terminal service to connect. This pc does not have anything else installed. No outlook, no other apps. I need to send mail and am required to use smtp. I have the code to send via smtp 2 different...

Any suggestions on making a gantt style chart for reservation system? I'm thinking of doing cross tab so I can sum by room number, but could use your help so I don't spin my wheels on crosstabs as they are so much fun :) also-I was thinking I need to sum by week in the query to create the...

All I want to do is run a make table query (or append) and show the user how many records were processed. If I try to set recordset equal to the qdf.Execute I get the Compile error "Expected Function or variable". I'm not sure what I'm missing...I've searched numerous threads and tried...

We use dreamweaver for our website development. We wish to have users register and log their downloads of pdf's in an access database (web host won't support mysql). I then want to extract the user info to create new records in exchange public folder or append to a user a note showing what they...

This is a real mind bender. I am running a2k. I am merging two databases. table1 is in the backend database. table2 is linked to the second database. I run an append query to add table2 entries to table1. The append fails for 96 recs saying key violation. Turns out I can rerun the append if I...

I need your opinion/comments - We are looking to consolidate four copies of the same A2K db into one sql server db. Naturally the access db could use more normalization. Heck, two main queries are at the maximum number of fields allowed in access! I tried importing into SQL server and the main...

Can A2k run over a 1.5Mb line? Would A2002/2003 run better? Any network parameters to tweak for speed? Any registry settings for Access worth trying? Splitting it to a fe/be did nothing for performance. It actually ran slower ;) I read other threads and will try to turn off name auto-correct...

I have a toggle button which is supposed to flip the form from 'view only' to 'edit mode'. Problem is once .Allow* is false then the toggle button is disabled. I had a break point in VB and it never was hit. I tried pushing the users to click yes/no on an Update Record question (Forms...

ANything to watch out for?? We have a database where most users would simply run w/ menus & forms. So standard /runtime. I want to split the database to fe/be's as follows: 1 BE - obviously 1 FE - typical users. Will sit on shared network drive 3 FE's - for the three power users so they can...

I tried GHudsons ExportDatabaseObjects code but fails in A95 with an unknown method: Application.SaveAsText Does anyone know the correct syntax in A95 to export report&form objects to text. Or the code to export the objects directly to another db from A95. note: I can not bulk export from A95...

The first field in the subforms are highlighted. Is there a way to turn this off? The field should only highlight when the user tabs or clicks into the subform. Thanks!

I have a popup form, whose result value is used on a form. I then want to refresh a subform linked to this value. A requery is not good, because I don't want to prompt the user to update. The refresh/repaint of the subform does not work well. In Main Form: DoCmd.OpenForm strPopupForm...

I have a database which can perform a mail merge on my windows 2000 machine running access 2000. I moved the db to WinXP machine running Access2003 and I can NOT get the mail merge to run correctly. I tried OLE, DDE, ODBC. No luck with the merge within access. No luck running a merge from within...

I wanted to close the backdoor Admin user (default system.mdw) to ensure nobody will copy the db & mess around. I tried it manually but did not work (move Admin to Users group & remove permissions for Users group) Then ran the wizard and like magic the db is now secure. So what else is the...

At my client's site they have access95 running on some client pcs. They tried to open/convert it to 2000, but received an error message. We tried to move the database and open up privileges, but it still points to the g:\users.mdw file, not our new d:\users.mdw file. Where do you change the...

This one will stump you! I don't think there is a way to fix this problem! Help! I have a database and made some changes to queries, forms, reports, and vb public module. The easiest way for me to move it into production is to simply rename the old objects and import the new ones. (Yes I know I...

Does this error occur with Access 2002/2003? Other Instances of Access Hang When One User Has a Table Locked Background: The access db is on a network drive. I ran an update query and need to use the task manager to kill the process. Shouldn't the query timeout...or continue to try the update...

I read numerous threads on the "You do not have exclusive access to the database..." error and have a few questions: I do not want to split the db for the five users. If I set the users group to read/run access for forms and queries I should never get this error message when I log in as Admin...