Search results

Hi I am trying to send tasks to other people using access vba. I had used before in my database but was using early binding and now through version issues of office I am trying to recreate the code using late binding, however I am getting various problems with certain lines of code. Primarily...

Good morning I have a piece of code which creates a spreadsheet using acOutputQuery The coee then opens the spreadsheet and formats .activesheet . Finally I want to turn the filter to 'on' for the spreadsheet but am struggling with the line of code I have tried...

I have been having some problems with Missing Object Libraries in my database, and having searched this forum have realised that the solution appears to be to convert references for Excel, Word and Outlook in vba to Late Binding I believe I have done this throughout my project but am still...

Hi I am trying to create an audit trail of changes to control values on forms within a database. I have found a method on the internet, which has a module to insert the relevant information into a table called Audit. The problem I have found with the code is that if the control is 'blank' or...

Hi I have a database created in Access 2000 File Format using Access 2003. Due to upgrades at work we all now have Access 2010. Database is still a Access 2000 database I have created some reports using the Access 2010 version, these reports only export the report headers to excel. Reports that...

I have a form (frmEnquirySearch) which is based upon a query (qryEnquirySearch), the form is used to search Enquirys and I have a unbound control on the form. This was referenced in the criteria section of the query where I had a field called search that basically created a string of all the...

Hallo I have a form which is used to create job sheets, where the control JobNumber is the primary key in tblnapswork As more than one user can be entering at one time I need to prevent duplicate job numbers being given out by the system. I have a module which should trap the Error 3022 and...

I have posted a couple of times about a loop I am trying to create to populate Outlook appointments, the loop is working but my record selection is not. I have posted the whole code below, but have highlighted the bits that are causing problems The purpose of the code is to create an appointment...

Hi I have a form for creating jobs with a subform allowing employees to be allocated to the job. the main form captures appointment times, dates duration etc. I have some vba code which will put the appointments into Outlook, however I have been asked to expand on this and create an...

Good Morning I am using some code from Accesstips to create an appointment in Outlook, using information from my form JobNumber. Now I have been asked to allocate employees to jobs and also create the same appointment in outlook for each employee allocated to job as a seperate appointment. I...

I have the following code in the on click event of a commad button I am looking to duplicate the majority of the last record using this command button(further similar lines of code not shown). The problem I am encountering is that the Field SalesID is an autonumber field and is at 23650 as a...

Hi I have two queries, one captures the last test date, formatted at the minute as a 'general number' using Format([Field],"0") on a piece of plant and the other captures the interval between tests on same piece of plant When I add a spcific number to either field in my joining query they act...

Hi I have a report which shows sales, labour costs etc by date and project number. The main report summarises the labour cost by project and I have a sub report summarising Sales values by project, which then links to the main report on the Project ID. The problem I have is that we may have...

Hi Following a recent post I have created a piece of code to put vbcrlf between various fields to create an address field in a report, however a line is created for each field whether blank or not. If I no not want to have the blank lines, is an IIf(IsNull() statement for each field the best...

The company I work for have recently upgraded PC's to Office 2010 from 2003. I am getting some errors in my database which I am dealing with one at a time. The latest is when I run a particular report I am receiving an error saying Undefined function 'Chr' in expression Below is the...

I have been trying to create a command button on a form that sends a task in outlook to another colleague. I have searched forums and have some code that works for the most part, the only part not working is setting the reminder. I have attached the code and would like some feedback as to why...

Hi I have a subform which is shown in Continuous Forms view. I have a control called PaintPrice which has an after update event where I need to check if value in the PaintID control is the max, if this is so then I wish to move to other controls. The problem I am having is selecting the...

Hi I have a form based on a query. I wish to apply more than one filter to the form.I am using the docmd.applyfilter event. I have created two filters strcriteria and strcriteria2. If I apply these seperately they work fine, if I use then consecutively then only the latter...

Hi I have a form (frmenquirysearch) dwhich displays a summary of all the records in tblenquiry in continous view. I want to open up frmenquiry which is a detailed view of the records using a command button on frmenquirysearch. I used the command button wizard and it has given me the code...

Hi I have a costing database. With a structure of tblenquiry where the primary key (enquiryNo)appears as the foreign key in tblparts, tbllabour and tblpaint Not all enquiries will have all three parts, labour and paint. This is giving me a problem when I run estimate report to show the total...