Search results for query: *

Hi, First of all I'm only a part time user of Access code and would be in huge trouble if not for the help received from you guys here :) My latest problem is with building an email and sending it to Lotus Notes, in short my code is as follows Private Sub cboSendEmail_Click() Dim strEmail...

Hi, Is it possible to change the background colour of a single field in a sub form in datasheet view dependant on a value on the main form (using the menu option conditional formatting requires a set value that does not vary) Any help would be really appreciated. Thanks Phil

Very new to coding so take it easy on me. I need to know how to check a mainform checkbox from a double click on a record in a subform. The string below sets the name of the checkbox that needs updating but I can't get the last line of code right. Private Sub txtShift_DblClick(Cancel As...

Hi All, Just throwing this one out there for any thoughts. Can I open a pdf file at a desired page via vba. Opening the file is easy but to a desired page has me stumped! Any ideas would be much appreciated. Thanks Phil

I have a spreadsheet that has similar data on consecutive worksheets (one sheet for each day) On a "Charts" worksheet I want to change a charts data range from one sheet to another. i.e. in a macro delete an existing chart and then add a new chart of the same name - can I in the code below have...

Hi, Is there a way of finding the sum of a range that has to satisfy 2 criteria with the SUMIF function? I have a list labelled Type - Year - QTY as shown below, I need to find the sum of the QTY column when for example the TYPE is "A" and the year is 2009. The result should be 4. TYPE - YEAR...

Here is my problem, I have data sent to me in an Excel workbook at the end of each month (large company) with safety stats for the whole company, from this I extract data to my spreadsheet at the press of a button. I have code written that works fine untill the monthly spreadsheet sent to me has...

Are you able to clear the contents of the clipboard via code? Thanks Phil

I need to copy the contents of a field to the clipboard for use in another application. What I want is the user to click the field for this to occur - this is then used by an on screen phone dialler

I have 4 identical sheets in layout with data and have a 5th totals sheet. I have formula taking data from sheet one to the totals sheet and wanted to copy them down to retrieve the info from the other 3 sheets - can I 'pin' the cell address and copy down changing the sheet # - ie ='Sheet...

This will be hard to explain - so here goes I have a calculated field on a sub form that tallies up hours that my on call staff has worked in the previous 24hrs. When this total exceeds 14 hrs I have a field that displays a warning. Now I have been asked for an audible warning as well. I have...

Is there any way to "trick" the OnTmer into running an event procedure at a period of longer than the 65,535 milliseconds - say 10 minutes

I have a form that adds and edits data and is accessed by two users. The most current change is to be saved EVERY time but users are sick of the "Write Conflict" message as they always select "Save Record" - can this message be disabled or After Update code written that...

I need to turn the numlock on via code - can't work it out using help file - can anyone help

example of what i need to do table name time out time home total ted - 2/2/02 10:00 - 2/2/02 20:00 - 10:00 bill - 3/2/02 12:00 - 3/2/02 13:00 - 1:00 ted - 3/2/02 04:00 - 3/2/02 15:00 - 11:00 query1 - returns todays staff hours of work name time out time home...

A Colleague asked me how to combine many tables (150) into one table via code and a user command button. Can anyone help?

Is it possile to copy only the time of a date/time field to another field ie 01/01/01 16:00:00 as 16:00:00. Thanks in advance Phil

In a table I have a 'Time_Out' field. This field has a date/time entry "01/01/01 16:00:00". I need to limit a report between two dates (which I have done) but also display only times between 'start_time' and 'end_time" within this data range. I have a user form to get the date...

When importing a column from excel formatted to text that contains predominantly number entries all cells with text entries are not imported (blank), only the cells with the number entry are imported. This has had me stumped for a while, I would appreciate any idea's. Thanks Phil

In a table I have a 'Time_Out' field. This field has a date/time entry "01/01/01 16:00:00". I need to limit a report between two dates (which I have done) but also display only times between 'start_time' and 'end_time" within this data range. I have a user form to get the date...