Search results

I've got some code that sends emails from a specific user account in Exchange where the user doesn't need to have Outlook open. However, I also need to send a calendar invite using information from fields in my form Can anyone help with using similar but calling the calendar function to send...

I've been banging my head with this for a few days.. I have 2 dates, one in column J and the other in L, I need to calculate the difference between the 2 dates, however where 1 of them may be blank (this could be either / or), then I need to return "N/A" to the cell. I've tried this, but...

I have a form for users to enter criteria for queries & reports that has 12 text boxes that are either enabled or disabled depending on a dlookup from my Reports table based on the report name. I then have various command buttons so each report can either be printed, previewed, exported to...

Hi I'm trying to calculate the difference in working hours between a start and end date so I can calculate the labour cost for time spent on a job. I can easily do the calculation if the visit is on the same day, but i'm struggling where the visit may span over a number of days. Initially I...

Hi Does anyone know how to change the Caption/Description Name of a query in Access 2007 so that when users run the query in view mode it shows something meaning full such as "Demo Reports Not Input By User" instead of the query name "qrySalesTabDemoReportNotInputByUser" I've tried changing...

I've inherited a clocking in database which enables staff to register an 'In' and 'Out' event based on their fingerprint stamp. The table has the following fields and creates a record for each fingerprint stamp, so I've got In's and Out's on separate records. ClockID - Employee number Name -...

I've got an invoice report all set up which works perfect, however, I'm now being asked to add an additional information line for each item on the invoice but only print it when it has been populated The extra information field is the easy bit, I've done that and added it underneath the...

I've been working at this for a few weeks now but can't seem to get the right results. I have a graph in a form that pulls data from my query based on the current month and year. It uses todays date to find the month and year. However, I am being asked if the graph can be displayed by using...

:)My database has a section where 'quotes' are created based on a 'follow up' and a 'demo' for a specific 'customer' I have a form 'frmQuoteLink' with 2 subforms as we have 2 completely different types of quotes that we do. Each record on the subform contains a 'CustRef', 'CustFlwUpID' and a...

Bit of a tricky one here, sort of know what I've got to do but keep thinking that there must be an easier way.... :) I have several check boxes on a form which represent 'stages' of work to be carried out, along with start and end dates for each stage. What I'm trying to achieve is that the...

Hi guys :) I have a quotes table that will allow the user to create more than one quote for a follow up call to any customer. What i'm trying to do is have a 'Create New' button on the form that will create a new quote, defaulting the custref and custflwUpID to the same as the quote that is...

Hi Sorry if i've posted this in the wrong forum but I couldn't find one specific to excel. I have a workbook with several sheets called "Instructions", "Summary", "Template" and then several other sheets labelled "Company1", "Company2", "Company3", etc. I keep getting a Runtime 1004 Select...

Hi Hope someone can help with this one, I've been banging my head up a brick wall all weekend! I have a form showing a field called 'QuoteDate', I also have a 'QuoteExpiry' date field which I would like to show the expiry date as the end of the current quarter after the 'QuoteDate' has been...

I have an unbound form with 'AllowAdditions', 'Edits', 'Deletions' , etc. all set to YES I have an unbound combobox on the form, enabled is set to YES and locked is set to NO. The combobox looks up a field (DemoNumber) in another table which is working great. I want to use that value from...

I have a form which allows data entry, additions or edits, however, if the field 'COMPBY" is populated, this indicates that the record is completed and therefore shouldnt have any further edits made to it. If the first record is complete, I can click on my next command button (cmdNext) which...

Hi all I've created 2 new forms both based on fields from tblCustomer. The first form is used for creating new customers (frmAddNewCust) and the second one for viewing with very few fields (frmViewCustomer) which uses tab control. An email address field exists on both forms (same field from...

Hi all I have a text box in a form which I would like a user to input a value into and for the database to search for a record matching that value. If the record is not found, then a msgbox needs to appear asking if the user would like to create a new record. I've tried playing around with...

Hi I know there is something about this on here already but I've been searching all day and can't seem to find it. I have 2 tables (tblVehicle and tblBuild) both with a field called "BuildNo" which have a one-to-many relationship set to 'Cascade update', etc Users only input the data into...

Hi :):):) I'm trying to use dlookup to find a suplliers address from the table "tblSuppliers" and insert it into the corresponding address fields in a form "frmPurchaseOrders" So far, I just keep getting "#Name?" in the "address1" field I'm not sure if i'm putting the dlookup in the...

Hi everyone :-) I'm struggling with updating records in my table by importing from an excel spreadsheet. I have tblContacts with the primary key being [CustRef] and a field called [OtherEnqSource] amongst other fields. I have 359 records where I want to change the value in...