Search results

Hello, I am having an issue with the display of a crosstab query in a report. My query is based on a date renge entered by a manager Where date between[pbegindate], [penddate]. It groups by worker and branch (row headings) and displays the date(s) across the top as a column heading. The...

Thank you! looks like I have some reading to do!

Is it possible to retain lines in a Report Header when exporting to RTF and if yes, how? Many Thanks, Ksaab :p

I have tried to bring everything into a blank DB to no avail. I will however try to update to version 8..thanks for your help so far..

Thanks for your input, I agree with the work around on the first two messages - it is the last two errors that really hurt - since it is inevitable that they happen and my DB shuts down..

Hi friendly people :) I am running Access 2003 and office 2000 on an XP install and am encountering the following errors.. "Security warning: Unsafe expressions are not blocked" which prompted me to install new MS updates - which I did. NO use. I still get the error when I open any Access DB...

I would like to know how to make Access more able to deal with special characters found in languages other than English. I do a lot of importing /exporting from text files on an international level and haven't yet found a way to make Access keep characters well. Is this something I do at the...

Yes, thanks but I am aware of that. I really would like to know what types of underlying issues create this though.. in this case I have an access DB being connected to via ODBC using a VB6 application. The VB app gives me the error. The Access DB opens but is not fully functional (some...

I am getting this error and need immediate help...please! Run-Time error '-2147467259 (80004005)': [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

Nope...it is not a link issue..I tested and relinked.. Thanks though!

Hello, I have several split DB's in Access 2000. Typically we use a template Data.mdb and Forms.mdb and import data into them..customize the forms..make a few .mde's for users.. For some reason the following error is happening on several PC's when attempting to open the Forms.mdb...

On your form right click on the Combo Box.Click on the properties Click on the Event Tab. Go to where it says "On Change" click the "..." to build an expression in VBA. You do not want the "builder" just open a new event procedure in VBA. Access will fill in the Heading and ending like this...

Yes, I too went through and tried to make a map to analyze all entry points to the DB from the MDE. In my case the MDB is hidden and the MDE's are the only thing available to the users. I know someone could feasibly "unhide" objects and "find" my MDB's on the network. Unless there is some...

I have an Access mdb database with several mde "front ends" set up. It has tblCompanies where primary key = CompanyKey and tblNames where primary key = NameKey. There is a one to many relationship from tblCompanies.CompanyKey to tblNames.CompanyKey. Somehow this relationship was...

Try selecting the excel table save it as a .txt file. Then go into your Access DB and import it with the text wizard. Make sure all fields are datatype "Text" when going through the Wizard process. Once imported as a new table you can open your imported table in design view and change any...

I have a series of split databases each with separate forms databases and data databases. Example: Data: Names.mdb has all the data and no forms Form: Names.mdb has all the forms and only data via links to tables in Data:Names.mdb. There are several of these setups, and each one has...

I can do "Not is Null" for several strings but must do it on so many that it makes the Query too slow. I end up with several boolean OR's. I am hoping t o find a way to update based only on incoming values being "Not null" as a rule or script.

Question: How do I write a (very Large) query to exclude any updates where the "from" field is null ? Must I alter each Criteria line manually? I am lazy and trying to avoid this...can I write a script or macro to do this each time I need one of these large queries? Any help appreciated....