Search results for query: *

Well, nothing worked. I don't have time to keep fighting this. She only has 1 Access program that uses Access security so I just joined the workgroup thru the workgroup administrator program. At least she can do her work. I hope to get that onto a SQL back-end before long, but I still wish I...

Thanks. I'll try that tomorrow. I'm goofing off this afternoon. ;-)

Hello. I have someone who has the following command line in her shortcut (and it worked on her previous computer): "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "F:\QC DB\QC WORK STATION.mdb" /WRKGRP "F:\QC DB\Secured.mdw" (yes there really are spaces in the path and filename...

Everyone, If anyone thinks they know the answer, please post it. But don't work too hard, I have a workaround. I am just going to delete/rebuild that particular link in my code. That seems to work fine. Thanks.

Sorry, my answer won't work as I didn't notice the ">" sign.

Hello, I am having trouble refreshing the link to an Oracle view from Access 97. I refresh links to some Oracle tables successfully, but not the view - I just get a long wait and a generic "ODBC Error" message. I have included the relevant code below. (I have tried the refresh of the view with...

Something very similar to this should work: For the criteria part of that field in the query, type: [forms]![frmName]![selectioncriteria] ..just replace frmName with the name of your form. This won't cover the "like" that you want to do but will give you exact matches. I'll try to get back to...

Sometimes there is something to be said for "low-tech"!

You'll have to use a form that calls the report and put the dropdown on the form. The form would open the report, sending it a filter based on the dropdown value.

Working in a copy of the report: I would delete all of the subreports, if there are any, and then run the report. If it works, you know the problem is one of the subreports. Just figure out which one and then try the method below. If no subreports (or if you determined that the problem is a...

If you just run the query (as opposed to the report), do you still get the error?

PJName, I would back up the MDB before trying this: Have you tried running a "Compact and Repair Database" (under "Tools", "Database Utilities" and doing a decompile? To do a "decompile": 1) go to a DOS prompt and type: "<path to Access>\msaccess.exe" "<Path>\<Filename>.mdb" /decompile...

That looks like a Windows error message, so you will probably have to fix the underlying problem rather than suppress it. Are the tables pointing to a back-end server of some type, like SQL Server? Perhaps that server is getting restarted (or the SQL Service is getting restarted) at night.

JJJ, Is Microsoft Access an option for you here? This could be done so easily in Access using the .Columns command.

This should be one way (I'll just use one block of your code as an example). Change: .ActiveDocument.Bookmarks("bfirst").Select .Selection.Text = (CStr(Forms!frm_quote!bfirst)) to if not isnull(Forms!frm_quote!bfirst) then .ActiveDocument.Bookmarks("bfirst").Select...

If either of those fields have a single quote in the data, you need to change your code. Wherever you have a single quote, replace it with 2 double-quotes: Criteria = "([OffTypeDesc] = """ & frm!cboOffType & """) And " & _ "([FileTypeDesc] = """ & frm!cboFileType & """)

The startup option mentioned by Scorpio above is probably your best bet, but another way would be to create a macro called "Autoexec". In the "Action" column, select "OpenForm". For it's properties select your form's name next to "Form Name". This macro will execute each time you open the database.

Correction: Change it to: Set rst = CurrentDb.OpenRecordset("SELECT * FROM [CreditFile] Where [CreditFile].[ProjectID]=""" & Me.[ProjectID] & """)

Is [CreditFile].[ProjectID] defined as a numeric field, or text? If text, change: Set rst = CurrentDb.OpenRecordset("SELECT * FROM [CreditFile] Where [CreditFile].[ProjectID]=" & Me.[ProjectID]) to Set rst = CurrentDb.OpenRecordset("SELECT * FROM [CreditFile] Where...

Thanks for the info. I've saved your notes. Hopefully I'll get back to that project soon.