A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 27
Search took 0.06 seconds.
Search: Posts made by: Jey
Forum: Using Forms June 2nd, 2010, 09:52 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 446
Posted By Jey
Value list updates not appearing in form

Ah ha, I figured it out, sorry for the premature question. I'll answer the
question myself, just in case anyone else runs into the same problem.

It's the 'inherit value list' property (in the form,...
Forum: Using Forms June 2nd, 2010, 08:36 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 446
Posted By Jey
Value list updates not appearing in form

I have a table with several fields who's display control is combo-box, source
is value list, and multiple values are allowed.
In one of the fields, when I add a new option to the value list, it...
Forum: General Discussion March 3rd, 2010, 06:02 PM Posted to microsoft.public.access
Replies: 5
Views: 107
Posted By Jey
allowing multiple values causes front end to report error

That solved it, thanks! I've set them to compact on close, so hopefully I
won't run into that again.


"Allen Browne" wrote:

Try:
1. Delete the linked table from the front end.
2....
Forum: General Discussion February 23rd, 2010, 06:08 PM Posted to microsoft.public.access
Replies: 5
Views: 107
Posted By Jey
allowing multiple values causes front end to report error

My database is split into back and front ends. I already have one text field
that allows multiple values in a combo box with value list. When I add
another multiple value field, the front end gives...
Forum: General Discussion January 13th, 2010, 09:22 PM Posted to microsoft.public.word.docmanagement
Replies: 2
Views: 353
Posted By Jey
Runtime Error code: 429, Active X component can't create objec

I read this KB, the word 2007 works fine when another user login to the same
computer, this error only comes on when a patricular user login. When I
re-create that user's windows profile , it works...
Forum: General Discussion January 13th, 2010, 04:30 PM Posted to microsoft.public.word.docmanagement
Replies: 1
Views: 85
Posted By Jey
Word 2007 error

We hvae offfcie 2007 professional installed, user's getting the following
erro when launch word 2007, If I re-create the windows user profile it works
fine. Is any easire workaround for...
Forum: General Discussion January 12th, 2010, 09:13 PM Posted to microsoft.public.word.docmanagement
Replies: 0
Views: 116
Posted By Jey
Word 2007, Runtime Error code: 429, Active X component can't creat

We have office 2007 professional installed, some users are getting the
following error when opening word 2007

Runtime Error code: 429, Active X component can't create object.

When I re-create...
Forum: General Discussion January 12th, 2010, 06:45 PM Posted to microsoft.public.word.docmanagement
Replies: 0
Views: 80
Posted By Jey
Word 2007 error

We just installed office 2007 Professional, users getting the follwoing error
when opening word 2007

Runtime Error code: 429 , Active X component can't create object.
Forum: General Discussion January 12th, 2010, 03:31 PM Posted to microsoft.public.word.docmanagement
Replies: 2
Views: 353
Posted By Jey
Runtime Error code: 429, Active X component can't create object,

Hi,

we just installed offcie 2007 professional, and every time a user opes word
2007, she get the follwoing error

Runtime Error code: 429, Active X component can't create object.

I did...
Forum: General Discussion February 19th, 2009, 11:38 AM Posted to microsoft.public.excel.misc
Replies: 1
Views: 64
Posted By Jey
how to place objects behind text in excel 2007?

how to place objects behind text in excel 2007?
Forum: Running & Setting Up Queries January 30th, 2009, 06:50 PM Posted to microsoft.public.access.queries
Replies: 6
Views: 61
Posted By Jey
help using a parameter in an 'In (...)' criteria

Hi,

OK, I got it to work. Thanks!

I don't understand why my three other parameters are in square brackets in
the WHERE clause, but for the survey list parameter it's the field name that
is in...
Forum: Running & Setting Up Queries January 28th, 2009, 08:07 PM Posted to microsoft.public.access.queries
Replies: 6
Views: 61
Posted By Jey
help using a parameter in an 'In (...)' criteria

Hi,

I can't get it to work!?! In the code I have:
strSurveyList = "2,3"
qdf.Parameters("parSurveyList") = strSurveyList

But I get an error when the code hits the qdf.Parameters... line, because...
Forum: Running & Setting Up Queries January 27th, 2009, 10:37 PM Posted to microsoft.public.access.queries
Replies: 6
Views: 61
Posted By Jey
help using a parameter in an 'In (...)' criteria

