Search results

Thank you kindly CJ, thats the information I was looking for. I understand the situation of the custom temp file being manually deleted/renamed but still hoped the first switchboard form would be safe.

I think a few of you have missed the end of my original post and just answered the Topic Header. Database loads to a switchboard form first, what does the user want to do in the db.. open the form that adds a new employee or open the form that runs x report? Before ANY records are even close to...

Hi folks, I'd like to understand what causes errors when multiple users simultanously access an unsplit database. Is it just that the database file is accessed or when changing records? I want to make an db and keep it unsplit for now during the design stage. However I also would prefer to...

I appreciate this is an old (VERY old) post, but it popped up whilst I was searching. Eventually I found this solution to set any attribute of all controls of the same type... Dim cCont As Control For Each cCont In Me.Controls Select Case TypeName(cCont) Case Is = "Page"...

Thanks for the input guys - appreciated. I hadnt considered the export to Excel idea because frankly I have a genuine need to make this absolutely as simplistic as possible, to be used by technophobes to put it politely... click, done!! Will keep you posted how it goes.

Hi, I have a subform in Continuous Records format (records displayed are determined by controls on the parent). I would like to create a button that prepares an email and copies the contents of that subform in to the body of an email message. The email I have a method to create a new email, set...

Hi folks, I have a report that lists peoples names and login IDs and there is also a mugshot of that person. (As well as other detail, but thats not important). • The image file name is the same as the login ID. • The rest of the file path is in a non-visible control called txtPath...

I appreciate this is an old post but similar problem, this solution of pop-up / normal window type didnt work for me... On the Form_Load event, I run a series of checks to determine the day and even windows user login ID etc. My form is essentially a list for user sessions. One record per user...

Perfect - thank you :)

SELECT tblInbAisleAudit.AisleID AS Expr1, Max(tblSession.AuditDate) AS MaxDate FROM tblSession INNER JOIN tblInbAisleAudit ON tblSession.SessionID = tblInbAisleAudit.SessionID GROUP BY tblInbAisleAudit.AisleID; In tblSession I also have a field called 'Auditor'. I would like to include this...

Because the fields on the form are blank, the query is searching for blank records in the table. If the form fields are completed, use that data as the query criteria (for instance 'Auditor' or 'Audit Date'). If the form fields are blank, include ALL records (for instance 'PalletID'). SELECT...

In addition to showing the maximum date, I would like the query to show the name of the person that actioned the last date activity but ONLY for that last date, regardless of who did it. My code below returns the last date that an audit took place for each individual auditor. eg, Aisle numbers...

I would like a query where the search criteria is populated from a form - pretty simple so far. However, I would like to include ALL records where the data on the Form in blank For instance, Form fields... Name: John Smith Date: [blank] Result... All records for John Smith, regardless of date...

Thanks for your input Stopher - all sorted. Solution in case anyone else has the same problem... When I copy and pasted the controls, of course it left the original ones in place (remember I used copy and paste, not CUT and paste). Once pasted correctly on the Tab, it gave them a whole new set...

I would like to add a reply to thread 27700 but when I go to it, I am logged out :confused: I have a Tab Control on my form and have recently copy-pasted my controls on to it - however my VBA no longer works. From what I've read, each control (regardless of which tab its on) needs a unique name...

Thanks for your reply Guus. Sample db/table in image... List of customer quotations which, among other info I've omitted, includes both a received date (enquiry date) and a date when we responded (quote date). There is currently no existing field to simply return the difference between these...

txtQuoteID is the form Text Box thats bound to the autonumber field that generates the quote number itself.

I am eventually wanting to create a chart on a report. Im guessing that the points on the chart are determined by the numbers returned in a query? The Table fields include... • Enquiry Date • Quotation Date I need the query first of all to do a simple sum (quotation minus enquiry) to return...

Can anyone please help with the following. If the file its trying to refer to does not exist, sure enough I get a 'Cannot find file' message box. If the file does exists, the program begins to load Adobe but half a second later, closes again. Its OK with XP running Office 2007 and Adobe Reader...

Sorry.. its not a report. Its a form that returns search results as a Continuous Form with fields all in a line (there are only 3 fields per record).