Recent content by Rainbowhawk

The db is written to their C drive as part of the process, however the admins need to be able to update this information on the fly. I have added a version number to the data set that highlights if its older than the established version and prompts them to update. They access the data through...

Hi I have already hidden my tables by holding them in another db and linking to them, I now have half a dozen queries, with just one output query, however I don't want the end user to access the feed queries.

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...

The current query no looks like SELECT Forecast.Article, Forecast_Detail_Working.FYear, Forecast_Detail_Working.FPeriod, Forecast_Detail_Working.Qty, First(DateLookup.CalDate) AS FirstOfCalDate, ASPProjected.NewASP AS Price, ASPProjected.FromDate FROM ((Forecast INNER JOIN...

It would work well in excel, however the bigger picture is requiring a full access solution, Think the solution involves finding when next price starts and using that a between query, however not sure how to obtain this, as this may or may not exist when query is run

The output of this is forecasted revenue, the selling price varies sale to sale and is not finalised until after the event, we are forecasting based on pending orders, these are then set against a price which is an average of previous sales, however we also have planned increases coming up, and...

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, Replacing the line Public Property Set ViewS(ByRef ViewA As Boolean) with Public Property Let ViewS(ByRef ViewA As Boolean) worked Many thanks

It was working until i added the set and get procedures, Will try to replace set with let and see if that works

Hi rps is defined as Private rps As ReportPrintStatus This is the name of the Class module the full class module code reads as Private WithEvents mrpt As Access.Report Private WithEvents msecReportHeader As Access.[_SectionInReport] Private mintCounter As Integer Private ViewC As...

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()...

Cheers Guys will give this ago.