Hi,
Sorry, but I'm not really clear on all that!
Ideally, I'd like to make a variable, define it as "2,3", then be able to
use the variable to define the paramater every time I call the query. Such...
Forum: Running & Setting Up Queries January 27th, 2009, 06:28 PM Posted to microsoft.public.access.queries
Replies: 6
Views: 61
Posted By Jey
help using a parameter in an 'In (...)' criteria

I have a series of queries that all have the same criteria: "In (2,3)" (plus
a few others). They are being called from VBA code, where the parameters are
generated and passed to the queries. I want...
Forum: Running & Setting Up Queries October 20th, 2008, 10:08 PM Posted to microsoft.public.access.queries
Replies: 0
Views: 57
Posted By Jey
bring related fields into a query that uses MaxofDate and GROUP BY

Oops, one more complication that I hadn't forseen. In my first query I only
needed the date of the last locate... but if I want the location (lat/long),
then I also need the specific loacte on that...
Forum: Running & Setting Up Queries October 20th, 2008, 08:56 PM Posted to microsoft.public.access.queries
Replies: 1
Views: 53
Posted By Jey
bring related fields into a query that uses MaxofDate and GROU

That was the first thing I tried, but what it produces is a MaxDate for each
unique combination of which is about 95% of
all the records. (These animals don't stay still for very long!). I need a...
Forum: General Discussion September 12th, 2008, 07:06 PM Posted to microsoft.public.access
Replies: 3
Views: 77
Posted By Jey
Can't change data type to date in access table

I was actually just seaching the forum because I was having the same problem.
I wanted to add a double precision field to an existing table that has about
300,000 records. I got three error...
Forum: General Discussion July 25th, 2008, 10:30 PM Posted to microsoft.public.excel.misc
Replies: 8
Views: 111
Posted By Jey
Hidden Drop Down List

Hi,
Thanks for the link. It wasn't any of those, but on a whim I just copied
everything to a new worksheet, and now it all works fine! I tried copying
back to the original worksheet, and still no...
Forum: General Discussion July 25th, 2008, 09:31 PM Posted to microsoft.public.excel.misc
Replies: 8
Views: 111
Posted By Jey
Hidden Drop Down List

Did you ever get this resolved? I'm having the same problem in Excel 2007.
The 'In-cell dropdown' option is checked, and 'For objects-show all' is
checked (in Office Button-Excel...
Forum: General Discussion May 31st, 2008, 05:36 PM Posted to microsoft.public.access
Replies: 3
Views: 88
Posted By Jey
File sharing lock and append paste

Oh, duh. Yep, that does it!

Thanks,
Jey


"Jeff Boyce" wrote:

Jey
Forum: General Discussion May 30th, 2008, 10:37 PM Posted to microsoft.public.access
Replies: 3
Views: 88
Posted By Jey
File sharing lock and append paste

Hi, thanks in advance if someone can shed some light on this for me...

I'm simply trying to copy records from Excel to Access. Just to make sure I
have everything formatted right in the Excel...
Forum: General Discussion May 8th, 2008, 09:51 PM Posted to microsoft.public.access
Replies: 5
Views: 59
Posted By Jey
Opening & saving a database in '07 as an '03

Thanks!

That sounds like exactly what I needed to know. I'll try to remove all early
binding from my code and hopefully that will fix it. Will it just be the
Excel reference that I want to...
Forum: General Discussion May 8th, 2008, 07:18 PM Posted to microsoft.public.access
Replies: 5
Views: 59
Posted By Jey
Opening & saving a database in '07 as an '03

Hi Tom,

Yes, in the version that I edited at home and now want to open in A2003, the
Excel 12.0 library is marked 'Missing'. In the copy of the database that I
didn't take home, I have the Excel...
Forum: General Discussion May 7th, 2008, 07:02 PM Posted to microsoft.public.access
Replies: 5
Views: 59
Posted By Jey
Opening & saving a database in '07 as an '03

I want to work from home... but I have Office '07 there and '03 at work. Can
I open an '03 Access database in '07 but force it to remain in a naitive '03
format... including all object library...
Forum: Running & Setting Up Queries April 11th, 2008, 05:37 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 91
Posted By Jey
Help with update query, using result of Max query

Works like a charm. Great, thanks!
Jey


"Gary Walter" wrote:


"Jey" wrote:
I have three tables: one for individual animals, and one each for GPS &
VHF
Showing results 1 to 25 of 27

 
Forum Jump

All times are GMT +1. The time now is 06:41 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.