Search results

Is there a way to stop selected queries and tables from being available to excel as external data sources? I am looking for a way to hide them from the list of available data sources to anyone who selects a particular database Thoughts?

I need to pass a variable from one Access Database to another The senario is I have a item number in one database that I need to use to open a form in another database, I can open the database using vba, currently launching a BAT file that copies the latest version database to a local drive...

I have a table of upcoming price increases by item / valid from date Item Price ValidFrom 1234 10 01/01/2014 1234 20 01/06/2014 3456 15 01/01/2014 3456 25 01/06/2014 3456 35 01/01/2015 I also have a table of upcoming sales Item Month Qty Price 1234 Feb 14 20 ???? 1234 July 14 30 ...

SourceIDEFinYEftPTypeSub Type 1Sub Type 2Sub Type 3%change1201411****5220153Air Purifying***7320154Air PurifyingFilters**3420152Air PurifyingFiltersHood*4520152Air PurifyingFull FaceM SeriesM-9849201411Air PurifyingEscapeHoodHood Civic2QuestionsEFinYEftPTypeSub Type 1Sub Type 2Sub Type 3Answer...

Hi All Does anyone have any experince in using Logility? If so does anyone have experince of linking Access to Logility tables? Tim

Hi All I am trying to pass a boolean variable to a class module Set rps.ViewS = View the code in the module that this in theory is calling reads as Private ViewC As Boolean Public Property Set ViewS(ByRef ViewA As Boolean) Set ViewC = ViewA End Property Public Property Get ViewS()...

Hi All We are in the process of upgrading from Access 97 to Access 2010 The database admins have a full copy of 2010 and the general users will have a copy of the Access 2010 runtime installed. The issue is that when a database is opened in the runtime, the ribbon disappears, this is...

Hi All After many, many years we may finally be allowed to upgrade to Access 2003 (we have had to fight to get this far) We have a number of obstacles still to overcome and I would appreciate some advice. We have approx 60 databases with various links and around 150 machines supporting 200...

Hi all I am trying to send reports via email using VB code DoCmd.SendObject acReport, "MOEmailOrderList", "RichTextFormat(*.rtf)", Eaddress, "", "", subj, msg, False, "" However its is intermittently crashing, will work 5 times then fall over for no apparent reason the next 4 times...

I have linked a "table" from AS400 via ODBC, however when I view the table in Access one field with a list of numbers develops a small issue numbers such as 3880470 are fine however 4242002557649 appears as 02557649E+12 how do I resolve this, NB: Using Access 97 on XP Machines ( I...

Having an issue with an unmatched query, The first part retrieves a list of people who have passed a course and compares it against another query to check that the course has not expired, this is then presented to the end users, however when the query is run it reports This recordset is...

Hi All I have an issue with this piece of code This code converts fuel in litres and Kilometres covered in to MPG However when it writes the answer to the field it is populating the answer is being rounded, field is set as fixed to 2 decimal places. I am using Access 97 (yep still in the...

Hi All Currently got a sumif formula that works =SUM(IF(Sheet3!$A$2:$A$1059=D15,IF(Sheet3!$D$2:$D$1059=D16,IF(Sheet3!$E$2:$E$1059=D17,IF(Sheet3!$F$2:$F$1059=D18,IF(Sheet3!$H$2:$H$1059=D19,Sheet3!$L$2:$L$1059,0),0))))) Where D15,D16 etc are drop downs that allow me to filter the result...

Hi Guys I need a way for any database that opens to Load one of two reference library’s depending on the Operating System version For various reasons we are forced to run Access 97 across all machines onsite, however due to recent hardware upgrades we have some machines running Windows 2000...

Hi Guys Does anyone know if it is possiable to caputre and store what a user inputs into a search box. I have a button that focuses on a field and then opens the search dialog, but I could do with being able to capture the information they are looking for. Me.fieldname.SetFocus...

Hi all, One of the databases we use on site has disabled all the menubars when I open access I have tried to use the shift override however this does not resolve the issue I have also tried Application.CommandBars("menu bar").Enabled = True This works while the database is open but the...

We are encountering intermittent problems printing out certain reports on one of our databases. The issue is that occasionally when printing we get just the one sheet with IB in the top corner instead of the report we have pressed print for. We have noticed that this is more likely to...

Silly Question of the Day, Does anyone know where I can get a csv file of quotes by famous persons etc, The boss has decided that it would be a good feature to include a random quote everyday for the database users. Hawk

Morning All, The company I work for has decided to send me on a MCDBA course and has asked me to choice which one of the elective modules I wish to do. My choices are Visual Basic .NET for Web 70-305 Series Visual C# Web Applications 70-315 Series Microsoft .NET Applications 70-316 Visual C#...

Hi All I am currently building an email using the code below, ugly but it seems to work in general. the problem i am trying to overcome is the fields [DailyExceptionReportV3]![Items subform5].[Form]![Item] and [DailyExceptionReportV3]![Items subform5].[Form]![Products] only give the...