run-time error 3075
I have the following message when clicking on a command button designed to
print a report based on the current record in a tabbed form.
Syntax error (missing operator) in query expression '(MachNumber=2G-CH01)'.
The following code is on the "click" event of the button:
Private Sub MachTag_Click()
DoCmd.OpenReport "M-Equipment Tag", acPreview, , "MachNumber = " &
The 1st tab of the form is pulling the MachNumber data directly from the
table. The 2nd tab form (is a subform) and is pulling the data from a second
I do...Serial #'s and workorders
I sell alot of computer parts that are serialized and what ticks me off is
that if I scan in parts & serial #'s and create a workorder it'll save the
serial #'s, but if I make any change at all to the workorder all the serial
#'s go bye bye! Also, when ringing up the the sale and finalizing the
workorder it asks for serial #'s and if the customer decides to add another
item to the sale I need to cancel completing the sale and go back to the work
order screen and add in the product, but again this will loose all the serial
#'s. Anyways, I'm sick of havin...time quick entry
I would like to do quick entry for times to the hundredth of a second (e.g.,
m:ss.00). I've used Chip Pearson's method for time quick entry as a starting
point, and edited the Cases, but it's not working for me. I've included the
code I've tried below.
Thanks for any help,
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim TimeStr As String
On Error GoTo EndMacro
If Application.Intersect(Target, Range("A1:A10")) Is Nothing Then
If Target.Cells.Count > 1 Then
If Target.Value = "" Then
...Run-time error '2147217900 (80040e14)
I have a tree list control I want to populate with Categories based on a
Client. The client number is input into a text box & then the update event
populates the tree based on the selection. I get a syntax error when it
tries to open the recordset based on the SQL. Two tables are invloved
(Client & Categories; in a 1-to-many relationship on pID field). Here'e the
Dim rstCategory As New ADODB.recordset, rstComponent As New ADODB.recordset
Dim rstSubComponent As New ADODB.recordset
Dim tvwTree As Object
Dim nodX As Node
Dim I As Integer
Dim blnAllRecs As B...time to decimal
I have numbers like 283 hours 13 min 7 sec 283:13:07 in an excel work
I want to convert this to decimal minutes. What formula can accomplish
I hope someone can help because I have lots of them to do.
Thanks for any help,
Format as General or number, not as Time, which is what Excel does automatically
Microsoft MVP - Excel
"Louie" <firstname.lastname@example.org> wrote in message news:ePZ%23UeIIIHA.4296@TK2MSFTNGP04.phx.gbl...
|I have numbers like 283 hours 13 min 7 sec 283:13:07 in an excel work
| I want to conve...how do I record times from track meets and find averages
I need toot been able keep track of athletes time and find averages. I have
not been able to figure it out.
go over to debra's site:
some files have been provided for download. check what fits you
Message posted from http://www.ExcelForum.com
I had an issue with data not syncing,because it kept referencing the old
spreadsheet, so I went into tools, database utilities, linked manager to
update the linked file, now I'm getting:
The record source 'Select tbl_JobTracking.[job tracking id],
tbl_JobTra...' specified on this form or report does not exist.
You misspelled the name, or it was deleted or renamed in the current
database, or it exist in a different database.
In the Form or Report's Design view, display the property sheet ...average line needed from one single cell
in B3 to M3 (=12cells) I enter data for 12 months
in N3, I calculate the average of the 12months
How will I get an average line in a graph from that single cell N3?
Tushar has an example of using a named range.
> in B3 to M3 (=12cells) I enter data for 12 months
> in N3, I calculate the average of the 12months
> How will I get an average line in a graph from that single cell N3?
Andy Pope, Microsoft MVP - Excel
thanks for tha...Start and End times to show in Apptointments
I have recently migrated from Lotus Notes which on the Calendar displays the
Start and End time of an Appointment on views such as the daily or weekly
view. I know in Outlook it displays these times if you hover onto a specific
appt but is there any way so it displays all the time on all the appts ?
you can turn it on for month view - right click on the calendar and choose
other settings, show end time. Day and week views don't show times unless
the appointment is not within the currently selected scale.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-t...Run-time error after screen lock in XP
In several Excel files I noticed the following error.
VBA code works fine until screen is locked by screensaver or pressing
Ctrl-Alt-Del and choosing Lock Computer.
After unlocking VBA code that worked fine before, now brings the
run-time error like run-time error 380.
We have OfficeXp SP3 installed.
...All day event (Birthday) start time setting for a WORK day, not full day.
this problem is literally robbing my sleep. I was using Outlook 2003 and now
updated to Vista and Outlook 2007.
If I create a new contact and enter his/her birthday, Outlook will create a
new all day event for this birthday. This is being synched to my Windows
So far so good.
In OL 2003 this birthday "all day event" would remind me 15 minutes before I
start working at 8 am.
After the Upgrade 2007 now starts an all day event at 0:00 am. This means,
my PDA now reminds me at 11:45 in the night about a birthday.
How can I set this back? Or how can I tell Outloo...chart a time frame
I have a spreadsheet that contains a list of projects
where each project has a start date and an end date.
I need to chart these projects all into one chart showing
the start date and end date for each different project in
a monthly calander type of format with the months going
across the top of the chart from left to right.
I'm having trouble finding a chart that will plot these
dates as point "A" and point "B" with a line in between
for each different project.
What type of chart should I use and how can I get the
results that I'm looking for?
Thank you ...Current Time subtract a specific amount every second
I have a total in A1 and B2
I want B2 to be subtracted from A1 every second of the day.. Based on the
Current Time in D4
D4 contains =now()
Is this what you want:
Format as number
"Jman" <Jman@discussions.microsoft.com> wrote in message
>I have a total in A1 and B2
> I want B2 to be subtracted from A1 every second of the day.. Based on the
> Current Time in D4
> D4 contains =now()
"Fred Smith" wrote:
> Is thi...Time-stamping a chart
I am querying a database and charting the info which I
want to publish on a web page.
I'd like to time and date of the latest query result to
appear on the chart so that users know how current the
Maybe even embed the last update info in the chart title?
That would work...
"Average Time - Last updated 01/08/2004 9:16 AM EST"
How is the query executed? Is it through custom VBA code? Or through
native XL capabilities?
If the former, use the code to put the desired title in a cell. Link
the cell to the chart title. For ...Sum by range of time
I have a column of values (A) and a column of times (B). The times
fall between 8:00am and 10:00am, but I'm only interested in the values
between 9:00am and 10:00am. I want to sum all values in column A
whose time values in column B are >=9:00 and <=9:59. I've tried
sumif, nested if, or() and and() functions, and I can't get anything
to work properly. Can anyone help?
"rocketD" <email@example.com> w...Microsoft CRM 3.0 ignoring british summer time
We've got a installation of CRM 3.0 with rollup update 2 installed.
Win 2k3 EE SP1 as guest on ESX 2.5 host.
The guest servers are on BST (GMT+1), however any dates get saved on GMT on
the database. This throws reporting off which is a serious concern around
MS seemed to have pulled rollup update 3, however I went through the list of
individual updates and none seem relevant
Anybody suffering from the same thing?
The Crm database allways stores time in GMT. The conversion to and from local
time is done in the user interface.
The CRM database does...changeing the time CRM sends emails
I have set up various workflow rules that send an email reminder for us a
couple of weeks before a contract expires.
Is there a way to set the time that these email reminders are sent?
At the moment they are coming through at 00.00 which is a pain if you have a
blackberry by the bed and they do not get actioned staright away.
Any advice would be greatly appreciated
...Rounding up Time Values
I am using the formula below to round time values up,in this case t
the next five minute increment
BB13 = 5
BB14 = 16:00:02
This formula only rounds up to 16:05:02 if the time is 16:01:00 o
greater,i would prefer it if the formula could make the time round u
as soon as one second has passed, 16:00:01 and not when one minute ha
Can this be done
Message posted from http://www.ExcelForum.com
What is in BB14?
You can just use
will do what you want
Or if there are dates as well you can just format...2nd time posting this problem, pls help
Dear Kindly solve my problem
table t1 has fields pictures, name
in design view pictures field is ole object and
name field is text.
now in table, i have inserted some jpeg pictures in field pictures,
written some name in name field
if we open table t1 to view.
now i have written a small query as
select t1.pictures from t1 where name = x;
x is given in run time, like any thing as n1 /n2/n3/n4 /....
let say x is n2 now.
i a...Receive email in real-time
We have several PCs in our company that are receiving Exchange email
messages in real-time, whereas others have to click Send/Receive within MS
Outlook to receive their email. How do I setup Exchange where all users can
receive their email instantaneously on any machine in the organization onto
which they logon.
Thanks in advance,
You can't configure Exchange to not deliver emails instantly to Outlook
This is an Outlook setting and will have to be configured here.
"Mervin Williams" <firstname.lastname@example.org> skrev i en meddelel...Free busy time O2003 / Anonymous user in 2007
How do I disable the free/busy time in the calendar for Exchange/Outlook
So other users can't see the appointments of myself.
In Outlook 2007 you will set this due to change the sharing permissions of
and change the default user permission to none.
Any idea how you will get the anonymous user with none permissions back in
What's btw the extra functionality of this user.
Any help is appreciated,
...time over 1 hour #2
I have a cell that displays teh amount of time a person waited at a certain
For example, 1:30 for 1 hour, 30 min.
I need to have another cell that will tell me the time above one hour, in
this case, :30
Excel counts one day as 1. Therefore 1 hour = 1/24. Try something like
With the time in A1
or if it 02:30 should be 01:30 over one hour
format as hh:mm
"johnfli" <email@example.com> wrote in message
> I have a cell that ...Changing text/color after a time period?
I hope some of the brilliant Excel people here can help me out. What I
am looking to do, is enter a date in a certain cell (if it helps
conceptualize, the date that I ship something to someone). Is it
possible to have that cell with the "ship date" in it, either change
colors, or change the font size, or something, after 30 days have gone
by? My reasoning is that the product I ship out, has to be back to me
in 30 days, or a penalty will incur to the other party. I just want
these fields that have exceeded the 30 day mark, to stick out, so I can
easily identify them. Thanks for any h...Employee Time card form
I have a table containing two fields - Employee_ID and Time_Stamp.
I've already created a form that scans in Employee_IDs; and once any
Employee_ID is scanned in, the ID and scanned time is recorded to the table.
In addition to what it already does, the form needs to populate the
employee's punch time records for the current week.
For example: (current date and time is Wednesday 9:02 am)
(Form view before update)
Employee ID: ___________________
(Form view after update)
Employee ID: _1001 (Enter)_______
Employee ID: 1001
Mon: ...Indiana to Eastern Time Zone Exchange Appointment fixer scripts
Attached are some server-side VBScripts for Exchange 2003 (2000 was not
tested) that effectively change appointments created in the Indiana Time
Zone to Eastern Time Zone. It fixes both the time zone tags and start times
where appropriate. Recurring meetings are dealt with properly, without
creating exceptions. In fact, recurrences and exceptions adjust
automatically. It also fixes single occurrence appointments for Apr 2 - Oct
29, 2006 ONLY. All fixed meetings have their subject lines appended with
the original time and date of the item.
There are additional scripts for fixing Pu...