Search results

Using Access 2013 I have a form of continuous records with a custom search/filter text boxes in the form header . In the date fields I have purposefully formatted the display of the dates as dd-mmm-yyyy for the avoidance of any doubt so 01/10 shows as 01-Oct instead of 10-Jan. However when...

I will apologise in advance - perhaps this is the wrong time of night, wrong frame of mind... my head is just mush - I should know this!! How do I get this query to return the number of people that attended each event? The Expr = number of people (eg MemID #7 had a 'plus 2' of non-registered...

Hi All. I have a query and one of the fields is an expression that returns a number. This number represents number of days between 2 dates and is called ExprDaysDiff The query draws fields from many different tables and the Report on which its based already includes a first level of grouping by...

Hi all. I would like to have a way to build recipes and see the nutritional content for both each ingredient and the overall recipe, live, as the numbers are being entered. The small figures in pink are bound to the MasterFoodList table that has its values stored at the 'per 100g' rate and will...

Sorry if this has been covered many times, I just cant get to grips with it using others data and syntax... I never know what is a table, field name or the name of a control. I want to update a particular record in a particular table with the results from a VBA variable. In the table tblMySys...

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

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

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

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

There is nothing special in my report, the text box refers to a specific text field in a query. • The 'Can Grow' and 'Can Shrink' properties are both set to Yes. • There are other text boxes on the same line but even if I move it down so there is nothing on the same line, or even delete all the...

There is nothing special in my report, the text box refers to a specific text field in a query. • The 'Can Grow' and 'Can Shrink' properties are both set to Yes. • There are other text boxes on the same line but even if I move it down so there is nothing on the same line, or even delete all the...

Im trying to send an email from VB... Private Sub lblEmail_Click() DoCmd.SendObject acSendNoObject, , acFormatRTF, txtEmail, , , "YourSubject", _ "YourMessage", True End Sub I have tried both acFormatTXT and acFormatRTF. I've also tried a few others too but didnt expect them to work anyway...

I have created a query thats initiated by a command button from a form and one of the criteria for the query is a 'Like' command. On the form, various option buttons and combi-boxes determine the search criteria and put it into a hidden textbox. Then, the query is run based on the contents of...

I have a query that contains, among other things, the name of X people attending X event and another name (from the same table) who is to act as their 'in case of emergency' contact. However, how can I check using VBA to make sure that the emergency contact isnt also attending the same event...