Search results

Hi I currently have database that provides staff briefings, due to use of a Citrix Server and some very slow local connections there is one table in particular [tblcontent] that is only needed on occasion and therefore I create a link to that table as required via VBA. This table then needs...

Hi I currently have a system that provides staff briefings on a 24/7 basis. I am now expanding the usage over a much wider area but to users who are also spread across three different, non connected servers as they are regionally located. However there will be a need for certain articles to...

Hi I think what I'm thinking of is possible but I can't work out how!! I have a worksheet which is tracking the number of times a uniform is washed so it can be replaced when needed. Between columns E:BD the user simply enters the letter W when they have washed their uniform and a simple...

Hi I have not used the FollowHyperlink method before and have started to use it to open another Access database. The database is one that opens briefly, emails out a report then show a message box and then quits. I have used the following Application.FollowHyperlink "G:\NW REGION OP...

Hi How do I call a variable in a public function into a query. I have an append query and need a variable within a function to append to a field. The function ImmediateCount() has Mill, Low & Total as variable - I want the variable Total to be called Thanks for your help

I have a form for calculating working hours with TOILDate as Date, TimeStart as Date and Time Finish as Date To allow for night shifts, where TimeFinish is less than TimeStart the following vb is used : 'Night Shift Fix - Test' Private Sub Command91_Click() If Me.TimeFinish < Me.TimeStart...

Hi I have a main report 'WeeklyReport' that is currently 7 A4 pages long that works fine. I have an additional report that users a similar layout but different data that I wish to add to the end of the main report if possible 'WeeklyReport2' I have initially added the second report as a...

Hi All I'm setting up a Dbase which will sift through scheduled works from two business areas before sending bespoke reports out to staff concerned. The works list comes as an Excel Sheet which I have imported once to create tables within access with a Primary Key as [WorkID] When a job is...

I need some guidance on how I can do the following: Data will be [Junction] = text such as "M6 J29 to J30" [JunctionLength] = number such as '1.88' Objective If the data includes numerous junctions with their lengths is it possible to feed in a start and end point and get back the total...

Quick question about refreshing a chart on a form. I currently have a chart ICCSChart which gets data from a query qryICCS that simply sifts information from tblICCS by [Date] from an unbound field called [Date] on frmMain. On opening frmMain I would like the chart to update and show that...

Hi Quick one, if [Field1] contains text that is equal to the name of another field, how do i use [Field1] in vba as the field it contains rather than as Field 1. Basically I want to do some on screen calculations and [Field1] will say which field to place the answer in Many Thanks

I am using the output of a qryAVG to import into some GIS Mappring software. At the moment I have a location made up across fields say Field1-3. Ideally I need to merge these into one string such as "Field1/Field2/Field3" so the software can read it. How can I build an expression to do this...

I have the form, frmAddStaff which contains the field - this is in the format User.Name@Email.com. The first part of the address is the Username which I want to add to a further table - tbltm. This contains the field [Username] How can I set up a query that will append the [Email] from the...

I often use the SendObject method in order to automate emails from databases. I also use a number of MS Exchange email accounts and sometimes need certain emails to send from a certain account. Is it possible for Access to set the From field in an email to do this? Thanks

I have a qryLog containing field [Account] I want users in a form to be able to alter the account name used to generate a subform based on which check boxes for example are ticked. These would be Account1, Account2 etc. How can I do this and then have the active subform update itself, maybe...

A quick question about DCount I have a table with field [Location], it contains data from a larger databases of where a job occured. I would like to make a count of the number of jobs in certain locations but the location format can change sometimes. Is there a way to specify a criteria...

I am attempting to update the field [Team] in tbldata using the [Team] field in tblteam. I have added the following expression into the Update To section in the query builder DLookUp("[Team]","tblteam","[Date]=[Date] And [Shift]=[Shift]") Basically tblteam has a [Date], [Shift] and [Team]...

Two stored fields and one calculated unbound text box. When I find the difference between working times like this: ([FinishTime] - [StartTime]) *24 , I should get a decimalised answer but where the answer is say 1.5hrs it only displays 1 in the unbound box How can I get it to acknowledge...

Hi Quick question. I have a form with field [Remaining] which contains the hh:mm:ss of time staff are owed in it. I want to populate two other fields from this one on a form. 1) [RemainingShift] needs to be the hours remaining as full shifts which are 7hrs56mins long 2) [RemainingCost] needs...

Me.TotalSamppe = IIf([TotalRecppe] < 1, "0", ([TotalCompppe] / [TotalRecppe]) * 100) I have used this live in some vb code for a while, not sure why but now its causing and overflow - can anyone tell me why this might be?? Thanks for any help